SHOW TABLES does not show temporary tables in version 3.23.44

Hello there.

How-to-repeat:

The subject says it all, actually, but here it is once more to satisfy
mail filtering requirements:

1) Create a temporary table with "CREATE TEMPORARY new_temp_table ...".
2) This new temporary table 'new_temp_table' will not appear in "SHOW
TABLES" and finding it again is left up to the good memory of the user
as only direct and exact reference by name to the temporary table
results in its successful handling.

More details:
a) SHOW TABLES; SHOW TABLE STATUS; and even SHOW TABLES LIKE
'new_temp_table'; and SHOW TABLE STATUS LIKE 'new_temp_table'; do not
show the temporary table. Even using LIKE '%' returns only the permanent
tables, but not the temporary ones.
b) SHOW DESCRIBE TABLE new_temp_table; and DESCRIBE TABLE
new_temp_table; work correctly, but only when being fed the exact name
of the temporary table.
c) Although SHOW CREATE TABLE new_temp_table; appears to work, the
output routine creates a somewhat broken output as the two-column
ascii-drawn result table breaks on the second line, flowing the second
column as if there were only one starting from the second row of the
output body (not the headers). Here is a simple example:

+-------+----------------------------------~
| Table | Create Table
+-------+----------------------------------~
| test | CREATE TEMPORARY TABLE `test` (
`gubba` int(11) default NULL
) TYPE=MyISAM |
+-------+----------------------------------~

Note how the vertical pipe characters to separate the output into
columns are not set (or overwritten by the flowing output as it appears).

Dunno whether this is of any importance at all for the present state of
things, but I cannot check since the MySQL bugtracker does not seem to
be publicly accessible.

greetings,
Daniel



------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13394@lists.mysql.com
To unsubscribe, e-mail

Re: SHOW TABLES does not show temporary tables in version 3.23.44

On Friday 03 January 2003 08:28, Daniel Pisano wrote:
> Hello there.
>
> How-to-repeat:
>
> The subject says it all, actually, but here it is once more to
> satisfy mail filtering requirements:
>
> 1) Create a temporary table with "CREATE TEMPORARY
> new_temp_table ...". 2) This new temporary table
> 'new_temp_table' will not appear in "SHOW TABLES" and finding
> it again is left up to the good memory of the user as only
> direct and exact reference by name to the temporary table
> results in its successful handling.


Thanks for your feedback. I've added this to the list of our
requested features.


--
MySQL 2003 Users Conf. -> http://www.mysql.com/events/uc2003/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Peter Zaitsev
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Moscow, Russia
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13413@lists.mysql.com
To unsubscribe, e-mail