Remembered login throws SQL error (Postgres only?)

Description

Conditions:

  • "Remember me" turned on for admin logins

  • Login session has expired, so login being driven by cookie values

  • PostgreSQL database (maybe others, not sure)

The following error is thrown:

The issue is that we are asking for user.login_id, and "user" is a reserved word in PostgreSQL (and they enforce it strictly!).

The query works fine if user is surrounded by quotes. So we could maybe either just fix this specific case, or implement a general rule that all selectFields get automatically wrapped in quotes (by using listQualify() with . as a separator, we could handle table.column selectFields as well as plain column names).

Environment

PostreSQL database

Assignee

Unassigned

Reporter

Seb Duggan

Labels

None

Accepted

Yes

Fix versions

Affects versions

Priority

Medium
Configure