You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
There are some individual workarounds scattered around code, e.g.:
NOT joining users
manually setting the quote_name before doing something, then trying to roll back
The first makes me sad, and the 2nd is overly tricky and according to #dbix-class may be hard to properly localise so risks subtle bugs. Worth spending a bit of time to test and refactor this properly.
The text was updated successfully, but these errors were encountered:
This setting would allow us to join to the users table without generating invalid SQL like
JOIN users user
asuser
is a reserved word.It's not possible to simply add this, as I discovered, because there is various literal SQL that isn't correctly escaped. Also quoting searches which should work has some oddities, e.g. https://gist.githubusercontent.com/osfameron/104bb2d98879bf0b8616/raw/61d08c7ccc9982f36fe8342369607fa49c9b3be4/gistfile1.txt
There are some individual workarounds scattered around code, e.g.:
The first makes me sad, and the 2nd is overly tricky and according to #dbix-class may be hard to properly localise so risks subtle bugs. Worth spending a bit of time to test and refactor this properly.
The text was updated successfully, but these errors were encountered: