search

AdaCore / gnatcoll-db

GNAT Components Collection – Database packages
Other
10 stars 22 forks source link

PGRES_FATAL_ERROR ERROR: invalid name syntax in ORM SELECT currval #7

Open OCTAGRAM opened 6 years ago

OCTAGRAM commented 6 years ago

I am getting this trace when trying to insert new data via ORM:

[SQL.ERROR] select failed: SELECT currval('"Comm_Watch_Items"_"Comm_Watch_Item_Id"_seq') PGRES_FATAL_ERROR ERROR: invalid name syntax

Environment: Linux x86_64, GNAT 2017 GPL, XMLAda from Git, libgpr from Git, GNATCOLL from Git (Change-Id: Ia6649032bde129c9ed36e359f2a75ffc2530586a).

OCTAGRAM commented 6 years ago

4b7c92540b37d6489dea8e3498bbc959588a806b is the problem. Quoting should be done on behalf of SQL engines. MSAccess uses square brackets, MySQL uses backticks.