#22057Invalid quoting of numeric column names [scheduler]
Description
Sysext scheduler uses following query to check whether backend user exists:
SELECT 1 FROM be_users WHERE username = ‘_cli_scheduler’ AND admin = 0 AND be_users.deleted = 0
However DBAL fails to quote this query correctly as it returns
SELECT “1” FROM “be_users” WHERE “username” = ‘_cli_scheduler’ AND “admin” = 0 AND “be_users”.“deleted” = 0
instead of not quoting the ‘1’ column name:
SELECT 1 FROM “be_users” WHERE “username” = ‘_cli_scheduler’ AND “admin” = 0 AND “be_users”.“deleted” = 0
This results in a query error when using Oracle:
ORA-00904: “1”: invalid identifier
(issue imported from #M13422)
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.