Issue Bug Closed

#22057Invalid quoting of numeric column names [scheduler]

Xavier Perseguers 02/04/10, 13:17 updated 02/22/10, 22:57

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.