#17554Problem with strings in IN
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)
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.