Bug #89084

DB Analyzer Compare Fails with Typo3 9.5.8 and MariaDB 10.3

Added by Lioh Moeller 18 days ago.

Status:
New
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2019-09-05
Due date:
% Done:

0%

TYPO3 Version:
9
PHP Version:
7.2
Tags:
DBAL MariaDB
Complexity:
Is Regression:
Sprint Focus:

Description

We have set up Typo3 according to the specifications listed here: https://get.typo3.org/version/9#system-requirements

As database engine we are using MariaDB 10.3 as listed as supported there.

When we run the DB Analyzer in Maintenance / Analyse Database, we got the following messages:

Typo3 Test Result:
============================================================================================
ALTER TABLE `be_groups` CHANGE `title` `title` VARCHAR(50) DEFAULT '' NOT NULL
Current value: title VARCHAR(50) DEFAULT '''' NOT NULL COLLATE utf8mb4_unicode_ci
...

The test function used for this seems to be:

Typo3 Compare Source: /typo3/sysext/core/ext_tables.sql
/.../
CREATE TABLE be_groups (
        title varchar(50) DEFAULT '' NOT NULL,
/.../

SQL Database Read: SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, 
                          COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, 
                          COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, 
                          COLLATION_NAME AS Collation 
                     FROM information_schema.COLUMNS 
                    WHERE TABLE_SCHEMA = 'typo3_tri_hp_eu' 
                      AND TABLE_NAME = 'be_groups' 
                    ORDER BY ORDINAL_POSITION ASC

The actual DB result from a manual query is:

SQL DB Result:
============================================================================================
Field    Type        Null    Key    Default        Extra    Comment    CharacterSet    Collation
title    varchar(50)    NO            ''                            utf8mb4            utf8mb4_unicode_ci

When I manually compare it, the results are actually the same:

        title varchar(50) DEFAULT '' NOT NULL,
        title varchar(50)            ''

But still the Typo3 DB Compare function fails, probably because the test function adds ' ' around the result.

DBAL is the version shipped with Typo3 9.5.8 which is actually 2.8.

Also available in: Atom PDF