Important: #81751 - DBAL compatible quoting in TCA
See forge#81751
Description
Names of tables and columns used in SQL fragments of TCA
definitions need proper quoting to be compatible with different database drivers. The database
framework of the core now applies proper quoting to table and column names if they are wrapped as {#table
It is advised to adapt extensions accordingly to run successfully on databases like PostgreSQL.
Example for a TCA
definition snippet:
'columns' => [
'aField' => [
'config' => [
'foreign_table' => 'tt_content',
'foreign_table_where' => 'AND {#tt_content}.{#CType} IN (\'text\',\'textpic\',\'textmedia\') ORDER BY {#tt_content}.{#CType} ASC',
...
],
],
...
],
'columns' => [
'aField' => [
'config' => [
'type' => 'text',
'search' => [
'andWhere' => '{#CType}=\'text\' OR {#CType}=\'textpic\' OR {#CType}=\'textmedia\''
],
...
],
],
...
],
Copied!