Bug #67708
closed
Invalid SQL: ProcessedFileChecksumUpdate compares BLOB with INTEGER column
100%
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.
Updated by Gerrit Code Review over 9 years ago
- Status changed from New to Under Review
Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/40576
Updated by Gerrit Code Review over 9 years ago
Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/40576
Updated by Gerrit Code Review over 9 years ago
Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/40576
Updated by Susanne Moog over 9 years ago
- Category changed from Install Tool to 1601
Updated by Morton Jonuschat over 9 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset acdca0a628d736af9143bd9ce90725bd119b3651.
Updated by Herbert Sojnik about 9 years ago
I have to disagree, that the query works fine on MySQL and this is only a problem using DBAL:
In our installation there are about 170.000 entries in sys_file_processedfile and 28.000 in sys_registry.
The original query lasts more than 2000 seconds.
Using the statement with CAST it needs a few seconds.
I would suggest to include the patch also in 6.2
Updated by Riccardo De Contardi over 7 years ago
- Status changed from Resolved to Closed