Project

General

Profile

Actions

Bug #41344

closed

Bug parsing ext_tables.sql

Added by Kay Strobach about 12 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Extension Manager
Target version:
-
Start date:
2013-06-12
Due date:
% Done:

100%

Estimated time:
(Total: 0.00 h)
TYPO3 Version:
4.5
PHP Version:
Tags:
Complexity:
easy
Is Regression:
Sprint Focus:

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


Subtasks 1 (0 open1 closed)

Bug #49072: Fix missing single quotes in SchemaMigratorTestClosed2013-06-12

Actions
Actions

Also available in: Atom PDF