* Ben Clewett > I was trying to create a table named 'con' on version 3.23.52-max-nt and > found my request was ignored: > > mysql> > create table if not exists con ( > code integer unsigned not null auto_increment primary key, > ... > ... > ) type=innodb; > Query OK, 0 rows affected (0.00 sec) > > A 'show tables' would not list this table. Nothing showed up in the > error log. > > Oddly, I had some foreign key's defined to this table 'con' in later > tables, which were accepted without problem?? > > Can anybody explain what's going on, and what I should / should not be > doing??
CON is a special device name in DOS (and win), so is NUL, LPT1, LPT2, COM1, COM2 and so on. This should not prevent you from creating a table with these names, but I am guessing this is the reason for the bug. I tried this on my 3.23.30-gamma on w2k: mysql> create table CON (id int); ERROR 1050: Table 'con' already exists mysql> create table NUL (id int); ERROR 1050: Table 'nul' already exists mysql> create table LPT1 (id int); ERROR 1050: Table 'lpt1' already exists mysql> create table LPT2 (id int); ERROR 1050: Table 'lpt2' already exists mysql> create table LPT3 (id int); ERROR 1050: Table 'lpt3' already exists mysql> create table COM1 (id int); ERROR 1050: Table 'com1' already exists mysql> create table COM2 (id int); ERROR 1050: Table 'com2' already exists None of the tables really existed. I experience this only on win platform, no problem on linux or solaris. -- Roger --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php