The Little Guy Posted July 18, 2012 Share Posted July 18, 2012 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 Link to comment https://forums.phpfreaks.com/topic/265921-mysql-bug/ Share on other sites More sharing options...
Jessica Posted July 18, 2012 Share Posted July 18, 2012 Did you try creating it with backticks around the name. `words` Link to comment https://forums.phpfreaks.com/topic/265921-mysql-bug/#findComment-1362570 Share on other sites More sharing options...
The Little Guy Posted July 18, 2012 Author Share Posted July 18, 2012 Did you try creating it with backticks around the name. `words` Yes I did, and I still get the same message. Link to comment https://forums.phpfreaks.com/topic/265921-mysql-bug/#findComment-1362571 Share on other sites More sharing options...
Maq Posted July 18, 2012 Share Posted July 18, 2012 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) Link to comment https://forums.phpfreaks.com/topic/265921-mysql-bug/#findComment-1362579 Share on other sites More sharing options...
PFMaBiSmAd Posted July 18, 2012 Share Posted July 18, 2012 it errors out saying that the table doesn't exist What errors out? What's the exact error message? Link to comment https://forums.phpfreaks.com/topic/265921-mysql-bug/#findComment-1362583 Share on other sites More sharing options...
Mahngiel Posted July 18, 2012 Share Posted July 18, 2012 mysql Ver 14.14 Distrib 5.5.24, for debian-linux-gnu (x86_64) using readline 6.2 Link to comment https://forums.phpfreaks.com/topic/265921-mysql-bug/#findComment-1362596 Share on other sites More sharing options...
The Little Guy Posted July 18, 2012 Author Share Posted July 18, 2012 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 Link to comment https://forums.phpfreaks.com/topic/265921-mysql-bug/#findComment-1362606 Share on other sites More sharing options...
xyph Posted July 19, 2012 Share Posted July 19, 2012 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) Link to comment https://forums.phpfreaks.com/topic/265921-mysql-bug/#findComment-1362618 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.