Bug #71480 error not visible with show warnings

• Submitted: 26 Jan 2014 3:12
• Modified: 27 Jan 2014 8:27
• Reporter: Federico Razzoli
• Status: Verified
• Category: MySQL Server: Errors
• Severity: S3 (Non-critical)
• Version: 5.6
• OS: Any
• CPU Architecture: Any

[26 Jan 2014 3:12] Federico Razzoli

Description:
If you issue a REPAIR TABLE on an InnoDB table, you get a Note. But if you issue a SHOW WARNINGS, the Note is not showed.

How to repeat:
MariaDB [test]> CREATE TABLE x (c1 INT, c2 INT, INDEX idxc1 (c1)) ENGINE=InnoDB;
Query OK, 0 rows affected (0.57 sec)

MariaDB [test]> REPAIR TABLE x;
+--------+--------+----------+---------------------------------------------------------+
| Table  | Op     | Msg_type | Msg_text                                                |
+--------+--------+----------+---------------------------------------------------------+
| test.x | repair | note     | The storage engine for the table doesn't support repair |
+--------+--------+----------+---------------------------------------------------------+
1 row in set (0.00 sec)

MariaDB [test]> SHOW WARNINGS;
Empty set (0.00 sec)

Suggested fix:
The warning should be showed. It's useful.

[27 Jan 2014 8:27] MySQL Verification Team

Hello Federico,

Thank you for the bug report.
Verified as described.

Thanks,
Umesh