Xupeng's blog

圆外之大,心向往之

Gentoo MySQL 5.0.92 数据表不可见的 bug

Gentoo 维护的 MySQL 5.0.92 有数据表不可见的 bug,表现为:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
xupeng@localhost [(none)] mysql> use test;
Database changed
xupeng@localhost [test] mysql> create table testing (type tinyint) engine=innodb;
Query OK, 0 rows affected (0.26 sec)

xupeng@localhost [test] mysql> show tables;
Empty set (0.00 sec)

xupeng@localhost [test] mysql> show tables from information_schema;
Empty set (0.00 sec)

xupeng@localhost [test] mysql> select table_name from information_schema.tables where table_schema='test';
+------------+
| table_name |
+------------+
| testing    | 
+------------+
1 row in set (0.00 sec)

xupeng@localhost [test] mysql> insert into testing values (1);
Query OK, 1 row affected (0.04 sec)

xupeng@localhost [test] mysql> select * from testing;
+------+
| type |
+------+
|    1 | 
+------+
1 row in set (0.00 sec)

如上,数据表可正常读写,但 show tables 看不到,此问题和客户端无关。

5.0.92 官方版本则无此 bug。

Comments