Issue Bug Closed

#67708Invalid SQL: ProcessedFileChecksumUpdate compares BLOB with INTEGER column

Morton Jonuschat 06/23/15, 20:13 updated 10/19/17, 21:38

Description

The following statement is performed during the 7.4-dev Upgrade Wizard:

SELECT COUNT(*) FROM "sys_file_processedfile" LEFT JOIN "sys_registry" ON "entry_key"="sys_file_processedfile"."uid" AND "entry_namespace"='ProcessedFileChecksumUpdate' WHERE ("entry_key" IS NULL AND "sys_file_processedfile"."identifier" <> '') OR "sys_file_processedfile"."width" IS NULL

This query compares a BLOB field with an INTEGER field without doing an explicit cast. This is fine on MySQL but fails on DBAL Installations, i.e. running PostgreSQL.

Reviews 3