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] MySQL Verification Team
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)

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.051 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.