TYPO3 Core

We have an enum field like this:

enum_field enum ('A', 'B', 'C') default 'A' not null

We switched from MySQL to MariaDB. On MySQL this made no problems in the DB comparison in the Install Tool, but on MariaDB the DB comparison always trys to alter it, because it detects the field as this (note the triple-quoting on the default value):

enum_field enum ('A', 'B', 'C') default '''A''' not null

Additional info: this does also happen if declaring the field as nullable and using default null - TYPO3 then detects default 'null' (the string "null", not the literal null value)!

It happens with both drivers, mysqliq and pdo_mysql. On MySQL it works with both drivers, on MariaDB this change is alwas suggested with both drivers.

I'm not sure whether this is a Doctrine DBAL or a TYPO3 bug.

Discovered on v10, probably valid in others, too (v11 uses teh same DBAL version, so I assume it's still in there).