Percona Toolkit moved to https://jira.percona.com/projects/PT

  1. Bug #1708749
  2. Comment #2

Comment 2 for bug 1708749

Revision history for this message
Sveta Smirnova (svetasmirnova) wrote :

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