Package: phpmyadmin
Version: 4:3.3.5-1
Severity: normal
MySQL returns success when trying to re-define a non-nullable column as
nullable if the column cannot be NULL due to it being part as a primary
key. This can be considered a bug or not, so feel free to reassign. As
http://dev.mysql.com/doc/refman/5.1/en/create-table.html says:
A |PRIMARY KEY| is a unique index where all key columns must be defined
as |NOT NULL|. If they are not explicitly declared as |NOT NULL|, MySQL
declares them so implicitly (and silently).
What is definitely a bug is phpmyadmin saying that "Table
tiki_user_watches has been altered successfully", when the table was not
altered.
For example, this was the query:
|ALTER TABLE `tiki_user_watches` CHANGE `email` `email` VARCHAR( 200 )
CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT ''|