Database table name "group" reserved keyword

Issue #1058 new
Kai Bojens created an issue
  • piler 1.3.6, build 998, Janos SUTO 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 (2)

  1. Janos SUTO repo owner

    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.

  2. Log in to comment