Bug #92965 mysqldiff add AUTO_INCREMENT without setting value
Submitted: 26 Oct 2018 12:04 Modified: 26 Oct 2018 18:04
Reporter: salem ardjoune Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Utilities Severity:S3 (Non-critical)
Version:1.6.1 OS:Any
Assigned to: MySQL Verification Team CPU Architecture:Any

[26 Oct 2018 12:04] salem ardjoune
Description:
I want to use mysqldiff to compare the schema of two sql tables (just the schema, not the data).
I run the command on two tables (table1 and table2), which are exactly the same except that table one as a column that has AUTO_INCREMENT option but the same column in table2 doesn't have this option. 

I discovered that if I don't use the --skip-table-options, table that are the same but that have different AUTO_INCREMENT values will fail, so I must use this option. However, with this option, when comparing table1 and table2 will fail but the transformation doesn't add AUTO_INCREMENT. Is there an option to compare only the structure (including AUTO_INCREMENT) but not the values?

How to repeat:
Use mysqldiff with the option --skip-table-options to compare two tables which have the same structure, with AUTO_INCREMENT activated for one table and deactivated for other
[26 Oct 2018 18:04] MySQL Verification Team
The binary that was maintained by us is no longer being developed. It's now under "sustaining support" only so you are encouraged to move to MySQL Shell
https://dev.mysql.com/doc/mysql-shell/8.0/en/

If you want to continue using mysqldiff you might want to report a problem here: https://github.com/aspiers/mysqldiff/issues

all best
Bogdan