MySQL Bugs: #1902: Can't create a table named groups.

Bug #1902	Can't create a table named groups.
Submitted:	20 Nov 2003 7:15	Modified:	20 Nov 2003 7:25
Reporter:	[ name withheld ]	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S3 (Non-critical)
Version:	4.0.15a	OS:	Linux (Linux)
Assigned to:	Dean Ellis	CPU Architecture:	Any

Description:

It's not possible to create a InnoDB table named groups. groups is not listed as a reserved word and surrounding with backticks didn't help.

The following errormessage is returned:

ERROR 1005: Can't create table './testdb/groups.frm' (errno: 150)

If the table type is MyISAM it works as expected.

How to repeat:
CREATE TABLE `groups` (somecol VARCHAR(10)) TYPE=InnoDB;

I cannot duplicate this using the latest BitKeeper sources.  InnoDB accepts "groups" as a table name.

Check the manual regarding InnoDB errno 150.

Thank you.

I have this problem too. I'm using MySQL 4.1 and this is what happened:

I created t InnoDB table with the name m_Client. When I added some foreign keys to the table the server hung for 10 minutes. When it was back the table m_Client was gone and if I tried to create a new table with this name it didnt work : 

Error message was something like this: Cant create table m_Client (errno:150).

I can create the same table with a different name like m_Client2.

 / Daniel

The problem seems to be foreign keys and InnoDb.  I remember having this problem with 4.1, but am experiencing the problem with 5.0.17.  If someone wants the full schema I can provide it, but for the sake of reducing the noise I'll leave it out.  Even with the "SET FOREIGN_KEY_CHECKS = 0;" at the start of the script, the SQL script generated using WorkBench (which is a great tool) fails when it runs into tables with CONSTRAINTS.  Will try adding the FK's after table creation and see if this provides a work-around.

still I am facing this issue 
ALTER TABLE test.hrm_workflows ADD CONSTRAINT `FK_hrm_workflows_1` FOREIGN KEY `FK_hrm_workflows_1` (site_id)
REFERENCES hrm_site (site_id)
ON DELETE RESTRICT
ON UPDATE RESTRICT;