I can confirm this bug.
To reproduce, create a database name testdb and run the command:
$ mysql -u root testdb -e 'CREATE TABLE test ( `testId` int unsigned NOT
NULL auto_increment, PRIMARY KEY (`testId`));'
Then run mysqldump:
$ mysqldump -u root --no-data --compatible=mysql40 testdb | grep testId.*NOT
`testId` int(10) unsigned NOT NULL,
The previous line should have an auto_increment property:
$ mysqldump -u root --no-data --compatible=mysql40 testdb | grep testId.*NOT
`testId` int(10) unsigned NOT NULL auto_increment,
** Changed in: mysql-dfsg-5.0 (Ubuntu)
Importance: Undecided => Medium
Status: New => Triaged
--
mysqldump --opt --compatible=mysql40 fails to preserve auto_increment
https://bugs.launchpad.net/bugs/65217
You received this bug notification because you are a member of Ubuntu
Bugs, which is the bug contact for Ubuntu.
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
