Project

General

Profile

Actions
Copy link

Bug #88762

closed

SchemaIndexDefinitionListener::onSchemaIndexDefinition builds invalid SQL

Added by Alexander Schnitzler over 5 years ago. Updated over 5 years ago.

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.

Actions
Copy link

Also available in: Atom PDF