Public bug reported:
Binary package hint: mysql-server-5.1
Package : 5.1.41-3ubuntu12.7
Release : Ubuntu 10.04.1 LTS
After creating table with the name 'key', 'keys' or other similar names,
beginning with 'key', cant access this table no more.
mysql> CREATE TABLE `asd` ( `key_id` int(11) NOT NULL auto_increment ,
PRIMARY KEY (`key_id`));
Query OK, 0 rows affected (0.07 sec)
mysql> select * from asd;
Empty set (0.00 sec)
mysql> drop table asd;
Query OK, 0 rows affected (0.00 sec)
mysql> CREATE TABLE `key` ( `key_id` int(11) NOT NULL auto_increment ,
PRIMARY KEY (`key_id`));
Query OK, 0 rows affected (0.04 sec)
mysql> select * from key;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'key'
at line 1
mysql> drop table key;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'key'
at line 1
** Affects: mysql-5.1 (Ubuntu)
Importance: Undecided
Status: New
** Tags: mysql
--
Problem with table 'key' and similar 'keys' etc.
https://bugs.launchpad.net/bugs/681891
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-5.1 in ubuntu.
--
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at:
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
