Actions
Bug #88762
closed
SchemaIndexDefinitionListener::onSchemaIndexDefinition builds invalid SQL
Status:
Rejected
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2019-07-15
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
10
PHP Version:
7.2
Tags:
Complexity:
Is Regression:
Sprint Focus:
Description
While using the analyze database functionality in the install tool, method `\TYPO3\CMS\Core\Database\Schema\EventListener\SchemaIndexDefinitionListener::onSchemaIndexDefinition` builds invalid SQL. At least for MariaDB 10.4.
The query ends with `ORDER BY SEQ_IN_INDEX ASC AND `INDEX_NAME` = 'PRIMARY'`.
I am not sure what exactly fails here. Maybe on other DB-Engines there is no ORDER BY and the "AND `INDEX_NAME` = 'PRIMARY'" should be added to the where statement or other DB-Engines allow to add orderings via AND (which I have never seen in my life).
However, the comparison fails.
Updated by Alexander Schnitzler almost 5 years ago
- Status changed from New to Rejected
Nevermind. This is a false report.
Actions