Hello,
I have a fresh new install using postgreSQL 9.6 on a debian 9. All versions are last stable.
Expected behavior : results displaying normally
Error encountered: In postgreSQL logs, I have the lines:
2019-03-08 17:35:03.833 CET [2773] root@tasks ERREUR: l’opérateur n’existe pas : name = integer au caractère 84
2019-03-08 17:35:03.833 CET [2773] root@tasks ASTUCE : Aucun opérateur ne correspond au nom donné et aux types d’arguments.
Vous devez ajouter des conversions explicites de type.
2019-03-08 17:35:03.833 CET [2773] root@tasks INSTRUCTION : SELECT max(severity) FROM report_counts WHERE report = 8 AND override = 1 AND user = (SELECT id FROM users WHERE uuid = ‘cb9ea5dd-70da-410c-aa69-533dc138802b’) AND min_qod = 70 AND (end_time = 0 or end_time >= m_now ());
After investigation, I found out that the reason this error occurs is because the reserved keyword ‘user’ is used, when I manually request
SELECT max(severity) FROM report_counts WHERE report = 8 AND override = 1 AND “user” = (SELECT id FROM users WHERE uuid = ‘cb9ea5dd-70da-410c-aa69-533dc138802b’) AND min_qod = 70 AND (end_time = 0 or end_time >= m_now ());
I have no errors.
Should I create an issue on the repository or is it a misconfiguration from my installation ?
What can I do for the moment to prevent this from happening ? (I am not very confident with PostgreSQL and DBs in general)
Thank you for reading.