Bug #12770 DESC cannot display the info. about temporary table
Submitted: 23 Aug 2005 23:40 Modified: 21 Dec 2005 14:21
Reporter: Shuichi Tamagawa Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:5.0.12-bk Aug 17 OS:Linux (SuSE Linux 9.2)
Assigned to: Sergei Glukhov CPU Architecture:Any
Triage: D5 (Feature request)

[23 Aug 2005 23:40] Shuichi Tamagawa
Description:
DESC cannot display the information of the temporary table with multi-byte table name. For nomal table, this does not happen. Also, it was fine as of 5.0.10.

How to repeat:
mysql> create table `あ`(a int);
Query OK, 0 rows affected (0.11 sec)

mysql> desc `あ`;
+-------+---------+------+-----+---------+-------+
| Field | Type    | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| a     | int(11) | YES  |     | NULL    |       |
+-------+---------+------+-----+---------+-------+
1 row in set (0.01 sec)

mysql> drop table `あ`;
Query OK, 0 rows affected (0.00 sec)

mysql> create temporary table `あ`(a int);
Query OK, 0 rows affected (0.00 sec)

mysql> desc `あ`;
ERROR 1146 (42S02): Table 'test.あ' doesn't exist
mysql> drop table `あ`;
Query OK, 0 rows affected (0.00 sec)
[24 Aug 2005 9:28] Andrey Hristov
DESCRIBE does not work even with temporary tables with ascii names.

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

mysql> describe tmp_table;
ERROR 1146 (42S02): Table 'test.tmp_table' doesn't exist
[25 Aug 2005 23:34] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/28866
[6 Dec 2005 5:19] Sergei Glukhov
http://lists.mysql.com/internals/32821
[19 Dec 2005 10:46] Sergei Glukhov
Fixed in 5.0.18
[21 Dec 2005 14:21] Jon Stephens
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

Documented bugfix in 5.0.18 changelog. Closed.