Issue Bug Rejected

#88762SchemaIndexDefinitionListener::onSchemaIndexDefinition builds invalid SQL

Alexander Schnitzler 07/15/19, 15:01 updated 07/15/19, 15:09

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.

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.