Actions
Bug #67708
closedInvalid SQL: ProcessedFileChecksumUpdate compares BLOB with INTEGER column
Status:
Closed
Priority:
Must have
Assignee:
Category:
Install Tool
Target version:
Start date:
2015-06-23
Due date:
% Done:
100%
Estimated time:
TYPO3 Version:
7
PHP Version:
5.6
Tags:
Complexity:
easy
Is Regression:
No
Sprint Focus:
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.
Actions