Bug #7218 information_schema: errors in "tables"

• Submitted: 13 Dec 2004 1:30
• Modified: 24 Dec 2004 7:01
• Reporter: Peter Gulutzan
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0.3-alpha-debug
• OS: Linux (SUSE 9.2)
• Assigned to: Sergei Glukhov
• CPU Architecture: Any

[13 Dec 2004 1:30] Peter Gulutzan

Description:
The eighteenth column of information_schema.tables should 
be TABLE_COLLATION not COLLATION, 
and the values in TABLE_ROWS should be non-zero for 
information_schema tables, and the table_type values 
for ordinary base tables should be 'BASE TABLE' not 
'TEMPORARY'. 
 

How to repeat:
mysql> select table_collation from information_schema.tables; 
ERROR 1054 (42S22): Unknown column 'table_collation' in 'field list' 
 
mysql> select sum(table_rows) from information_schema.tables where table_schema = 
'information_schema'; 
+-----------------+ 
| sum(table_rows) | 
+-----------------+ 
|               0 | 
+-----------------+ 
1 row in set (0.05 sec) 
 
mysql> select table_type from information_schema.tables where table_schema = 'mysql'; 
+------------+ 
| table_type | 
+------------+ 
| TEMPORARY  | 
... 
+------------+ 
17 rows in set (0.01 sec)

[24 Dec 2004 7:01] Sergei Glukhov

Fixed in 5.0 source tree