Issue Bug Closed

#20401Extension Manager should ignore SQL COMMENT for extensions

Stephan Großberndt 05/07/09, 23:33 updated 10/02/18, 12:27

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)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.