#21408Various crashes in SQL parsing when using install tool to compare and fix database.
Description
I tried updating a rather outdated TYPO3 database and got a few errors.
When updating a table where the engine type is the only difference I get:
ERROR: Query could not be parsed: “SQL engine parse ERROR: No action CHANGE, DROP or ADD found!: near “ENGINE=InnoDB “”. Query: “ALTER TABLE cache_hash ENGINE=InnoDB;”
When removing a field by prefixing the field type is missing:
ERROR: Query could not be parsed: “SQL engine parse ERROR: Field type unknown in parseFieldDef()!: near “(250) default ‘’ ”“. Query: “ALTER TABLE cache_hash CHANGE identifier zzz_deleted_identifier (250) default ‘’;”
When dropping all tables and setting up from scratch a compare gives tons of differences in engine type and field defaults…
PHP 5.3.0, MySQL 5.0.86, TYPO3 4.x trunk as of today, 11:00+1
(issue imported from #M12404)
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.