MySQL Bug?

[The Little Guy]

this is a small bug I think I may have found....

 

When I run this query:

create table words (word_id int unsigned primary key auto_increment, word char(32));

 

it errors out saying that the table doesn't exist.

 

I then try this (changing "words" to "wrds"):

create table wrds (word_id int unsigned primary key auto_increment, word char(32));

 

it creates the table just fine

 

Next I run this:

rename table wrds to words;

 

It renames the table just fine.

 

So is it a bug that it couldn't create the table words but it can rename a table to words?

 

MySQL Version: 5.5.20-log

[Jessica]

Did you try creating it with backticks around the name.

`words`

[The Little Guy]

Did you try creating it with backticks around the name.

`words`

 

Yes I did, and I still get the same message.

[Maq]

It worked fine with this setup:

tim@tim-laptop:~$ mysql --version
mysql  Ver 14.14 Distrib 5.1.63, for debian-linux-gnu

 

mysql> create table words (word_id int unsigned primary key auto_increment, word char(32));
Query OK, 0 rows affected (0.13 sec)

mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| control        |
| testing        |
| words          |
+----------------+
3 rows in set (0.00 sec)

[PFMaBiSmAd]

it errors out saying that the table doesn't exist

 

What errors out? What's the exact error message?

[Mahngiel]

mysql  Ver 14.14 Distrib 5.5.24, for debian-linux-gnu (x86_64) using readline 6.2

[The Little Guy]

it errors out saying that the table doesn't exist

 

What errors out? What's the exact error message?

 

ERROR 1146 (42S02): Table 'indexer.words' doesn't exist

[xyph]

mysql> select version();
+------------+
| version()  |
+------------+
| 5.5.20-log |
+------------+
1 row in set (0.00 sec)

mysql> use db
Database changed
mysql> create table words (word_id int unsigned primary key auto_increment, word char(32));
Query OK, 0 rows affected (0.06 sec)