Issue Bug Closed

#17554Problem with strings in IN

Marcel Alburg 08/22/07, 21:54 updated 11/09/09, 11:21

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.