Bug #6153 Migration problem
Submitted: 19 Oct 2004 7:18 Modified: 19 Nov 2004 9:11
Reporter: Struchkov Vladimir Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:3.23.58 --> 4.1.6-gamma OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[19 Oct 2004 7:18] Struchkov Vladimir 
Description:
I have  small mysql dump for table  from mysql 3.23.58

create table newsgroup (
newsGroupId int unsigned not null auto_increment default 0,
name varchar(255) not null default '',
catId int unsigned not null default 0, key(catId),
primary key(newsGroupId));

I install new mysql version, but this dump is wrong now. I see  " ERROR 1067 (42000): Invalid default value for 'newsGroupId' " in my mysql-client.

In my opinion this staff is incompatibility with older versions

How to repeat:
always
[19 Oct 2004 8:36] MySQL Verification Team 
Hi,

Thank you for the report. From version 4.1 you can't specify DEFAULT value for AUTO_INCREMENT column.
I tested your example with v3.23.58, but mysqldump always generates the output without DEFAULT clause for auto_increment. So it works fine with 4.1.
How did you do thedump of 'newgroup' table?
[19 Oct 2004 9:11] Struchkov Vladimir 
I write this dump manually. 
It's seems to me inability to specify default value for this field is problem of compatibility between two versions. 
I have already understood that this is not critical problem.
[14 Feb 2005 22:54] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".