~drizzle-trunk/drizzle/development : contents of mysql-test/r/mysqldump-max.result at revision 33

~drizzle-trunk/drizzle/development : (revision 33)

drop table if exists t1, t2, t3, t4, t5, t6;
create table t1 (id int(8), name varchar(32));
create table t2 (id int(8), name varchar(32)) ENGINE="MyISAM";
create table t3 (id int(8), name varchar(32)) ENGINE="MEMORY";
create table t4 (id int(8), name varchar(32)) ENGINE="HEAP";
create table t5 (id int(8), name varchar(32)) ENGINE="ARCHIVE";
create table t6 (id int(8), name varchar(32)) ENGINE="InnoDB";
insert into t1 values (1, 'first value');
insert into t1 values (2, 'first value');
insert into t1 values (3, 'first value');
insert into t1 values (4, 'first value');
insert into t1 values (5, 'first value');
insert into t2 values (1, 'first value');
insert into t2 values (2, 'first value');
insert into t2 values (3, 'first value');
insert into t2 values (4, 'first value');
insert into t2 values (5, 'first value');
insert into t3 values (1, 'first value');
insert into t3 values (2, 'first value');
insert into t3 values (3, 'first value');
insert into t3 values (4, 'first value');
insert into t3 values (5, 'first value');
insert into t4 values (1, 'first value');
insert into t4 values (2, 'first value');
insert into t4 values (3, 'first value');
insert into t4 values (4, 'first value');
insert into t4 values (5, 'first value');
insert into t5 values (1, 'first value');
insert into t5 values (2, 'first value');
insert into t5 values (3, 'first value');
insert into t5 values (4, 'first value');
insert into t5 values (5, 'first value');
insert into t6 values (1, 'first value');
insert into t6 values (2, 'first value');
insert into t6 values (3, 'first value');
insert into t6 values (4, 'first value');
insert into t6 values (5, 'first value');
select * from t1;
id	name
1	first value
2	first value
3	first value
4	first value
5	first value
select * from t2;
id	name
1	first value
2	first value
3	first value
4	first value
5	first value
select * from t3;
id	name
1	first value
2	first value
3	first value
4	first value
5	first value
select * from t4;
id	name
1	first value
2	first value
3	first value
4	first value
5	first value
select * from t5;
id	name
1	first value
2	first value
3	first value
4	first value
5	first value
select * from t6;
id	name
1	first value
2	first value
3	first value
4	first value
5	first value

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `test`;
DROP TABLE IF EXISTS `t1`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `t1` (
  `id` int(8) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
INSERT  DELAYED IGNORE INTO `t1` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
DROP TABLE IF EXISTS `t2`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `t2` (
  `id` int(8) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

/*!40000 ALTER TABLE `t2` DISABLE KEYS */;
INSERT  DELAYED IGNORE INTO `t2` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
/*!40000 ALTER TABLE `t2` ENABLE KEYS */;
DROP TABLE IF EXISTS `t3`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `t3` (
  `id` int(8) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL
) ENGINE=MEMORY DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

/*!40000 ALTER TABLE `t3` DISABLE KEYS */;
INSERT  DELAYED IGNORE INTO `t3` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
/*!40000 ALTER TABLE `t3` ENABLE KEYS */;
DROP TABLE IF EXISTS `t4`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `t4` (
  `id` int(8) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL
) ENGINE=MEMORY DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

/*!40000 ALTER TABLE `t4` DISABLE KEYS */;
INSERT  DELAYED IGNORE INTO `t4` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
/*!40000 ALTER TABLE `t4` ENABLE KEYS */;
DROP TABLE IF EXISTS `t5`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `t5` (
  `id` int(8) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

/*!40000 ALTER TABLE `t5` DISABLE KEYS */;
INSERT  DELAYED IGNORE INTO `t5` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
/*!40000 ALTER TABLE `t5` ENABLE KEYS */;
DROP TABLE IF EXISTS `t6`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `t6` (
  `id` int(8) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

/*!40000 ALTER TABLE `t6` DISABLE KEYS */;
INSERT  IGNORE INTO `t6` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
/*!40000 ALTER TABLE `t6` ENABLE KEYS */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `test`;
DROP TABLE IF EXISTS `t1`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `t1` (
  `id` int(8) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
INSERT  DELAYED INTO `t1` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
DROP TABLE IF EXISTS `t2`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `t2` (
  `id` int(8) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

/*!40000 ALTER TABLE `t2` DISABLE KEYS */;
INSERT  DELAYED INTO `t2` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
/*!40000 ALTER TABLE `t2` ENABLE KEYS */;
DROP TABLE IF EXISTS `t3`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `t3` (
  `id` int(8) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL
) ENGINE=MEMORY DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

/*!40000 ALTER TABLE `t3` DISABLE KEYS */;
INSERT  DELAYED INTO `t3` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
/*!40000 ALTER TABLE `t3` ENABLE KEYS */;
DROP TABLE IF EXISTS `t4`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `t4` (
  `id` int(8) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL
) ENGINE=MEMORY DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

/*!40000 ALTER TABLE `t4` DISABLE KEYS */;
INSERT  DELAYED INTO `t4` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
/*!40000 ALTER TABLE `t4` ENABLE KEYS */;
DROP TABLE IF EXISTS `t5`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `t5` (
  `id` int(8) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

/*!40000 ALTER TABLE `t5` DISABLE KEYS */;
INSERT  DELAYED INTO `t5` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
/*!40000 ALTER TABLE `t5` ENABLE KEYS */;
DROP TABLE IF EXISTS `t6`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `t6` (
  `id` int(8) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

/*!40000 ALTER TABLE `t6` DISABLE KEYS */;
INSERT INTO `t6` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
/*!40000 ALTER TABLE `t6` ENABLE KEYS */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

drop table t1;
drop table t2;
drop table t3;
drop table t4;
drop table t5;
drop table t6;

1 by brian clean slate	1	drop table if exists t1, t2, t3, t4, t5, t6;
	2	create table t1 (id int(8), name varchar(32));
	3	create table t2 (id int(8), name varchar(32)) ENGINE="MyISAM";
	4	create table t3 (id int(8), name varchar(32)) ENGINE="MEMORY";
	5	create table t4 (id int(8), name varchar(32)) ENGINE="HEAP";
	6	create table t5 (id int(8), name varchar(32)) ENGINE="ARCHIVE";
	7	create table t6 (id int(8), name varchar(32)) ENGINE="InnoDB";
	8	insert into t1 values (1, 'first value');
	9	insert into t1 values (2, 'first value');
	10	insert into t1 values (3, 'first value');
	11	insert into t1 values (4, 'first value');
	12	insert into t1 values (5, 'first value');
	13	insert into t2 values (1, 'first value');
	14	insert into t2 values (2, 'first value');
	15	insert into t2 values (3, 'first value');
	16	insert into t2 values (4, 'first value');
	17	insert into t2 values (5, 'first value');
	18	insert into t3 values (1, 'first value');
	19	insert into t3 values (2, 'first value');
	20	insert into t3 values (3, 'first value');
	21	insert into t3 values (4, 'first value');
	22	insert into t3 values (5, 'first value');
	23	insert into t4 values (1, 'first value');
	24	insert into t4 values (2, 'first value');
	25	insert into t4 values (3, 'first value');
	26	insert into t4 values (4, 'first value');
	27	insert into t4 values (5, 'first value');
	28	insert into t5 values (1, 'first value');
	29	insert into t5 values (2, 'first value');
	30	insert into t5 values (3, 'first value');
	31	insert into t5 values (4, 'first value');
	32	insert into t5 values (5, 'first value');
	33	insert into t6 values (1, 'first value');
	34	insert into t6 values (2, 'first value');
	35	insert into t6 values (3, 'first value');
	36	insert into t6 values (4, 'first value');
	37	insert into t6 values (5, 'first value');
	38	select * from t1;
	39	id name
	40	1 first value
	41	2 first value
	42	3 first value
	43	4 first value
	44	5 first value
	45	select * from t2;
	46	id name
	47	1 first value
	48	2 first value
	49	3 first value
	50	4 first value
	51	5 first value
	52	select * from t3;
	53	id name
	54	1 first value
	55	2 first value
	56	3 first value
	57	4 first value
	58	5 first value
	59	select * from t4;
	60	id name
	61	1 first value
	62	2 first value
	63	3 first value
	64	4 first value
65	5 first value
66	select * from t5;
67	id name
68	1 first value
69	2 first value
70	3 first value
71	4 first value
72	5 first value
73	select * from t6;
74	id name
75	1 first value
76	2 first value
77	3 first value
78	4 first value
79	5 first value
80
81	/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;
82	/!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /;
83	/!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /;
84	/!40101 SET NAMES utf8 /;
85	/!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE /;
86	/!40103 SET TIME_ZONE='+00:00' /;
87	/!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 /;
88	/!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 /;
89	/!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' /;
90	/!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 /;
91
92	CREATE DATABASE /!32312 IF NOT EXISTS/ `test` /!40100 DEFAULT CHARACTER SET latin1 /;
93
94	USE `test`;
95	DROP TABLE IF EXISTS `t1`;
96	SET @saved_cs_client = @@character_set_client;
97	SET character_set_client = utf8;
98	CREATE TABLE `t1` (
99	`id` int(8) DEFAULT NULL,
100	`name` varchar(32) DEFAULT NULL
101	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
102	SET character_set_client = @saved_cs_client;
103
104	/!40000 ALTER TABLE `t1` DISABLE KEYS /;
105	INSERT DELAYED IGNORE INTO `t1` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
106	/!40000 ALTER TABLE `t1` ENABLE KEYS /;
107	DROP TABLE IF EXISTS `t2`;
108	SET @saved_cs_client = @@character_set_client;
109	SET character_set_client = utf8;
110	CREATE TABLE `t2` (
111	`id` int(8) DEFAULT NULL,
112	`name` varchar(32) DEFAULT NULL
113	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
114	SET character_set_client = @saved_cs_client;
115
116	/!40000 ALTER TABLE `t2` DISABLE KEYS /;
117	INSERT DELAYED IGNORE INTO `t2` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
118	/!40000 ALTER TABLE `t2` ENABLE KEYS /;
119	DROP TABLE IF EXISTS `t3`;
120	SET @saved_cs_client = @@character_set_client;
121	SET character_set_client = utf8;
122	CREATE TABLE `t3` (
123	`id` int(8) DEFAULT NULL,
124	`name` varchar(32) DEFAULT NULL
125	) ENGINE=MEMORY DEFAULT CHARSET=latin1;
126	SET character_set_client = @saved_cs_client;
127
128	/!40000 ALTER TABLE `t3` DISABLE KEYS /;
129	INSERT DELAYED IGNORE INTO `t3` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
130	/!40000 ALTER TABLE `t3` ENABLE KEYS /;
131	DROP TABLE IF EXISTS `t4`;
132	SET @saved_cs_client = @@character_set_client;
133	SET character_set_client = utf8;
134	CREATE TABLE `t4` (
135	`id` int(8) DEFAULT NULL,
136	`name` varchar(32) DEFAULT NULL
137	) ENGINE=MEMORY DEFAULT CHARSET=latin1;
138	SET character_set_client = @saved_cs_client;
139
140	/!40000 ALTER TABLE `t4` DISABLE KEYS /;
141	INSERT DELAYED IGNORE INTO `t4` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
142	/!40000 ALTER TABLE `t4` ENABLE KEYS /;
143	DROP TABLE IF EXISTS `t5`;
144	SET @saved_cs_client = @@character_set_client;
145	SET character_set_client = utf8;
146	CREATE TABLE `t5` (
147	`id` int(8) DEFAULT NULL,
148	`name` varchar(32) DEFAULT NULL
149	) ENGINE=ARCHIVE DEFAULT CHARSET=latin1;
150	SET character_set_client = @saved_cs_client;
151
152	/!40000 ALTER TABLE `t5` DISABLE KEYS /;
153	INSERT DELAYED IGNORE INTO `t5` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
154	/!40000 ALTER TABLE `t5` ENABLE KEYS /;
155	DROP TABLE IF EXISTS `t6`;
156	SET @saved_cs_client = @@character_set_client;
157	SET character_set_client = utf8;
158	CREATE TABLE `t6` (
159	`id` int(8) DEFAULT NULL,
160	`name` varchar(32) DEFAULT NULL
161	) ENGINE=InnoDB DEFAULT CHARSET=latin1;
162	SET character_set_client = @saved_cs_client;
163
164	/!40000 ALTER TABLE `t6` DISABLE KEYS /;
165	INSERT IGNORE INTO `t6` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
166	/!40000 ALTER TABLE `t6` ENABLE KEYS /;
167	/!40103 SET TIME_ZONE=@OLD_TIME_ZONE /;
168
169	/!40101 SET SQL_MODE=@OLD_SQL_MODE /;
170	/!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /;
171	/!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS /;
172	/!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /;
173	/!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /;
174	/!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION /;
175	/!40111 SET SQL_NOTES=@OLD_SQL_NOTES /;
176
177
178	/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;
179	/!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /;
180	/!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /;
181	/!40101 SET NAMES utf8 /;
182	/!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE /;
183	/!40103 SET TIME_ZONE='+00:00' /;
184	/!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 /;
185	/!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 /;
186	/!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' /;
187	/!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 /;
188
189	CREATE DATABASE /!32312 IF NOT EXISTS/ `test` /!40100 DEFAULT CHARACTER SET latin1 /;
190
191	USE `test`;
192	DROP TABLE IF EXISTS `t1`;
193	SET @saved_cs_client = @@character_set_client;
194	SET character_set_client = utf8;
195	CREATE TABLE `t1` (
196	`id` int(8) DEFAULT NULL,
197	`name` varchar(32) DEFAULT NULL
198	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
199	SET character_set_client = @saved_cs_client;
200
201	/!40000 ALTER TABLE `t1` DISABLE KEYS /;
202	INSERT DELAYED INTO `t1` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
203	/!40000 ALTER TABLE `t1` ENABLE KEYS /;
204	DROP TABLE IF EXISTS `t2`;
205	SET @saved_cs_client = @@character_set_client;
206	SET character_set_client = utf8;
207	CREATE TABLE `t2` (
208	`id` int(8) DEFAULT NULL,
209	`name` varchar(32) DEFAULT NULL
210	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
211	SET character_set_client = @saved_cs_client;
212
213	/!40000 ALTER TABLE `t2` DISABLE KEYS /;
214	INSERT DELAYED INTO `t2` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
215	/!40000 ALTER TABLE `t2` ENABLE KEYS /;
216	DROP TABLE IF EXISTS `t3`;
217	SET @saved_cs_client = @@character_set_client;
218	SET character_set_client = utf8;
219	CREATE TABLE `t3` (
220	`id` int(8) DEFAULT NULL,
221	`name` varchar(32) DEFAULT NULL
222	) ENGINE=MEMORY DEFAULT CHARSET=latin1;
223	SET character_set_client = @saved_cs_client;
224
225	/!40000 ALTER TABLE `t3` DISABLE KEYS /;
226	INSERT DELAYED INTO `t3` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
227	/!40000 ALTER TABLE `t3` ENABLE KEYS /;
228	DROP TABLE IF EXISTS `t4`;
229	SET @saved_cs_client = @@character_set_client;
230	SET character_set_client = utf8;
231	CREATE TABLE `t4` (
232	`id` int(8) DEFAULT NULL,
233	`name` varchar(32) DEFAULT NULL
234	) ENGINE=MEMORY DEFAULT CHARSET=latin1;
235	SET character_set_client = @saved_cs_client;
236
237	/!40000 ALTER TABLE `t4` DISABLE KEYS /;
238	INSERT DELAYED INTO `t4` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
239	/!40000 ALTER TABLE `t4` ENABLE KEYS /;
240	DROP TABLE IF EXISTS `t5`;
241	SET @saved_cs_client = @@character_set_client;
242	SET character_set_client = utf8;
243	CREATE TABLE `t5` (
244	`id` int(8) DEFAULT NULL,
245	`name` varchar(32) DEFAULT NULL
246	) ENGINE=ARCHIVE DEFAULT CHARSET=latin1;
247	SET character_set_client = @saved_cs_client;
248
249	/!40000 ALTER TABLE `t5` DISABLE KEYS /;
250	INSERT DELAYED INTO `t5` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
251	/!40000 ALTER TABLE `t5` ENABLE KEYS /;
252	DROP TABLE IF EXISTS `t6`;
253	SET @saved_cs_client = @@character_set_client;
254	SET character_set_client = utf8;
255	CREATE TABLE `t6` (
256	`id` int(8) DEFAULT NULL,
257	`name` varchar(32) DEFAULT NULL
258	) ENGINE=InnoDB DEFAULT CHARSET=latin1;
259	SET character_set_client = @saved_cs_client;
260
261	/!40000 ALTER TABLE `t6` DISABLE KEYS /;
262	INSERT INTO `t6` VALUES (1,'first value'),(2,'first value'),(3,'first value'),(4,'first value'),(5,'first value');
263	/!40000 ALTER TABLE `t6` ENABLE KEYS /;
264	/!40103 SET TIME_ZONE=@OLD_TIME_ZONE /;
265
266	/!40101 SET SQL_MODE=@OLD_SQL_MODE /;
267	/!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /;
268	/!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS /;
269	/!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /;
270	/!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /;
271	/!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION /;
272	/!40111 SET SQL_NOTES=@OLD_SQL_NOTES /;
273
274	drop table t1;
275	drop table t2;
276	drop table t3;
277	drop table t4;
278	drop table t5;
279	drop table t6;