Actions
Bug #20401
closedExtension Manager should ignore SQL COMMENT for extensions
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)
Actions