Project

General

Profile

Actions

Bug #20401

closed

Extension Manager should ignore SQL COMMENT for extensions

Added by Stephan Großberndt over 15 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Category:
Extension Manager
Target version:
-
Start date:
2009-05-07
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.2
PHP Version:
5.2
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

When an extension adds a table with a field containing a SQL COMMENT

CREATE TABLE tx_comment_test (
uid int(11) COMMENT 'ID of the record',
) COMMENT 'Testing Table';

each time the Information of the extension is refreshed, it says an update is needed:

Update needed:
Changing fields
ALTER TABLE tx_comment_test CHANGE uid uid int(11) COMMENT 'ID of the record';
Current value: int(11)

because the COMMENT is not detected.

Either the comment in the sql-file should be ignored when comparing sql-file to database or compared to the comment in the database.

The comment is displayed by the SHOW CREATE TABLE and SHOW FULL COLUMNS statements. (http://dev.mysql.com/doc/refman/5.0/en/create-table.html)
(issue imported from #M11048)


Related issues 1 (0 open1 closed)

Is duplicate of TYPO3 Core - Bug #21343: Database Analyser does't undestand comments in sql fileClosed2009-10-22

Actions
Actions

Also available in: Atom PDF