#41344Bug parsing ext_tables.sql
Description
Hello Guys,
in theory these two statements should be seen as equal (in sql)
CREATE TABLE tx_coreupdate_cache (
id INT(11) INSIGNED NOT NULL AUTO_INCREMENT
)
based on example from: http://wiki.typo3.org/Caching_framework#Cache_registration_and_usage_for_extensions_supporting_TYPO3_4.3_and_above
This code causes constant warnings of not uptodate database for this extension, if i change the case like below everything works fine.
This is reproduceable in 4.5 to 4.7 :D
CREATE TABLE tx_coreupdate_cache (
id int(11) unsigned NOT NULL auto_increment,
)
Solution should be to either convert all reserved words to lower / to uppercase and then do the comparision, or change the examples in the wiki :D
Regards
Kay
Reviews 6
- TYPO3_6-0 21353[BUGFIX] False-Positives in SQL comparison
- TYPO3_6-1 21352[BUGFIX] False-Positives in SQL comparison
- TYPO3_4-5 21355[BUGFIX] False-Positives in SQL comparison
- TYPO3_4-7 21354[BUGFIX] False-Positives in SQL comparison
- main 21371[BUGFIX] Fix missing single quotes in SchemaMigratorTest
- main 19630[BUGFIX] False-Positives in SQL comparison