Bug #12770 DESC cannot display the info. about temporary table
Submitted: 24 Aug 2005 1:40 Modified: 21 Dec 2005 15:21
Reporter: Shuichi Tamagawa
Status: Closed
Category:Server Severity:S4 (Feature request)
Version:5.0.12-bk Aug 17 OS:Linux (SuSE Linux 9.2)
Assigned to: Sergey Gluhov Target Version:
Triage: D5 (Feature request)

[24 Aug 2005 1: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 11: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
[26 Aug 2005 1: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 6:19] Sergey Gluhov 
http://lists.mysql.com/internals/32821
[19 Dec 2005 11:46] Sergey Gluhov 
Fixed in 5.0.18
[21 Dec 2005 15: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.