Issue Bug Closed

#41344Bug parsing ext_tables.sql

Kay Strobach 09/25/12, 11:36 updated 10/02/18, 12:16

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

Subtasks 1