MySQL Bugs: #22048: Can't create table and/or primary key

Bug #22048	Can't create table and/or primary key
Submitted:	6 Sep 2006 9:17	Modified:	11 Sep 2006 16:31
Reporter:	Elise van Looij	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.1.1	OS:	10.4
Assigned to:	Alfredo Kojima	CPU Architecture:	Any
Tags:	primary key, row, table

Description:
When creating a primary key (checking the Primary Key and Auto Increment boxes), one gets an error 1067 Invalid default value for ID. The generated SQL looks like this:

CREATE TABLE `my_db`.`myTable` (
  `my_id` INT NOT NULL DEFAULT 0 AUTO_INCREMENT,
  PRIMARY KEY(`my_id`, `my_id`)
)
ENGINE = MYISAM
CHARACTER SET utf8;

Then I tried to simply an empty table and got an 1064 errror with the suggestion that I look in the manual for the proper syntax.

How to repeat:
Create a table with a primary key

Thank you for the bug report. Could you please test with latest released
version 1.2.2 Beta and if still you get the error please provide the
server version and Operating System.

Thanks in advance.

[6 Sep 14:46] Miguel Solorzano wrote:

>>Thank you for the bug report. Could you please test with latest
>>released
>>version 1.2.2 Beta and if still you get the error please provide the
>>server version and Operating System.

I would, but I can't find the 1.2.2 beta version. Could you point me in the right direction?
The version I reported on I downloaded from http://dev.mysql.com/downloads/gui-tools/5.0.html the MAC OSX 10.4 (Universal binaries). I downloaded that a few days ago to replace a version I got about two weeks ago which suffered from the same problems. My operating system is Mac OSX 10.4.7.

A new release which fixes the bug has been made recently. Please download
release 3 of the GUI tools bundle from http://dev.mysql.com/downloads/gui-tools/5.0.html