Bug #14736 Cannot create table with primary id column

• Submitted: 8 Nov 2005 8:24
• Modified: 8 Nov 2005 8:45
• Reporter: Andreas Götz
• Status: Closed
• Category: MySQL Administrator
• Severity: S2 (Serious)
• Version: 1.1.4
• OS: Windows (WinXP SP2)
• CPU Architecture: Any

[8 Nov 2005 8:24] Andreas Götz

Description:
I'm trying to create a table with a primary id column (integer autoincrement not null) using MA. This code is produced:

row_id INTERGER UNSIGNED NOT NULL DEFAULT 0 AUTO_INCREMENT

The DEFAULT 0 creates a SQL error. I couldn't find a way to define the table in MA.

How to repeat:
Create MyISAM table with primary id column (integer not null autoincrement)

Suggested fix:
.

[8 Nov 2005 8:45] Andreas Götz

Sorry for posting multiple time- received server error 500 repeatedly.

[14 Nov 2005 12:18] Mickael Besson

This error occurs also in v1.1.5 ...