#82023Install Tool DB Analyzer tries to change all VARCHAR fields
Description
Hi developers,
I’m experiencing an issue with DB Migrations in Install Tool – the analyzer complains every time about all varchar fields. E.g.:
ALTER TABLE `be_groups` CHANGE `title` `title` VARCHAR(50) DEFAULT '' NOT NULL Current value: title VARCHAR(50) DEFAULT '''' NOT NULL COLLATE utf8_unicode_ci ALTER TABLE `be_groups` CHANGE `allowed_languages` `allowed_languages` VARCHAR(255) DEFAULT '' NOT NULL Current value: allowed_languages VARCHAR(255) DEFAULT '''' NOT NULL COLLATE utf8_unicode_ci ALTER TABLE `be_groups` CHANGE `pagetypes_select` `pagetypes_select` VARCHAR(255) DEFAULT '' NOT NULL Current value: pagetypes_select VARCHAR(255) DEFAULT '''' NOT NULL COLLATE utf8_unicode_ci ...
What I’ve also noticed: the reported DEFAULT value in DB consists of 4 quotes: '''', while proposed one contains two: ''
Altering table doesn’t change anything, and I’m quite unsure how to fix this.
TYPO3 8.7.4
PHP 7.1
MariaDB 10.2.7
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.