From 04be293dfa18ee0e75d26f1cae061b692e04a232 Mon Sep 17 00:00:00 2001 From: Mingxing LAI Date: Wed, 19 Oct 2016 16:33:59 +0800 Subject: [PATCH] Fix issue #15 mysqldiff generate wrong result for SQL statement with auto_increment --- mysql/utilities/common/sql_transform.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/mysql/utilities/common/sql_transform.py b/mysql/utilities/common/sql_transform.py index 30989e6..09819ce 100644 --- a/mysql/utilities/common/sql_transform.py +++ b/mysql/utilities/common/sql_transform.py @@ -630,7 +630,7 @@ def _get_column_format(col_data): def_val = to_sql(def_val) values['default'] = " DEFAULT %s" % def_val if len(col_data[_COLUMN_EXTRA]) > 0: - if col_data[_COLUMN_EXTRA].upper() != "AUTO_INCREMENT": + if col_data[_COLUMN_EXTRA].upper() == "AUTO_INCREMENT": values['extra'] = " %s" % col_data[_COLUMN_EXTRA] if len(col_data[_COLUMN_COMMENT]) > 0: values['comment'] = " COMMENT '%s'" % col_data[_COLUMN_COMMENT]