Database table name "group" reserved keyword
Issue #1058
resolved
- piler 1.3.6, build 998, Janos SUTO sj@acts.hu Build Date: Thu Feb 6 15:41:27 CET 2020
- Fresh install from source
The database has a table named ‘group’ – this leads to problems as ‘group’ is a reserved keyword in MySQL/MariaDB:
MariaDB [piler]> select * from group;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'group' at line 1
This is not so much a bug as an inconvenience. I’m trying to access the database with some scripts and errors like this makes the handling rather “interesting”.
Comments (3)
-
repo owner -
repo owner I’ve just asked the mailing list members to suggest a resolution to the issue.
-
repo owner - changed status to resolved
Fixed issue
#1058renamed table group to usergroupSigned-off-by: Janos SUTO sj@acts.hu
→ <<cset ebab0eabcc02>>
- Log in to comment
You are right, I see your point. However, it’s more like a cosmetic annoyance, as you can you the back tick character to reach the table. Anyway, I’ll think about renaming it to something still usable. I didn’t find a better word for a group, than group.