1set @orig_show_compatibility_56=@@global.show_compatibility_56;
2set global show_compatibility_56 = 0;
3create table t1(a int auto_increment primary key not null) engine=innodb;
4insert into t1(a) values(null), (null), (null), (null), (null), (null);
5
6/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
7/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
8/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
9/*!40101 SET NAMES utf8 */;
10/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
11/*!40103 SET TIME_ZONE='+00:00' */;
12/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
13/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
14/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
15/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
16/*!50717 SELECT COUNT(*) INTO @rocksdb_has_p_s_session_variables FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'performance_schema' AND TABLE_NAME = 'session_variables' */;
17/*!50717 SET @rocksdb_get_is_supported = IF (@rocksdb_has_p_s_session_variables, 'SELECT COUNT(*) INTO @rocksdb_is_supported FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'rocksdb_bulk_load\'', 'SELECT 0') */;
18/*!50717 PREPARE s FROM @rocksdb_get_is_supported */;
19/*!50717 EXECUTE s */;
20/*!50717 DEALLOCATE PREPARE s */;
21/*!50717 SET @rocksdb_enable_bulk_load = IF (@rocksdb_is_supported, 'SET SESSION rocksdb_bulk_load = 1', 'SET @rocksdb_dummy_bulk_load = 0') */;
22/*!50717 PREPARE s FROM @rocksdb_enable_bulk_load */;
23/*!50717 EXECUTE s */;
24/*!50717 DEALLOCATE PREPARE s */;
25DROP TABLE IF EXISTS `t1`;
26/*!40101 SET @saved_cs_client     = @@character_set_client */;
27/*!40101 SET character_set_client = utf8 */;
28CREATE TABLE `t1` (
29  `a` int(11) NOT NULL,
30  PRIMARY KEY (`a`)
31);
32/*!40101 SET character_set_client = @saved_cs_client */;
33
34LOCK TABLES `t1` WRITE;
35/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
36INSERT INTO `t1` VALUES (1),(2),(3),(4),(5),(6);
37/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
38UNLOCK TABLES;
39/*!50112 SET @disable_bulk_load = IF (@is_rocksdb_supported, 'SET SESSION rocksdb_bulk_load = @old_rocksdb_bulk_load', 'SET @dummy_rocksdb_bulk_load = 0') */;
40/*!50112 PREPARE s FROM @disable_bulk_load */;
41/*!50112 EXECUTE s */;
42/*!50112 DEALLOCATE PREPARE s */;
43/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
44
45/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
46/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
47/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
48/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
49/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
50/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
51/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
52
53drop table t1;
54set global show_compatibility_56 = 1;
55create table t1(a int auto_increment primary key not null) engine=innodb;
56insert into t1(a) values(null), (null), (null), (null), (null), (null);
57
58/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
59/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
60/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
61/*!40101 SET NAMES utf8 */;
62/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
63/*!40103 SET TIME_ZONE='+00:00' */;
64/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
65/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
66/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
67/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
68/*!50717 SELECT COUNT(*) INTO @rocksdb_has_p_s_session_variables FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'performance_schema' AND TABLE_NAME = 'session_variables' */;
69/*!50717 SET @rocksdb_get_is_supported = IF (@rocksdb_has_p_s_session_variables, 'SELECT COUNT(*) INTO @rocksdb_is_supported FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'rocksdb_bulk_load\'', 'SELECT 0') */;
70/*!50717 PREPARE s FROM @rocksdb_get_is_supported */;
71/*!50717 EXECUTE s */;
72/*!50717 DEALLOCATE PREPARE s */;
73/*!50717 SET @rocksdb_enable_bulk_load = IF (@rocksdb_is_supported, 'SET SESSION rocksdb_bulk_load = 1', 'SET @rocksdb_dummy_bulk_load = 0') */;
74/*!50717 PREPARE s FROM @rocksdb_enable_bulk_load */;
75/*!50717 EXECUTE s */;
76/*!50717 DEALLOCATE PREPARE s */;
77DROP TABLE IF EXISTS `t1`;
78/*!40101 SET @saved_cs_client     = @@character_set_client */;
79/*!40101 SET character_set_client = utf8 */;
80CREATE TABLE `t1` (
81  `a` int(11) NOT NULL,
82  PRIMARY KEY (`a`)
83);
84/*!40101 SET character_set_client = @saved_cs_client */;
85
86LOCK TABLES `t1` WRITE;
87/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
88INSERT INTO `t1` VALUES (1),(2),(3),(4),(5),(6);
89/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
90UNLOCK TABLES;
91/*!50112 SET @disable_bulk_load = IF (@is_rocksdb_supported, 'SET SESSION rocksdb_bulk_load = @old_rocksdb_bulk_load', 'SET @dummy_rocksdb_bulk_load = 0') */;
92/*!50112 PREPARE s FROM @disable_bulk_load */;
93/*!50112 EXECUTE s */;
94/*!50112 DEALLOCATE PREPARE s */;
95/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
96
97/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
98/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
99/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
100/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
101/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
102/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
103/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
104
105drop table t1;
106set global show_compatibility_56 = @@global.show_compatibility_56;
107