Bug #39357 Can't create table '.\sw\orders.frm' (errno: 150)

• Submitted: 10 Sep 2008 3:15
• Modified: 10 Sep 2008 3:57
• Reporter: Thiong Teck Kong
• Status: Closed
• Category: MySQL Server: Errors
• Severity: S2 (Serious)
• Version: MySQL 5.0.51b-community-nt
• OS: Windows
• CPU Architecture: Any
• Tags: Can't create table

[10 Sep 2008 3:15] Thiong Teck Kong

Description:
While creating a table called "orders", the following error occurred:

Can't create table '.\sw\orders.frm' (errno: 150)

In my knowledge, "order" is reserved word commonly used as part of SQL command "order by".  "orders" should be safe to be used as a table name.

How to repeat:
Create "orders" by simply execute the following SQL command in MySQL Query Browser:

create table orders (a char(8));

[10 Sep 2008 3:57] Thiong Teck Kong

Problem resolved due to missing "unsigned" in table refer to orders's primary key (where unsigned is defined).