Bug #88166

TCA entry 'foreign_table_where' => ' ORDER BY LOWER(tx_my_table.name) ASC' not working anymore

Added by Kurt Gusbeth about 1 month ago.

Status:
New
Priority:
Should have
Assignee:
-
Category:
-
Target version:
-
Start date:
2019-04-17
Due date:
% Done:

0%

TYPO3 Version:
9
PHP Version:
Tags:
tca
Complexity:
Is Regression:
Sprint Focus:

Description

In TYPO3 8 this worked:

'config' => [
    'type' => 'select',
    'renderType' => 'selectSingle',
    'foreign_table' => 'tx_my_table',
    'foreign_table_where' => ' ORDER BY LOWER(tx_my_table.name) ASC',
    'items' => [
        [' --- Bitte wählen --- ',0]
    ],
    'minitems' => 0,
    'maxitems' => 1,
],

In TYPO3 9.5.5 it does not work. Error:
Datenbank-Fehler

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BY LOWER(tx_my_table.name) ASC) AND ( 1=1) AND' at line 1.
Es ist ein SQL-Fehler aufgetreten. Dies kann auf eine Schema-Abweichung zwischen TCA und der Datenbank hindeuten. Versuchen Sie im Install Tool einen Datenbank-Vergleich durchzuführen.

It works only if I remove the
 LOWER()

And other mySQL functions causes this error.

Also available in: Atom PDF