Bug #15232 show index from tbl not working

• Submitted: 24 Nov 2005 15:24
• Modified: 24 Nov 2005 15:35
• Reporter: Jorge del Conde
• Status: Duplicate
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0.15
• CPU Architecture: Any

[24 Nov 2005 15:24] Jorge del Conde

Description:
I received a "table doesn't exist" error after executing show indexes:

mysql> create temporary table a(a int, index(a));
Query OK, 0 rows affected (0.11 sec)

mysql> insert into a values('1'),('2'),('3'),('4'),('5');
Query OK, 5 rows affected (0.02 sec)
Records: 5  Duplicates: 0  Warnings: 0

mysql> show index from a;
ERROR 1146 (42S02): Table 'test.a' doesn't exist
mysql> show index from a\G;
ERROR 1146 (42S02): Table 'test.a' doesn't exist
ERROR:
No query specified

mysql> analyze table a;
+--------+---------+----------+----------+
| Table  | Op      | Msg_type | Msg_text |
+--------+---------+----------+----------+
| test.a | analyze | status   | OK       |
+--------+---------+----------+----------+
1 row in set (0.02 sec)

mysql>

How to repeat:
see above

[24 Nov 2005 15:35] MySQL Verification Team

Duplicate of bug #15224.