Actions
Bug #22057
closed
Invalid quoting of numeric column names [scheduler]
Status:
Closed
Priority:
Should have
Assignee:
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2010-02-04
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:
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)
Files
Updated by Xavier Perseguers almost 15 years ago
Committed to:
- DBAL trunk (rev. 29688)
- DBAL_1-0 (rev. 29689)
Actions