| Bug #12126 | Lost connection when querying INFORMATION_SCHEMA.TABLES | ||
|---|---|---|---|
| Submitted: | 22 Jul 2005 23:54 | Modified: | 23 Jul 2005 0:02 |
| Reporter: | Markus Popp | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | 5.0.9-beta | OS: | Linux (Linux) |
| Assigned to: | CPU Architecture: | Any | |
[22 Jul 2005 23:54]
Markus Popp
[23 Jul 2005 0:02]
MySQL Verification Team
I was unable to repeat with current BK server:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.11-beta
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use INFORMATION_SCHEMA;
Database changed
mysql> select TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE from
-> INFORMATION_SCHEMA.TABLES;
+--------------------+---------------------------------------+------------+
| TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE |
+--------------------+---------------------------------------+------------+
| information_schema | SCHEMATA | TEMPORARY |
| information_schema | TABLES | TEMPORARY |
| information_schema | COLUMNS | TEMPORARY |
| information_schema | CHARACTER_SETS | TEMPORARY |
| information_schema | COLLATIONS | TEMPORARY |
| information_schema | COLLATION_CHARACTER_SET_APPLICABILITY | TEMPORARY |
| information_schema | ROUTINES | TEMPORARY |
| information_schema | STATISTICS | TEMPORARY |
| information_schema | VIEWS | TEMPORARY |
| information_schema | USER_PRIVILEGES | TEMPORARY |
| information_schema | SCHEMA_PRIVILEGES | TEMPORARY |
| information_schema | TABLE_PRIVILEGES | TEMPORARY |
| information_schema | COLUMN_PRIVILEGES | TEMPORARY |
| information_schema | TABLE_CONSTRAINTS | TEMPORARY |
| information_schema | KEY_COLUMN_USAGE | TEMPORARY |
| information_schema | TRIGGERS | TEMPORARY |
| mysql | columns_priv | BASE TABLE |
| mysql | db | BASE TABLE |
| mysql | func | BASE TABLE |
| mysql | help_category | BASE TABLE |
| mysql | help_keyword | BASE TABLE |
| mysql | help_relation | BASE TABLE |
| mysql | help_topic | BASE TABLE |
| mysql | host | BASE TABLE |
| mysql | proc | BASE TABLE |
| mysql | procs_priv | BASE TABLE |
| mysql | tables_priv | BASE TABLE |
| mysql | time_zone | BASE TABLE |
| mysql | time_zone_leap_second | BASE TABLE |
| mysql | time_zone_name | BASE TABLE |
| mysql | time_zone_transition | BASE TABLE |
| mysql | time_zone_transition_type | BASE TABLE |
| mysql | user | BASE TABLE |
| test | V_ADR_FULL | VIEW |
| test | V_LOCA | VIEW |
| test | adrhdr | BASE TABLE |
| test | loca | BASE TABLE |
| test | mdl152_user | BASE TABLE |
| test | tb1 | BASE TABLE |
| test | test | BASE TABLE |
+--------------------+---------------------------------------+------------+
40 rows in set (0.30 sec)
mysql>
