Bug #83838 Fix issue #15 mysqldiff generate wrong result for SQL statement with auto_increm
Submitted: 16 Nov 2016 9:53 Modified: 16 Nov 2016 9:57
Reporter: OCA Admin (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Utilities Severity:S3 (Non-critical)
Version:1.6.x OS:Any
Assigned to: CPU Architecture:Any

[16 Nov 2016 9:53] OCA Admin
Description:
This bug tracks a contribution by mingxing lai (Github user: lalor) as described in http://github.com/mysql/mysql-utilities/pull/16

How to repeat:
See description

Suggested fix:
See contribution code attached
[16 Nov 2016 9:53] OCA Admin
Contribution submitted via Github - Fix issue #15 mysqldiff generate wrong result for SQL statement with auto_increm 
(*) Contribution by mingxing lai (Github lalor, mysql-utilities/pull/16#issuecomment-260875527): I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: git_patch_89964732.txt (text/plain), 1.07 KiB.

[16 Nov 2016 9:57] Umesh Shastry
Hello Mingxing lai,

Thank you for the report and contribution.

Thanks,
Umesh
[2 Nov 2018 15:32] Buchan Milne
Is this change released?

I ran into it, and so has someone else recently (https://github.com/mysql/mysql-utilities/issues/40 )

If it hasn't been release, it may make sense to use:
values['extra'] = " %s" % col_data[_COLUMN_EXTRA].upper()

instead of:

values['extra'] = " %s" % col_data[_COLUMN_EXTRA]

(to be consistent with the way other column options are formatted)