Bug #113575 mysqlpump generate wrong stmt when deal with AUTO_INCREMENT cloumn
Submitted: 8 Jan 2024 9:57 Modified: 8 Jan 2024 10:04
Reporter: zongyi chen Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Server: mysqlpump Command-line Client Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[8 Jan 2024 9:57] zongyi chen 
Description:
mysqlpump generate wrong sql when deal with auto_increment column

How to repeat:
1.CREATE TABLE t1 (f1 INT AUTO_INCREMENT, UNIQUE KEY(f1));

2./home/czy/open/mysql/bin/mysql -uroot -h127.0.0.1 -P8035 < "/home/czy/test1.sql"

3.drop table t1;

4./home/czy/open/mysql/bin/mysql -uroot -h127.0.0.1 -P8035 < "/home/czy/test1.sql"

you will see 
`ERROR 1075 (42000) at line 17: Incorrect table definition; there can be only one auto column and it must be defined as a key`

Suggested fix:
null
[8 Jan 2024 9:59] zongyi chen 
step2 is:/home/czy/open/mysql/bin/mysqlpump -uroot -h127.0.0.1 -P8035 --databases test > "/home/czy/test1.sql"
[8 Jan 2024 10:04] MySQL Verification Team 
Hi Mr. chen,

Thank you very much for your bug report.

However, mysqlpump is a discontinued product and it is no longer supported.

If you find a bug like this in mysqldump utility program, then please file a new bug report.

Thanks in advance.