41
CREATE TABLE t1 (a int);
42
INSERT INTO t1 VALUES (1), (2);
43
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
44
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
45
DROP TABLE IF EXISTS `t1`;
48
) ENGINE=InnoDB COLLATE = utf8_general_ci;
50
ALTER TABLE `t1` DISABLE KEYS;
51
INSERT INTO `t1` VALUES (1),(2);
52
ALTER TABLE `t1` ENABLE KEYS;
53
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
54
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
55
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
56
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
57
DROP TABLE IF EXISTS `t1`;
60
) ENGINE=InnoDB COLLATE = utf8_general_ci;
62
ALTER TABLE `t1` DISABLE KEYS;
63
INSERT INTO `t1` VALUES (1),(2);
64
ALTER TABLE `t1` ENABLE KEYS;
65
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
66
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
69
39
# Bug #2592 'mysqldump doesn't quote "tricky" names correctly'
71
41
create table ```a` (i int);