[BUGFIX] DBAL: VARCHAR DEFAULT NULL PostgreSQL->MySQL syntax conversion 57/43957/3
authorMorton Jonuschat <m.jonuschat@mojocode.de>
Fri, 9 Oct 2015 21:21:40 +0000 (23:21 +0200)
committerMorton Jonuschat <m.jonuschat@mojocode.de>
Sat, 10 Oct 2015 09:20:39 +0000 (11:20 +0200)
commit573051827670c5f11c47d52acdd534d057d8bed5
tree92a32e3ffe662ae43240b435f1c4af7f45c7c477
parente2d2b18707899d199b2f1c1fded1e846882b7378
[BUGFIX] DBAL: VARCHAR DEFAULT NULL PostgreSQL->MySQL syntax conversion

PostgreSQL returns 'NULL::character varying' as the default value for a
field defined with 'VARCHAR(255) DEFAULT NULL'. The schema compare in
the InstallTool expects the MySQL syntax without the trailing
::character varying. Add support for this default value type to the
converter that rewrites the PostgreSQL default values to MySQL.

Resolves: #70558
Releases: master
Change-Id: If49962a3be265ca7a51e3f178a0682a9a073e9b7
Reviewed-on: http://review.typo3.org/43957
Reviewed-by: Nicole Cordes <typo3@cordes.co>
Reviewed-by: Christian Kuhn <lolli@schwarzbu.ch>
Reviewed-by: Andreas Fernandez <typo3@scripting-base.de>
Tested-by: Andreas Fernandez <typo3@scripting-base.de>
Reviewed-by: Morton Jonuschat <m.jonuschat@mojocode.de>
Tested-by: Morton Jonuschat <m.jonuschat@mojocode.de>
typo3/sysext/dbal/Classes/Database/Specifics/PostgresSpecifics.php
typo3/sysext/dbal/Tests/Unit/Database/DatabaseSpecificsPostgresqlTest.php