1
# Bug#37938 Test "mysqldump" lacks various insert statements
2
# Turn off concurrent inserts to avoid random errors
3
# NOTE: We reset the variable back to saved value at the end of test
4
SET @OLD_CONCURRENT_INSERT = @@GLOBAL.CONCURRENT_INSERT;
5
SET @@GLOBAL.CONCURRENT_INSERT = 0;
6
DROP TABLE IF EXISTS t1, `"t"1`, t1aa, t2, t2aa, t3;
7
drop database if exists mysqldump_test_db;
8
drop database if exists db1;
9
drop database if exists db2;
10
drop view if exists v1, v2, v3;
11
CREATE TABLE t1(a INT, KEY (a)) KEY_BLOCK_SIZE=1024;
12
INSERT INTO t1 VALUES (1), (2);
14
<mysqldump xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
15
<database name="test">
16
<table_structure name="t1">
17
<field Field="a" Type="int(11)" Null="YES" Key="MUL" Extra="" />
18
<key Table="t1" Non_unique="1" Key_name="a" Seq_in_index="1" Column_name="a" Collation="A" Null="YES" Index_type="BTREE" Comment="" />
20
<table_data name="t1">
22
<field name="a">1</field>
25
<field name="a">2</field>
32
# Bug#2005 Long decimal comparison bug.
34
CREATE TABLE t1 (a decimal(64, 20));
35
INSERT INTO t1 VALUES ("1234567890123456789012345678901234567890"),
36
("0987654321098765432109876543210987654321");
37
/*!40101 SET @saved_cs_client = @@character_set_client */;
38
/*!40101 SET character_set_client = utf8 */;
40
`a` decimal(64,20) DEFAULT NULL
41
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
42
/*!40101 SET character_set_client = @saved_cs_client */;
43
INSERT INTO `t1` VALUES ('1234567890123456789012345678901234567890.00000000000000000000'),('987654321098765432109876543210987654321.00000000000000000000');
46
# Bug#2055 mysqldump should replace "-inf" numeric field values with "NULL"
48
CREATE TABLE t1 (a double);
49
INSERT INTO t1 VALUES ('-9e999999');
51
Warning 1264 Out of range value for column 'a' at row 1
52
/*!40101 SET @saved_cs_client = @@character_set_client */;
53
/*!40101 SET character_set_client = utf8 */;
55
`a` double DEFAULT NULL
56
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
57
/*!40101 SET character_set_client = @saved_cs_client */;
58
INSERT INTO `t1` VALUES (RES);
61
# Bug#3361 mysqldump quotes DECIMAL values inconsistently
63
CREATE TABLE t1 (a DECIMAL(10,5), b FLOAT);
64
INSERT INTO t1 VALUES (1.2345, 2.3456);
65
INSERT INTO t1 VALUES ('1.2345', 2.3456);
66
INSERT INTO t1 VALUES ("1.2345", 2.3456);
67
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ANSI_QUOTES';
68
INSERT INTO t1 VALUES (1.2345, 2.3456);
69
INSERT INTO t1 VALUES ('1.2345', 2.3456);
70
INSERT INTO t1 VALUES ("1.2345", 2.3456);
71
ERROR 42S22: Unknown column '1.2345' in 'field list'
72
SET SQL_MODE=@OLD_SQL_MODE;
73
/*!40101 SET @saved_cs_client = @@character_set_client */;
74
/*!40101 SET character_set_client = utf8 */;
76
`a` decimal(10,5) DEFAULT NULL,
77
`b` float DEFAULT NULL
78
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
79
/*!40101 SET character_set_client = @saved_cs_client */;
80
INSERT INTO `t1` VALUES ('1.23450',2.3456),('1.23450',2.3456),('1.23450',2.3456),('1.23450',2.3456),('1.23450',2.3456);
81
/*!40101 SET @saved_cs_client = @@character_set_client */;
82
/*!40101 SET character_set_client = utf8 */;
84
`a` decimal(10,5) DEFAULT NULL,
85
`b` float DEFAULT NULL
87
/*!40101 SET character_set_client = @saved_cs_client */;
88
INSERT INTO `t1` VALUES ('1.23450',2.3456),('1.23450',2.3456),('1.23450',2.3456),('1.23450',2.3456),('1.23450',2.3456);
90
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
91
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
92
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
93
/*!40101 SET NAMES utf8 */;
94
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
95
/*!40103 SET TIME_ZONE='+00:00' */;
96
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
97
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
98
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
99
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
100
DROP TABLE IF EXISTS `t1`;
101
/*!40101 SET @saved_cs_client = @@character_set_client */;
102
/*!40101 SET character_set_client = utf8 */;
104
`a` decimal(10,5) DEFAULT NULL,
105
`b` float DEFAULT NULL
107
/*!40101 SET character_set_client = @saved_cs_client */;
109
LOCK TABLES `t1` WRITE;
110
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
111
INSERT INTO `t1` VALUES ('1.23450',2.3456),('1.23450',2.3456),('1.23450',2.3456),('1.23450',2.3456),('1.23450',2.3456);
112
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
114
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
116
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
117
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
118
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
119
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
120
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
121
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
122
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
124
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
125
/*!40103 SET TIME_ZONE='+00:00' */;
126
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
127
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
128
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
129
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
130
/*!40101 SET @saved_cs_client = @@character_set_client */;
131
/*!40101 SET character_set_client = utf8 */;
133
`a` decimal(10,5) DEFAULT NULL,
134
`b` float DEFAULT NULL
136
/*!40101 SET character_set_client = @saved_cs_client */;
138
INSERT INTO `t1` VALUES ('1.23450',2.3456),('1.23450',2.3456),('1.23450',2.3456),('1.23450',2.3456),('1.23450',2.3456);
139
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
141
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
142
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
143
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
144
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
147
CREATE TABLE t1(a int, b text, c varchar(3));
148
INSERT INTO t1 VALUES (1, "test", "tes"), (2, "TEST", "TES");
149
<?xml version="1.0"?>
150
<mysqldump xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
151
<database name="test">
152
<table_structure name="t1">
153
<field Field="a" Type="int(11)" Null="YES" Key="" Extra="" />
154
<field Field="b" Type="text" Null="YES" Key="" Extra="" />
155
<field Field="c" Type="varchar(3)" Null="YES" Key="" Extra="" />
157
<table_data name="t1">
159
<field name="a">1</field>
160
<field name="b">test</field>
161
<field name="c">tes</field>
164
<field name="a">2</field>
165
<field name="b">TEST</field>
166
<field name="c">TES</field>
173
# Bug#1707 mysqldump -X does't quote field and table names
175
CREATE TABLE t1 (`a"b"` char(2));
176
INSERT INTO t1 VALUES ("1\""), ("\"2");
177
<?xml version="1.0"?>
178
<mysqldump xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
179
<database name="test">
180
<table_structure name="t1">
181
<field Field="a"b"" Type="char(2)" Null="YES" Key="" Extra="" />
183
<table_data name="t1">
185
<field name="a"b"">1"</field>
188
<field name="a"b"">"2</field>
195
# Bug#1994 mysqldump does not correctly dump UCS2 data
196
# Bug#4261 mysqldump 10.7 (mysql 4.1.2) --skip-extended-insert drops NULL from inserts
198
CREATE TABLE t1 (a VARCHAR(255)) DEFAULT CHARSET koi8r;
199
INSERT INTO t1 VALUES (_koi8r x'C1C2C3C4C5'), (NULL);
201
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
202
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
203
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
204
/*!40101 SET NAMES utf8 */;
205
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
206
/*!40103 SET TIME_ZONE='+00:00' */;
207
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
208
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
209
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
210
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
211
DROP TABLE IF EXISTS `t1`;
212
/*!40101 SET @saved_cs_client = @@character_set_client */;
213
/*!40101 SET character_set_client = utf8 */;
215
`a` varchar(255) DEFAULT NULL
216
) ENGINE=MyISAM DEFAULT CHARSET=koi8r;
217
/*!40101 SET character_set_client = @saved_cs_client */;
219
LOCK TABLES `t1` WRITE;
220
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
221
INSERT INTO `t1` VALUES ('абцде');
222
INSERT INTO `t1` VALUES (NULL);
223
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
225
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
227
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
228
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
229
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
230
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
231
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
232
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
233
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
237
# Bug#2634 mysqldump in --compatible=mysql4
239
CREATE TABLE t1 (a int) ENGINE=MYISAM;
240
INSERT INTO t1 VALUES (1), (2);
241
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
242
/*!40103 SET TIME_ZONE='+00:00' */;
243
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
244
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
245
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,MYSQL40' */;
246
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
247
DROP TABLE IF EXISTS `t1`;
249
`a` int(11) DEFAULT NULL
252
LOCK TABLES `t1` WRITE;
253
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
254
INSERT INTO `t1` VALUES (1),(2);
255
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
257
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
259
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
260
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
261
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
262
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
264
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
265
/*!40103 SET TIME_ZONE='+00:00' */;
266
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
267
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
268
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,MYSQL323' */;
269
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
270
DROP TABLE IF EXISTS `t1`;
272
`a` int(11) DEFAULT NULL
275
LOCK TABLES `t1` WRITE;
276
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
277
INSERT INTO `t1` VALUES (1),(2);
278
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
280
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
282
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
283
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
284
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
285
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
289
# Bug#2592 mysqldump doesn't quote "tricky" names correctly
291
create table ```a` (i int);
292
/*!40101 SET @saved_cs_client = @@character_set_client */;
293
/*!40101 SET character_set_client = utf8 */;
295
`i` int(11) DEFAULT NULL
296
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
297
/*!40101 SET character_set_client = @saved_cs_client */;
300
# Bug#2591 mysqldump quotes names inconsistently
302
create table t1(a int);
304
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
305
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
306
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
307
/*!40101 SET NAMES utf8 */;
308
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
309
/*!40103 SET TIME_ZONE='+00:00' */;
310
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
311
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
312
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
313
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
314
DROP TABLE IF EXISTS `t1`;
315
/*!40101 SET @saved_cs_client = @@character_set_client */;
316
/*!40101 SET character_set_client = utf8 */;
318
`a` int(11) DEFAULT NULL
319
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
320
/*!40101 SET character_set_client = @saved_cs_client */;
322
LOCK TABLES `t1` WRITE;
323
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
324
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
326
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
328
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
329
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
330
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
331
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
332
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
333
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
334
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
336
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
337
/*!40103 SET TIME_ZONE='+00:00' */;
338
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
339
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
340
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,ANSI' */;
341
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
342
DROP TABLE IF EXISTS "t1";
343
/*!40101 SET @saved_cs_client = @@character_set_client */;
344
/*!40101 SET character_set_client = utf8 */;
346
"a" int(11) DEFAULT NULL
348
/*!40101 SET character_set_client = @saved_cs_client */;
350
LOCK TABLES "t1" WRITE;
351
/*!40000 ALTER TABLE "t1" DISABLE KEYS */;
352
/*!40000 ALTER TABLE "t1" ENABLE KEYS */;
354
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
356
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
357
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
358
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
359
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
361
set global sql_mode='ANSI_QUOTES';
363
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
364
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
365
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
366
/*!40101 SET NAMES utf8 */;
367
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
368
/*!40103 SET TIME_ZONE='+00:00' */;
369
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
370
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
371
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
372
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
373
DROP TABLE IF EXISTS `t1`;
374
/*!40101 SET @saved_cs_client = @@character_set_client */;
375
/*!40101 SET character_set_client = utf8 */;
377
`a` int(11) DEFAULT NULL
378
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
379
/*!40101 SET character_set_client = @saved_cs_client */;
381
LOCK TABLES `t1` WRITE;
382
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
383
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
385
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
387
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
388
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
389
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
390
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
391
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
392
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
393
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
395
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
396
/*!40103 SET TIME_ZONE='+00:00' */;
397
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
398
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
399
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,ANSI' */;
400
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
401
DROP TABLE IF EXISTS "t1";
402
/*!40101 SET @saved_cs_client = @@character_set_client */;
403
/*!40101 SET character_set_client = utf8 */;
405
"a" int(11) DEFAULT NULL
407
/*!40101 SET character_set_client = @saved_cs_client */;
409
LOCK TABLES "t1" WRITE;
410
/*!40000 ALTER TABLE "t1" DISABLE KEYS */;
411
/*!40000 ALTER TABLE "t1" ENABLE KEYS */;
413
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
415
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
416
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
417
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
418
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
420
set global sql_mode='';
423
# Bug#2705 mysqldump --tab extra output
425
create table t1(a int);
426
insert into t1 values (1),(2),(3);
428
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
429
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
430
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
431
/*!40101 SET NAMES utf8 */;
432
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
433
/*!40103 SET TIME_ZONE='+00:00' */;
434
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
435
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
436
DROP TABLE IF EXISTS `t1`;
437
/*!40101 SET @saved_cs_client = @@character_set_client */;
438
/*!40101 SET character_set_client = utf8 */;
440
`a` int(11) DEFAULT NULL
441
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
442
/*!40101 SET character_set_client = @saved_cs_client */;
444
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
446
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
447
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
448
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
449
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
450
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
457
# Bug#6101 create database problem
460
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
461
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
462
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
463
/*!40101 SET NAMES utf8 */;
464
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
465
/*!40103 SET TIME_ZONE='+00:00' */;
466
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
467
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
468
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
469
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
471
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test` /*!40100 DEFAULT CHARACTER SET latin1 */;
474
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
476
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
477
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
478
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
479
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
480
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
481
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
482
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
484
create database mysqldump_test_db character set latin2 collate latin2_bin;
486
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
487
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
488
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
489
/*!40101 SET NAMES utf8 */;
490
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
491
/*!40103 SET TIME_ZONE='+00:00' */;
492
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
493
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
494
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
495
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
497
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysqldump_test_db` /*!40100 DEFAULT CHARACTER SET latin2 COLLATE latin2_bin */;
499
USE `mysqldump_test_db`;
500
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
502
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
503
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
504
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
505
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
506
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
507
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
508
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
510
drop database mysqldump_test_db;
512
# Bug#7020 mysqldump --compatible=mysql40 should set --skip-set-charset --default-char...
513
# Check that we don't dump in UTF8 in compatible mode by default,
514
# but use the default compiled values, or the values given in
515
# --default-character-set=xxx. However, we should dump in UTF8
516
# if it is explicitely set.
517
CREATE TABLE t1 (a CHAR(10));
518
INSERT INTO t1 VALUES (_latin1 '����');
520
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
521
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
522
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
523
/*!40101 SET NAMES utf8 */;
524
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
525
/*!40103 SET TIME_ZONE='+00:00' */;
526
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
527
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
528
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
529
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
530
DROP TABLE IF EXISTS `t1`;
531
/*!40101 SET @saved_cs_client = @@character_set_client */;
532
/*!40101 SET character_set_client = utf8 */;
534
`a` char(10) DEFAULT NULL
535
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
536
/*!40101 SET character_set_client = @saved_cs_client */;
538
LOCK TABLES `t1` WRITE;
539
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
540
INSERT INTO `t1` VALUES ('ÄÖÜß');
541
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
543
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
545
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
546
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
547
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
548
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
549
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
550
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
551
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
554
# Bug#8063 make test mysqldump [ fail ]
555
# We cannot test this command because its output depends
556
# on --default-character-set incompiled into "mysqldump" program.
557
# If the future we can move this command into a separate test with
558
# checking that "mysqldump" is compiled with "latin1"
560
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
561
/*!40103 SET TIME_ZONE='+00:00' */;
562
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
563
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
564
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,MYSQL323' */;
565
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
566
DROP TABLE IF EXISTS `t1`;
568
`a` char(10) DEFAULT NULL
571
LOCK TABLES `t1` WRITE;
572
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
573
INSERT INTO `t1` VALUES ('����');
574
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
576
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
578
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
579
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
580
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
581
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
583
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
584
/*!40103 SET TIME_ZONE='+00:00' */;
585
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
586
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
587
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,MYSQL323' */;
588
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
589
DROP TABLE IF EXISTS `t1`;
591
`a` char(10) DEFAULT NULL
594
LOCK TABLES `t1` WRITE;
595
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
596
INSERT INTO `t1` VALUES ('����');
597
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
599
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
601
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
602
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
603
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
604
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
606
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
607
/*!40103 SET TIME_ZONE='+00:00' */;
608
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
609
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
610
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,MYSQL323' */;
611
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
612
DROP TABLE IF EXISTS `t1`;
614
`a` char(10) DEFAULT NULL
617
LOCK TABLES `t1` WRITE;
618
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
619
INSERT INTO `t1` VALUES ('ÄÖÜß');
620
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
622
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
624
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
625
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
626
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
627
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
631
# WL#2319 Exclude Tables from dump
633
CREATE TABLE t1 (a int);
634
CREATE TABLE t2 (a int);
635
INSERT INTO t1 VALUES (1),(2),(3);
636
INSERT INTO t2 VALUES (4),(5),(6);
638
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
639
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
640
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
641
/*!40101 SET NAMES utf8 */;
642
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
643
/*!40103 SET TIME_ZONE='+00:00' */;
644
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
645
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
646
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
647
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
648
DROP TABLE IF EXISTS `t2`;
649
/*!40101 SET @saved_cs_client = @@character_set_client */;
650
/*!40101 SET character_set_client = utf8 */;
652
`a` int(11) DEFAULT NULL
653
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
654
/*!40101 SET character_set_client = @saved_cs_client */;
656
LOCK TABLES `t2` WRITE;
657
/*!40000 ALTER TABLE `t2` DISABLE KEYS */;
658
INSERT INTO `t2` VALUES (4),(5),(6);
659
/*!40000 ALTER TABLE `t2` ENABLE KEYS */;
661
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
663
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
664
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
665
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
666
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
667
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
668
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
669
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
674
# Bug#8830 mysqldump --skip-extended-insert causes --hex-blob to dump wrong values
676
CREATE TABLE t1 (`b` blob);
677
INSERT INTO `t1` VALUES (0x602010000280100005E71A);
679
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
680
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
681
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
682
/*!40101 SET NAMES utf8 */;
683
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
684
/*!40103 SET TIME_ZONE='+00:00' */;
685
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
686
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
687
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
688
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
689
DROP TABLE IF EXISTS `t1`;
690
/*!40101 SET @saved_cs_client = @@character_set_client */;
691
/*!40101 SET character_set_client = utf8 */;
694
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
695
/*!40101 SET character_set_client = @saved_cs_client */;
697
LOCK TABLES `t1` WRITE;
698
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
699
INSERT INTO `t1` VALUES (0x602010000280100005E71A);
700
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
702
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
704
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
705
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
706
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
707
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
708
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
709
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
710
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
714
# Test for --insert-ignore
716
CREATE TABLE t1 (a INT);
717
INSERT INTO t1 VALUES (1),(2),(3);
718
INSERT INTO t1 VALUES (4),(5),(6);
720
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
721
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
722
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
723
/*!40101 SET NAMES utf8 */;
724
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
725
/*!40103 SET TIME_ZONE='+00:00' */;
726
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
727
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
728
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
729
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
730
DROP TABLE IF EXISTS `t1`;
731
/*!40101 SET @saved_cs_client = @@character_set_client */;
732
/*!40101 SET character_set_client = utf8 */;
734
`a` int(11) DEFAULT NULL
735
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
736
/*!40101 SET character_set_client = @saved_cs_client */;
738
LOCK TABLES `t1` WRITE;
739
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
740
INSERT IGNORE INTO `t1` VALUES (1),(2),(3),(4),(5),(6);
741
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
743
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
745
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
746
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
747
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
748
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
749
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
750
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
751
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
754
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
755
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
756
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
757
/*!40101 SET NAMES utf8 */;
758
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
759
/*!40103 SET TIME_ZONE='+00:00' */;
760
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
761
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
762
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
763
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
764
DROP TABLE IF EXISTS `t1`;
765
/*!40101 SET @saved_cs_client = @@character_set_client */;
766
/*!40101 SET character_set_client = utf8 */;
768
`a` int(11) DEFAULT NULL
769
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
770
/*!40101 SET character_set_client = @saved_cs_client */;
772
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
773
INSERT DELAYED IGNORE INTO `t1` VALUES (1),(2),(3),(4),(5),(6);
774
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
775
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
777
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
778
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
779
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
780
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
781
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
782
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
783
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
787
# Bug#10286 mysqldump -c crashes on table that has many fields with long
791
F_c4ca4238a0b923820dcc509a6f75849b int,
792
F_c81e728d9d4c2f636f067f89cc14862c int,
793
F_eccbc87e4b5ce2fe28308fd9f2a7baf3 int,
794
F_a87ff679a2f3e71d9181a67b7542122c int,
795
F_e4da3b7fbbce2345d7772b0674a318d5 int,
796
F_1679091c5a880faf6fb5e6087eb1b2dc int,
797
F_8f14e45fceea167a5a36dedd4bea2543 int,
798
F_c9f0f895fb98ab9159f51fd0297e236d int,
799
F_45c48cce2e2d7fbdea1afc51c7c6ad26 int,
800
F_d3d9446802a44259755d38e6d163e820 int,
801
F_6512bd43d9caa6e02c990b0a82652dca int,
802
F_c20ad4d76fe97759aa27a0c99bff6710 int,
803
F_c51ce410c124a10e0db5e4b97fc2af39 int,
804
F_aab3238922bcc25a6f606eb525ffdc56 int,
805
F_9bf31c7ff062936a96d3c8bd1f8f2ff3 int,
806
F_c74d97b01eae257e44aa9d5bade97baf int,
807
F_70efdf2ec9b086079795c442636b55fb int,
808
F_6f4922f45568161a8cdf4ad2299f6d23 int,
809
F_1f0e3dad99908345f7439f8ffabdffc4 int,
810
F_98f13708210194c475687be6106a3b84 int,
811
F_3c59dc048e8850243be8079a5c74d079 int,
812
F_b6d767d2f8ed5d21a44b0e5886680cb9 int,
813
F_37693cfc748049e45d87b8c7d8b9aacd int,
814
F_1ff1de774005f8da13f42943881c655f int,
815
F_8e296a067a37563370ded05f5a3bf3ec int,
816
F_4e732ced3463d06de0ca9a15b6153677 int,
817
F_02e74f10e0327ad868d138f2b4fdd6f0 int,
818
F_33e75ff09dd601bbe69f351039152189 int,
819
F_6ea9ab1baa0efb9e19094440c317e21b int,
820
F_34173cb38f07f89ddbebc2ac9128303f int,
821
F_c16a5320fa475530d9583c34fd356ef5 int,
822
F_6364d3f0f495b6ab9dcf8d3b5c6e0b01 int,
823
F_182be0c5cdcd5072bb1864cdee4d3d6e int,
824
F_e369853df766fa44e1ed0ff613f563bd int,
825
F_1c383cd30b7c298ab50293adfecb7b18 int,
826
F_19ca14e7ea6328a42e0eb13d585e4c22 int,
827
F_a5bfc9e07964f8dddeb95fc584cd965d int,
828
F_a5771bce93e200c36f7cd9dfd0e5deaa int,
829
F_d67d8ab4f4c10bf22aa353e27879133c int,
830
F_d645920e395fedad7bbbed0eca3fe2e0 int,
831
F_3416a75f4cea9109507cacd8e2f2aefc int,
832
F_a1d0c6e83f027327d8461063f4ac58a6 int,
833
F_17e62166fc8586dfa4d1bc0e1742c08b int,
834
F_f7177163c833dff4b38fc8d2872f1ec6 int,
835
F_6c8349cc7260ae62e3b1396831a8398f int,
836
F_d9d4f495e875a2e075a1a4a6e1b9770f int,
837
F_67c6a1e7ce56d3d6fa748ab6d9af3fd7 int,
838
F_642e92efb79421734881b53e1e1b18b6 int,
839
F_f457c545a9ded88f18ecee47145a72c0 int,
840
F_c0c7c76d30bd3dcaefc96f40275bdc0a int,
841
F_2838023a778dfaecdc212708f721b788 int,
842
F_9a1158154dfa42caddbd0694a4e9bdc8 int,
843
F_d82c8d1619ad8176d665453cfb2e55f0 int,
844
F_a684eceee76fc522773286a895bc8436 int,
845
F_b53b3a3d6ab90ce0268229151c9bde11 int,
846
F_9f61408e3afb633e50cdf1b20de6f466 int,
847
F_72b32a1f754ba1c09b3695e0cb6cde7f int,
848
F_66f041e16a60928b05a7e228a89c3799 int,
849
F_093f65e080a295f8076b1c5722a46aa2 int,
850
F_072b030ba126b2f4b2374f342be9ed44 int,
851
F_7f39f8317fbdb1988ef4c628eba02591 int,
852
F_44f683a84163b3523afe57c2e008bc8c int,
853
F_03afdbd66e7929b125f8597834fa83a4 int,
854
F_ea5d2f1c4608232e07d3aa3d998e5135 int,
855
F_fc490ca45c00b1249bbe3554a4fdf6fb int,
856
F_3295c76acbf4caaed33c36b1b5fc2cb1 int,
857
F_735b90b4568125ed6c3f678819b6e058 int,
858
F_a3f390d88e4c41f2747bfa2f1b5f87db int,
859
F_14bfa6bb14875e45bba028a21ed38046 int,
860
F_7cbbc409ec990f19c78c75bd1e06f215 int,
861
F_e2c420d928d4bf8ce0ff2ec19b371514 int,
862
F_32bb90e8976aab5298d5da10fe66f21d int,
863
F_d2ddea18f00665ce8623e36bd4e3c7c5 int,
864
F_ad61ab143223efbc24c7d2583be69251 int,
865
F_d09bf41544a3365a46c9077ebb5e35c3 int,
866
F_fbd7939d674997cdb4692d34de8633c4 int,
867
F_28dd2c7955ce926456240b2ff0100bde int,
868
F_35f4a8d465e6e1edc05f3d8ab658c551 int,
869
F_d1fe173d08e959397adf34b1d77e88d7 int,
870
F_f033ab37c30201f73f142449d037028d int,
871
F_43ec517d68b6edd3015b3edc9a11367b int,
872
F_9778d5d219c5080b9a6a17bef029331c int,
873
F_fe9fc289c3ff0af142b6d3bead98a923 int,
874
F_68d30a9594728bc39aa24be94b319d21 int,
875
F_3ef815416f775098fe977004015c6193 int,
876
F_93db85ed909c13838ff95ccfa94cebd9 int,
877
F_c7e1249ffc03eb9ded908c236bd1996d int,
878
F_2a38a4a9316c49e5a833517c45d31070 int,
879
F_7647966b7343c29048673252e490f736 int,
880
F_8613985ec49eb8f757ae6439e879bb2a int,
881
F_54229abfcfa5649e7003b83dd4755294 int,
882
F_92cc227532d17e56e07902b254dfad10 int,
883
F_98dce83da57b0395e163467c9dae521b int,
884
F_f4b9ec30ad9f68f89b29639786cb62ef int,
885
F_812b4ba287f5ee0bc9d43bbf5bbe87fb int,
886
F_26657d5ff9020d2abefe558796b99584 int,
887
F_e2ef524fbf3d9fe611d5a8e90fefdc9c int,
888
F_ed3d2c21991e3bef5e069713af9fa6ca int,
889
F_ac627ab1ccbdb62ec96e702f07f6425b int,
890
F_f899139df5e1059396431415e770c6dd int,
891
F_38b3eff8baf56627478ec76a704e9b52 int,
892
F_ec8956637a99787bd197eacd77acce5e int,
893
F_6974ce5ac660610b44d9b9fed0ff9548 int,
894
F_c9e1074f5b3f9fc8ea15d152add07294 int,
895
F_65b9eea6e1cc6bb9f0cd2a47751a186f int,
896
F_f0935e4cd5920aa6c7c996a5ee53a70f int,
897
F_a97da629b098b75c294dffdc3e463904 int,
898
F_a3c65c2974270fd093ee8a9bf8ae7d0b int,
899
F_2723d092b63885e0d7c260cc007e8b9d int,
900
F_5f93f983524def3dca464469d2cf9f3e int,
901
F_698d51a19d8a121ce581499d7b701668 int,
902
F_7f6ffaa6bb0b408017b62254211691b5 int,
903
F_73278a4a86960eeb576a8fd4c9ec6997 int,
904
F_5fd0b37cd7dbbb00f97ba6ce92bf5add int,
905
F_2b44928ae11fb9384c4cf38708677c48 int,
906
F_c45147dee729311ef5b5c3003946c48f int,
907
F_eb160de1de89d9058fcb0b968dbbbd68 int,
908
F_5ef059938ba799aaa845e1c2e8a762bd int,
909
F_07e1cd7dca89a1678042477183b7ac3f int,
910
F_da4fb5c6e93e74d3df8527599fa62642 int,
911
F_4c56ff4ce4aaf9573aa5dff913df997a int,
912
F_a0a080f42e6f13b3a2df133f073095dd int,
913
F_202cb962ac59075b964b07152d234b70 int,
914
F_c8ffe9a587b126f152ed3d89a146b445 int,
915
F_3def184ad8f4755ff269862ea77393dd int,
916
F_069059b7ef840f0c74a814ec9237b6ec int,
917
F_ec5decca5ed3d6b8079e2e7e7bacc9f2 int,
918
F_76dc611d6ebaafc66cc0879c71b5db5c int,
919
F_d1f491a404d6854880943e5c3cd9ca25 int,
920
F_9b8619251a19057cff70779273e95aa6 int,
921
F_1afa34a7f984eeabdbb0a7d494132ee5 int,
922
F_65ded5353c5ee48d0b7d48c591b8f430 int,
923
F_9fc3d7152ba9336a670e36d0ed79bc43 int,
924
F_02522a2b2726fb0a03bb19f2d8d9524d int,
925
F_7f1de29e6da19d22b51c68001e7e0e54 int,
926
F_42a0e188f5033bc65bf8d78622277c4e int,
927
F_3988c7f88ebcb58c6ce932b957b6f332 int,
928
F_013d407166ec4fa56eb1e1f8cbe183b9 int,
929
F_e00da03b685a0dd18fb6a08af0923de0 int,
930
F_1385974ed5904a438616ff7bdb3f7439 int,
931
F_0f28b5d49b3020afeecd95b4009adf4c int,
932
F_a8baa56554f96369ab93e4f3bb068c22 int,
933
F_903ce9225fca3e988c2af215d4e544d3 int,
934
F_0a09c8844ba8f0936c20bd791130d6b6 int,
935
F_2b24d495052a8ce66358eb576b8912c8 int,
936
F_a5e00132373a7031000fd987a3c9f87b int,
937
F_8d5e957f297893487bd98fa830fa6413 int,
938
F_47d1e990583c9c67424d369f3414728e int,
939
F_f2217062e9a397a1dca429e7d70bc6ca int,
940
F_7ef605fc8dba5425d6965fbd4c8fbe1f int,
941
F_a8f15eda80c50adb0e71943adc8015cf int,
942
F_37a749d808e46495a8da1e5352d03cae int,
943
F_b3e3e393c77e35a4a3f3cbd1e429b5dc int,
944
F_1d7f7abc18fcb43975065399b0d1e48e int,
945
F_2a79ea27c279e471f4d180b08d62b00a int,
946
F_1c9ac0159c94d8d0cbedc973445af2da int,
947
F_6c4b761a28b734fe93831e3fb400ce87 int,
948
F_06409663226af2f3114485aa4e0a23b4 int,
949
F_140f6969d5213fd0ece03148e62e461e int,
950
F_b73ce398c39f506af761d2277d853a92 int,
951
F_bd4c9ab730f5513206b999ec0d90d1fb int,
952
F_82aa4b0af34c2313a562076992e50aa3 int,
953
F_0777d5c17d4066b82ab86dff8a46af6f int,
954
F_fa7cdfad1a5aaf8370ebeda47a1ff1c3 int,
955
F_9766527f2b5d3e95d4a733fcfb77bd7e int,
956
F_7e7757b1e12abcb736ab9a754ffb617a int,
957
F_5878a7ab84fb43402106c575658472fa int,
958
F_006f52e9102a8d3be2fe5614f42ba989 int,
959
F_3636638817772e42b59d74cff571fbb3 int,
960
F_149e9677a5989fd342ae44213df68868 int,
961
F_a4a042cf4fd6bfb47701cbc8a1653ada int,
962
F_1ff8a7b5dc7a7d1f0ed65aaa29c04b1e int,
963
F_f7e6c85504ce6e82442c770f7c8606f0 int,
964
F_bf8229696f7a3bb4700cfddef19fa23f int,
965
F_82161242827b703e6acf9c726942a1e4 int,
966
F_38af86134b65d0f10fe33d30dd76442e int,
967
F_96da2f590cd7246bbde0051047b0d6f7 int,
968
F_8f85517967795eeef66c225f7883bdcb int,
969
F_8f53295a73878494e9bc8dd6c3c7104f int,
970
F_045117b0e0a11a242b9765e79cbf113f int,
971
F_fc221309746013ac554571fbd180e1c8 int,
972
F_4c5bde74a8f110656874902f07378009 int,
973
F_cedebb6e872f539bef8c3f919874e9d7 int,
974
F_6cdd60ea0045eb7a6ec44c54d29ed402 int,
975
F_eecca5b6365d9607ee5a9d336962c534 int,
976
F_9872ed9fc22fc182d371c3e9ed316094 int,
977
F_31fefc0e570cb3860f2a6d4b38c6490d int,
978
F_9dcb88e0137649590b755372b040afad int,
979
F_a2557a7b2e94197ff767970b67041697 int,
980
F_cfecdb276f634854f3ef915e2e980c31 int,
981
F_0aa1883c6411f7873cb83dacb17b0afc int,
982
F_58a2fc6ed39fd083f55d4182bf88826d int,
983
F_bd686fd640be98efaae0091fa301e613 int,
984
F_a597e50502f5ff68e3e25b9114205d4a int,
985
F_0336dcbab05b9d5ad24f4333c7658a0e int,
986
F_084b6fbb10729ed4da8c3d3f5a3ae7c9 int,
987
F_85d8ce590ad8981ca2c8286f79f59954 int,
988
F_0e65972dce68dad4d52d063967f0a705 int,
989
F_84d9ee44e457ddef7f2c4f25dc8fa865 int,
990
F_3644a684f98ea8fe223c713b77189a77 int,
991
F_757b505cfd34c64c85ca5b5690ee5293 int,
992
F_854d6fae5ee42911677c739ee1734486 int,
993
F_e2c0be24560d78c5e599c2a9c9d0bbd2 int,
994
F_274ad4786c3abca69fa097b85867d9a4 int,
995
F_eae27d77ca20db309e056e3d2dcd7d69 int,
996
F_7eabe3a1649ffa2b3ff8c02ebfd5659f int,
997
F_69adc1e107f7f7d035d7baf04342e1ca int,
998
F_091d584fced301b442654dd8c23b3fc9 int,
999
F_b1d10e7bafa4421218a51b1e1f1b0ba2 int,
1000
F_6f3ef77ac0e3619e98159e9b6febf557 int,
1001
F_eb163727917cbba1eea208541a643e74 int,
1002
F_1534b76d325a8f591b52d302e7181331 int,
1003
F_979d472a84804b9f647bc185a877a8b5 int,
1004
F_ca46c1b9512a7a8315fa3c5a946e8265 int,
1005
F_3b8a614226a953a8cd9526fca6fe9ba5 int,
1006
F_45fbc6d3e05ebd93369ce542e8f2322d int,
1007
F_63dc7ed1010d3c3b8269faf0ba7491d4 int,
1008
F_e96ed478dab8595a7dbda4cbcbee168f int,
1009
F_c0e190d8267e36708f955d7ab048990d int,
1010
F_ec8ce6abb3e952a85b8551ba726a1227 int,
1011
F_060ad92489947d410d897474079c1477 int,
1012
F_bcbe3365e6ac95ea2c0343a2395834dd int,
1013
F_115f89503138416a242f40fb7d7f338e int,
1014
F_13fe9d84310e77f13a6d184dbf1232f3 int,
1015
F_d1c38a09acc34845c6be3a127a5aacaf int,
1016
F_9cfdf10e8fc047a44b08ed031e1f0ed1 int,
1017
F_705f2172834666788607efbfca35afb3 int,
1018
F_74db120f0a8e5646ef5a30154e9f6deb int,
1019
F_57aeee35c98205091e18d1140e9f38cf int,
1020
F_6da9003b743b65f4c0ccd295cc484e57 int,
1021
F_9b04d152845ec0a378394003c96da594 int,
1022
F_be83ab3ecd0db773eb2dc1b0a17836a1 int,
1023
F_e165421110ba03099a1c0393373c5b43 int,
1024
F_289dff07669d7a23de0ef88d2f7129e7 int,
1025
F_577ef1154f3240ad5b9b413aa7346a1e int,
1026
F_01161aaa0b6d1345dd8fe4e481144d84 int,
1027
F_539fd53b59e3bb12d203f45a912eeaf2 int,
1028
F_ac1dd209cbcc5e5d1c6e28598e8cbbe8 int,
1029
F_555d6702c950ecb729a966504af0a635 int,
1030
F_335f5352088d7d9bf74191e006d8e24c int,
1031
F_f340f1b1f65b6df5b5e3f94d95b11daf int,
1032
F_e4a6222cdb5b34375400904f03d8e6a5 int,
1033
F_cb70ab375662576bd1ac5aaf16b3fca4 int,
1034
F_9188905e74c28e489b44e954ec0b9bca int,
1035
F_0266e33d3f546cb5436a10798e657d97 int,
1036
F_38db3aed920cf82ab059bfccbd02be6a int,
1037
F_3cec07e9ba5f5bb252d13f5f431e4bbb int,
1038
F_621bf66ddb7c962aa0d22ac97d69b793 int,
1039
F_077e29b11be80ab57e1a2ecabb7da330 int,
1040
F_6c9882bbac1c7093bd25041881277658 int,
1041
F_19f3cd308f1455b3fa09a282e0d496f4 int,
1042
F_03c6b06952c750899bb03d998e631860 int,
1043
F_c24cd76e1ce41366a4bbe8a49b02a028 int,
1044
F_c52f1bd66cc19d05628bd8bf27af3ad6 int,
1045
F_fe131d7f5a6b38b23cc967316c13dae2 int,
1046
F_f718499c1c8cef6730f9fd03c8125cab int,
1047
F_d96409bf894217686ba124d7356686c9 int,
1048
F_502e4a16930e414107ee22b6198c578f int,
1049
F_cfa0860e83a4c3a763a7e62d825349f7 int,
1050
F_a4f23670e1833f3fdb077ca70bbd5d66 int,
1051
F_b1a59b315fc9a3002ce38bbe070ec3f5 int,
1052
F_36660e59856b4de58a219bcf4e27eba3 int,
1053
F_8c19f571e251e61cb8dd3612f26d5ecf int,
1054
F_d6baf65e0b240ce177cf70da146c8dc8 int,
1055
F_e56954b4f6347e897f954495eab16a88 int,
1056
F_f7664060cc52bc6f3d620bcedc94a4b6 int,
1057
F_eda80a3d5b344bc40f3bc04f65b7a357 int,
1058
F_8f121ce07d74717e0b1f21d122e04521 int,
1059
F_06138bc5af6023646ede0e1f7c1eac75 int,
1060
F_39059724f73a9969845dfe4146c5660e int,
1061
F_7f100b7b36092fb9b06dfb4fac360931 int,
1062
F_7a614fd06c325499f1680b9896beedeb int,
1063
F_4734ba6f3de83d861c3176a6273cac6d int,
1064
F_d947bf06a885db0d477d707121934ff8 int,
1065
F_63923f49e5241343aa7acb6a06a751e7 int,
1066
F_db8e1af0cb3aca1ae2d0018624204529 int,
1067
F_20f07591c6fcb220ffe637cda29bb3f6 int,
1068
F_07cdfd23373b17c6b337251c22b7ea57 int,
1069
F_d395771085aab05244a4fb8fd91bf4ee int,
1070
F_92c8c96e4c37100777c7190b76d28233 int,
1071
F_e3796ae838835da0b6f6ea37bcf8bcb7 int,
1072
F_6a9aeddfc689c1d0e3b9ccc3ab651bc5 int,
1073
F_0f49c89d1e7298bb9930789c8ed59d48 int,
1074
F_46ba9f2a6976570b0353203ec4474217 int,
1075
F_0e01938fc48a2cfb5f2217fbfb00722d int,
1076
F_16a5cdae362b8d27a1d8f8c7b78b4330 int,
1077
F_918317b57931b6b7a7d29490fe5ec9f9 int,
1078
F_48aedb8880cab8c45637abc7493ecddd int,
1079
F_839ab46820b524afda05122893c2fe8e int,
1080
F_f90f2aca5c640289d0a29417bcb63a37 int,
1081
F_9c838d2e45b2ad1094d42f4ef36764f6 int,
1082
F_1700002963a49da13542e0726b7bb758 int,
1083
F_53c3bce66e43be4f209556518c2fcb54 int,
1084
F_6883966fd8f918a4aa29be29d2c386fb int,
1085
F_49182f81e6a13cf5eaa496d51fea6406 int,
1086
F_d296c101daa88a51f6ca8cfc1ac79b50 int,
1087
F_9fd81843ad7f202f26c1a174c7357585 int,
1088
F_26e359e83860db1d11b6acca57d8ea88 int,
1089
F_ef0d3930a7b6c95bd2b32ed45989c61f int,
1090
F_94f6d7e04a4d452035300f18b984988c int,
1091
F_34ed066df378efacc9b924ec161e7639 int,
1092
F_577bcc914f9e55d5e4e4f82f9f00e7d4 int,
1093
F_11b9842e0a271ff252c1903e7132cd68 int,
1094
F_37bc2f75bf1bcfe8450a1a41c200364c int,
1095
F_496e05e1aea0a9c4655800e8a7b9ea28 int,
1096
F_b2eb7349035754953b57a32e2841bda5 int,
1097
F_8e98d81f8217304975ccb23337bb5761 int,
1098
F_a8c88a0055f636e4a163a5e3d16adab7 int,
1099
F_eddea82ad2755b24c4e168c5fc2ebd40 int,
1100
F_06eb61b839a0cefee4967c67ccb099dc int,
1101
F_9dfcd5e558dfa04aaf37f137a1d9d3e5 int,
1102
F_950a4152c2b4aa3ad78bdd6b366cc179 int,
1103
F_158f3069a435b314a80bdcb024f8e422 int,
1104
F_758874998f5bd0c393da094e1967a72b int,
1105
F_ad13a2a07ca4b7642959dc0c4c740ab6 int,
1106
F_3fe94a002317b5f9259f82690aeea4cd int,
1107
F_5b8add2a5d98b1a652ea7fd72d942dac int,
1108
F_432aca3a1e345e339f35a30c8f65edce int,
1109
F_8d3bba7425e7c98c50f52ca1b52d3735 int,
1110
F_320722549d1751cf3f247855f937b982 int,
1111
F_caf1a3dfb505ffed0d024130f58c5cfa int,
1112
F_5737c6ec2e0716f3d8a7a5c4e0de0d9a int,
1113
F_bc6dc48b743dc5d013b1abaebd2faed2 int,
1114
F_f2fc990265c712c49d51a18a32b39f0c int,
1115
F_89f0fd5c927d466d6ec9a21b9ac34ffa int,
1116
F_a666587afda6e89aec274a3657558a27 int,
1117
F_b83aac23b9528732c23cc7352950e880 int,
1118
F_cd00692c3bfe59267d5ecfac5310286c int,
1119
F_6faa8040da20ef399b63a72d0e4ab575 int,
1120
F_fe73f687e5bc5280214e0486b273a5f9 int);
1121
insert into t1 (F_8d3bba7425e7c98c50f52ca1b52d3735) values (1);
1123
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
1124
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
1125
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
1126
/*!40101 SET NAMES utf8 */;
1127
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
1128
/*!40103 SET TIME_ZONE='+00:00' */;
1129
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
1130
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
1131
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
1132
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
1133
DROP TABLE IF EXISTS `t1`;
1134
/*!40101 SET @saved_cs_client = @@character_set_client */;
1135
/*!40101 SET character_set_client = utf8 */;
1137
`F_c4ca4238a0b923820dcc509a6f75849b` int(11) DEFAULT NULL,
1138
`F_c81e728d9d4c2f636f067f89cc14862c` int(11) DEFAULT NULL,
1139
`F_eccbc87e4b5ce2fe28308fd9f2a7baf3` int(11) DEFAULT NULL,
1140
`F_a87ff679a2f3e71d9181a67b7542122c` int(11) DEFAULT NULL,
1141
`F_e4da3b7fbbce2345d7772b0674a318d5` int(11) DEFAULT NULL,
1142
`F_1679091c5a880faf6fb5e6087eb1b2dc` int(11) DEFAULT NULL,
1143
`F_8f14e45fceea167a5a36dedd4bea2543` int(11) DEFAULT NULL,
1144
`F_c9f0f895fb98ab9159f51fd0297e236d` int(11) DEFAULT NULL,
1145
`F_45c48cce2e2d7fbdea1afc51c7c6ad26` int(11) DEFAULT NULL,
1146
`F_d3d9446802a44259755d38e6d163e820` int(11) DEFAULT NULL,
1147
`F_6512bd43d9caa6e02c990b0a82652dca` int(11) DEFAULT NULL,
1148
`F_c20ad4d76fe97759aa27a0c99bff6710` int(11) DEFAULT NULL,
1149
`F_c51ce410c124a10e0db5e4b97fc2af39` int(11) DEFAULT NULL,
1150
`F_aab3238922bcc25a6f606eb525ffdc56` int(11) DEFAULT NULL,
1151
`F_9bf31c7ff062936a96d3c8bd1f8f2ff3` int(11) DEFAULT NULL,
1152
`F_c74d97b01eae257e44aa9d5bade97baf` int(11) DEFAULT NULL,
1153
`F_70efdf2ec9b086079795c442636b55fb` int(11) DEFAULT NULL,
1154
`F_6f4922f45568161a8cdf4ad2299f6d23` int(11) DEFAULT NULL,
1155
`F_1f0e3dad99908345f7439f8ffabdffc4` int(11) DEFAULT NULL,
1156
`F_98f13708210194c475687be6106a3b84` int(11) DEFAULT NULL,
1157
`F_3c59dc048e8850243be8079a5c74d079` int(11) DEFAULT NULL,
1158
`F_b6d767d2f8ed5d21a44b0e5886680cb9` int(11) DEFAULT NULL,
1159
`F_37693cfc748049e45d87b8c7d8b9aacd` int(11) DEFAULT NULL,
1160
`F_1ff1de774005f8da13f42943881c655f` int(11) DEFAULT NULL,
1161
`F_8e296a067a37563370ded05f5a3bf3ec` int(11) DEFAULT NULL,
1162
`F_4e732ced3463d06de0ca9a15b6153677` int(11) DEFAULT NULL,
1163
`F_02e74f10e0327ad868d138f2b4fdd6f0` int(11) DEFAULT NULL,
1164
`F_33e75ff09dd601bbe69f351039152189` int(11) DEFAULT NULL,
1165
`F_6ea9ab1baa0efb9e19094440c317e21b` int(11) DEFAULT NULL,
1166
`F_34173cb38f07f89ddbebc2ac9128303f` int(11) DEFAULT NULL,
1167
`F_c16a5320fa475530d9583c34fd356ef5` int(11) DEFAULT NULL,
1168
`F_6364d3f0f495b6ab9dcf8d3b5c6e0b01` int(11) DEFAULT NULL,
1169
`F_182be0c5cdcd5072bb1864cdee4d3d6e` int(11) DEFAULT NULL,
1170
`F_e369853df766fa44e1ed0ff613f563bd` int(11) DEFAULT NULL,
1171
`F_1c383cd30b7c298ab50293adfecb7b18` int(11) DEFAULT NULL,
1172
`F_19ca14e7ea6328a42e0eb13d585e4c22` int(11) DEFAULT NULL,
1173
`F_a5bfc9e07964f8dddeb95fc584cd965d` int(11) DEFAULT NULL,
1174
`F_a5771bce93e200c36f7cd9dfd0e5deaa` int(11) DEFAULT NULL,
1175
`F_d67d8ab4f4c10bf22aa353e27879133c` int(11) DEFAULT NULL,
1176
`F_d645920e395fedad7bbbed0eca3fe2e0` int(11) DEFAULT NULL,
1177
`F_3416a75f4cea9109507cacd8e2f2aefc` int(11) DEFAULT NULL,
1178
`F_a1d0c6e83f027327d8461063f4ac58a6` int(11) DEFAULT NULL,
1179
`F_17e62166fc8586dfa4d1bc0e1742c08b` int(11) DEFAULT NULL,
1180
`F_f7177163c833dff4b38fc8d2872f1ec6` int(11) DEFAULT NULL,
1181
`F_6c8349cc7260ae62e3b1396831a8398f` int(11) DEFAULT NULL,
1182
`F_d9d4f495e875a2e075a1a4a6e1b9770f` int(11) DEFAULT NULL,
1183
`F_67c6a1e7ce56d3d6fa748ab6d9af3fd7` int(11) DEFAULT NULL,
1184
`F_642e92efb79421734881b53e1e1b18b6` int(11) DEFAULT NULL,
1185
`F_f457c545a9ded88f18ecee47145a72c0` int(11) DEFAULT NULL,
1186
`F_c0c7c76d30bd3dcaefc96f40275bdc0a` int(11) DEFAULT NULL,
1187
`F_2838023a778dfaecdc212708f721b788` int(11) DEFAULT NULL,
1188
`F_9a1158154dfa42caddbd0694a4e9bdc8` int(11) DEFAULT NULL,
1189
`F_d82c8d1619ad8176d665453cfb2e55f0` int(11) DEFAULT NULL,
1190
`F_a684eceee76fc522773286a895bc8436` int(11) DEFAULT NULL,
1191
`F_b53b3a3d6ab90ce0268229151c9bde11` int(11) DEFAULT NULL,
1192
`F_9f61408e3afb633e50cdf1b20de6f466` int(11) DEFAULT NULL,
1193
`F_72b32a1f754ba1c09b3695e0cb6cde7f` int(11) DEFAULT NULL,
1194
`F_66f041e16a60928b05a7e228a89c3799` int(11) DEFAULT NULL,
1195
`F_093f65e080a295f8076b1c5722a46aa2` int(11) DEFAULT NULL,
1196
`F_072b030ba126b2f4b2374f342be9ed44` int(11) DEFAULT NULL,
1197
`F_7f39f8317fbdb1988ef4c628eba02591` int(11) DEFAULT NULL,
1198
`F_44f683a84163b3523afe57c2e008bc8c` int(11) DEFAULT NULL,
1199
`F_03afdbd66e7929b125f8597834fa83a4` int(11) DEFAULT NULL,
1200
`F_ea5d2f1c4608232e07d3aa3d998e5135` int(11) DEFAULT NULL,
1201
`F_fc490ca45c00b1249bbe3554a4fdf6fb` int(11) DEFAULT NULL,
1202
`F_3295c76acbf4caaed33c36b1b5fc2cb1` int(11) DEFAULT NULL,
1203
`F_735b90b4568125ed6c3f678819b6e058` int(11) DEFAULT NULL,
1204
`F_a3f390d88e4c41f2747bfa2f1b5f87db` int(11) DEFAULT NULL,
1205
`F_14bfa6bb14875e45bba028a21ed38046` int(11) DEFAULT NULL,
1206
`F_7cbbc409ec990f19c78c75bd1e06f215` int(11) DEFAULT NULL,
1207
`F_e2c420d928d4bf8ce0ff2ec19b371514` int(11) DEFAULT NULL,
1208
`F_32bb90e8976aab5298d5da10fe66f21d` int(11) DEFAULT NULL,
1209
`F_d2ddea18f00665ce8623e36bd4e3c7c5` int(11) DEFAULT NULL,
1210
`F_ad61ab143223efbc24c7d2583be69251` int(11) DEFAULT NULL,
1211
`F_d09bf41544a3365a46c9077ebb5e35c3` int(11) DEFAULT NULL,
1212
`F_fbd7939d674997cdb4692d34de8633c4` int(11) DEFAULT NULL,
1213
`F_28dd2c7955ce926456240b2ff0100bde` int(11) DEFAULT NULL,
1214
`F_35f4a8d465e6e1edc05f3d8ab658c551` int(11) DEFAULT NULL,
1215
`F_d1fe173d08e959397adf34b1d77e88d7` int(11) DEFAULT NULL,
1216
`F_f033ab37c30201f73f142449d037028d` int(11) DEFAULT NULL,
1217
`F_43ec517d68b6edd3015b3edc9a11367b` int(11) DEFAULT NULL,
1218
`F_9778d5d219c5080b9a6a17bef029331c` int(11) DEFAULT NULL,
1219
`F_fe9fc289c3ff0af142b6d3bead98a923` int(11) DEFAULT NULL,
1220
`F_68d30a9594728bc39aa24be94b319d21` int(11) DEFAULT NULL,
1221
`F_3ef815416f775098fe977004015c6193` int(11) DEFAULT NULL,
1222
`F_93db85ed909c13838ff95ccfa94cebd9` int(11) DEFAULT NULL,
1223
`F_c7e1249ffc03eb9ded908c236bd1996d` int(11) DEFAULT NULL,
1224
`F_2a38a4a9316c49e5a833517c45d31070` int(11) DEFAULT NULL,
1225
`F_7647966b7343c29048673252e490f736` int(11) DEFAULT NULL,
1226
`F_8613985ec49eb8f757ae6439e879bb2a` int(11) DEFAULT NULL,
1227
`F_54229abfcfa5649e7003b83dd4755294` int(11) DEFAULT NULL,
1228
`F_92cc227532d17e56e07902b254dfad10` int(11) DEFAULT NULL,
1229
`F_98dce83da57b0395e163467c9dae521b` int(11) DEFAULT NULL,
1230
`F_f4b9ec30ad9f68f89b29639786cb62ef` int(11) DEFAULT NULL,
1231
`F_812b4ba287f5ee0bc9d43bbf5bbe87fb` int(11) DEFAULT NULL,
1232
`F_26657d5ff9020d2abefe558796b99584` int(11) DEFAULT NULL,
1233
`F_e2ef524fbf3d9fe611d5a8e90fefdc9c` int(11) DEFAULT NULL,
1234
`F_ed3d2c21991e3bef5e069713af9fa6ca` int(11) DEFAULT NULL,
1235
`F_ac627ab1ccbdb62ec96e702f07f6425b` int(11) DEFAULT NULL,
1236
`F_f899139df5e1059396431415e770c6dd` int(11) DEFAULT NULL,
1237
`F_38b3eff8baf56627478ec76a704e9b52` int(11) DEFAULT NULL,
1238
`F_ec8956637a99787bd197eacd77acce5e` int(11) DEFAULT NULL,
1239
`F_6974ce5ac660610b44d9b9fed0ff9548` int(11) DEFAULT NULL,
1240
`F_c9e1074f5b3f9fc8ea15d152add07294` int(11) DEFAULT NULL,
1241
`F_65b9eea6e1cc6bb9f0cd2a47751a186f` int(11) DEFAULT NULL,
1242
`F_f0935e4cd5920aa6c7c996a5ee53a70f` int(11) DEFAULT NULL,
1243
`F_a97da629b098b75c294dffdc3e463904` int(11) DEFAULT NULL,
1244
`F_a3c65c2974270fd093ee8a9bf8ae7d0b` int(11) DEFAULT NULL,
1245
`F_2723d092b63885e0d7c260cc007e8b9d` int(11) DEFAULT NULL,
1246
`F_5f93f983524def3dca464469d2cf9f3e` int(11) DEFAULT NULL,
1247
`F_698d51a19d8a121ce581499d7b701668` int(11) DEFAULT NULL,
1248
`F_7f6ffaa6bb0b408017b62254211691b5` int(11) DEFAULT NULL,
1249
`F_73278a4a86960eeb576a8fd4c9ec6997` int(11) DEFAULT NULL,
1250
`F_5fd0b37cd7dbbb00f97ba6ce92bf5add` int(11) DEFAULT NULL,
1251
`F_2b44928ae11fb9384c4cf38708677c48` int(11) DEFAULT NULL,
1252
`F_c45147dee729311ef5b5c3003946c48f` int(11) DEFAULT NULL,
1253
`F_eb160de1de89d9058fcb0b968dbbbd68` int(11) DEFAULT NULL,
1254
`F_5ef059938ba799aaa845e1c2e8a762bd` int(11) DEFAULT NULL,
1255
`F_07e1cd7dca89a1678042477183b7ac3f` int(11) DEFAULT NULL,
1256
`F_da4fb5c6e93e74d3df8527599fa62642` int(11) DEFAULT NULL,
1257
`F_4c56ff4ce4aaf9573aa5dff913df997a` int(11) DEFAULT NULL,
1258
`F_a0a080f42e6f13b3a2df133f073095dd` int(11) DEFAULT NULL,
1259
`F_202cb962ac59075b964b07152d234b70` int(11) DEFAULT NULL,
1260
`F_c8ffe9a587b126f152ed3d89a146b445` int(11) DEFAULT NULL,
1261
`F_3def184ad8f4755ff269862ea77393dd` int(11) DEFAULT NULL,
1262
`F_069059b7ef840f0c74a814ec9237b6ec` int(11) DEFAULT NULL,
1263
`F_ec5decca5ed3d6b8079e2e7e7bacc9f2` int(11) DEFAULT NULL,
1264
`F_76dc611d6ebaafc66cc0879c71b5db5c` int(11) DEFAULT NULL,
1265
`F_d1f491a404d6854880943e5c3cd9ca25` int(11) DEFAULT NULL,
1266
`F_9b8619251a19057cff70779273e95aa6` int(11) DEFAULT NULL,
1267
`F_1afa34a7f984eeabdbb0a7d494132ee5` int(11) DEFAULT NULL,
1268
`F_65ded5353c5ee48d0b7d48c591b8f430` int(11) DEFAULT NULL,
1269
`F_9fc3d7152ba9336a670e36d0ed79bc43` int(11) DEFAULT NULL,
1270
`F_02522a2b2726fb0a03bb19f2d8d9524d` int(11) DEFAULT NULL,
1271
`F_7f1de29e6da19d22b51c68001e7e0e54` int(11) DEFAULT NULL,
1272
`F_42a0e188f5033bc65bf8d78622277c4e` int(11) DEFAULT NULL,
1273
`F_3988c7f88ebcb58c6ce932b957b6f332` int(11) DEFAULT NULL,
1274
`F_013d407166ec4fa56eb1e1f8cbe183b9` int(11) DEFAULT NULL,
1275
`F_e00da03b685a0dd18fb6a08af0923de0` int(11) DEFAULT NULL,
1276
`F_1385974ed5904a438616ff7bdb3f7439` int(11) DEFAULT NULL,
1277
`F_0f28b5d49b3020afeecd95b4009adf4c` int(11) DEFAULT NULL,
1278
`F_a8baa56554f96369ab93e4f3bb068c22` int(11) DEFAULT NULL,
1279
`F_903ce9225fca3e988c2af215d4e544d3` int(11) DEFAULT NULL,
1280
`F_0a09c8844ba8f0936c20bd791130d6b6` int(11) DEFAULT NULL,
1281
`F_2b24d495052a8ce66358eb576b8912c8` int(11) DEFAULT NULL,
1282
`F_a5e00132373a7031000fd987a3c9f87b` int(11) DEFAULT NULL,
1283
`F_8d5e957f297893487bd98fa830fa6413` int(11) DEFAULT NULL,
1284
`F_47d1e990583c9c67424d369f3414728e` int(11) DEFAULT NULL,
1285
`F_f2217062e9a397a1dca429e7d70bc6ca` int(11) DEFAULT NULL,
1286
`F_7ef605fc8dba5425d6965fbd4c8fbe1f` int(11) DEFAULT NULL,
1287
`F_a8f15eda80c50adb0e71943adc8015cf` int(11) DEFAULT NULL,
1288
`F_37a749d808e46495a8da1e5352d03cae` int(11) DEFAULT NULL,
1289
`F_b3e3e393c77e35a4a3f3cbd1e429b5dc` int(11) DEFAULT NULL,
1290
`F_1d7f7abc18fcb43975065399b0d1e48e` int(11) DEFAULT NULL,
1291
`F_2a79ea27c279e471f4d180b08d62b00a` int(11) DEFAULT NULL,
1292
`F_1c9ac0159c94d8d0cbedc973445af2da` int(11) DEFAULT NULL,
1293
`F_6c4b761a28b734fe93831e3fb400ce87` int(11) DEFAULT NULL,
1294
`F_06409663226af2f3114485aa4e0a23b4` int(11) DEFAULT NULL,
1295
`F_140f6969d5213fd0ece03148e62e461e` int(11) DEFAULT NULL,
1296
`F_b73ce398c39f506af761d2277d853a92` int(11) DEFAULT NULL,
1297
`F_bd4c9ab730f5513206b999ec0d90d1fb` int(11) DEFAULT NULL,
1298
`F_82aa4b0af34c2313a562076992e50aa3` int(11) DEFAULT NULL,
1299
`F_0777d5c17d4066b82ab86dff8a46af6f` int(11) DEFAULT NULL,
1300
`F_fa7cdfad1a5aaf8370ebeda47a1ff1c3` int(11) DEFAULT NULL,
1301
`F_9766527f2b5d3e95d4a733fcfb77bd7e` int(11) DEFAULT NULL,
1302
`F_7e7757b1e12abcb736ab9a754ffb617a` int(11) DEFAULT NULL,
1303
`F_5878a7ab84fb43402106c575658472fa` int(11) DEFAULT NULL,
1304
`F_006f52e9102a8d3be2fe5614f42ba989` int(11) DEFAULT NULL,
1305
`F_3636638817772e42b59d74cff571fbb3` int(11) DEFAULT NULL,
1306
`F_149e9677a5989fd342ae44213df68868` int(11) DEFAULT NULL,
1307
`F_a4a042cf4fd6bfb47701cbc8a1653ada` int(11) DEFAULT NULL,
1308
`F_1ff8a7b5dc7a7d1f0ed65aaa29c04b1e` int(11) DEFAULT NULL,
1309
`F_f7e6c85504ce6e82442c770f7c8606f0` int(11) DEFAULT NULL,
1310
`F_bf8229696f7a3bb4700cfddef19fa23f` int(11) DEFAULT NULL,
1311
`F_82161242827b703e6acf9c726942a1e4` int(11) DEFAULT NULL,
1312
`F_38af86134b65d0f10fe33d30dd76442e` int(11) DEFAULT NULL,
1313
`F_96da2f590cd7246bbde0051047b0d6f7` int(11) DEFAULT NULL,
1314
`F_8f85517967795eeef66c225f7883bdcb` int(11) DEFAULT NULL,
1315
`F_8f53295a73878494e9bc8dd6c3c7104f` int(11) DEFAULT NULL,
1316
`F_045117b0e0a11a242b9765e79cbf113f` int(11) DEFAULT NULL,
1317
`F_fc221309746013ac554571fbd180e1c8` int(11) DEFAULT NULL,
1318
`F_4c5bde74a8f110656874902f07378009` int(11) DEFAULT NULL,
1319
`F_cedebb6e872f539bef8c3f919874e9d7` int(11) DEFAULT NULL,
1320
`F_6cdd60ea0045eb7a6ec44c54d29ed402` int(11) DEFAULT NULL,
1321
`F_eecca5b6365d9607ee5a9d336962c534` int(11) DEFAULT NULL,
1322
`F_9872ed9fc22fc182d371c3e9ed316094` int(11) DEFAULT NULL,
1323
`F_31fefc0e570cb3860f2a6d4b38c6490d` int(11) DEFAULT NULL,
1324
`F_9dcb88e0137649590b755372b040afad` int(11) DEFAULT NULL,
1325
`F_a2557a7b2e94197ff767970b67041697` int(11) DEFAULT NULL,
1326
`F_cfecdb276f634854f3ef915e2e980c31` int(11) DEFAULT NULL,
1327
`F_0aa1883c6411f7873cb83dacb17b0afc` int(11) DEFAULT NULL,
1328
`F_58a2fc6ed39fd083f55d4182bf88826d` int(11) DEFAULT NULL,
1329
`F_bd686fd640be98efaae0091fa301e613` int(11) DEFAULT NULL,
1330
`F_a597e50502f5ff68e3e25b9114205d4a` int(11) DEFAULT NULL,
1331
`F_0336dcbab05b9d5ad24f4333c7658a0e` int(11) DEFAULT NULL,
1332
`F_084b6fbb10729ed4da8c3d3f5a3ae7c9` int(11) DEFAULT NULL,
1333
`F_85d8ce590ad8981ca2c8286f79f59954` int(11) DEFAULT NULL,
1334
`F_0e65972dce68dad4d52d063967f0a705` int(11) DEFAULT NULL,
1335
`F_84d9ee44e457ddef7f2c4f25dc8fa865` int(11) DEFAULT NULL,
1336
`F_3644a684f98ea8fe223c713b77189a77` int(11) DEFAULT NULL,
1337
`F_757b505cfd34c64c85ca5b5690ee5293` int(11) DEFAULT NULL,
1338
`F_854d6fae5ee42911677c739ee1734486` int(11) DEFAULT NULL,
1339
`F_e2c0be24560d78c5e599c2a9c9d0bbd2` int(11) DEFAULT NULL,
1340
`F_274ad4786c3abca69fa097b85867d9a4` int(11) DEFAULT NULL,
1341
`F_eae27d77ca20db309e056e3d2dcd7d69` int(11) DEFAULT NULL,
1342
`F_7eabe3a1649ffa2b3ff8c02ebfd5659f` int(11) DEFAULT NULL,
1343
`F_69adc1e107f7f7d035d7baf04342e1ca` int(11) DEFAULT NULL,
1344
`F_091d584fced301b442654dd8c23b3fc9` int(11) DEFAULT NULL,
1345
`F_b1d10e7bafa4421218a51b1e1f1b0ba2` int(11) DEFAULT NULL,
1346
`F_6f3ef77ac0e3619e98159e9b6febf557` int(11) DEFAULT NULL,
1347
`F_eb163727917cbba1eea208541a643e74` int(11) DEFAULT NULL,
1348
`F_1534b76d325a8f591b52d302e7181331` int(11) DEFAULT NULL,
1349
`F_979d472a84804b9f647bc185a877a8b5` int(11) DEFAULT NULL,
1350
`F_ca46c1b9512a7a8315fa3c5a946e8265` int(11) DEFAULT NULL,
1351
`F_3b8a614226a953a8cd9526fca6fe9ba5` int(11) DEFAULT NULL,
1352
`F_45fbc6d3e05ebd93369ce542e8f2322d` int(11) DEFAULT NULL,
1353
`F_63dc7ed1010d3c3b8269faf0ba7491d4` int(11) DEFAULT NULL,
1354
`F_e96ed478dab8595a7dbda4cbcbee168f` int(11) DEFAULT NULL,
1355
`F_c0e190d8267e36708f955d7ab048990d` int(11) DEFAULT NULL,
1356
`F_ec8ce6abb3e952a85b8551ba726a1227` int(11) DEFAULT NULL,
1357
`F_060ad92489947d410d897474079c1477` int(11) DEFAULT NULL,
1358
`F_bcbe3365e6ac95ea2c0343a2395834dd` int(11) DEFAULT NULL,
1359
`F_115f89503138416a242f40fb7d7f338e` int(11) DEFAULT NULL,
1360
`F_13fe9d84310e77f13a6d184dbf1232f3` int(11) DEFAULT NULL,
1361
`F_d1c38a09acc34845c6be3a127a5aacaf` int(11) DEFAULT NULL,
1362
`F_9cfdf10e8fc047a44b08ed031e1f0ed1` int(11) DEFAULT NULL,
1363
`F_705f2172834666788607efbfca35afb3` int(11) DEFAULT NULL,
1364
`F_74db120f0a8e5646ef5a30154e9f6deb` int(11) DEFAULT NULL,
1365
`F_57aeee35c98205091e18d1140e9f38cf` int(11) DEFAULT NULL,
1366
`F_6da9003b743b65f4c0ccd295cc484e57` int(11) DEFAULT NULL,
1367
`F_9b04d152845ec0a378394003c96da594` int(11) DEFAULT NULL,
1368
`F_be83ab3ecd0db773eb2dc1b0a17836a1` int(11) DEFAULT NULL,
1369
`F_e165421110ba03099a1c0393373c5b43` int(11) DEFAULT NULL,
1370
`F_289dff07669d7a23de0ef88d2f7129e7` int(11) DEFAULT NULL,
1371
`F_577ef1154f3240ad5b9b413aa7346a1e` int(11) DEFAULT NULL,
1372
`F_01161aaa0b6d1345dd8fe4e481144d84` int(11) DEFAULT NULL,
1373
`F_539fd53b59e3bb12d203f45a912eeaf2` int(11) DEFAULT NULL,
1374
`F_ac1dd209cbcc5e5d1c6e28598e8cbbe8` int(11) DEFAULT NULL,
1375
`F_555d6702c950ecb729a966504af0a635` int(11) DEFAULT NULL,
1376
`F_335f5352088d7d9bf74191e006d8e24c` int(11) DEFAULT NULL,
1377
`F_f340f1b1f65b6df5b5e3f94d95b11daf` int(11) DEFAULT NULL,
1378
`F_e4a6222cdb5b34375400904f03d8e6a5` int(11) DEFAULT NULL,
1379
`F_cb70ab375662576bd1ac5aaf16b3fca4` int(11) DEFAULT NULL,
1380
`F_9188905e74c28e489b44e954ec0b9bca` int(11) DEFAULT NULL,
1381
`F_0266e33d3f546cb5436a10798e657d97` int(11) DEFAULT NULL,
1382
`F_38db3aed920cf82ab059bfccbd02be6a` int(11) DEFAULT NULL,
1383
`F_3cec07e9ba5f5bb252d13f5f431e4bbb` int(11) DEFAULT NULL,
1384
`F_621bf66ddb7c962aa0d22ac97d69b793` int(11) DEFAULT NULL,
1385
`F_077e29b11be80ab57e1a2ecabb7da330` int(11) DEFAULT NULL,
1386
`F_6c9882bbac1c7093bd25041881277658` int(11) DEFAULT NULL,
1387
`F_19f3cd308f1455b3fa09a282e0d496f4` int(11) DEFAULT NULL,
1388
`F_03c6b06952c750899bb03d998e631860` int(11) DEFAULT NULL,
1389
`F_c24cd76e1ce41366a4bbe8a49b02a028` int(11) DEFAULT NULL,
1390
`F_c52f1bd66cc19d05628bd8bf27af3ad6` int(11) DEFAULT NULL,
1391
`F_fe131d7f5a6b38b23cc967316c13dae2` int(11) DEFAULT NULL,
1392
`F_f718499c1c8cef6730f9fd03c8125cab` int(11) DEFAULT NULL,
1393
`F_d96409bf894217686ba124d7356686c9` int(11) DEFAULT NULL,
1394
`F_502e4a16930e414107ee22b6198c578f` int(11) DEFAULT NULL,
1395
`F_cfa0860e83a4c3a763a7e62d825349f7` int(11) DEFAULT NULL,
1396
`F_a4f23670e1833f3fdb077ca70bbd5d66` int(11) DEFAULT NULL,
1397
`F_b1a59b315fc9a3002ce38bbe070ec3f5` int(11) DEFAULT NULL,
1398
`F_36660e59856b4de58a219bcf4e27eba3` int(11) DEFAULT NULL,
1399
`F_8c19f571e251e61cb8dd3612f26d5ecf` int(11) DEFAULT NULL,
1400
`F_d6baf65e0b240ce177cf70da146c8dc8` int(11) DEFAULT NULL,
1401
`F_e56954b4f6347e897f954495eab16a88` int(11) DEFAULT NULL,
1402
`F_f7664060cc52bc6f3d620bcedc94a4b6` int(11) DEFAULT NULL,
1403
`F_eda80a3d5b344bc40f3bc04f65b7a357` int(11) DEFAULT NULL,
1404
`F_8f121ce07d74717e0b1f21d122e04521` int(11) DEFAULT NULL,
1405
`F_06138bc5af6023646ede0e1f7c1eac75` int(11) DEFAULT NULL,
1406
`F_39059724f73a9969845dfe4146c5660e` int(11) DEFAULT NULL,
1407
`F_7f100b7b36092fb9b06dfb4fac360931` int(11) DEFAULT NULL,
1408
`F_7a614fd06c325499f1680b9896beedeb` int(11) DEFAULT NULL,
1409
`F_4734ba6f3de83d861c3176a6273cac6d` int(11) DEFAULT NULL,
1410
`F_d947bf06a885db0d477d707121934ff8` int(11) DEFAULT NULL,
1411
`F_63923f49e5241343aa7acb6a06a751e7` int(11) DEFAULT NULL,
1412
`F_db8e1af0cb3aca1ae2d0018624204529` int(11) DEFAULT NULL,
1413
`F_20f07591c6fcb220ffe637cda29bb3f6` int(11) DEFAULT NULL,
1414
`F_07cdfd23373b17c6b337251c22b7ea57` int(11) DEFAULT NULL,
1415
`F_d395771085aab05244a4fb8fd91bf4ee` int(11) DEFAULT NULL,
1416
`F_92c8c96e4c37100777c7190b76d28233` int(11) DEFAULT NULL,
1417
`F_e3796ae838835da0b6f6ea37bcf8bcb7` int(11) DEFAULT NULL,
1418
`F_6a9aeddfc689c1d0e3b9ccc3ab651bc5` int(11) DEFAULT NULL,
1419
`F_0f49c89d1e7298bb9930789c8ed59d48` int(11) DEFAULT NULL,
1420
`F_46ba9f2a6976570b0353203ec4474217` int(11) DEFAULT NULL,
1421
`F_0e01938fc48a2cfb5f2217fbfb00722d` int(11) DEFAULT NULL,
1422
`F_16a5cdae362b8d27a1d8f8c7b78b4330` int(11) DEFAULT NULL,
1423
`F_918317b57931b6b7a7d29490fe5ec9f9` int(11) DEFAULT NULL,
1424
`F_48aedb8880cab8c45637abc7493ecddd` int(11) DEFAULT NULL,
1425
`F_839ab46820b524afda05122893c2fe8e` int(11) DEFAULT NULL,
1426
`F_f90f2aca5c640289d0a29417bcb63a37` int(11) DEFAULT NULL,
1427
`F_9c838d2e45b2ad1094d42f4ef36764f6` int(11) DEFAULT NULL,
1428
`F_1700002963a49da13542e0726b7bb758` int(11) DEFAULT NULL,
1429
`F_53c3bce66e43be4f209556518c2fcb54` int(11) DEFAULT NULL,
1430
`F_6883966fd8f918a4aa29be29d2c386fb` int(11) DEFAULT NULL,
1431
`F_49182f81e6a13cf5eaa496d51fea6406` int(11) DEFAULT NULL,
1432
`F_d296c101daa88a51f6ca8cfc1ac79b50` int(11) DEFAULT NULL,
1433
`F_9fd81843ad7f202f26c1a174c7357585` int(11) DEFAULT NULL,
1434
`F_26e359e83860db1d11b6acca57d8ea88` int(11) DEFAULT NULL,
1435
`F_ef0d3930a7b6c95bd2b32ed45989c61f` int(11) DEFAULT NULL,
1436
`F_94f6d7e04a4d452035300f18b984988c` int(11) DEFAULT NULL,
1437
`F_34ed066df378efacc9b924ec161e7639` int(11) DEFAULT NULL,
1438
`F_577bcc914f9e55d5e4e4f82f9f00e7d4` int(11) DEFAULT NULL,
1439
`F_11b9842e0a271ff252c1903e7132cd68` int(11) DEFAULT NULL,
1440
`F_37bc2f75bf1bcfe8450a1a41c200364c` int(11) DEFAULT NULL,
1441
`F_496e05e1aea0a9c4655800e8a7b9ea28` int(11) DEFAULT NULL,
1442
`F_b2eb7349035754953b57a32e2841bda5` int(11) DEFAULT NULL,
1443
`F_8e98d81f8217304975ccb23337bb5761` int(11) DEFAULT NULL,
1444
`F_a8c88a0055f636e4a163a5e3d16adab7` int(11) DEFAULT NULL,
1445
`F_eddea82ad2755b24c4e168c5fc2ebd40` int(11) DEFAULT NULL,
1446
`F_06eb61b839a0cefee4967c67ccb099dc` int(11) DEFAULT NULL,
1447
`F_9dfcd5e558dfa04aaf37f137a1d9d3e5` int(11) DEFAULT NULL,
1448
`F_950a4152c2b4aa3ad78bdd6b366cc179` int(11) DEFAULT NULL,
1449
`F_158f3069a435b314a80bdcb024f8e422` int(11) DEFAULT NULL,
1450
`F_758874998f5bd0c393da094e1967a72b` int(11) DEFAULT NULL,
1451
`F_ad13a2a07ca4b7642959dc0c4c740ab6` int(11) DEFAULT NULL,
1452
`F_3fe94a002317b5f9259f82690aeea4cd` int(11) DEFAULT NULL,
1453
`F_5b8add2a5d98b1a652ea7fd72d942dac` int(11) DEFAULT NULL,
1454
`F_432aca3a1e345e339f35a30c8f65edce` int(11) DEFAULT NULL,
1455
`F_8d3bba7425e7c98c50f52ca1b52d3735` int(11) DEFAULT NULL,
1456
`F_320722549d1751cf3f247855f937b982` int(11) DEFAULT NULL,
1457
`F_caf1a3dfb505ffed0d024130f58c5cfa` int(11) DEFAULT NULL,
1458
`F_5737c6ec2e0716f3d8a7a5c4e0de0d9a` int(11) DEFAULT NULL,
1459
`F_bc6dc48b743dc5d013b1abaebd2faed2` int(11) DEFAULT NULL,
1460
`F_f2fc990265c712c49d51a18a32b39f0c` int(11) DEFAULT NULL,
1461
`F_89f0fd5c927d466d6ec9a21b9ac34ffa` int(11) DEFAULT NULL,
1462
`F_a666587afda6e89aec274a3657558a27` int(11) DEFAULT NULL,
1463
`F_b83aac23b9528732c23cc7352950e880` int(11) DEFAULT NULL,
1464
`F_cd00692c3bfe59267d5ecfac5310286c` int(11) DEFAULT NULL,
1465
`F_6faa8040da20ef399b63a72d0e4ab575` int(11) DEFAULT NULL,
1466
`F_fe73f687e5bc5280214e0486b273a5f9` int(11) DEFAULT NULL
1467
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1468
/*!40101 SET character_set_client = @saved_cs_client */;
1470
LOCK TABLES `t1` WRITE;
1471
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
1472
INSERT INTO `t1` (`F_c4ca4238a0b923820dcc509a6f75849b`, `F_c81e728d9d4c2f636f067f89cc14862c`, `F_eccbc87e4b5ce2fe28308fd9f2a7baf3`, `F_a87ff679a2f3e71d9181a67b7542122c`, `F_e4da3b7fbbce2345d7772b0674a318d5`, `F_1679091c5a880faf6fb5e6087eb1b2dc`, `F_8f14e45fceea167a5a36dedd4bea2543`, `F_c9f0f895fb98ab9159f51fd0297e236d`, `F_45c48cce2e2d7fbdea1afc51c7c6ad26`, `F_d3d9446802a44259755d38e6d163e820`, `F_6512bd43d9caa6e02c990b0a82652dca`, `F_c20ad4d76fe97759aa27a0c99bff6710`, `F_c51ce410c124a10e0db5e4b97fc2af39`, `F_aab3238922bcc25a6f606eb525ffdc56`, `F_9bf31c7ff062936a96d3c8bd1f8f2ff3`, `F_c74d97b01eae257e44aa9d5bade97baf`, `F_70efdf2ec9b086079795c442636b55fb`, `F_6f4922f45568161a8cdf4ad2299f6d23`, `F_1f0e3dad99908345f7439f8ffabdffc4`, `F_98f13708210194c475687be6106a3b84`, `F_3c59dc048e8850243be8079a5c74d079`, `F_b6d767d2f8ed5d21a44b0e5886680cb9`, `F_37693cfc748049e45d87b8c7d8b9aacd`, `F_1ff1de774005f8da13f42943881c655f`, `F_8e296a067a37563370ded05f5a3bf3ec`, `F_4e732ced3463d06de0ca9a15b6153677`, `F_02e74f10e0327ad868d138f2b4fdd6f0`, `F_33e75ff09dd601bbe69f351039152189`, `F_6ea9ab1baa0efb9e19094440c317e21b`, `F_34173cb38f07f89ddbebc2ac9128303f`, `F_c16a5320fa475530d9583c34fd356ef5`, `F_6364d3f0f495b6ab9dcf8d3b5c6e0b01`, `F_182be0c5cdcd5072bb1864cdee4d3d6e`, `F_e369853df766fa44e1ed0ff613f563bd`, `F_1c383cd30b7c298ab50293adfecb7b18`, `F_19ca14e7ea6328a42e0eb13d585e4c22`, `F_a5bfc9e07964f8dddeb95fc584cd965d`, `F_a5771bce93e200c36f7cd9dfd0e5deaa`, `F_d67d8ab4f4c10bf22aa353e27879133c`, `F_d645920e395fedad7bbbed0eca3fe2e0`, `F_3416a75f4cea9109507cacd8e2f2aefc`, `F_a1d0c6e83f027327d8461063f4ac58a6`, `F_17e62166fc8586dfa4d1bc0e1742c08b`, `F_f7177163c833dff4b38fc8d2872f1ec6`, `F_6c8349cc7260ae62e3b1396831a8398f`, `F_d9d4f495e875a2e075a1a4a6e1b9770f`, `F_67c6a1e7ce56d3d6fa748ab6d9af3fd7`, `F_642e92efb79421734881b53e1e1b18b6`, `F_f457c545a9ded88f18ecee47145a72c0`, `F_c0c7c76d30bd3dcaefc96f40275bdc0a`, `F_2838023a778dfaecdc212708f721b788`, `F_9a1158154dfa42caddbd0694a4e9bdc8`, `F_d82c8d1619ad8176d665453cfb2e55f0`, `F_a684eceee76fc522773286a895bc8436`, `F_b53b3a3d6ab90ce0268229151c9bde11`, `F_9f61408e3afb633e50cdf1b20de6f466`, `F_72b32a1f754ba1c09b3695e0cb6cde7f`, `F_66f041e16a60928b05a7e228a89c3799`, `F_093f65e080a295f8076b1c5722a46aa2`, `F_072b030ba126b2f4b2374f342be9ed44`, `F_7f39f8317fbdb1988ef4c628eba02591`, `F_44f683a84163b3523afe57c2e008bc8c`, `F_03afdbd66e7929b125f8597834fa83a4`, `F_ea5d2f1c4608232e07d3aa3d998e5135`, `F_fc490ca45c00b1249bbe3554a4fdf6fb`, `F_3295c76acbf4caaed33c36b1b5fc2cb1`, `F_735b90b4568125ed6c3f678819b6e058`, `F_a3f390d88e4c41f2747bfa2f1b5f87db`, `F_14bfa6bb14875e45bba028a21ed38046`, `F_7cbbc409ec990f19c78c75bd1e06f215`, `F_e2c420d928d4bf8ce0ff2ec19b371514`, `F_32bb90e8976aab5298d5da10fe66f21d`, `F_d2ddea18f00665ce8623e36bd4e3c7c5`, `F_ad61ab143223efbc24c7d2583be69251`, `F_d09bf41544a3365a46c9077ebb5e35c3`, `F_fbd7939d674997cdb4692d34de8633c4`, `F_28dd2c7955ce926456240b2ff0100bde`, `F_35f4a8d465e6e1edc05f3d8ab658c551`, `F_d1fe173d08e959397adf34b1d77e88d7`, `F_f033ab37c30201f73f142449d037028d`, `F_43ec517d68b6edd3015b3edc9a11367b`, `F_9778d5d219c5080b9a6a17bef029331c`, `F_fe9fc289c3ff0af142b6d3bead98a923`, `F_68d30a9594728bc39aa24be94b319d21`, `F_3ef815416f775098fe977004015c6193`, `F_93db85ed909c13838ff95ccfa94cebd9`, `F_c7e1249ffc03eb9ded908c236bd1996d`, `F_2a38a4a9316c49e5a833517c45d31070`, `F_7647966b7343c29048673252e490f736`, `F_8613985ec49eb8f757ae6439e879bb2a`, `F_54229abfcfa5649e7003b83dd4755294`, `F_92cc227532d17e56e07902b254dfad10`, `F_98dce83da57b0395e163467c9dae521b`, `F_f4b9ec30ad9f68f89b29639786cb62ef`, `F_812b4ba287f5ee0bc9d43bbf5bbe87fb`, `F_26657d5ff9020d2abefe558796b99584`, `F_e2ef524fbf3d9fe611d5a8e90fefdc9c`, `F_ed3d2c21991e3bef5e069713af9fa6ca`, `F_ac627ab1ccbdb62ec96e702f07f6425b`, `F_f899139df5e1059396431415e770c6dd`, `F_38b3eff8baf56627478ec76a704e9b52`, `F_ec8956637a99787bd197eacd77acce5e`, `F_6974ce5ac660610b44d9b9fed0ff9548`, `F_c9e1074f5b3f9fc8ea15d152add07294`, `F_65b9eea6e1cc6bb9f0cd2a47751a186f`, `F_f0935e4cd5920aa6c7c996a5ee53a70f`, `F_a97da629b098b75c294dffdc3e463904`, `F_a3c65c2974270fd093ee8a9bf8ae7d0b`, `F_2723d092b63885e0d7c260cc007e8b9d`, `F_5f93f983524def3dca464469d2cf9f3e`, `F_698d51a19d8a121ce581499d7b701668`, `F_7f6ffaa6bb0b408017b62254211691b5`, `F_73278a4a86960eeb576a8fd4c9ec6997`, `F_5fd0b37cd7dbbb00f97ba6ce92bf5add`, `F_2b44928ae11fb9384c4cf38708677c48`, `F_c45147dee729311ef5b5c3003946c48f`, `F_eb160de1de89d9058fcb0b968dbbbd68`, `F_5ef059938ba799aaa845e1c2e8a762bd`, `F_07e1cd7dca89a1678042477183b7ac3f`, `F_da4fb5c6e93e74d3df8527599fa62642`, `F_4c56ff4ce4aaf9573aa5dff913df997a`, `F_a0a080f42e6f13b3a2df133f073095dd`, `F_202cb962ac59075b964b07152d234b70`, `F_c8ffe9a587b126f152ed3d89a146b445`, `F_3def184ad8f4755ff269862ea77393dd`, `F_069059b7ef840f0c74a814ec9237b6ec`, `F_ec5decca5ed3d6b8079e2e7e7bacc9f2`, `F_76dc611d6ebaafc66cc0879c71b5db5c`, `F_d1f491a404d6854880943e5c3cd9ca25`, `F_9b8619251a19057cff70779273e95aa6`, `F_1afa34a7f984eeabdbb0a7d494132ee5`, `F_65ded5353c5ee48d0b7d48c591b8f430`, `F_9fc3d7152ba9336a670e36d0ed79bc43`, `F_02522a2b2726fb0a03bb19f2d8d9524d`, `F_7f1de29e6da19d22b51c68001e7e0e54`, `F_42a0e188f5033bc65bf8d78622277c4e`, `F_3988c7f88ebcb58c6ce932b957b6f332`, `F_013d407166ec4fa56eb1e1f8cbe183b9`, `F_e00da03b685a0dd18fb6a08af0923de0`, `F_1385974ed5904a438616ff7bdb3f7439`, `F_0f28b5d49b3020afeecd95b4009adf4c`, `F_a8baa56554f96369ab93e4f3bb068c22`, `F_903ce9225fca3e988c2af215d4e544d3`, `F_0a09c8844ba8f0936c20bd791130d6b6`, `F_2b24d495052a8ce66358eb576b8912c8`, `F_a5e00132373a7031000fd987a3c9f87b`, `F_8d5e957f297893487bd98fa830fa6413`, `F_47d1e990583c9c67424d369f3414728e`, `F_f2217062e9a397a1dca429e7d70bc6ca`, `F_7ef605fc8dba5425d6965fbd4c8fbe1f`, `F_a8f15eda80c50adb0e71943adc8015cf`, `F_37a749d808e46495a8da1e5352d03cae`, `F_b3e3e393c77e35a4a3f3cbd1e429b5dc`, `F_1d7f7abc18fcb43975065399b0d1e48e`, `F_2a79ea27c279e471f4d180b08d62b00a`, `F_1c9ac0159c94d8d0cbedc973445af2da`, `F_6c4b761a28b734fe93831e3fb400ce87`, `F_06409663226af2f3114485aa4e0a23b4`, `F_140f6969d5213fd0ece03148e62e461e`, `F_b73ce398c39f506af761d2277d853a92`, `F_bd4c9ab730f5513206b999ec0d90d1fb`, `F_82aa4b0af34c2313a562076992e50aa3`, `F_0777d5c17d4066b82ab86dff8a46af6f`, `F_fa7cdfad1a5aaf8370ebeda47a1ff1c3`, `F_9766527f2b5d3e95d4a733fcfb77bd7e`, `F_7e7757b1e12abcb736ab9a754ffb617a`, `F_5878a7ab84fb43402106c575658472fa`, `F_006f52e9102a8d3be2fe5614f42ba989`, `F_3636638817772e42b59d74cff571fbb3`, `F_149e9677a5989fd342ae44213df68868`, `F_a4a042cf4fd6bfb47701cbc8a1653ada`, `F_1ff8a7b5dc7a7d1f0ed65aaa29c04b1e`, `F_f7e6c85504ce6e82442c770f7c8606f0`, `F_bf8229696f7a3bb4700cfddef19fa23f`, `F_82161242827b703e6acf9c726942a1e4`, `F_38af86134b65d0f10fe33d30dd76442e`, `F_96da2f590cd7246bbde0051047b0d6f7`, `F_8f85517967795eeef66c225f7883bdcb`, `F_8f53295a73878494e9bc8dd6c3c7104f`, `F_045117b0e0a11a242b9765e79cbf113f`, `F_fc221309746013ac554571fbd180e1c8`, `F_4c5bde74a8f110656874902f07378009`, `F_cedebb6e872f539bef8c3f919874e9d7`, `F_6cdd60ea0045eb7a6ec44c54d29ed402`, `F_eecca5b6365d9607ee5a9d336962c534`, `F_9872ed9fc22fc182d371c3e9ed316094`, `F_31fefc0e570cb3860f2a6d4b38c6490d`, `F_9dcb88e0137649590b755372b040afad`, `F_a2557a7b2e94197ff767970b67041697`, `F_cfecdb276f634854f3ef915e2e980c31`, `F_0aa1883c6411f7873cb83dacb17b0afc`, `F_58a2fc6ed39fd083f55d4182bf88826d`, `F_bd686fd640be98efaae0091fa301e613`, `F_a597e50502f5ff68e3e25b9114205d4a`, `F_0336dcbab05b9d5ad24f4333c7658a0e`, `F_084b6fbb10729ed4da8c3d3f5a3ae7c9`, `F_85d8ce590ad8981ca2c8286f79f59954`, `F_0e65972dce68dad4d52d063967f0a705`, `F_84d9ee44e457ddef7f2c4f25dc8fa865`, `F_3644a684f98ea8fe223c713b77189a77`, `F_757b505cfd34c64c85ca5b5690ee5293`, `F_854d6fae5ee42911677c739ee1734486`, `F_e2c0be24560d78c5e599c2a9c9d0bbd2`, `F_274ad4786c3abca69fa097b85867d9a4`, `F_eae27d77ca20db309e056e3d2dcd7d69`, `F_7eabe3a1649ffa2b3ff8c02ebfd5659f`, `F_69adc1e107f7f7d035d7baf04342e1ca`, `F_091d584fced301b442654dd8c23b3fc9`, `F_b1d10e7bafa4421218a51b1e1f1b0ba2`, `F_6f3ef77ac0e3619e98159e9b6febf557`, `F_eb163727917cbba1eea208541a643e74`, `F_1534b76d325a8f591b52d302e7181331`, `F_979d472a84804b9f647bc185a877a8b5`, `F_ca46c1b9512a7a8315fa3c5a946e8265`, `F_3b8a614226a953a8cd9526fca6fe9ba5`, `F_45fbc6d3e05ebd93369ce542e8f2322d`, `F_63dc7ed1010d3c3b8269faf0ba7491d4`, `F_e96ed478dab8595a7dbda4cbcbee168f`, `F_c0e190d8267e36708f955d7ab048990d`, `F_ec8ce6abb3e952a85b8551ba726a1227`, `F_060ad92489947d410d897474079c1477`, `F_bcbe3365e6ac95ea2c0343a2395834dd`, `F_115f89503138416a242f40fb7d7f338e`, `F_13fe9d84310e77f13a6d184dbf1232f3`, `F_d1c38a09acc34845c6be3a127a5aacaf`, `F_9cfdf10e8fc047a44b08ed031e1f0ed1`, `F_705f2172834666788607efbfca35afb3`, `F_74db120f0a8e5646ef5a30154e9f6deb`, `F_57aeee35c98205091e18d1140e9f38cf`, `F_6da9003b743b65f4c0ccd295cc484e57`, `F_9b04d152845ec0a378394003c96da594`, `F_be83ab3ecd0db773eb2dc1b0a17836a1`, `F_e165421110ba03099a1c0393373c5b43`, `F_289dff07669d7a23de0ef88d2f7129e7`, `F_577ef1154f3240ad5b9b413aa7346a1e`, `F_01161aaa0b6d1345dd8fe4e481144d84`, `F_539fd53b59e3bb12d203f45a912eeaf2`, `F_ac1dd209cbcc5e5d1c6e28598e8cbbe8`, `F_555d6702c950ecb729a966504af0a635`, `F_335f5352088d7d9bf74191e006d8e24c`, `F_f340f1b1f65b6df5b5e3f94d95b11daf`, `F_e4a6222cdb5b34375400904f03d8e6a5`, `F_cb70ab375662576bd1ac5aaf16b3fca4`, `F_9188905e74c28e489b44e954ec0b9bca`, `F_0266e33d3f546cb5436a10798e657d97`, `F_38db3aed920cf82ab059bfccbd02be6a`, `F_3cec07e9ba5f5bb252d13f5f431e4bbb`, `F_621bf66ddb7c962aa0d22ac97d69b793`, `F_077e29b11be80ab57e1a2ecabb7da330`, `F_6c9882bbac1c7093bd25041881277658`, `F_19f3cd308f1455b3fa09a282e0d496f4`, `F_03c6b06952c750899bb03d998e631860`, `F_c24cd76e1ce41366a4bbe8a49b02a028`, `F_c52f1bd66cc19d05628bd8bf27af3ad6`, `F_fe131d7f5a6b38b23cc967316c13dae2`, `F_f718499c1c8cef6730f9fd03c8125cab`, `F_d96409bf894217686ba124d7356686c9`, `F_502e4a16930e414107ee22b6198c578f`, `F_cfa0860e83a4c3a763a7e62d825349f7`, `F_a4f23670e1833f3fdb077ca70bbd5d66`, `F_b1a59b315fc9a3002ce38bbe070ec3f5`, `F_36660e59856b4de58a219bcf4e27eba3`, `F_8c19f571e251e61cb8dd3612f26d5ecf`, `F_d6baf65e0b240ce177cf70da146c8dc8`, `F_e56954b4f6347e897f954495eab16a88`, `F_f7664060cc52bc6f3d620bcedc94a4b6`, `F_eda80a3d5b344bc40f3bc04f65b7a357`, `F_8f121ce07d74717e0b1f21d122e04521`, `F_06138bc5af6023646ede0e1f7c1eac75`, `F_39059724f73a9969845dfe4146c5660e`, `F_7f100b7b36092fb9b06dfb4fac360931`, `F_7a614fd06c325499f1680b9896beedeb`, `F_4734ba6f3de83d861c3176a6273cac6d`, `F_d947bf06a885db0d477d707121934ff8`, `F_63923f49e5241343aa7acb6a06a751e7`, `F_db8e1af0cb3aca1ae2d0018624204529`, `F_20f07591c6fcb220ffe637cda29bb3f6`, `F_07cdfd23373b17c6b337251c22b7ea57`, `F_d395771085aab05244a4fb8fd91bf4ee`, `F_92c8c96e4c37100777c7190b76d28233`, `F_e3796ae838835da0b6f6ea37bcf8bcb7`, `F_6a9aeddfc689c1d0e3b9ccc3ab651bc5`, `F_0f49c89d1e7298bb9930789c8ed59d48`, `F_46ba9f2a6976570b0353203ec4474217`, `F_0e01938fc48a2cfb5f2217fbfb00722d`, `F_16a5cdae362b8d27a1d8f8c7b78b4330`, `F_918317b57931b6b7a7d29490fe5ec9f9`, `F_48aedb8880cab8c45637abc7493ecddd`, `F_839ab46820b524afda05122893c2fe8e`, `F_f90f2aca5c640289d0a29417bcb63a37`, `F_9c838d2e45b2ad1094d42f4ef36764f6`, `F_1700002963a49da13542e0726b7bb758`, `F_53c3bce66e43be4f209556518c2fcb54`, `F_6883966fd8f918a4aa29be29d2c386fb`, `F_49182f81e6a13cf5eaa496d51fea6406`, `F_d296c101daa88a51f6ca8cfc1ac79b50`, `F_9fd81843ad7f202f26c1a174c7357585`, `F_26e359e83860db1d11b6acca57d8ea88`, `F_ef0d3930a7b6c95bd2b32ed45989c61f`, `F_94f6d7e04a4d452035300f18b984988c`, `F_34ed066df378efacc9b924ec161e7639`, `F_577bcc914f9e55d5e4e4f82f9f00e7d4`, `F_11b9842e0a271ff252c1903e7132cd68`, `F_37bc2f75bf1bcfe8450a1a41c200364c`, `F_496e05e1aea0a9c4655800e8a7b9ea28`, `F_b2eb7349035754953b57a32e2841bda5`, `F_8e98d81f8217304975ccb23337bb5761`, `F_a8c88a0055f636e4a163a5e3d16adab7`, `F_eddea82ad2755b24c4e168c5fc2ebd40`, `F_06eb61b839a0cefee4967c67ccb099dc`, `F_9dfcd5e558dfa04aaf37f137a1d9d3e5`, `F_950a4152c2b4aa3ad78bdd6b366cc179`, `F_158f3069a435b314a80bdcb024f8e422`, `F_758874998f5bd0c393da094e1967a72b`, `F_ad13a2a07ca4b7642959dc0c4c740ab6`, `F_3fe94a002317b5f9259f82690aeea4cd`, `F_5b8add2a5d98b1a652ea7fd72d942dac`, `F_432aca3a1e345e339f35a30c8f65edce`, `F_8d3bba7425e7c98c50f52ca1b52d3735`, `F_320722549d1751cf3f247855f937b982`, `F_caf1a3dfb505ffed0d024130f58c5cfa`, `F_5737c6ec2e0716f3d8a7a5c4e0de0d9a`, `F_bc6dc48b743dc5d013b1abaebd2faed2`, `F_f2fc990265c712c49d51a18a32b39f0c`, `F_89f0fd5c927d466d6ec9a21b9ac34ffa`, `F_a666587afda6e89aec274a3657558a27`, `F_b83aac23b9528732c23cc7352950e880`, `F_cd00692c3bfe59267d5ecfac5310286c`, `F_6faa8040da20ef399b63a72d0e4ab575`, `F_fe73f687e5bc5280214e0486b273a5f9`) VALUES (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
1473
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
1475
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1477
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1478
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1479
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1480
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1481
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1482
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1483
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1487
# Test for --add-drop-database
1489
CREATE TABLE t1 (a int);
1490
INSERT INTO t1 VALUES (1),(2),(3);
1492
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
1493
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
1494
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
1495
/*!40101 SET NAMES utf8 */;
1496
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
1497
/*!40103 SET TIME_ZONE='+00:00' */;
1498
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
1499
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
1500
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
1501
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
1503
/*!40000 DROP DATABASE IF EXISTS `test`*/;
1505
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test` /*!40100 DEFAULT CHARACTER SET latin1 */;
1508
DROP TABLE IF EXISTS `t1`;
1509
/*!40101 SET @saved_cs_client = @@character_set_client */;
1510
/*!40101 SET character_set_client = utf8 */;
1512
`a` int(11) DEFAULT NULL
1513
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1514
/*!40101 SET character_set_client = @saved_cs_client */;
1516
LOCK TABLES `t1` WRITE;
1517
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
1518
INSERT INTO `t1` VALUES (1),(2),(3);
1519
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
1521
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1523
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1524
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1525
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1526
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1527
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1528
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1529
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1533
# Bug#9558 mysqldump --no-data db t1 t2 format still dumps data
1535
CREATE DATABASE mysqldump_test_db;
1536
USE mysqldump_test_db;
1537
CREATE TABLE t1 ( a INT );
1538
CREATE TABLE t2 ( a INT );
1539
INSERT INTO t1 VALUES (1), (2);
1540
INSERT INTO t2 VALUES (1), (2);
1542
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
1543
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
1544
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
1545
/*!40101 SET NAMES utf8 */;
1546
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
1547
/*!40103 SET TIME_ZONE='+00:00' */;
1548
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
1549
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
1550
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
1551
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
1552
DROP TABLE IF EXISTS `t1`;
1553
/*!40101 SET @saved_cs_client = @@character_set_client */;
1554
/*!40101 SET character_set_client = utf8 */;
1556
`a` int(11) DEFAULT NULL
1557
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1558
/*!40101 SET character_set_client = @saved_cs_client */;
1559
DROP TABLE IF EXISTS `t2`;
1560
/*!40101 SET @saved_cs_client = @@character_set_client */;
1561
/*!40101 SET character_set_client = utf8 */;
1563
`a` int(11) DEFAULT NULL
1564
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1565
/*!40101 SET character_set_client = @saved_cs_client */;
1566
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1568
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1569
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1570
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1571
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1572
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1573
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1574
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1577
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
1578
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
1579
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
1580
/*!40101 SET NAMES utf8 */;
1581
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
1582
/*!40103 SET TIME_ZONE='+00:00' */;
1583
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
1584
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
1585
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
1586
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
1587
DROP TABLE IF EXISTS `t1`;
1588
/*!40101 SET @saved_cs_client = @@character_set_client */;
1589
/*!40101 SET character_set_client = utf8 */;
1591
`a` int(11) DEFAULT NULL
1592
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1593
/*!40101 SET character_set_client = @saved_cs_client */;
1594
DROP TABLE IF EXISTS `t2`;
1595
/*!40101 SET @saved_cs_client = @@character_set_client */;
1596
/*!40101 SET character_set_client = utf8 */;
1598
`a` int(11) DEFAULT NULL
1599
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1600
/*!40101 SET character_set_client = @saved_cs_client */;
1601
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1603
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1604
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1605
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1606
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1607
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1608
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1609
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1611
<?xml version="1.0"?>
1612
<mysqldump xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
1613
<database name="mysqldump_test_db">
1614
<table_structure name="t1">
1615
<field Field="a" Type="int(11)" Null="YES" Key="" Extra="" />
1617
<table_structure name="t2">
1618
<field Field="a" Type="int(11)" Null="YES" Key="" Extra="" />
1622
<?xml version="1.0"?>
1623
<mysqldump xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
1624
<database name="mysqldump_test_db">
1625
<table_structure name="t1">
1626
<field Field="a" Type="int(11)" Null="YES" Key="" Extra="" />
1628
<table_structure name="t2">
1629
<field Field="a" Type="int(11)" Null="YES" Key="" Extra="" />
1634
DROP DATABASE mysqldump_test_db;
1636
# Testing with tables and databases that don't exists
1637
# or contains illegal characters
1638
# (Bug#9358 mysqldump crashes if tablename starts with \)
1640
create database mysqldump_test_db;
1641
use mysqldump_test_db;
1642
create table t1(a varchar(30) primary key, b int not null);
1643
create table t2(a varchar(30) primary key, b int not null);
1644
create table t3(a varchar(30) primary key, b int not null);
1646
------ Testing with illegal table names ------
1647
mysqldump: Couldn't find table: "\d-2-1.sql"
1648
mysqldump: Couldn't find table: "\t1"
1649
mysqldump: Couldn't find table: "\t1"
1650
mysqldump: Couldn't find table: "\\t1"
1651
mysqldump: Couldn't find table: "t\1"
1652
mysqldump: Couldn't find table: "t\1"
1653
mysqldump: Couldn't find table: "t/1"
1654
mysqldump: Couldn't find table: "T_1"
1655
mysqldump: Couldn't find table: "T%1"
1656
mysqldump: Couldn't find table: "T'1"
1657
mysqldump: Couldn't find table: "T_1"
1658
mysqldump: Couldn't find table: "T_"
1660
------ Testing with illegal database names ------
1661
mysqldump: Got error: 1049: Unknown database 'mysqldump_test_d' when selecting the database
1662
mysqldump: Got error: 1049: Unknown database 'mysqld\ump_test_db' when selecting the database
1663
drop table t1, t2, t3;
1664
drop database mysqldump_test_db;
1667
# Bug#9657 mysqldump xml ( -x ) does not format NULL fields correctly
1669
create table t1 (a int(10));
1670
create table t2 (pk int primary key auto_increment,
1671
a int(10), b varchar(30), c datetime, d blob, e text);
1672
insert into t1 values (NULL), (10), (20);
1673
insert into t2 (a, b) values (NULL, NULL),(10, NULL),(NULL, "twenty"),(30, "thirty");
1674
<?xml version="1.0"?>
1675
<mysqldump xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
1676
<database name="test">
1677
<table_data name="t1">
1679
<field name="a" xsi:nil="true" />
1682
<field name="a">10</field>
1685
<field name="a">20</field>
1688
<table_data name="t2">
1690
<field name="pk">1</field>
1691
<field name="a" xsi:nil="true" />
1692
<field name="b" xsi:nil="true" />
1693
<field name="c" xsi:nil="true" />
1694
<field name="d" xsi:nil="true" />
1695
<field name="e" xsi:nil="true" />
1698
<field name="pk">2</field>
1699
<field name="a">10</field>
1700
<field name="b" xsi:nil="true" />
1701
<field name="c" xsi:nil="true" />
1702
<field name="d" xsi:nil="true" />
1703
<field name="e" xsi:nil="true" />
1706
<field name="pk">3</field>
1707
<field name="a" xsi:nil="true" />
1708
<field name="b">twenty</field>
1709
<field name="c" xsi:nil="true" />
1710
<field name="d" xsi:nil="true" />
1711
<field name="e" xsi:nil="true" />
1714
<field name="pk">4</field>
1715
<field name="a">30</field>
1716
<field name="b">thirty</field>
1717
<field name="c" xsi:nil="true" />
1718
<field name="d" xsi:nil="true" />
1719
<field name="e" xsi:nil="true" />
1726
# Bug#12123 mysqldump --tab results in text file which can't be imported
1728
create table t1 (a text character set utf8, b text character set latin1);
1729
insert t1 values (0x4F736E616272C3BC636B, 0x4BF66C6E);
1733
test.t1: Records: 1 Deleted: 0 Skipped: 0 Warnings: 0
1739
# Bug#15328 Segmentation fault occured if my.cnf is invalid for escape sequence
1741
--fields-optionally-enclosed-by="
1743
# Bug#19025 mysqldump doesn't correctly dump "auto_increment = [int]"
1746
t1_name varchar(255) default null,
1747
t1_id int(10) unsigned not null auto_increment,
1750
) auto_increment = 1000 default charset=latin1;
1751
insert into t1 (t1_name) values('bla');
1752
insert into t1 (t1_name) values('bla');
1753
insert into t1 (t1_name) values('bla');
1759
show create table `t1`;
1761
t1 CREATE TABLE `t1` (
1762
`t1_name` varchar(255) DEFAULT NULL,
1763
`t1_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1764
PRIMARY KEY (`t1_id`),
1765
KEY `t1_name` (`t1_name`)
1766
) ENGINE=MyISAM AUTO_INCREMENT=1003 DEFAULT CHARSET=latin1
1773
show create table `t1`;
1775
t1 CREATE TABLE `t1` (
1776
`t1_name` varchar(255) DEFAULT NULL,
1777
`t1_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1778
PRIMARY KEY (`t1_id`),
1779
KEY `t1_name` (`t1_name`)
1780
) ENGINE=MyISAM AUTO_INCREMENT=1003 DEFAULT CHARSET=latin1
1783
# Bug#18536 wrong table order
1785
create table t1(a int);
1786
create table t2(a int);
1787
create table t3(a int);
1789
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
1790
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
1791
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
1792
/*!40101 SET NAMES utf8 */;
1793
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
1794
/*!40103 SET TIME_ZONE='+00:00' */;
1795
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
1796
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
1797
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
1798
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
1799
DROP TABLE IF EXISTS `t3`;
1800
/*!40101 SET @saved_cs_client = @@character_set_client */;
1801
/*!40101 SET character_set_client = utf8 */;
1803
`a` int(11) DEFAULT NULL
1804
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1805
/*!40101 SET character_set_client = @saved_cs_client */;
1806
DROP TABLE IF EXISTS `t1`;
1807
/*!40101 SET @saved_cs_client = @@character_set_client */;
1808
/*!40101 SET character_set_client = utf8 */;
1810
`a` int(11) DEFAULT NULL
1811
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1812
/*!40101 SET character_set_client = @saved_cs_client */;
1813
DROP TABLE IF EXISTS `t2`;
1814
/*!40101 SET @saved_cs_client = @@character_set_client */;
1815
/*!40101 SET character_set_client = utf8 */;
1817
`a` int(11) DEFAULT NULL
1818
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1819
/*!40101 SET character_set_client = @saved_cs_client */;
1820
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1822
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1823
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1824
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1825
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1826
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1827
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1828
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1830
drop table t1, t2, t3;
1832
# Bug#21288 mysqldump segmentation fault when using --where
1834
create table t1 (a int);
1835
mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM `t1` WHERE xx xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' at line 1 (1064)
1836
mysqldump: Got error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' at line 1 when retrieving data from server
1838
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
1839
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
1840
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
1841
/*!40101 SET NAMES utf8 */;
1842
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
1843
/*!40103 SET TIME_ZONE='+00:00' */;
1844
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
1845
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
1846
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
1847
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
1848
DROP TABLE IF EXISTS `t1`;
1849
/*!40101 SET @saved_cs_client = @@character_set_client */;
1850
/*!40101 SET character_set_client = utf8 */;
1852
`a` int(11) DEFAULT NULL
1853
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1854
/*!40101 SET character_set_client = @saved_cs_client */;
1856
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1858
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1859
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1860
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1861
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1862
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1863
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1864
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1868
# Bug#13926 --order-by-primary fails if PKEY contains quote character
1870
DROP TABLE IF EXISTS `t1`;
1875
PRIMARY KEY (`a b`, `c"d`, `e``f`)
1876
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1877
insert into t1 values (0815, 4711, 2006);
1878
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
1879
/*!40103 SET TIME_ZONE='+00:00' */;
1880
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
1881
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
1882
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,ANSI' */;
1883
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
1884
DROP TABLE IF EXISTS "t1";
1885
/*!40101 SET @saved_cs_client = @@character_set_client */;
1886
/*!40101 SET character_set_client = utf8 */;
1888
"a b" int(11) NOT NULL DEFAULT '0',
1889
"c""d" int(11) NOT NULL DEFAULT '0',
1890
"e`f" int(11) NOT NULL DEFAULT '0',
1891
PRIMARY KEY ("a b","c""d","e`f")
1893
/*!40101 SET character_set_client = @saved_cs_client */;
1895
LOCK TABLES "t1" WRITE;
1896
/*!40000 ALTER TABLE "t1" DISABLE KEYS */;
1897
INSERT INTO "t1" VALUES (815,4711,2006);
1898
/*!40000 ALTER TABLE "t1" ENABLE KEYS */;
1900
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1902
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1903
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1904
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1905
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1908
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
1909
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
1910
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
1911
/*!40101 SET NAMES utf8 */;
1912
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
1913
/*!40103 SET TIME_ZONE='+00:00' */;
1914
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
1915
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
1916
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
1917
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
1918
DROP TABLE IF EXISTS `t1`;
1919
/*!40101 SET @saved_cs_client = @@character_set_client */;
1920
/*!40101 SET character_set_client = utf8 */;
1922
`a b` int(11) NOT NULL DEFAULT '0',
1923
`c"d` int(11) NOT NULL DEFAULT '0',
1924
`e``f` int(11) NOT NULL DEFAULT '0',
1925
PRIMARY KEY (`a b`,`c"d`,`e``f`)
1926
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1927
/*!40101 SET character_set_client = @saved_cs_client */;
1929
LOCK TABLES `t1` WRITE;
1930
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
1931
INSERT INTO `t1` VALUES (815,4711,2006);
1932
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
1934
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1936
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1937
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1938
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1939
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1940
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1941
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1942
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1947
# Bug#10213 mysqldump crashes when dumping VIEWs(on MacOS X)
1949
create database db1;
1952
a varchar(30) default NULL,
1955
INSERT INTO t2 VALUES ('alfred');
1956
INSERT INTO t2 VALUES ('angie');
1957
INSERT INTO t2 VALUES ('bingo');
1958
INSERT INTO t2 VALUES ('waffle');
1959
INSERT INTO t2 VALUES ('lemon');
1960
create view v2 as select * from t2 where a like 'a%' with check option;
1962
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
1963
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
1964
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
1965
/*!40101 SET NAMES utf8 */;
1966
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
1967
/*!40103 SET TIME_ZONE='+00:00' */;
1968
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
1969
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
1970
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
1971
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
1972
DROP TABLE IF EXISTS `t2`;
1973
/*!40101 SET @saved_cs_client = @@character_set_client */;
1974
/*!40101 SET character_set_client = utf8 */;
1976
`a` varchar(30) DEFAULT NULL,
1978
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1979
/*!40101 SET character_set_client = @saved_cs_client */;
1981
LOCK TABLES `t2` WRITE;
1982
/*!40000 ALTER TABLE `t2` DISABLE KEYS */;
1983
INSERT INTO `t2` VALUES ('alfred'),('angie'),('bingo'),('waffle'),('lemon');
1984
/*!40000 ALTER TABLE `t2` ENABLE KEYS */;
1986
DROP TABLE IF EXISTS `v2`;
1987
/*!50001 DROP VIEW IF EXISTS `v2`*/;
1988
SET @saved_cs_client = @@character_set_client;
1989
SET character_set_client = utf8;
1990
/*!50001 CREATE TABLE `v2` (
1993
SET character_set_client = @saved_cs_client;
1994
/*!50001 DROP TABLE IF EXISTS `v2`*/;
1995
/*!50001 DROP VIEW IF EXISTS `v2`*/;
1996
/*!50001 SET @saved_cs_client = @@character_set_client */;
1997
/*!50001 SET @saved_cs_results = @@character_set_results */;
1998
/*!50001 SET @saved_col_connection = @@collation_connection */;
1999
/*!50001 SET character_set_client = latin1 */;
2000
/*!50001 SET character_set_results = latin1 */;
2001
/*!50001 SET collation_connection = latin1_swedish_ci */;
2002
/*!50001 CREATE ALGORITHM=UNDEFINED */
2003
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
2004
/*!50001 VIEW `v2` AS select `t2`.`a` AS `a` from `t2` where (`t2`.`a` like 'a%') */
2005
/*!50002 WITH CASCADED CHECK OPTION */;
2006
/*!50001 SET character_set_client = @saved_cs_client */;
2007
/*!50001 SET character_set_results = @saved_cs_results */;
2008
/*!50001 SET collation_connection = @saved_col_connection */;
2009
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
2011
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
2012
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
2013
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
2014
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
2015
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
2016
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
2017
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
2024
# Bug#10713 mysqldump includes database in create view and referenced tables
2026
create database db2;
2028
create table t1 (a int);
2029
create table t2 (a int, b varchar(10), primary key(a));
2030
insert into t2 values (1, "on"), (2, "off"), (10, "pol"), (12, "meg");
2031
insert into t1 values (289), (298), (234), (456), (789);
2032
create view v1 as select * from t2;
2033
create view v2 as select * from t1;
2038
create database db1;
2046
select * from t2 order by a;
2055
create table t1(a int);
2056
create view v1 as select * from t1;
2058
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
2059
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
2060
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
2061
/*!40101 SET NAMES utf8 */;
2062
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
2063
/*!40103 SET TIME_ZONE='+00:00' */;
2064
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
2065
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
2066
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
2067
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
2068
DROP TABLE IF EXISTS `t1`;
2069
/*!40101 SET @saved_cs_client = @@character_set_client */;
2070
/*!40101 SET character_set_client = utf8 */;
2072
`a` int(11) DEFAULT NULL
2073
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2074
/*!40101 SET character_set_client = @saved_cs_client */;
2076
LOCK TABLES `t1` WRITE;
2077
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
2078
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
2080
DROP TABLE IF EXISTS `v1`;
2081
/*!50001 DROP VIEW IF EXISTS `v1`*/;
2082
SET @saved_cs_client = @@character_set_client;
2083
SET character_set_client = utf8;
2084
/*!50001 CREATE TABLE `v1` (
2087
SET character_set_client = @saved_cs_client;
2088
/*!50001 DROP TABLE IF EXISTS `v1`*/;
2089
/*!50001 DROP VIEW IF EXISTS `v1`*/;
2090
/*!50001 SET @saved_cs_client = @@character_set_client */;
2091
/*!50001 SET @saved_cs_results = @@character_set_results */;
2092
/*!50001 SET @saved_col_connection = @@collation_connection */;
2093
/*!50001 SET character_set_client = latin1 */;
2094
/*!50001 SET character_set_results = latin1 */;
2095
/*!50001 SET collation_connection = latin1_swedish_ci */;
2096
/*!50001 CREATE ALGORITHM=UNDEFINED */
2097
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
2098
/*!50001 VIEW `v1` AS select `t1`.`a` AS `a` from `t1` */;
2099
/*!50001 SET character_set_client = @saved_cs_client */;
2100
/*!50001 SET character_set_results = @saved_cs_results */;
2101
/*!50001 SET collation_connection = @saved_col_connection */;
2102
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
2104
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
2105
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
2106
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
2107
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
2108
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
2109
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
2110
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
2115
# Bug#10213 mysqldump crashes when dumping VIEWs(on MacOS X)
2117
create database mysqldump_test_db;
2118
use mysqldump_test_db;
2120
a varchar(30) default NULL,
2123
INSERT INTO t2 VALUES ('alfred');
2124
INSERT INTO t2 VALUES ('angie');
2125
INSERT INTO t2 VALUES ('bingo');
2126
INSERT INTO t2 VALUES ('waffle');
2127
INSERT INTO t2 VALUES ('lemon');
2128
create view v2 as select * from t2 where a like 'a%' with check option;
2130
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
2131
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
2132
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
2133
/*!40101 SET NAMES utf8 */;
2134
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
2135
/*!40103 SET TIME_ZONE='+00:00' */;
2136
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
2137
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
2138
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
2139
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
2140
DROP TABLE IF EXISTS `t2`;
2141
/*!40101 SET @saved_cs_client = @@character_set_client */;
2142
/*!40101 SET character_set_client = utf8 */;
2144
`a` varchar(30) DEFAULT NULL,
2146
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2147
/*!40101 SET character_set_client = @saved_cs_client */;
2149
LOCK TABLES `t2` WRITE;
2150
/*!40000 ALTER TABLE `t2` DISABLE KEYS */;
2151
INSERT INTO `t2` VALUES ('alfred'),('angie'),('bingo'),('waffle'),('lemon');
2152
/*!40000 ALTER TABLE `t2` ENABLE KEYS */;
2154
DROP TABLE IF EXISTS `v2`;
2155
/*!50001 DROP VIEW IF EXISTS `v2`*/;
2156
SET @saved_cs_client = @@character_set_client;
2157
SET character_set_client = utf8;
2158
/*!50001 CREATE TABLE `v2` (
2161
SET character_set_client = @saved_cs_client;
2162
/*!50001 DROP TABLE IF EXISTS `v2`*/;
2163
/*!50001 DROP VIEW IF EXISTS `v2`*/;
2164
/*!50001 SET @saved_cs_client = @@character_set_client */;
2165
/*!50001 SET @saved_cs_results = @@character_set_results */;
2166
/*!50001 SET @saved_col_connection = @@collation_connection */;
2167
/*!50001 SET character_set_client = latin1 */;
2168
/*!50001 SET character_set_results = latin1 */;
2169
/*!50001 SET collation_connection = latin1_swedish_ci */;
2170
/*!50001 CREATE ALGORITHM=UNDEFINED */
2171
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
2172
/*!50001 VIEW `v2` AS select `t2`.`a` AS `a` from `t2` where (`t2`.`a` like 'a%') */
2173
/*!50002 WITH CASCADED CHECK OPTION */;
2174
/*!50001 SET character_set_client = @saved_cs_client */;
2175
/*!50001 SET character_set_results = @saved_cs_results */;
2176
/*!50001 SET collation_connection = @saved_col_connection */;
2177
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
2179
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
2180
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
2181
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
2182
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
2183
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
2184
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
2185
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
2189
drop database mysqldump_test_db;
2192
# Bug#9756 mysql client failing on dumps containing certain \ sequences
2194
CREATE TABLE t1 (a char(10));
2195
INSERT INTO t1 VALUES ('\'');
2197
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
2198
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
2199
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
2200
/*!40101 SET NAMES utf8 */;
2201
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
2202
/*!40103 SET TIME_ZONE='+00:00' */;
2203
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
2204
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
2205
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
2206
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
2207
DROP TABLE IF EXISTS `t1`;
2208
/*!40101 SET @saved_cs_client = @@character_set_client */;
2209
/*!40101 SET character_set_client = utf8 */;
2211
`a` char(10) DEFAULT NULL
2212
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2213
/*!40101 SET character_set_client = @saved_cs_client */;
2215
LOCK TABLES `t1` WRITE;
2216
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
2217
INSERT INTO `t1` VALUES ('\'');
2218
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
2220
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
2222
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
2223
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
2224
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
2225
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
2226
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
2227
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
2228
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
2232
# Bug#10927 mysqldump: Can't reload dump with view that consist of other view
2234
create table t1(a int, b int, c varchar(30));
2235
insert into t1 values(1, 2, "one"), (2, 4, "two"), (3, 6, "three");
2239
select * from v3 where b in (1, 2, 3, 4, 5, 6, 7);
2241
select v3.a from v3, v1 where v1.a=v3.a and v3.b=3 limit 1;
2243
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
2244
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
2245
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
2246
/*!40101 SET NAMES utf8 */;
2247
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
2248
/*!40103 SET TIME_ZONE='+00:00' */;
2249
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
2250
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
2251
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
2252
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
2253
DROP TABLE IF EXISTS `t1`;
2254
/*!40101 SET @saved_cs_client = @@character_set_client */;
2255
/*!40101 SET character_set_client = utf8 */;
2257
`a` int(11) DEFAULT NULL,
2258
`b` int(11) DEFAULT NULL,
2259
`c` varchar(30) DEFAULT NULL
2260
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2261
/*!40101 SET character_set_client = @saved_cs_client */;
2263
LOCK TABLES `t1` WRITE;
2264
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
2265
INSERT INTO `t1` VALUES (1,2,'one'),(2,4,'two'),(3,6,'three');
2266
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
2268
DROP TABLE IF EXISTS `v1`;
2269
/*!50001 DROP VIEW IF EXISTS `v1`*/;
2270
SET @saved_cs_client = @@character_set_client;
2271
SET character_set_client = utf8;
2272
/*!50001 CREATE TABLE `v1` (
2277
SET character_set_client = @saved_cs_client;
2278
DROP TABLE IF EXISTS `v2`;
2279
/*!50001 DROP VIEW IF EXISTS `v2`*/;
2280
SET @saved_cs_client = @@character_set_client;
2281
SET character_set_client = utf8;
2282
/*!50001 CREATE TABLE `v2` (
2285
SET character_set_client = @saved_cs_client;
2286
DROP TABLE IF EXISTS `v3`;
2287
/*!50001 DROP VIEW IF EXISTS `v3`*/;
2288
SET @saved_cs_client = @@character_set_client;
2289
SET character_set_client = utf8;
2290
/*!50001 CREATE TABLE `v3` (
2295
SET character_set_client = @saved_cs_client;
2296
/*!50001 DROP TABLE IF EXISTS `v1`*/;
2297
/*!50001 DROP VIEW IF EXISTS `v1`*/;
2298
/*!50001 SET @saved_cs_client = @@character_set_client */;
2299
/*!50001 SET @saved_cs_results = @@character_set_results */;
2300
/*!50001 SET @saved_col_connection = @@collation_connection */;
2301
/*!50001 SET character_set_client = latin1 */;
2302
/*!50001 SET character_set_results = latin1 */;
2303
/*!50001 SET collation_connection = latin1_swedish_ci */;
2304
/*!50001 CREATE ALGORITHM=UNDEFINED */
2305
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
2306
/*!50001 VIEW `v1` AS select `v3`.`a` AS `a`,`v3`.`b` AS `b`,`v3`.`c` AS `c` from `v3` where (`v3`.`b` in (1,2,3,4,5,6,7)) */;
2307
/*!50001 SET character_set_client = @saved_cs_client */;
2308
/*!50001 SET character_set_results = @saved_cs_results */;
2309
/*!50001 SET collation_connection = @saved_col_connection */;
2310
/*!50001 DROP TABLE IF EXISTS `v2`*/;
2311
/*!50001 DROP VIEW IF EXISTS `v2`*/;
2312
/*!50001 SET @saved_cs_client = @@character_set_client */;
2313
/*!50001 SET @saved_cs_results = @@character_set_results */;
2314
/*!50001 SET @saved_col_connection = @@collation_connection */;
2315
/*!50001 SET character_set_client = latin1 */;
2316
/*!50001 SET character_set_results = latin1 */;
2317
/*!50001 SET collation_connection = latin1_swedish_ci */;
2318
/*!50001 CREATE ALGORITHM=UNDEFINED */
2319
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
2320
/*!50001 VIEW `v2` AS select `v3`.`a` AS `a` from (`v3` join `v1`) where ((`v1`.`a` = `v3`.`a`) and (`v3`.`b` = 3)) limit 1 */;
2321
/*!50001 SET character_set_client = @saved_cs_client */;
2322
/*!50001 SET character_set_results = @saved_cs_results */;
2323
/*!50001 SET collation_connection = @saved_col_connection */;
2324
/*!50001 DROP TABLE IF EXISTS `v3`*/;
2325
/*!50001 DROP VIEW IF EXISTS `v3`*/;
2326
/*!50001 SET @saved_cs_client = @@character_set_client */;
2327
/*!50001 SET @saved_cs_results = @@character_set_results */;
2328
/*!50001 SET @saved_col_connection = @@collation_connection */;
2329
/*!50001 SET character_set_client = latin1 */;
2330
/*!50001 SET character_set_results = latin1 */;
2331
/*!50001 SET collation_connection = latin1_swedish_ci */;
2332
/*!50001 CREATE ALGORITHM=UNDEFINED */
2333
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
2334
/*!50001 VIEW `v3` AS select `t1`.`a` AS `a`,`t1`.`b` AS `b`,`t1`.`c` AS `c` from `t1` */;
2335
/*!50001 SET character_set_client = @saved_cs_client */;
2336
/*!50001 SET character_set_results = @saved_cs_results */;
2337
/*!50001 SET collation_connection = @saved_col_connection */;
2338
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
2340
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
2341
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
2342
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
2343
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
2344
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
2345
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
2346
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
2348
drop view v1, v2, v3;
2351
# Test for dumping triggers
2353
CREATE TABLE t1 (a int, b bigint default NULL);
2354
CREATE TABLE t2 (a int);
2355
create trigger trg1 before insert on t1 for each row
2362
create trigger trg2 before update on t1 for each row begin
2363
if old.a % 2 = 0 then set new.b := 12; end if;
2365
set sql_mode="traditional"|
2366
create trigger trg3 after update on t1 for each row
2372
create trigger trg4 before insert on t2 for each row
2378
set sql_mode=default|
2379
show triggers like "t1";
2380
Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation
2381
trg1 INSERT t1 begin
2386
end BEFORE 0000-00-00 00:00:00 root@localhost latin1 latin1_swedish_ci latin1_swedish_ci
2387
trg2 UPDATE t1 begin
2388
if old.a % 2 = 0 then set new.b := 12; end if;
2389
end BEFORE 0000-00-00 00:00:00 root@localhost latin1 latin1_swedish_ci latin1_swedish_ci
2390
trg3 UPDATE t1 begin
2394
end AFTER 0000-00-00 00:00:00 STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER root@localhost latin1 latin1_swedish_ci latin1_swedish_ci
2395
INSERT INTO t1 (a) VALUES (1),(2),(3),(22);
2396
update t1 set a = 4 where a=3;
2398
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
2399
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
2400
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
2401
/*!40101 SET NAMES utf8 */;
2402
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
2403
/*!40103 SET TIME_ZONE='+00:00' */;
2404
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
2405
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
2406
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
2407
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
2409
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test` /*!40100 DEFAULT CHARACTER SET latin1 */;
2412
DROP TABLE IF EXISTS `t1`;
2413
/*!40101 SET @saved_cs_client = @@character_set_client */;
2414
/*!40101 SET character_set_client = utf8 */;
2416
`a` int(11) DEFAULT NULL,
2417
`b` bigint(20) DEFAULT NULL
2418
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2419
/*!40101 SET character_set_client = @saved_cs_client */;
2421
LOCK TABLES `t1` WRITE;
2422
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
2423
INSERT INTO `t1` VALUES (1,NULL),(2,NULL),(4,NULL),(11,NULL);
2424
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
2426
/*!50003 SET @saved_cs_client = @@character_set_client */ ;
2427
/*!50003 SET @saved_cs_results = @@character_set_results */ ;
2428
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
2429
/*!50003 SET character_set_client = latin1 */ ;
2430
/*!50003 SET character_set_results = latin1 */ ;
2431
/*!50003 SET collation_connection = latin1_swedish_ci */ ;
2432
/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
2433
/*!50003 SET sql_mode = '' */ ;
2435
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 trigger trg1 before insert on t1 for each row
2443
/*!50003 SET sql_mode = @saved_sql_mode */ ;
2444
/*!50003 SET character_set_client = @saved_cs_client */ ;
2445
/*!50003 SET character_set_results = @saved_cs_results */ ;
2446
/*!50003 SET collation_connection = @saved_col_connection */ ;
2447
/*!50003 SET @saved_cs_client = @@character_set_client */ ;
2448
/*!50003 SET @saved_cs_results = @@character_set_results */ ;
2449
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
2450
/*!50003 SET character_set_client = latin1 */ ;
2451
/*!50003 SET character_set_results = latin1 */ ;
2452
/*!50003 SET collation_connection = latin1_swedish_ci */ ;
2453
/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
2454
/*!50003 SET sql_mode = '' */ ;
2456
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 trigger trg2 before update on t1 for each row begin
2457
if old.a % 2 = 0 then set new.b := 12; end if;
2460
/*!50003 SET sql_mode = @saved_sql_mode */ ;
2461
/*!50003 SET character_set_client = @saved_cs_client */ ;
2462
/*!50003 SET character_set_results = @saved_cs_results */ ;
2463
/*!50003 SET collation_connection = @saved_col_connection */ ;
2464
/*!50003 SET @saved_cs_client = @@character_set_client */ ;
2465
/*!50003 SET @saved_cs_results = @@character_set_results */ ;
2466
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
2467
/*!50003 SET character_set_client = latin1 */ ;
2468
/*!50003 SET character_set_results = latin1 */ ;
2469
/*!50003 SET collation_connection = latin1_swedish_ci */ ;
2470
/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
2471
/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER' */ ;
2473
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 trigger trg3 after update on t1 for each row
2480
/*!50003 SET sql_mode = @saved_sql_mode */ ;
2481
/*!50003 SET character_set_client = @saved_cs_client */ ;
2482
/*!50003 SET character_set_results = @saved_cs_results */ ;
2483
/*!50003 SET collation_connection = @saved_col_connection */ ;
2484
DROP TABLE IF EXISTS `t2`;
2485
/*!40101 SET @saved_cs_client = @@character_set_client */;
2486
/*!40101 SET character_set_client = utf8 */;
2488
`a` int(11) DEFAULT NULL
2489
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2490
/*!40101 SET character_set_client = @saved_cs_client */;
2492
LOCK TABLES `t2` WRITE;
2493
/*!40000 ALTER TABLE `t2` DISABLE KEYS */;
2494
/*!40000 ALTER TABLE `t2` ENABLE KEYS */;
2496
/*!50003 SET @saved_cs_client = @@character_set_client */ ;
2497
/*!50003 SET @saved_cs_results = @@character_set_results */ ;
2498
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
2499
/*!50003 SET character_set_client = latin1 */ ;
2500
/*!50003 SET character_set_results = latin1 */ ;
2501
/*!50003 SET collation_connection = latin1_swedish_ci */ ;
2502
/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
2503
/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER' */ ;
2505
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 trigger trg4 before insert on t2 for each row
2512
/*!50003 SET sql_mode = @saved_sql_mode */ ;
2513
/*!50003 SET character_set_client = @saved_cs_client */ ;
2514
/*!50003 SET character_set_results = @saved_cs_results */ ;
2515
/*!50003 SET collation_connection = @saved_col_connection */ ;
2516
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
2518
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
2519
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
2520
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
2521
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
2522
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
2523
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
2524
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
2527
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
2528
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
2529
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
2530
/*!40101 SET NAMES utf8 */;
2531
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
2532
/*!40103 SET TIME_ZONE='+00:00' */;
2533
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
2534
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
2535
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
2536
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
2538
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test` /*!40100 DEFAULT CHARACTER SET latin1 */;
2541
DROP TABLE IF EXISTS `t1`;
2542
/*!40101 SET @saved_cs_client = @@character_set_client */;
2543
/*!40101 SET character_set_client = utf8 */;
2545
`a` int(11) DEFAULT NULL,
2546
`b` bigint(20) DEFAULT NULL
2547
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2548
/*!40101 SET character_set_client = @saved_cs_client */;
2550
LOCK TABLES `t1` WRITE;
2551
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
2552
INSERT INTO `t1` VALUES (1,NULL),(2,NULL),(4,NULL),(11,NULL);
2553
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
2555
DROP TABLE IF EXISTS `t2`;
2556
/*!40101 SET @saved_cs_client = @@character_set_client */;
2557
/*!40101 SET character_set_client = utf8 */;
2559
`a` int(11) DEFAULT NULL
2560
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2561
/*!40101 SET character_set_client = @saved_cs_client */;
2563
LOCK TABLES `t2` WRITE;
2564
/*!40000 ALTER TABLE `t2` DISABLE KEYS */;
2565
/*!40000 ALTER TABLE `t2` ENABLE KEYS */;
2567
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
2569
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
2570
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
2571
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
2572
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
2573
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
2574
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
2575
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
2583
Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation
2584
trg1 INSERT t1 begin
2589
end BEFORE # root@localhost latin1 latin1_swedish_ci latin1_swedish_ci
2590
trg2 UPDATE t1 begin
2591
if old.a % 2 = 0 then set new.b := 12; end if;
2592
end BEFORE # root@localhost latin1 latin1_swedish_ci latin1_swedish_ci
2593
trg3 UPDATE t1 begin
2597
end AFTER # STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER root@localhost latin1 latin1_swedish_ci latin1_swedish_ci
2598
trg4 INSERT t2 begin
2602
end BEFORE # STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER root@localhost latin1 latin1_swedish_ci latin1_swedish_ci
2605
# Bug#9136 my_print_defaults changed behaviour between 4.1.7 and 4.1.10a
2606
# Bug#12917 The --defaults-extra-file option is ignored by the 5.0 client binaries
2607
# (Problems with --defaults-extra-file option)
2612
# Test of fix to Bug#12597 mysqldump dumps triggers wrongly
2614
DROP TABLE IF EXISTS `test1`;
2616
Note 1051 Unknown table 'test1'
2617
CREATE TABLE `test1` (
2618
`a1` int(11) default NULL
2619
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2620
DROP TABLE IF EXISTS `test2`;
2622
Note 1051 Unknown table 'test2'
2623
CREATE TABLE `test2` (
2624
`a2` int(11) default NULL
2625
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2626
CREATE TRIGGER `testref` BEFORE INSERT ON `test1` FOR EACH ROW BEGIN
2627
INSERT INTO test2 SET a2 = NEW.a1; END //
2628
INSERT INTO `test1` VALUES (1);
2629
SELECT * FROM `test2`;
2633
Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation
2634
testref INSERT test1 BEGIN
2635
INSERT INTO test2 SET a2 = NEW.a1; END BEFORE NULL root@localhost latin1 latin1_swedish_ci latin1_swedish_ci
2636
SELECT * FROM `test1`;
2639
SELECT * FROM `test2`;
2642
DROP TRIGGER testref;
2646
# Bug#9056 mysqldump does not dump routines
2648
DROP TABLE IF EXISTS t1;
2649
DROP FUNCTION IF EXISTS bug9056_func1;
2650
DROP FUNCTION IF EXISTS bug9056_func2;
2651
DROP PROCEDURE IF EXISTS bug9056_proc1;
2652
DROP PROCEDURE IF EXISTS bug9056_proc2;
2653
DROP PROCEDURE IF EXISTS `a'b`;
2654
CREATE TABLE t1 (id int);
2655
INSERT INTO t1 VALUES(1), (2), (3), (4), (5);
2656
CREATE FUNCTION `bug9056_func1`(a INT, b INT) RETURNS int(11) RETURN a+b //
2657
CREATE PROCEDURE `bug9056_proc1`(IN a INT, IN b INT, OUT c INT)
2658
BEGIN SELECT a+b INTO c; end //
2659
create function bug9056_func2(f1 char binary) returns char
2661
set f1= concat( 'hello', f1 );
2664
CREATE PROCEDURE bug9056_proc2(OUT a INT)
2666
select sum(id) from t1 into a;
2668
set sql_mode='ansi';
2669
create procedure `a'b` () select 1;
2672
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
2673
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
2674
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
2675
/*!40101 SET NAMES utf8 */;
2676
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
2677
/*!40103 SET TIME_ZONE='+00:00' */;
2678
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
2679
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
2680
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
2681
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
2683
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test` /*!40100 DEFAULT CHARACTER SET latin1 */;
2686
DROP TABLE IF EXISTS `t1`;
2687
/*!40101 SET @saved_cs_client = @@character_set_client */;
2688
/*!40101 SET character_set_client = utf8 */;
2690
`id` int(11) DEFAULT NULL
2691
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2692
/*!40101 SET character_set_client = @saved_cs_client */;
2694
LOCK TABLES `t1` WRITE;
2695
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
2696
INSERT INTO `t1` VALUES (1),(2),(3),(4),(5);
2697
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
2699
/*!50003 DROP FUNCTION IF EXISTS `bug9056_func1` */;
2700
/*!50003 SET @saved_cs_client = @@character_set_client */ ;
2701
/*!50003 SET @saved_cs_results = @@character_set_results */ ;
2702
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
2703
/*!50003 SET character_set_client = latin1 */ ;
2704
/*!50003 SET character_set_results = latin1 */ ;
2705
/*!50003 SET collation_connection = latin1_swedish_ci */ ;
2706
/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
2707
/*!50003 SET sql_mode = '' */ ;
2709
/*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 FUNCTION `bug9056_func1`(a INT, b INT) RETURNS int(11)
2712
/*!50003 SET sql_mode = @saved_sql_mode */ ;
2713
/*!50003 SET character_set_client = @saved_cs_client */ ;
2714
/*!50003 SET character_set_results = @saved_cs_results */ ;
2715
/*!50003 SET collation_connection = @saved_col_connection */ ;
2716
/*!50003 DROP FUNCTION IF EXISTS `bug9056_func2` */;
2717
/*!50003 SET @saved_cs_client = @@character_set_client */ ;
2718
/*!50003 SET @saved_cs_results = @@character_set_results */ ;
2719
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
2720
/*!50003 SET character_set_client = latin1 */ ;
2721
/*!50003 SET character_set_results = latin1 */ ;
2722
/*!50003 SET collation_connection = latin1_swedish_ci */ ;
2723
/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
2724
/*!50003 SET sql_mode = '' */ ;
2726
/*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 FUNCTION `bug9056_func2`(f1 char binary) RETURNS char(1) CHARSET latin1
2728
set f1= concat( 'hello', f1 );
2732
/*!50003 SET sql_mode = @saved_sql_mode */ ;
2733
/*!50003 SET character_set_client = @saved_cs_client */ ;
2734
/*!50003 SET character_set_results = @saved_cs_results */ ;
2735
/*!50003 SET collation_connection = @saved_col_connection */ ;
2736
/*!50003 DROP PROCEDURE IF EXISTS `a'b` */;
2737
/*!50003 SET @saved_cs_client = @@character_set_client */ ;
2738
/*!50003 SET @saved_cs_results = @@character_set_results */ ;
2739
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
2740
/*!50003 SET character_set_client = latin1 */ ;
2741
/*!50003 SET character_set_results = latin1 */ ;
2742
/*!50003 SET collation_connection = latin1_swedish_ci */ ;
2743
/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
2744
/*!50003 SET sql_mode = 'REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ANSI' */ ;
2746
/*!50003 CREATE*/ /*!50020 DEFINER="root"@"localhost"*/ /*!50003 PROCEDURE "a'b"()
2749
/*!50003 SET sql_mode = @saved_sql_mode */ ;
2750
/*!50003 SET character_set_client = @saved_cs_client */ ;
2751
/*!50003 SET character_set_results = @saved_cs_results */ ;
2752
/*!50003 SET collation_connection = @saved_col_connection */ ;
2753
/*!50003 DROP PROCEDURE IF EXISTS `bug9056_proc1` */;
2754
/*!50003 SET @saved_cs_client = @@character_set_client */ ;
2755
/*!50003 SET @saved_cs_results = @@character_set_results */ ;
2756
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
2757
/*!50003 SET character_set_client = latin1 */ ;
2758
/*!50003 SET character_set_results = latin1 */ ;
2759
/*!50003 SET collation_connection = latin1_swedish_ci */ ;
2760
/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
2761
/*!50003 SET sql_mode = '' */ ;
2763
/*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `bug9056_proc1`(IN a INT, IN b INT, OUT c INT)
2764
BEGIN SELECT a+b INTO c; end */;;
2766
/*!50003 SET sql_mode = @saved_sql_mode */ ;
2767
/*!50003 SET character_set_client = @saved_cs_client */ ;
2768
/*!50003 SET character_set_results = @saved_cs_results */ ;
2769
/*!50003 SET collation_connection = @saved_col_connection */ ;
2770
/*!50003 DROP PROCEDURE IF EXISTS `bug9056_proc2` */;
2771
/*!50003 SET @saved_cs_client = @@character_set_client */ ;
2772
/*!50003 SET @saved_cs_results = @@character_set_results */ ;
2773
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
2774
/*!50003 SET character_set_client = latin1 */ ;
2775
/*!50003 SET character_set_results = latin1 */ ;
2776
/*!50003 SET collation_connection = latin1_swedish_ci */ ;
2777
/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
2778
/*!50003 SET sql_mode = '' */ ;
2780
/*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `bug9056_proc2`(OUT a INT)
2782
select sum(id) from t1 into a;
2785
/*!50003 SET sql_mode = @saved_sql_mode */ ;
2786
/*!50003 SET character_set_client = @saved_cs_client */ ;
2787
/*!50003 SET character_set_results = @saved_cs_results */ ;
2788
/*!50003 SET collation_connection = @saved_col_connection */ ;
2789
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
2791
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
2792
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
2793
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
2794
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
2795
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
2796
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
2797
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
2799
DROP FUNCTION bug9056_func1;
2800
DROP FUNCTION bug9056_func2;
2801
DROP PROCEDURE bug9056_proc1;
2802
DROP PROCEDURE bug9056_proc2;
2803
DROP PROCEDURE `a'b`;
2806
# Bug#13052 mysqldump timestamp reloads broken
2808
drop table if exists t1;
2809
create table t1 (`d` timestamp, unique (`d`));
2810
set time_zone='+00:00';
2811
insert into t1 values ('2003-10-25 22:00:00'),('2003-10-25 23:00:00');
2816
set time_zone='Europe/Moscow';
2821
set global time_zone='Europe/Moscow';
2823
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
2824
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
2825
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
2826
/*!40101 SET NAMES utf8 */;
2827
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
2828
/*!40103 SET TIME_ZONE='+00:00' */;
2829
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
2830
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
2831
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
2832
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
2834
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test` /*!40100 DEFAULT CHARACTER SET latin1 */;
2837
DROP TABLE IF EXISTS `t1`;
2838
/*!40101 SET @saved_cs_client = @@character_set_client */;
2839
/*!40101 SET character_set_client = utf8 */;
2841
`d` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
2842
UNIQUE KEY `d` (`d`)
2843
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2844
/*!40101 SET character_set_client = @saved_cs_client */;
2846
LOCK TABLES `t1` WRITE;
2847
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
2848
INSERT INTO `t1` VALUES ('2003-10-25 22:00:00'),('2003-10-25 23:00:00');
2849
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
2851
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
2853
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
2854
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
2855
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
2856
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
2857
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
2858
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
2859
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
2862
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
2863
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
2864
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
2865
/*!40101 SET NAMES utf8 */;
2866
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
2867
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
2868
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
2869
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
2871
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test` /*!40100 DEFAULT CHARACTER SET latin1 */;
2874
DROP TABLE IF EXISTS `t1`;
2875
/*!40101 SET @saved_cs_client = @@character_set_client */;
2876
/*!40101 SET character_set_client = utf8 */;
2878
`d` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
2879
UNIQUE KEY `d` (`d`)
2880
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2881
/*!40101 SET character_set_client = @saved_cs_client */;
2883
LOCK TABLES `t1` WRITE;
2884
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
2885
INSERT INTO `t1` VALUES ('2003-10-26 02:00:00'),('2003-10-26 02:00:00');
2886
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
2889
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
2890
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
2891
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
2892
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
2893
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
2894
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
2895
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
2898
set global time_zone=default;
2899
set time_zone=default;
2901
# Test of fix to Bug#13146 ansi quotes break loading of triggers
2903
DROP TABLE IF EXISTS `t1 test`;
2904
DROP TABLE IF EXISTS `t2 test`;
2905
CREATE TABLE `t1 test` (
2906
`a1` int(11) default NULL
2907
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2908
CREATE TABLE `t2 test` (
2909
`a2` int(11) default NULL
2910
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2911
CREATE TRIGGER `test trig` BEFORE INSERT ON `t1 test` FOR EACH ROW BEGIN
2912
INSERT INTO `t2 test` SET a2 = NEW.a1; END //
2913
INSERT INTO `t1 test` VALUES (1);
2914
INSERT INTO `t1 test` VALUES (2);
2915
INSERT INTO `t1 test` VALUES (3);
2916
SELECT * FROM `t2 test`;
2921
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
2922
/*!40103 SET TIME_ZONE='+00:00' */;
2923
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
2924
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
2925
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,ANSI' */;
2926
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
2927
DROP TABLE IF EXISTS "t1 test";
2928
/*!40101 SET @saved_cs_client = @@character_set_client */;
2929
/*!40101 SET character_set_client = utf8 */;
2930
CREATE TABLE "t1 test" (
2931
"a1" int(11) DEFAULT NULL
2933
/*!40101 SET character_set_client = @saved_cs_client */;
2935
LOCK TABLES "t1 test" WRITE;
2936
/*!40000 ALTER TABLE "t1 test" DISABLE KEYS */;
2937
INSERT INTO "t1 test" VALUES (1),(2),(3);
2938
/*!40000 ALTER TABLE "t1 test" ENABLE KEYS */;
2940
/*!50003 SET @saved_cs_client = @@character_set_client */ ;
2941
/*!50003 SET @saved_cs_results = @@character_set_results */ ;
2942
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
2943
/*!50003 SET character_set_client = latin1 */ ;
2944
/*!50003 SET character_set_results = latin1 */ ;
2945
/*!50003 SET collation_connection = latin1_swedish_ci */ ;
2946
/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
2947
/*!50003 SET sql_mode = '' */ ;
2949
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `test trig` BEFORE INSERT ON `t1 test` FOR EACH ROW BEGIN
2950
INSERT INTO `t2 test` SET a2 = NEW.a1; END */;;
2952
/*!50003 SET sql_mode = @saved_sql_mode */ ;
2953
/*!50003 SET character_set_client = @saved_cs_client */ ;
2954
/*!50003 SET character_set_results = @saved_cs_results */ ;
2955
/*!50003 SET collation_connection = @saved_col_connection */ ;
2956
DROP TABLE IF EXISTS "t2 test";
2957
/*!40101 SET @saved_cs_client = @@character_set_client */;
2958
/*!40101 SET character_set_client = utf8 */;
2959
CREATE TABLE "t2 test" (
2960
"a2" int(11) DEFAULT NULL
2962
/*!40101 SET character_set_client = @saved_cs_client */;
2964
LOCK TABLES "t2 test" WRITE;
2965
/*!40000 ALTER TABLE "t2 test" DISABLE KEYS */;
2966
INSERT INTO "t2 test" VALUES (1),(2),(3);
2967
/*!40000 ALTER TABLE "t2 test" ENABLE KEYS */;
2969
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
2971
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
2972
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
2973
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
2974
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
2976
DROP TRIGGER `test trig`;
2977
DROP TABLE `t1 test`;
2978
DROP TABLE `t2 test`;
2980
# Bug#12838 mysqldump -x with views exits with error
2982
drop table if exists t1;
2983
create table t1 (a int, b varchar(32), c varchar(32));
2984
insert into t1 values (1, 'first value', 'xxxx');
2985
insert into t1 values (2, 'second value', 'tttt');
2986
insert into t1 values (3, 'third value', 'vvv vvv');
2987
create view v1 as select * from t1;
2988
create view v0 as select * from v1;
2989
create view v2 as select * from v0;
2994
3 third value vvv vvv
2996
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
2997
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
2998
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
2999
/*!40101 SET NAMES utf8 */;
3000
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
3001
/*!40103 SET TIME_ZONE='+00:00' */;
3002
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
3003
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
3004
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
3005
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
3007
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test` /*!40100 DEFAULT CHARACTER SET latin1 */;
3010
DROP TABLE IF EXISTS `t1`;
3011
/*!40101 SET @saved_cs_client = @@character_set_client */;
3012
/*!40101 SET character_set_client = utf8 */;
3014
`a` int(11) DEFAULT NULL,
3015
`b` varchar(32) DEFAULT NULL,
3016
`c` varchar(32) DEFAULT NULL
3017
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
3018
/*!40101 SET character_set_client = @saved_cs_client */;
3020
LOCK TABLES `t1` WRITE;
3021
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
3022
INSERT INTO `t1` VALUES (1,'first value','xxxx'),(2,'second value','tttt'),(3,'third value','vvv vvv');
3023
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
3025
DROP TABLE IF EXISTS `v0`;
3026
/*!50001 DROP VIEW IF EXISTS `v0`*/;
3027
SET @saved_cs_client = @@character_set_client;
3028
SET character_set_client = utf8;
3029
/*!50001 CREATE TABLE `v0` (
3034
SET character_set_client = @saved_cs_client;
3035
DROP TABLE IF EXISTS `v1`;
3036
/*!50001 DROP VIEW IF EXISTS `v1`*/;
3037
SET @saved_cs_client = @@character_set_client;
3038
SET character_set_client = utf8;
3039
/*!50001 CREATE TABLE `v1` (
3044
SET character_set_client = @saved_cs_client;
3045
DROP TABLE IF EXISTS `v2`;
3046
/*!50001 DROP VIEW IF EXISTS `v2`*/;
3047
SET @saved_cs_client = @@character_set_client;
3048
SET character_set_client = utf8;
3049
/*!50001 CREATE TABLE `v2` (
3054
SET character_set_client = @saved_cs_client;
3057
/*!50001 DROP TABLE IF EXISTS `v0`*/;
3058
/*!50001 DROP VIEW IF EXISTS `v0`*/;
3059
/*!50001 SET @saved_cs_client = @@character_set_client */;
3060
/*!50001 SET @saved_cs_results = @@character_set_results */;
3061
/*!50001 SET @saved_col_connection = @@collation_connection */;
3062
/*!50001 SET character_set_client = latin1 */;
3063
/*!50001 SET character_set_results = latin1 */;
3064
/*!50001 SET collation_connection = latin1_swedish_ci */;
3065
/*!50001 CREATE ALGORITHM=UNDEFINED */
3066
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
3067
/*!50001 VIEW `v0` AS select `v1`.`a` AS `a`,`v1`.`b` AS `b`,`v1`.`c` AS `c` from `v1` */;
3068
/*!50001 SET character_set_client = @saved_cs_client */;
3069
/*!50001 SET character_set_results = @saved_cs_results */;
3070
/*!50001 SET collation_connection = @saved_col_connection */;
3071
/*!50001 DROP TABLE IF EXISTS `v1`*/;
3072
/*!50001 DROP VIEW IF EXISTS `v1`*/;
3073
/*!50001 SET @saved_cs_client = @@character_set_client */;
3074
/*!50001 SET @saved_cs_results = @@character_set_results */;
3075
/*!50001 SET @saved_col_connection = @@collation_connection */;
3076
/*!50001 SET character_set_client = latin1 */;
3077
/*!50001 SET character_set_results = latin1 */;
3078
/*!50001 SET collation_connection = latin1_swedish_ci */;
3079
/*!50001 CREATE ALGORITHM=UNDEFINED */
3080
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
3081
/*!50001 VIEW `v1` AS select `t1`.`a` AS `a`,`t1`.`b` AS `b`,`t1`.`c` AS `c` from `t1` */;
3082
/*!50001 SET character_set_client = @saved_cs_client */;
3083
/*!50001 SET character_set_results = @saved_cs_results */;
3084
/*!50001 SET collation_connection = @saved_col_connection */;
3085
/*!50001 DROP TABLE IF EXISTS `v2`*/;
3086
/*!50001 DROP VIEW IF EXISTS `v2`*/;
3087
/*!50001 SET @saved_cs_client = @@character_set_client */;
3088
/*!50001 SET @saved_cs_results = @@character_set_results */;
3089
/*!50001 SET @saved_col_connection = @@collation_connection */;
3090
/*!50001 SET character_set_client = latin1 */;
3091
/*!50001 SET character_set_results = latin1 */;
3092
/*!50001 SET collation_connection = latin1_swedish_ci */;
3093
/*!50001 CREATE ALGORITHM=UNDEFINED */
3094
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
3095
/*!50001 VIEW `v2` AS select `v0`.`a` AS `a`,`v0`.`b` AS `b`,`v0`.`c` AS `c` from `v0` */;
3096
/*!50001 SET character_set_client = @saved_cs_client */;
3097
/*!50001 SET character_set_results = @saved_cs_results */;
3098
/*!50001 SET collation_connection = @saved_col_connection */;
3099
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3101
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3102
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3103
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
3104
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
3105
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
3106
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
3107
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
3114
# Bug#14554 mysqldump does not separate words "ROW" and "BEGIN"
3115
# for tables with trigger created in the IGNORE_SPACE sql mode.
3117
SET @old_sql_mode = @@SQL_MODE;
3118
SET SQL_MODE = IGNORE_SPACE;
3119
CREATE TABLE t1 (a INT);
3120
CREATE TRIGGER tr1 BEFORE INSERT ON t1
3125
SET SQL_MODE = @old_sql_mode;
3127
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
3128
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
3129
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
3130
/*!40101 SET NAMES utf8 */;
3131
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
3132
/*!40103 SET TIME_ZONE='+00:00' */;
3133
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
3134
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
3135
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
3136
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
3138
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test` /*!40100 DEFAULT CHARACTER SET latin1 */;
3141
DROP TABLE IF EXISTS `t1`;
3142
/*!40101 SET @saved_cs_client = @@character_set_client */;
3143
/*!40101 SET character_set_client = utf8 */;
3145
`a` int(11) DEFAULT NULL
3146
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
3147
/*!40101 SET character_set_client = @saved_cs_client */;
3149
LOCK TABLES `t1` WRITE;
3150
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
3151
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
3153
/*!50003 SET @saved_cs_client = @@character_set_client */ ;
3154
/*!50003 SET @saved_cs_results = @@character_set_results */ ;
3155
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
3156
/*!50003 SET character_set_client = latin1 */ ;
3157
/*!50003 SET character_set_results = latin1 */ ;
3158
/*!50003 SET collation_connection = latin1_swedish_ci */ ;
3159
/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
3160
/*!50003 SET sql_mode = 'IGNORE_SPACE' */ ;
3162
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER tr1 BEFORE INSERT ON t1
3168
/*!50003 SET sql_mode = @saved_sql_mode */ ;
3169
/*!50003 SET character_set_client = @saved_cs_client */ ;
3170
/*!50003 SET character_set_results = @saved_cs_results */ ;
3171
/*!50003 SET collation_connection = @saved_col_connection */ ;
3172
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3174
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3175
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3176
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
3177
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
3178
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
3179
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
3180
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
3185
# Bug#13318 Bad result with empty field and --hex-blob
3187
create table t1 (a binary(1), b blob);
3188
insert into t1 values ('','');
3190
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
3191
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
3192
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
3193
/*!40101 SET NAMES utf8 */;
3194
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
3195
/*!40103 SET TIME_ZONE='+00:00' */;
3196
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
3197
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
3198
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
3199
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
3200
DROP TABLE IF EXISTS `t1`;
3201
/*!40101 SET @saved_cs_client = @@character_set_client */;
3202
/*!40101 SET character_set_client = utf8 */;
3204
`a` binary(1) DEFAULT NULL,
3206
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
3207
/*!40101 SET character_set_client = @saved_cs_client */;
3209
LOCK TABLES `t1` WRITE;
3210
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
3211
INSERT INTO `t1` VALUES (0x00,'');
3212
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
3214
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3216
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3217
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3218
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
3219
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
3220
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
3221
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
3222
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
3225
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
3226
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
3227
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
3228
/*!40101 SET NAMES utf8 */;
3229
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
3230
/*!40103 SET TIME_ZONE='+00:00' */;
3231
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
3232
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
3233
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
3234
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
3235
DROP TABLE IF EXISTS `t1`;
3236
/*!40101 SET @saved_cs_client = @@character_set_client */;
3237
/*!40101 SET character_set_client = utf8 */;
3239
`a` binary(1) DEFAULT NULL,
3241
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
3242
/*!40101 SET character_set_client = @saved_cs_client */;
3244
LOCK TABLES `t1` WRITE;
3245
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
3246
INSERT INTO `t1` VALUES (0x00,'');
3247
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
3249
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3251
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3252
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3253
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
3254
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
3255
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
3256
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
3257
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
3261
# Bug#14871 Invalid view dump output
3263
create table t1 (a int);
3264
insert into t1 values (289), (298), (234), (456), (789);
3265
create definer = CURRENT_USER view v1 as select * from t1;
3266
create SQL SECURITY INVOKER view v2 as select * from t1;
3267
create view v3 as select * from t1 with local check option;
3268
create algorithm=merge view v4 as select * from t1 with cascaded check option;
3269
create algorithm =temptable view v5 as select * from t1;
3271
drop view v1, v2, v3, v4, v5;
3280
select * from v3 order by a;
3288
drop view v1, v2, v3, v4, v5;
3290
# Bug#16878 dump of trigger
3292
create table t1 (a int, created datetime);
3293
create table t2 (b int, created datetime);
3294
create trigger tr1 before insert on t1 for each row set
3296
create trigger tr2 after insert on t1
3299
insert into t2 set b=new.a and created=new.created;
3305
Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation
3307
new.created=now() BEFORE # root@localhost latin1 latin1_swedish_ci latin1_swedish_ci
3309
insert into t2 set b=new.a and created=new.created;
3310
end AFTER # root@localhost latin1 latin1_swedish_ci latin1_swedish_ci
3315
# Bug#18462 mysqldump does not dump view structures correctly
3317
create table t (qty int, price int);
3318
insert into t values(3, 50);
3319
insert into t values(5, 51);
3320
create view v1 as select qty, price, qty*price as value from t;
3321
create view v2 as select qty from v1;
3323
/*!50001 DROP TABLE IF EXISTS `v1`*/;
3324
/*!50001 SET @saved_cs_client = @@character_set_client */;
3325
/*!50001 SET @saved_cs_results = @@character_set_results */;
3326
/*!50001 SET @saved_col_connection = @@collation_connection */;
3327
/*!50001 SET character_set_client = latin1 */;
3328
/*!50001 SET character_set_results = latin1 */;
3329
/*!50001 SET collation_connection = latin1_swedish_ci */;
3330
/*!50001 CREATE ALGORITHM=UNDEFINED */
3331
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
3332
/*!50001 VIEW `v1` AS select `t`.`qty` AS `qty`,`t`.`price` AS `price`,(`t`.`qty` * `t`.`price`) AS `value` from `t` */;
3333
/*!50001 SET character_set_client = @saved_cs_client */;
3334
/*!50001 SET character_set_results = @saved_cs_results */;
3335
/*!50001 SET collation_connection = @saved_col_connection */;
3338
/*!50001 DROP TABLE IF EXISTS `v2`*/;
3339
/*!50001 SET @saved_cs_client = @@character_set_client */;
3340
/*!50001 SET @saved_cs_results = @@character_set_results */;
3341
/*!50001 SET @saved_col_connection = @@collation_connection */;
3342
/*!50001 SET character_set_client = latin1 */;
3343
/*!50001 SET character_set_results = latin1 */;
3344
/*!50001 SET collation_connection = latin1_swedish_ci */;
3345
/*!50001 CREATE ALGORITHM=UNDEFINED */
3346
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
3347
/*!50001 VIEW `v2` AS select `v1`.`qty` AS `qty` from `v1` */;
3348
/*!50001 SET character_set_client = @saved_cs_client */;
3349
/*!50001 SET character_set_results = @saved_cs_results */;
3350
/*!50001 SET collation_connection = @saved_col_connection */;
3357
# Bug#14857 Reading dump files with single statement stored routines fails.
3358
# fixed by patch for Bug#16878
3360
/*!50003 CREATE FUNCTION `f`() RETURNS bigint(20)
3362
/*!50003 CREATE PROCEDURE `p`()
3364
show create function f;
3365
Function sql_mode Create Function character_set_client collation_connection Database Collation
3366
f CREATE DEFINER=`root`@`localhost` FUNCTION `f`() RETURNS bigint(20)
3367
return 42 latin1 latin1_swedish_ci latin1_swedish_ci
3368
show create procedure p;
3369
Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
3370
p CREATE DEFINER=`root`@`localhost` PROCEDURE `p`()
3371
select 42 latin1 latin1_swedish_ci latin1_swedish_ci
3375
# Bug#17371 Unable to dump a schema with invalid views
3377
create table t1 ( id serial );
3378
create view v1 as select * from t1;
3382
-- failed on view `v1`: CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `test`.`t1`.`id` AS `id` from `t1`
3386
# Bug#17201 Spurious 'DROP DATABASE' in output,
3387
# also confusion between tables and views.
3388
# Example code from Markus Popp
3389
create database mysqldump_test_db;
3390
use mysqldump_test_db;
3391
create table t1 (id int);
3392
create view v1 as select * from t1;
3393
insert into t1 values (1232131);
3394
insert into t1 values (4711);
3395
insert into t1 values (3231);
3396
insert into t1 values (0815);
3398
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
3399
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
3400
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
3401
/*!40101 SET NAMES utf8 */;
3402
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
3403
/*!40103 SET TIME_ZONE='+00:00' */;
3404
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
3405
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
3406
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
3407
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
3409
/*!40000 DROP DATABASE IF EXISTS `mysqldump_test_db`*/;
3411
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysqldump_test_db` /*!40100 DEFAULT CHARACTER SET latin1 */;
3413
USE `mysqldump_test_db`;
3414
DROP TABLE IF EXISTS `t1`;
3415
/*!40101 SET @saved_cs_client = @@character_set_client */;
3416
/*!40101 SET character_set_client = utf8 */;
3418
`id` int(11) DEFAULT NULL
3419
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
3420
/*!40101 SET character_set_client = @saved_cs_client */;
3422
LOCK TABLES `t1` WRITE;
3423
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
3424
INSERT INTO `t1` VALUES (1232131),(4711),(3231),(815);
3425
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
3427
DROP TABLE IF EXISTS `v1`;
3428
/*!50001 DROP VIEW IF EXISTS `v1`*/;
3429
SET @saved_cs_client = @@character_set_client;
3430
SET character_set_client = utf8;
3431
/*!50001 CREATE TABLE `v1` (
3434
SET character_set_client = @saved_cs_client;
3436
USE `mysqldump_test_db`;
3437
/*!50001 DROP TABLE IF EXISTS `v1`*/;
3438
/*!50001 DROP VIEW IF EXISTS `v1`*/;
3439
/*!50001 SET @saved_cs_client = @@character_set_client */;
3440
/*!50001 SET @saved_cs_results = @@character_set_results */;
3441
/*!50001 SET @saved_col_connection = @@collation_connection */;
3442
/*!50001 SET character_set_client = latin1 */;
3443
/*!50001 SET character_set_results = latin1 */;
3444
/*!50001 SET collation_connection = latin1_swedish_ci */;
3445
/*!50001 CREATE ALGORITHM=UNDEFINED */
3446
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
3447
/*!50001 VIEW `v1` AS select `t1`.`id` AS `id` from `t1` */;
3448
/*!50001 SET character_set_client = @saved_cs_client */;
3449
/*!50001 SET character_set_results = @saved_cs_results */;
3450
/*!50001 SET collation_connection = @saved_col_connection */;
3451
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3453
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3454
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3455
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
3456
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
3457
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
3458
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
3459
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
3463
drop database mysqldump_test_db;
3465
# Bug#21014 Segmentation fault of mysqldump on view
3467
create database mysqldump_tables;
3468
use mysqldump_tables;
3469
create table basetable ( id serial, tag varchar(64) );
3470
create database mysqldump_views;
3471
use mysqldump_views;
3472
create view nasishnasifu as select mysqldump_tables.basetable.id from mysqldump_tables.basetable;
3474
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysqldump_tables` /*!40100 DEFAULT CHARACTER SET latin1 */;
3476
USE `mysqldump_tables`;
3477
/*!40101 SET @saved_cs_client = @@character_set_client */;
3478
/*!40101 SET character_set_client = utf8 */;
3479
CREATE TABLE `basetable` (
3480
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3481
`tag` varchar(64) DEFAULT NULL,
3482
UNIQUE KEY `id` (`id`)
3483
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
3484
/*!40101 SET character_set_client = @saved_cs_client */;
3486
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysqldump_views` /*!40100 DEFAULT CHARACTER SET latin1 */;
3488
USE `mysqldump_views`;
3489
SET @saved_cs_client = @@character_set_client;
3490
SET character_set_client = utf8;
3491
/*!50001 CREATE TABLE `nasishnasifu` (
3492
`id` bigint(20) unsigned
3494
SET character_set_client = @saved_cs_client;
3496
USE `mysqldump_tables`;
3498
USE `mysqldump_views`;
3499
/*!50001 DROP TABLE IF EXISTS `nasishnasifu`*/;
3500
/*!50001 SET @saved_cs_client = @@character_set_client */;
3501
/*!50001 SET @saved_cs_results = @@character_set_results */;
3502
/*!50001 SET @saved_col_connection = @@collation_connection */;
3503
/*!50001 SET character_set_client = latin1 */;
3504
/*!50001 SET character_set_results = latin1 */;
3505
/*!50001 SET collation_connection = latin1_swedish_ci */;
3506
/*!50001 CREATE ALGORITHM=UNDEFINED */
3507
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
3508
/*!50001 VIEW `nasishnasifu` AS select `mysqldump_tables`.`basetable`.`id` AS `id` from `mysqldump_tables`.`basetable` */;
3509
/*!50001 SET character_set_client = @saved_cs_client */;
3510
/*!50001 SET character_set_results = @saved_cs_results */;
3511
/*!50001 SET collation_connection = @saved_col_connection */;
3512
drop view nasishnasifu;
3513
drop database mysqldump_views;
3514
drop table mysqldump_tables.basetable;
3515
drop database mysqldump_tables;
3517
# Bug#20221 Dumping of multiple databases containing view(s) yields maleformed dumps
3519
create database mysqldump_dba;
3521
create table t1 (f1 int, f2 int);
3522
insert into t1 values (1,1);
3523
create view v1 as select f1, f2 from t1;
3524
create database mysqldump_dbb;
3526
create table t1 (f1 int, f2 int);
3527
insert into t1 values (2,2);
3528
create view v1 as select f1, f2 from t1;
3531
drop database mysqldump_dbb;
3535
drop database mysqldump_dba;
3536
select * from mysqldump_dba.v1;
3539
select * from mysqldump_dbb.v1;
3545
drop database mysqldump_dba;
3549
drop database mysqldump_dbb;
3552
# Bug#21215 mysqldump creating incomplete backups without warning
3554
create user mysqltest_1@localhost;
3555
create table t1(a int, b varchar(34));
3557
mysqldump: Couldn't execute 'FLUSH /*!40101 LOCAL */ TABLES': Access denied; you need the RELOAD privilege for this operation (1227)
3558
mysqldump: Couldn't execute 'FLUSH /*!40101 LOCAL */ TABLES': Access denied; you need the RELOAD privilege for this operation (1227)
3559
grant RELOAD on *.* to mysqltest_1@localhost;
3560
mysqldump: Couldn't execute 'SHOW MASTER STATUS': Access denied; you need the SUPER,REPLICATION CLIENT privilege for this operation (1227)
3561
mysqldump: Couldn't execute 'SHOW MASTER STATUS': Access denied; you need the SUPER,REPLICATION CLIENT privilege for this operation (1227)
3562
grant REPLICATION CLIENT on *.* to mysqltest_1@localhost;
3564
drop user mysqltest_1@localhost;
3566
# Bug#21424 mysqldump failing to export/import views
3568
create database mysqldump_myDB;
3570
create user myDB_User@localhost;
3571
grant create, create view, select, insert on mysqldump_myDB.* to myDB_User@localhost;
3572
create table t1 (c1 int);
3573
insert into t1 values (3);
3575
create table u1 (f1 int);
3576
insert into u1 values (4);
3577
create view v1 (c1) as select * from t1;
3582
revoke all privileges on mysqldump_myDB.* from myDB_User@localhost;
3583
drop user myDB_User@localhost;
3584
drop database mysqldump_myDB;
3586
# Bug#21424 continues from here.
3587
# Restore. Flush Privileges test ends.
3590
select * from mysqldump_myDB.v1;
3593
select * from mysqldump_myDB.u1;
3600
revoke all privileges on mysqldump_myDB.* from myDB_User@localhost;
3601
drop user myDB_User@localhost;
3602
drop database mysqldump_myDB;
3605
# Bug #21527 mysqldump incorrectly tries to LOCK TABLES on the
3606
# information_schema database.
3608
# Bug #33762: mysqldump can not dump INFORMATION_SCHEMA
3610
DROP TABLE IF EXISTS `TABLES`;
3611
/*!40101 SET @saved_cs_client = @@character_set_client */;
3612
/*!40101 SET character_set_client = utf8 */;
3613
CREATE TEMPORARY TABLE `TABLES` (
3614
`TABLE_CATALOG` varchar(512) DEFAULT NULL,
3615
`TABLE_SCHEMA` varchar(64) NOT NULL DEFAULT '',
3616
`TABLE_NAME` varchar(64) NOT NULL DEFAULT '',
3617
`TABLE_TYPE` varchar(64) NOT NULL DEFAULT '',
3618
`ENGINE` varchar(64) DEFAULT NULL,
3619
`VERSION` bigint(21) unsigned DEFAULT NULL,
3620
`ROW_FORMAT` varchar(10) DEFAULT NULL,
3621
`TABLE_ROWS` bigint(21) unsigned DEFAULT NULL,
3622
`AVG_ROW_LENGTH` bigint(21) unsigned DEFAULT NULL,
3623
`DATA_LENGTH` bigint(21) unsigned DEFAULT NULL,
3624
`MAX_DATA_LENGTH` bigint(21) unsigned DEFAULT NULL,
3625
`INDEX_LENGTH` bigint(21) unsigned DEFAULT NULL,
3626
`DATA_FREE` bigint(21) unsigned DEFAULT NULL,
3627
`AUTO_INCREMENT` bigint(21) unsigned DEFAULT NULL,
3628
`CREATE_TIME` datetime DEFAULT NULL,
3629
`UPDATE_TIME` datetime DEFAULT NULL,
3630
`CHECK_TIME` datetime DEFAULT NULL,
3631
`TABLE_COLLATION` varchar(32) DEFAULT NULL,
3632
`CHECKSUM` bigint(21) unsigned DEFAULT NULL,
3633
`CREATE_OPTIONS` varchar(255) DEFAULT NULL,
3634
`TABLE_COMMENT` varchar(80) NOT NULL DEFAULT ''
3635
) ENGINE=MEMORY DEFAULT CHARSET=utf8;
3636
/*!40101 SET character_set_client = @saved_cs_client */;
3638
# Bug#19745 mysqldump --xml produces invalid xml
3640
DROP TABLE IF EXISTS t1;
3641
CREATE TABLE t1 (f1 int(10), data MEDIUMBLOB);
3642
INSERT INTO t1 VALUES(1,0xff00fef0);
3643
<?xml version="1.0"?>
3644
<mysqldump xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
3645
<database name="test">
3646
<table_structure name="t1">
3647
<field Field="f1" Type="int(10)" Null="YES" Key="" Extra="" />
3648
<field Field="data" Type="mediumblob" Null="YES" Key="" Extra="" />
3650
<table_data name="t1">
3652
<field name="f1">1</field>
3653
<field name="data" xsi:type="xs:hexBinary">FF00FEF0</field>
3660
# Bug#26346 stack + buffer overrun in mysqldump
3662
CREATE TABLE t1(a int);
3663
INSERT INTO t1 VALUES (1), (2);
3664
mysqldump: Input filename too long: aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
3666
CREATE TABLE t2 (a INT);
3667
CREATE TABLE t3 (a INT);
3668
CREATE TABLE t1 (a INT) ENGINE=merge UNION=(t2, t3);
3670
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
3671
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
3672
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
3673
/*!40101 SET NAMES utf8 */;
3674
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
3675
/*!40103 SET TIME_ZONE='+00:00' */;
3676
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
3677
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
3678
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
3679
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
3680
DROP TABLE IF EXISTS `t1`;
3681
/*!40101 SET @saved_cs_client = @@character_set_client */;
3682
/*!40101 SET character_set_client = utf8 */;
3684
`a` int(11) DEFAULT NULL
3685
) ENGINE=MRG_MyISAM DEFAULT CHARSET=latin1 UNION=(`t2`,`t3`);
3686
/*!40101 SET character_set_client = @saved_cs_client */;
3687
DROP TABLE IF EXISTS `t2`;
3688
/*!40101 SET @saved_cs_client = @@character_set_client */;
3689
/*!40101 SET character_set_client = utf8 */;
3691
`a` int(11) DEFAULT NULL
3692
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
3693
/*!40101 SET character_set_client = @saved_cs_client */;
3695
LOCK TABLES `t2` WRITE;
3696
/*!40000 ALTER TABLE `t2` DISABLE KEYS */;
3697
/*!40000 ALTER TABLE `t2` ENABLE KEYS */;
3699
DROP TABLE IF EXISTS `t3`;
3700
/*!40101 SET @saved_cs_client = @@character_set_client */;
3701
/*!40101 SET character_set_client = utf8 */;
3703
`a` int(11) DEFAULT NULL
3704
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
3705
/*!40101 SET character_set_client = @saved_cs_client */;
3707
LOCK TABLES `t3` WRITE;
3708
/*!40000 ALTER TABLE `t3` DISABLE KEYS */;
3709
/*!40000 ALTER TABLE `t3` ENABLE KEYS */;
3711
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3713
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3714
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3715
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
3716
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
3717
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
3718
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
3719
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
3721
DROP TABLE t1, t2, t3;
3723
# Bug#23491 MySQLDump prefix function call in a view by database name
3725
create database bug23491_original;
3726
create database bug23491_restore;
3727
use bug23491_original;
3728
create table t1 (c1 int);
3729
create view v1 as select * from t1;
3730
create procedure p1() select 1;
3731
create function f1() returns int return 1;
3732
create view v2 as select f1();
3733
create function f2() returns int return f1();
3734
create view v3 as select bug23491_original.f1();
3735
use bug23491_restore;
3736
show create view bug23491_restore.v2;
3737
View Create View character_set_client collation_connection
3738
v2 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v2` AS select `f1`() AS `f1()` latin1 latin1_swedish_ci
3739
show create view bug23491_restore.v3;
3740
View Create View character_set_client collation_connection
3741
v3 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v3` AS select `bug23491_original`.`f1`() AS `bug23491_original.f1()` latin1 latin1_swedish_ci
3742
drop database bug23491_original;
3743
drop database bug23491_restore;
3746
# Bug#27293 mysqldump crashes when dumping routines
3747
# defined by a different user
3749
# Bug#22761 mysqldump reports no errors when using
3750
# --routines without mysql.proc privileges
3752
create database mysqldump_test_db;
3753
grant all privileges on mysqldump_test_db.* to user1;
3754
grant all privileges on mysqldump_test_db.* to user2;
3755
create procedure mysqldump_test_db.sp1() select 'hello';
3757
-- insufficient privileges to SHOW CREATE PROCEDURE `sp1`
3758
-- does user2 have permissions on mysql.proc?
3760
/*!50003 SET @saved_cs_client = @@character_set_client */ ;
3761
/*!50003 SET @saved_cs_results = @@character_set_results */ ;
3762
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
3763
/*!50003 SET character_set_client = latin1 */ ;
3764
/*!50003 SET character_set_results = latin1 */ ;
3765
/*!50003 SET collation_connection = latin1_swedish_ci */ ;
3766
/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
3767
/*!50003 SET sql_mode = '' */ ;
3769
/*!50003 CREATE*/ /*!50020 DEFINER=`user1`@`%`*/ /*!50003 PROCEDURE `sp1`()
3772
/*!50003 SET sql_mode = @saved_sql_mode */ ;
3773
/*!50003 SET character_set_client = @saved_cs_client */ ;
3774
/*!50003 SET character_set_results = @saved_cs_results */ ;
3775
/*!50003 SET collation_connection = @saved_col_connection */ ;
3779
drop database mysqldump_test_db;
3781
# Bug#28522 buffer overrun by '\0' byte using --hex-blob.
3783
CREATE TABLE t1 (c1 INT, c2 LONGBLOB);
3784
INSERT INTO t1 SET c1=11, c2=REPEAT('q',509);
3785
/*!40101 SET @saved_cs_client = @@character_set_client */;
3786
/*!40101 SET character_set_client = utf8 */;
3788
`c1` int(11) DEFAULT NULL,
3791
/*!40101 SET character_set_client = @saved_cs_client */;
3792
INSERT INTO `t1` VALUES (11,0x7171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171);
3795
# Bug#28524 mysqldump --skip-add-drop-table is not
3796
# compatible with views
3798
CREATE VIEW v1 AS SELECT 1;
3805
# Bug#29788 mysqldump discards the NO_AUTO_VALUE_ON_ZERO value of
3806
# the SQL_MODE variable after the dumping of triggers.
3808
CREATE TABLE t1 (c1 INT);
3809
CREATE TRIGGER t1bd BEFORE DELETE ON t1 FOR EACH ROW BEGIN END;
3810
CREATE TABLE t2 (c1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY);
3811
SET @TMP_SQL_MODE = @@SQL_MODE;
3812
SET SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';
3813
INSERT INTO t2 VALUES (0), (1), (2);
3814
SET SQL_MODE = @TMP_SQL_MODE;
3827
# Bug#29815 new option for suppressing last line of mysqldump:
3828
# "Dump completed on"
3841
-- Dump completed on DATE
3842
# --dump-date (default):
3847
-- Dump completed on DATE
3849
# Bug #42635: mysqldump includes views that were excluded using
3850
# the --ignore-table option
3852
create database db42635;
3854
create table t1 (id int);
3855
create view db42635.v1 (c) as select * from db42635.t1;
3856
create view db42635.v2 (c) as select * from db42635.t1;
3858
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
3859
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
3860
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
3861
/*!40101 SET NAMES utf8 */;
3862
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
3863
/*!40103 SET TIME_ZONE='+00:00' */;
3864
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
3865
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
3866
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
3867
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
3868
DROP TABLE IF EXISTS `t1`;
3869
/*!40101 SET @saved_cs_client = @@character_set_client */;
3870
/*!40101 SET character_set_client = utf8 */;
3872
`id` int(11) DEFAULT NULL
3873
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
3874
/*!40101 SET character_set_client = @saved_cs_client */;
3876
LOCK TABLES `t1` WRITE;
3877
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
3878
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
3880
DROP TABLE IF EXISTS `v2`;
3881
/*!50001 DROP VIEW IF EXISTS `v2`*/;
3882
SET @saved_cs_client = @@character_set_client;
3883
SET character_set_client = utf8;
3884
/*!50001 CREATE TABLE `v2` (
3887
SET character_set_client = @saved_cs_client;
3888
/*!50001 DROP TABLE IF EXISTS `v2`*/;
3889
/*!50001 DROP VIEW IF EXISTS `v2`*/;
3890
/*!50001 SET @saved_cs_client = @@character_set_client */;
3891
/*!50001 SET @saved_cs_results = @@character_set_results */;
3892
/*!50001 SET @saved_col_connection = @@collation_connection */;
3893
/*!50001 SET character_set_client = latin1 */;
3894
/*!50001 SET character_set_results = latin1 */;
3895
/*!50001 SET collation_connection = latin1_swedish_ci */;
3896
/*!50001 CREATE ALGORITHM=UNDEFINED */
3897
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
3898
/*!50001 VIEW `v2` AS select `t1`.`id` AS `c` from `t1` */;
3899
/*!50001 SET character_set_client = @saved_cs_client */;
3900
/*!50001 SET character_set_results = @saved_cs_results */;
3901
/*!50001 SET collation_connection = @saved_col_connection */;
3902
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3904
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3905
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3906
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
3907
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
3908
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
3909
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
3910
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
3913
drop database db42635;
3915
# Bug#33550 mysqldump 4.0 compatibility broken
3918
CREATE TABLE `straße` ( f1 INT );
3919
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
3920
/*!40103 SET TIME_ZONE='+00:00' */;
3921
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
3922
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
3923
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,MYSQL323' */;
3924
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
3925
DROP TABLE IF EXISTS `straße`;
3926
CREATE TABLE `straße` (
3927
`f1` int(11) DEFAULT NULL
3930
LOCK TABLES `straße` WRITE;
3931
/*!40000 ALTER TABLE `straße` DISABLE KEYS */;
3932
/*!40000 ALTER TABLE `straße` ENABLE KEYS */;
3934
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3936
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3937
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3938
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
3939
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
3941
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
3942
/*!40103 SET TIME_ZONE='+00:00' */;
3943
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
3944
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
3945
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,MYSQL323' */;
3946
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
3947
DROP TABLE IF EXISTS `stra�e`;
3948
CREATE TABLE `stra�e` (
3949
`f1` int(11) DEFAULT NULL
3952
LOCK TABLES `stra�e` WRITE;
3953
/*!40000 ALTER TABLE `stra�e` DISABLE KEYS */;
3954
/*!40000 ALTER TABLE `stra�e` ENABLE KEYS */;
3956
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3958
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3959
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3960
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
3961
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
3963
DROP TABLE `straße`;
3964
CREATE TABLE `כדשגכחךלדגכחשךדגחכךלדגכ` ( f1 INT );
3965
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
3966
/*!40103 SET TIME_ZONE='+00:00' */;
3967
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
3968
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
3969
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,MYSQL323' */;
3970
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
3971
DROP TABLE IF EXISTS `כדשגכחךלדגכחשךדגחכךלדגכ`;
3972
CREATE TABLE `כדשגכחךלדגכחשךדגחכךלדגכ` (
3973
`f1` int(11) DEFAULT NULL
3976
LOCK TABLES `כדשגכחךלדגכחשךדגחכךלדגכ` WRITE;
3977
/*!40000 ALTER TABLE `כדשגכחךלדגכחשךדגחכךלדגכ` DISABLE KEYS */;
3978
/*!40000 ALTER TABLE `כדשגכחךלדגכחשךדגחכךלדגכ` ENABLE KEYS */;
3980
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3982
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3983
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3984
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
3985
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
3987
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
3988
/*!40103 SET TIME_ZONE='+00:00' */;
3989
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
3990
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
3991
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,MYSQL323' */;
3992
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
3993
DROP TABLE `כדשגכחךלדגכחשךדגחכךלדגכ`;
3998
drop table if exists t1;
3999
CREATE TABLE t1(a int, b int);
4000
INSERT INTO t1 VALUES (1,1);
4001
INSERT INTO t1 VALUES (2,3);
4002
INSERT INTO t1 VALUES (3,4), (4,5);
4004
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
4005
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
4006
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
4007
/*!40101 SET NAMES utf8 */;
4008
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
4009
/*!40103 SET TIME_ZONE='+00:00' */;
4010
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
4011
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
4012
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
4013
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
4014
DROP TABLE IF EXISTS `t1`;
4015
/*!40101 SET @saved_cs_client = @@character_set_client */;
4016
/*!40101 SET character_set_client = utf8 */;
4018
`a` int(11) DEFAULT NULL,
4019
`b` int(11) DEFAULT NULL
4020
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
4021
/*!40101 SET character_set_client = @saved_cs_client */;
4023
LOCK TABLES `t1` WRITE;
4024
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
4025
REPLACE INTO `t1` VALUES (1,1),(2,3),(3,4),(4,5);
4026
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
4028
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
4030
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
4031
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
4032
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
4033
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
4034
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
4035
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
4036
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
4039
create table t1 (a text , b text);
4040
create table t2 (a text , b text);
4041
insert t1 values ("Duck, Duck", "goose");
4042
insert t1 values ("Duck, Duck", "pidgeon");
4043
insert t2 values ("We the people", "in order to perform");
4044
insert t2 values ("a more perfect", "union");
4051
We the people in order to perform
4052
a more perfect union
4053
test.t1: Records: 2 Deleted: 0 Skipped: 0 Warnings: 0
4054
test.t2: Records: 2 Deleted: 0 Skipped: 0 Warnings: 0
4063
We the people in order to perform
4064
a more perfect union
4065
We the people in order to perform
4066
a more perfect union
4067
create table words(a varchar(255));
4068
create table words2(b varchar(255));
4079
We the people in order to perform
4080
a more perfect union
4081
We the people in order to perform
4082
a more perfect union
4083
We the people in order to perform
4084
a more perfect union
4085
select * from words;
4157
select * from words2;
4210
mysql-import: Error: 1146, Table 'test.words' doesn't exist, when using table: words
4215
# Bug#16853 mysqldump doesn't show events
4217
create database first;
4219
set time_zone = 'UTC';
4220
create event ee1 on schedule at '2035-12-31 20:01:23' do set @a=5;
4222
Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation
4223
first ee1 root@localhost UTC ONE TIME 2035-12-31 20:01:23 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci
4224
show create event ee1;
4225
Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
4226
ee1 UTC CREATE EVENT `ee1` ON SCHEDULE AT '2035-12-31 20:01:23' ON COMPLETION NOT PRESERVE ENABLE DO set @a=5 latin1 latin1_swedish_ci latin1_swedish_ci
4227
drop database first;
4228
create database second;
4231
Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation
4232
second ee1 root@localhost UTC ONE TIME 2035-12-31 20:01:23 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci
4233
show create event ee1;
4234
Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
4235
ee1 UTC CREATE EVENT `ee1` ON SCHEDULE AT '2035-12-31 20:01:23' ON COMPLETION NOT PRESERVE ENABLE DO set @a=5 latin1 latin1_swedish_ci latin1_swedish_ci
4236
create event ee2 on schedule at '2018-12-31 21:01:23' do set @a=5;
4237
create event ee3 on schedule at '2030-12-31 22:01:23' do set @a=5;
4239
Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation
4240
second ee1 root@localhost UTC ONE TIME 2035-12-31 20:01:23 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci
4241
second ee2 root@localhost UTC ONE TIME 2018-12-31 21:01:23 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci
4242
second ee3 root@localhost UTC ONE TIME 2030-12-31 22:01:23 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci
4243
drop database second;
4244
create database third;
4247
Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation
4248
third ee1 root@localhost UTC ONE TIME 2035-12-31 20:01:23 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci
4249
third ee2 root@localhost UTC ONE TIME 2018-12-31 21:01:23 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci
4250
third ee3 root@localhost UTC ONE TIME 2030-12-31 22:01:23 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci
4251
drop database third;
4252
set time_zone = 'SYSTEM';
4255
# Bug#17201 Spurious 'DROP DATABASE' in output,
4256
# also confusion between tables and views.
4257
# Example code from Markus Popp
4259
create database mysqldump_test_db;
4260
use mysqldump_test_db;
4261
create table t1 (id int);
4262
create view v1 as select * from t1;
4263
insert into t1 values (1232131);
4264
insert into t1 values (4711);
4265
insert into t1 values (3231);
4266
insert into t1 values (0815);
4268
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
4269
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
4270
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
4271
/*!40101 SET NAMES utf8 */;
4272
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
4273
/*!40103 SET TIME_ZONE='+00:00' */;
4274
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
4275
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
4276
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
4277
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
4279
/*!40000 DROP DATABASE IF EXISTS `mysqldump_test_db`*/;
4281
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysqldump_test_db` /*!40100 DEFAULT CHARACTER SET latin1 */;
4283
USE `mysqldump_test_db`;
4284
DROP TABLE IF EXISTS `t1`;
4285
/*!40101 SET @saved_cs_client = @@character_set_client */;
4286
/*!40101 SET character_set_client = utf8 */;
4288
`id` int(11) DEFAULT NULL
4289
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
4290
/*!40101 SET character_set_client = @saved_cs_client */;
4292
LOCK TABLES `t1` WRITE;
4293
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
4294
INSERT INTO `t1` VALUES (1232131),(4711),(3231),(815);
4295
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
4297
DROP TABLE IF EXISTS `v1`;
4298
/*!50001 DROP VIEW IF EXISTS `v1`*/;
4299
SET @saved_cs_client = @@character_set_client;
4300
SET character_set_client = utf8;
4301
/*!50001 CREATE TABLE `v1` (
4304
SET character_set_client = @saved_cs_client;
4306
USE `mysqldump_test_db`;
4307
/*!50001 DROP TABLE IF EXISTS `v1`*/;
4308
/*!50001 DROP VIEW IF EXISTS `v1`*/;
4309
/*!50001 SET @saved_cs_client = @@character_set_client */;
4310
/*!50001 SET @saved_cs_results = @@character_set_results */;
4311
/*!50001 SET @saved_col_connection = @@collation_connection */;
4312
/*!50001 SET character_set_client = latin1 */;
4313
/*!50001 SET character_set_results = latin1 */;
4314
/*!50001 SET collation_connection = latin1_swedish_ci */;
4315
/*!50001 CREATE ALGORITHM=UNDEFINED */
4316
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
4317
/*!50001 VIEW `v1` AS select `t1`.`id` AS `id` from `t1` */;
4318
/*!50001 SET character_set_client = @saved_cs_client */;
4319
/*!50001 SET character_set_results = @saved_cs_results */;
4320
/*!50001 SET collation_connection = @saved_col_connection */;
4321
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
4323
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
4324
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
4325
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
4326
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
4327
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
4328
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
4329
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
4333
drop database mysqldump_test_db;
4335
# Bug#30027 mysqldump does not dump views properly.
4339
DROP DATABASE IF EXISTS mysqldump_test_db;
4342
CREATE DATABASE mysqldump_test_db;
4344
CREATE VIEW mysqldump_test_db.v2 AS SELECT 1 AS �������1;
4345
CREATE VIEW mysqldump_test_db.v1 AS SELECT �������1 FROM mysqldump_test_db.v2;
4348
# Dump mysqldump_test_db to bug30027.sql.
4350
# Drop mysqldump_test_db.
4351
DROP DATABASE mysqldump_test_db;
4353
# Restore mysqldump_test_db from bug30027.sql.
4357
SHOW CREATE VIEW mysqldump_test_db.v1;
4358
View Create View character_set_client collation_connection
4359
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `mysqldump_test_db`.`v1` AS select `v2`.`колонка1` AS `колонка1` from `mysqldump_test_db`.`v2` koi8r koi8r_general_ci
4360
SHOW CREATE VIEW mysqldump_test_db.v2;
4361
View Create View character_set_client collation_connection
4362
v2 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `mysqldump_test_db`.`v2` AS select 1 AS `колонка1` koi8r koi8r_general_ci
4366
DROP DATABASE mysqldump_test_db;
4368
# Bug#29938 wrong behavior of mysqldump --skip-events
4369
# with --all-databases
4371
TRUNCATE mysql.event;
4373
CREATE event e29938 ON SCHEDULE AT '2035-12-31 20:01:23' DO SET @bug29938=29938;
4375
Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation
4376
test e29938 root@localhost SYSTEM ONE TIME 2035-12-31 20:01:23 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci
4377
TRUNCATE mysql.event;
4379
Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation
4381
# Bug#31113 mysqldump 5.1 can't handle a dash ("-") in database names
4383
create database `test-database`;
4384
use `test-database`;
4385
create table test (a int);
4386
DROP TABLE IF EXISTS `test`;
4387
/*!40101 SET @saved_cs_client = @@character_set_client */;
4388
/*!40101 SET character_set_client = utf8 */;
4389
CREATE TABLE `test` (
4390
`a` int(11) DEFAULT NULL
4391
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
4392
/*!40101 SET character_set_client = @saved_cs_client */;
4393
LOCK TABLES `test` WRITE;
4394
/*!40000 ALTER TABLE `test` DISABLE KEYS */;
4395
/*!40000 ALTER TABLE `test` ENABLE KEYS */;
4397
drop database `test-database`;
4400
# -----------------------------------------------------------------
4401
# -- Bug#30217 Views: changes in metadata behaviour between 5.0 and 5.1.
4402
# -----------------------------------------------------------------
4404
DROP DATABASE IF EXISTS mysqldump_test_db;
4405
CREATE DATABASE mysqldump_test_db;
4406
use mysqldump_test_db;
4408
CREATE VIEW v1(x, y) AS SELECT 'a', 'a';
4410
SELECT view_definition
4411
FROM INFORMATION_SCHEMA.VIEWS
4412
WHERE table_schema = 'mysqldump_test_db' AND table_name = 'v1';
4414
select 'a' AS `x`,'a' AS `y`
4416
---> Dumping mysqldump_test_db to bug30217.sql
4418
DROP DATABASE mysqldump_test_db;
4421
---> Restoring mysqldump_test_db...
4423
SELECT view_definition
4424
FROM INFORMATION_SCHEMA.VIEWS
4425
WHERE table_schema = 'mysqldump_test_db' AND table_name = 'v1';
4427
select 'a' AS `x`,'a' AS `y`
4429
DROP DATABASE mysqldump_test_db;
4431
# -- End of test case for Bug#32538.
4434
# Bug#37377 Incorrect DROP TABLE statement in dump of a VIEW using --tab
4436
create table t1 (a int);
4437
create view v1 as select a from t1;
4443
# Bug#28071 mysqlimport does not quote or escape table name
4445
drop table if exists `load`;
4446
create table `load` (a varchar(255));
4447
test.load: Records: 70 Deleted: 0 Skipped: 0 Warnings: 0
4448
select count(*) from `load`;
4452
SET @@GLOBAL.CONCURRENT_INSERT = @OLD_CONCURRENT_INSERT;
4454
Bug #34861 - mysqldump with --tab gives weird output for triggers.
4456
CREATE TABLE t1 (f1 INT);
4457
CREATE TRIGGER tr1 BEFORE UPDATE ON t1 FOR EACH ROW SET @f1 = 1;
4458
CREATE PROCEDURE pr1 () SELECT "Meow";
4459
CREATE EVENT ev1 ON SCHEDULE AT '2030-01-01 00:00:00' DO SELECT "Meow";
4462
Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation
4463
tr1 UPDATE t1 SET @f1 = 1 BEFORE NULL root@localhost latin1 latin1_swedish_ci latin1_swedish_ci
4465
Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation
4466
test ev1 root@localhost SYSTEM ONE TIME 2030-01-01 00:00:00 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci
4467
SELECT name,body FROM mysql.proc WHERE NAME = 'pr1';
4471
dump table; if anything goes to stdout, it ends up here: ---------------
4479
reload table; this should restore table and trigger
4481
Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation
4482
tr1 UPDATE t1 SET @f1 = 1 BEFORE NULL root@localhost latin1 latin1_swedish_ci latin1_swedish_ci
4484
Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation
4485
SELECT name,body FROM mysql.proc WHERE NAME = 'pr1';
4488
reload db; this should restore routines and events
4490
Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation
4491
tr1 UPDATE t1 SET @f1 = 1 BEFORE NULL root@localhost latin1 latin1_swedish_ci latin1_swedish_ci
4493
Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation
4494
test ev1 root@localhost SYSTEM ONE TIME 2030-01-01 00:00:00 NULL NULL NULL NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci
4495
SELECT name,body FROM mysql.proc WHERE NAME = 'pr1';
4500
DROP EVENT IF EXISTS ev1;
4501
DROP PROCEDURE IF EXISTS pr1;
4502
DROP TRIGGER IF EXISTS tr1;
4503
DROP TABLE IF EXISTS t1;
4505
# Bug #30946: mysqldump silently ignores --default-character-set
4506
# when used with --tab
4508
# Also see outfile_loaddata.test
4511
CREATE TABLE t1 (a INT, b CHAR(10) CHARSET koi8r, c CHAR(10) CHARSET latin1);
4512
CREATE TABLE t2 LIKE t1;
4513
INSERT INTO t1 VALUES (1, 'ABC-АБВ', 'DEF-ÂÃÄ'), (2, NULL, NULL);
4514
# error on multi-character ENCLOSED/ESCAPED BY
4515
# default '--default-charset' (binary):
4516
##################################################
4519
##################################################
4521
LOAD DATA INFILE 'MYSQLTEST_VARDIR/tmp/t1.txt' INTO TABLE t2 CHARACTER SET binary;
4522
SELECT * FROM t1 UNION SELECT * FROM t2 ORDER BY a, b, c;
4527
##################################################
4530
##################################################
4532
LOAD DATA INFILE 'MYSQLTEST_VARDIR/tmp/t1.txt' INTO TABLE t2 CHARACTER SET utf8;
4533
SELECT * FROM t1 UNION SELECT * FROM t2 ORDER BY a, b, c;
4537
# latin1 (data corruption is expected):
4538
##################################################
4541
##################################################
4543
LOAD DATA INFILE 'MYSQLTEST_VARDIR/tmp/t1.txt' INTO TABLE t2 CHARACTER SET latin1 ;
4544
SELECT * FROM t1 UNION SELECT * FROM t2 ORDER BY a, b, c;
4549
# koi8r (data corruption is expected):
4550
##################################################
4553
##################################################
4555
LOAD DATA INFILE 'MYSQLTEST_VARDIR/tmp/t1.txt' INTO TABLE t2 CHARACTER SET koi8r;
4556
SELECT * FROM t1 UNION SELECT * FROM t2 ORDER BY a, b, c;