#20401Extension Manager should ignore SQL COMMENT for extensions
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.