Description:
The SHOW FULL COLUMNS command with temporary table returns the error message:
ERROR 1146 (42S02): Table 'test.mytemptable' doesn't exist.
The same statement is working with previous MySQL version 4.1.10
How to repeat:
mysql> create temporary table mytemptable (i int);
Query OK, 0 rows affected (0.51 sec)
mysql> show full columns from mytemptable;
ERROR 1146 (42S02): Table 'test.mytemptable' doesn't exist
mysql> \s
--------------
mysql Ver 14.12 Distrib 5.0.15, for Win32 (ia32)
Connection id: 1
Current database: test
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server version: 5.0.15-nt-log
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
TCP port: 3306
Uptime: 1 min 12 sec
Threads: 1 Questions: 5 Slow queries: 0 Opens: 2 Flush tables: 1 Open table
s: 6 Queries per second avg: 0.069
--------------
Here how it behaves with previous version:
mysql> create temporary table mytemptable (i int);
Query OK, 0 rows affected (0.09 sec)
mysql> show full columns from mytemptable;
+-------+---------+-----------+------+-----+---------+-------+------------------
---------------+---------+
| Field | Type | Collation | Null | Key | Default | Extra | Privileges
| Comment |
+-------+---------+-----------+------+-----+---------+-------+------------------
---------------+---------+
| i | int(11) | NULL | YES | | NULL | | select,insert,upd
ate,references | |
+-------+---------+-----------+------+-----+---------+-------+------------------
---------------+---------+
1 row in set (0.02 sec)
mysql> \s
--------------
mysql Ver 14.7 Distrib 4.1.10, for Win95/Win98 (i32)
Connection id: 2
Current database: test
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server version: 4.1.10-nt-log
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
TCP port: 3307
Uptime: 3 min 15 sec
Threads: 1 Questions: 7 Slow queries: 0 Opens: 13 Flush tables: 1 Open tabl
es: 0 Queries per second avg: 0.036
--------------
Description: The SHOW FULL COLUMNS command with temporary table returns the error message: ERROR 1146 (42S02): Table 'test.mytemptable' doesn't exist. The same statement is working with previous MySQL version 4.1.10 How to repeat: mysql> create temporary table mytemptable (i int); Query OK, 0 rows affected (0.51 sec) mysql> show full columns from mytemptable; ERROR 1146 (42S02): Table 'test.mytemptable' doesn't exist mysql> \s -------------- mysql Ver 14.12 Distrib 5.0.15, for Win32 (ia32) Connection id: 1 Current database: test Current user: root@localhost SSL: Not in use Using delimiter: ; Server version: 5.0.15-nt-log Protocol version: 10 Connection: localhost via TCP/IP Server characterset: latin1 Db characterset: latin1 Client characterset: latin1 Conn. characterset: latin1 TCP port: 3306 Uptime: 1 min 12 sec Threads: 1 Questions: 5 Slow queries: 0 Opens: 2 Flush tables: 1 Open table s: 6 Queries per second avg: 0.069 -------------- Here how it behaves with previous version: mysql> create temporary table mytemptable (i int); Query OK, 0 rows affected (0.09 sec) mysql> show full columns from mytemptable; +-------+---------+-----------+------+-----+---------+-------+------------------ ---------------+---------+ | Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment | +-------+---------+-----------+------+-----+---------+-------+------------------ ---------------+---------+ | i | int(11) | NULL | YES | | NULL | | select,insert,upd ate,references | | +-------+---------+-----------+------+-----+---------+-------+------------------ ---------------+---------+ 1 row in set (0.02 sec) mysql> \s -------------- mysql Ver 14.7 Distrib 4.1.10, for Win95/Win98 (i32) Connection id: 2 Current database: test Current user: root@localhost SSL: Not in use Using delimiter: ; Server version: 4.1.10-nt-log Protocol version: 10 Connection: localhost via TCP/IP Server characterset: latin1 Db characterset: latin1 Client characterset: latin1 Conn. characterset: latin1 TCP port: 3307 Uptime: 3 min 15 sec Threads: 1 Questions: 7 Slow queries: 0 Opens: 13 Flush tables: 1 Open tabl es: 0 Queries per second avg: 0.036 --------------