Actions
Bug #17554
closedProblem with strings in IN
Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2007-08-22
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:
Description
I've a problem with DAM and PostgreSQL (DBAL)
---
LOG: statement: SELECT COUNT as "count"
FROM "tx_dam"
WHERE
1 = 1 AND "tx_dam"."pid" IN (1) AND "tx_dam"."file_type" IN ("gif","png","jpg","jpeg") AND (
"tx_dam"."file_path" LIKE 'fileadmin/weeaar/images/pictures/%') AND "tx_dam"."deleted" = 0
ERROR: column "gif" does not exist
The IN ("gif","png","jpg","jpeg") is qouted wrong. It should be IN ('gif', 'png', 'jpg', 'jpeg').
Marcel
(issue imported from #M6198)
Actions