Issue Bug Closed

#89084DB Analyzer Compare Fails with Typo3 9.5.8 and MariaDB 10.3

Lioh Moeller 09/05/19, 07:40 updated 01/27/20, 21:28

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.

Reviews 0

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