Issue Bug Rejected

#81388SQL-keyword "recursive" not enclosed in ticks - inserts into tt_content fail with MariaDB >=10.2

Robert Görke 05/31/17, 14:00 updated 08/01/19, 11:36

Description

Situation: I am using typo3 together with mariaDB 10.2. on centos. Now mariaDB supports recursive queries since 10.2 und thus has “recursive” as a keyword – despite the fact that it is not listed in the official list of keywords: You cannot use “recursive” as an identifier without escaping it with ticks.
Problem: typo3 uses the keyword “recursive” without enclosing it in ticks.
Observation: When trying to insert a text element, the corresponding sql-insert tries to insert into table tt_content. Thereby it also lists all columns, among them a column called “recursive”, in the query – without ticks. This fails.
Result: It is not possible to use typo3 with mariaDB from 10.2 on.
Solution: A solution could simply be to enclose all identifiers in automatically built sql-queries by (correct) ticks.

Reviews 0

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