Project

General

Profile

Actions
Copy link

Bug #88489

closed

Problems with MariaDB 10.2 and above - recursive is reserved keyword

Added by Tomas Norre Mikkelsen over 5 years ago. Updated almost 5 years ago.

Status:
Rejected
Priority:
Should have
Assignee:
-
Category:
-
Target version:
-
Start date:
2019-06-05
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
9
PHP Version:
Tags:
CodingNight
Complexity:
Is Regression:
Sprint Focus:

Description

After updating to MariaDB 10.2 ( currently on 10.4)

I'm have problems with creating the `tt_content` and `sys_file_collection` tables due to the use of the reserved keyword `recursive`

https://github.com/TYPO3/TYPO3.CMS/blob/master/typo3/sysext/core/ext_tables.sql#L302
https://github.com/TYPO3/TYPO3.CMS/blob/master/typo3/sysext/frontend/ext_tables.sql#L135

How I reproduce this is running Functional Tests that creates these two tables.

So far I haven't experience any problems with the Running TYPO3 it self, but only within my tests, but I could potentially lead to problems, and I want to catch those before we experience them if possible.

Actions
Copy link
 #2

Updated by Tomas Norre Mikkelsen over 5 years ago

I've figured out that this is only a problem with TYPO3 7.6 so might not be priority.

I'm not sure which databases TYPO3 7.6 are supporting officially..

I've created a small repository that can help test this case.
https://github.com/tomasnorre/typo3-core-issue-88489

As you will see the test itself isn't doing anything beside `$this->assertTrue(true)`

The tests can be run with:

$ composer test:functional-mysql-5-6
$ composer test:functional-mysql-5-7
$ composer test:functional-maria-10-2
$ composer test:functional-maria-10-4

The two mysqls are working but the two mariadb isnt'

Actions
Copy link
 #3

Updated by Susanne Moog over 5 years ago

  • Tags set to CodingNight
Actions
Copy link
 #4

Updated by Benni Mack almost 5 years ago

  • Status changed from New to Rejected

Hi Tomas,

Thanks for your report.

I'm closing this ticket. TYPO3 v7.6 is in ELTS mode, so if you still need this, you can check with TYPO3.com / TYPO3 GmbH to make an offer to have this fixed. sorry but we won't release another TYPO3 v7.6 anymore.

Actions
Copy link

Also available in: Atom PDF