Bug #67708

Invalid SQL: ProcessedFileChecksumUpdate compares BLOB with INTEGER column

Added by Morton Jonuschat about 6 years ago. Updated almost 4 years ago.

Status:
Closed
Priority:
Must have
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.


Related issues

Related to TYPO3 Core - Bug #75932: SQL-Error in ProcessedFileChecksumUpdateClosedStephan GroƟberndt2016-04-26

Actions
#1

Updated by Gerrit Code Review about 6 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

#2

Updated by Gerrit Code Review about 6 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

#3

Updated by Gerrit Code Review about 6 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

#4

Updated by Susanne Moog about 6 years ago

  • Category changed from Install Tool to 1601
#5

Updated by Morton Jonuschat about 6 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
#6

Updated by Herbert Sojnik over 5 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

#7

Updated by Riccardo De Contardi almost 4 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF