Original DDL before parsing:
CREATE TABLE `t3` ( # `id` int(11) NOT NULL AUTO_INCREMENT, # `f22aBcDe` int(10) unsigned DEFAULT NULL COMMENT 'xxx`xxx', # `f23aBc` int(10) unsigned NOT NULL DEFAULT '255' COMMENT 'yyy', # PRIMARY KEY (`id`) # ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1
DDL after buggy parsing:
CREATE TABLE `t3` ( # `id` int(11) NOT NULL AUTO_INCREMENT, # `f22abcde` int(10) unsigned DEFAULT NULL COMMENT 'xxx`xxx', # `f23aBc` int(10) unsigned not null default '255' comment 'yyy', # primary key (`id`) # ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1
Expected behavior:
CREATE TABLE `t3` ( # `id` int(11) NOT NULL AUTO_INCREMENT, # `f22abcde` int(10) unsigned DEFAULT NULL COMMENT 'xxx`xxx', # `f23abc` int(10) unsigned NOT NULL DEFAULT '255' COMMENT 'yyy', # primary key (`id`) # ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1
Original DDL before parsing:
CREATE TABLE `t3` (
# `id` int(11) NOT NULL AUTO_INCREMENT,
# `f22aBcDe` int(10) unsigned DEFAULT NULL COMMENT 'xxx`xxx',
# `f23aBc` int(10) unsigned NOT NULL DEFAULT '255' COMMENT 'yyy',
# PRIMARY KEY (`id`)
# ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1
DDL after buggy parsing:
CREATE TABLE `t3` (
# `id` int(11) NOT NULL AUTO_INCREMENT,
# `f22abcde` int(10) unsigned DEFAULT NULL COMMENT 'xxx`xxx',
# `f23aBc` int(10) unsigned not null default '255' comment 'yyy',
# primary key (`id`)
# ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1
Expected behavior:
CREATE TABLE `t3` (
# `id` int(11) NOT NULL AUTO_INCREMENT,
# `f22abcde` int(10) unsigned DEFAULT NULL COMMENT 'xxx`xxx',
# `f23abc` int(10) unsigned NOT NULL DEFAULT '255' COMMENT 'yyy',
# primary key (`id`)
# ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1