# Ensure state is stable

DROP TEMPORARY TABLE IF EXISTS `t1`;

DROP TEMPORARY TABLE IF EXISTS `t2`;

# Run test

CREATE TEMPORARY TABLE `t1` (

  `i` INT AUTO_INCREMENT,

  `s` VARCHAR(16) CHECK (CHAR_LENGTH(`s`) > 5),

  PRIMARY KEY (`i`)

) ENGINE=INNODB;

RENAME TABLE `t1` TO `t2`;

ALTER TABLE `t2` AUTO_INCREMENT = 2; # Error: Unknown column '`test`.`t1`.`s`' in 'CHECK'

SHOW CREATE TABLE `t2`;

/*

CREATE TEMPORARY TABLE `t2` (

  `i` int(11) NOT NULL AUTO_INCREMENT,

  `s` varchar(16) DEFAULT NULL CHECK (char_length(`s`) > 5),

  PRIMARY KEY (`i`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8

*/

# Cleanup

DROP TEMPORARY TABLE IF EXISTS `t1`;

DROP TEMPORARY TABLE IF EXISTS `t2`;