2 set timestamp=1000000000;
3 drop table if exists t1,t2,t3,t4,t5,t03,t04;
4 create table t1 (word varchar(20));
5 create table t2 (id int auto_increment not null primary key);
6 insert into t1 values ("abirvalg");
7 insert into t2 values ();
8 load data infile '../../std_data/words.dat' into table t1;
9 load data infile '../../std_data/words.dat' into table t1;
10 load data infile '../../std_data/words.dat' into table t1;
11 load data infile '../../std_data/words.dat' into table t1;
12 load data infile '../../std_data/words.dat' into table t1;
13 insert into t1 values ("Alas");
17 /*!40019 SET @@session.max_insert_delayed_threads=0*/;
18 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
22 SET TIMESTAMP=1000000000/*!*/;
23 SET @@session.pseudo_thread_id=999999999/*!*/;
24 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
25 SET @@session.sql_mode=0/*!*/;
26 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
28 SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
29 SET @@session.lc_time_names=0/*!*/;
30 SET @@session.collation_database=DEFAULT/*!*/;
31 drop table if exists t1,t2,t3,t4,t5,t03,t04
33 SET TIMESTAMP=1000000000/*!*/;
34 create table t1 (word varchar(20))
36 SET TIMESTAMP=1000000000/*!*/;
37 create table t2 (id int auto_increment not null primary key)
39 SET TIMESTAMP=1000000000/*!*/;
40 insert into t1 values ("abirvalg")
43 SET TIMESTAMP=1000000000/*!*/;
44 insert into t2 values ()
46 SET TIMESTAMP=1000000000/*!*/;
47 LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-#-#' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`word`)
49 SET TIMESTAMP=1000000000/*!*/;
50 LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-#-#' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`word`)
52 SET TIMESTAMP=1000000000/*!*/;
53 LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-#-#' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`word`)
55 SET TIMESTAMP=1000000000/*!*/;
56 LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-#-#' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`word`)
60 ROLLBACK /* added by mysqlbinlog */;
61 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
63 --- Broken LOAD DATA --
64 /*!40019 SET @@session.max_insert_delayed_threads=0*/;
65 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
68 SET TIMESTAMP=1000000000/*!*/;
69 SET @@session.pseudo_thread_id=999999999/*!*/;
70 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
71 SET @@session.sql_mode=0/*!*/;
72 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
74 SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
75 SET @@session.lc_time_names=0/*!*/;
76 SET @@session.collation_database=DEFAULT/*!*/;
77 insert into t1 values ("Alas")
81 ROLLBACK /* added by mysqlbinlog */;
82 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
85 /*!40019 SET @@session.max_insert_delayed_threads=0*/;
86 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
92 ROLLBACK /* added by mysqlbinlog */;
93 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
96 Warning: The option '--position' is deprecated and will be removed in a future release. Please use --start-position instead.
97 /*!40019 SET @@session.max_insert_delayed_threads=0*/;
98 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
101 SET TIMESTAMP=1000000000/*!*/;
102 SET @@session.pseudo_thread_id=999999999/*!*/;
103 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
104 SET @@session.sql_mode=0/*!*/;
105 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
106 /*!\C latin1 *//*!*/;
107 SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
108 SET @@session.lc_time_names=0/*!*/;
109 SET @@session.collation_database=DEFAULT/*!*/;
110 insert into t1 values ("Alas")
114 ROLLBACK /* added by mysqlbinlog */;
115 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
118 /*!40019 SET @@session.max_insert_delayed_threads=0*/;
119 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
123 SET TIMESTAMP=1000000000/*!*/;
124 SET @@session.pseudo_thread_id=999999999/*!*/;
125 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
126 SET @@session.sql_mode=0/*!*/;
127 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
128 /*!\C latin1 *//*!*/;
129 SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
130 SET @@session.lc_time_names=0/*!*/;
131 SET @@session.collation_database=DEFAULT/*!*/;
132 drop table if exists t1,t2,t3,t4,t5,t03,t04
134 SET TIMESTAMP=1000000000/*!*/;
135 create table t1 (word varchar(20))
137 SET TIMESTAMP=1000000000/*!*/;
138 create table t2 (id int auto_increment not null primary key)
140 SET TIMESTAMP=1000000000/*!*/;
141 insert into t1 values ("abirvalg")
143 SET INSERT_ID=1/*!*/;
144 SET TIMESTAMP=1000000000/*!*/;
145 insert into t2 values ()
147 SET TIMESTAMP=1000000000/*!*/;
148 LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-#-#' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`word`)
150 SET TIMESTAMP=1000000000/*!*/;
151 LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-#-#' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`word`)
153 SET TIMESTAMP=1000000000/*!*/;
154 LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-#-#' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`word`)
156 SET TIMESTAMP=1000000000/*!*/;
157 LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-#-#' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`word`)
161 ROLLBACK /* added by mysqlbinlog */;
162 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
164 --- Broken LOAD DATA --
165 /*!40019 SET @@session.max_insert_delayed_threads=0*/;
166 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
169 SET TIMESTAMP=1000000000/*!*/;
170 SET @@session.pseudo_thread_id=999999999/*!*/;
171 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
172 SET @@session.sql_mode=0/*!*/;
173 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
174 /*!\C latin1 *//*!*/;
175 SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
176 SET @@session.lc_time_names=0/*!*/;
177 SET @@session.collation_database=DEFAULT/*!*/;
178 insert into t1 values ("Alas")
182 ROLLBACK /* added by mysqlbinlog */;
183 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
186 /*!40019 SET @@session.max_insert_delayed_threads=0*/;
187 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
190 SET INSERT_ID=1/*!*/;
193 ROLLBACK /* added by mysqlbinlog */;
194 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
197 Warning: The option '--position' is deprecated and will be removed in a future release. Please use --start-position instead.
198 /*!40019 SET @@session.max_insert_delayed_threads=0*/;
199 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
202 SET TIMESTAMP=1000000000/*!*/;
203 SET @@session.pseudo_thread_id=999999999/*!*/;
204 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
205 SET @@session.sql_mode=0/*!*/;
206 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
207 /*!\C latin1 *//*!*/;
208 SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
209 SET @@session.lc_time_names=0/*!*/;
210 SET @@session.collation_database=DEFAULT/*!*/;
211 insert into t1 values ("Alas")
215 ROLLBACK /* added by mysqlbinlog */;
216 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
219 /*!40019 SET @@session.max_insert_delayed_threads=0*/;
220 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
224 SET TIMESTAMP=1108844556/*!*/;
225 SET @@session.pseudo_thread_id=999999999/*!*/;
226 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
227 SET @@session.lc_time_names=0/*!*/;
228 SET @@session.collation_database=DEFAULT/*!*/;
231 SET TIMESTAMP=1108844555/*!*/;
236 ROLLBACK /* added by mysqlbinlog */;
237 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
238 Warning: The option '--position' is deprecated and will be removed in a future release. Please use --start-position instead.
239 /*!40019 SET @@session.max_insert_delayed_threads=0*/;
240 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
243 SET TIMESTAMP=1108844556/*!*/;
244 SET @@session.pseudo_thread_id=999999999/*!*/;
245 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
246 SET @@session.lc_time_names=0/*!*/;
247 SET @@session.collation_database=DEFAULT/*!*/;
250 SET TIMESTAMP=1108844555/*!*/;
255 ROLLBACK /* added by mysqlbinlog */;
256 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
260 select * from t5 /* must be (1),(1) */;
266 create table t5 (c1 int, c2 varchar(128) character set latin1 not null);
267 insert into t5 values (1, date_format('2001-01-01','%W'));
268 set lc_time_names=de_DE;
269 insert into t5 values (2, date_format('2001-01-01','%W'));
270 set lc_time_names=en_US;
271 insert into t5 values (3, date_format('2001-01-01','%W'));
272 select * from t5 order by c1;
279 select * from t5 order by c1;
285 drop procedure if exists p1;
287 create procedure p1()
298 ERROR 42000: PROCEDURE test.p1 does not exist
299 /*!40019 SET @@session.max_insert_delayed_threads=0*/;
300 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
303 SET TIMESTAMP=1000000000/*!*/;
304 SET @@session.pseudo_thread_id=999999999/*!*/;
305 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
306 SET @@session.sql_mode=0/*!*/;
307 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
308 /*!\C latin1 *//*!*/;
309 SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
310 SET @@session.lc_time_names=0/*!*/;
311 SET @@session.collation_database=DEFAULT/*!*/;
312 CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`()
319 ROLLBACK /* added by mysqlbinlog */;
320 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
326 create table t1 (a varchar(64) character set utf8);
327 load data infile '../../std_data/loaddata6.dat' into table t1;
328 set character_set_database=koi8r;
329 load data infile '../../std_data/loaddata6.dat' into table t1;
330 set character_set_database=latin1;
331 load data infile '../../std_data/loaddata6.dat' into table t1;
332 load data infile '../../std_data/loaddata6.dat' into table t1;
333 set character_set_database=koi8r;
334 load data infile '../../std_data/loaddata6.dat' into table t1;
335 set character_set_database=latin1;
336 load data infile '../../std_data/loaddata6.dat' into table t1;
337 load data infile '../../std_data/loaddata6.dat' into table t1 character set koi8r;
338 select hex(a) from t1;
349 /*!40019 SET @@session.max_insert_delayed_threads=0*/;
350 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
353 SET TIMESTAMP=1000000000/*!*/;
354 SET @@session.pseudo_thread_id=999999999/*!*/;
355 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
356 SET @@session.sql_mode=0/*!*/;
357 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
358 /*!\C latin1 *//*!*/;
359 SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
360 SET @@session.lc_time_names=0/*!*/;
361 SET @@session.collation_database=DEFAULT/*!*/;
362 create table t1 (a varchar(64) character set utf8)
364 SET TIMESTAMP=1000000000/*!*/;
365 LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-#-#' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`a`)
367 SET TIMESTAMP=1000000000/*!*/;
368 SET @@session.collation_database=7/*!*/;
369 LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-#-#' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`a`)
371 SET TIMESTAMP=1000000000/*!*/;
372 SET @@session.collation_database=DEFAULT/*!*/;
373 LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-#-#' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`a`)
375 SET TIMESTAMP=1000000000/*!*/;
376 LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-#-#' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`a`)
378 SET TIMESTAMP=1000000000/*!*/;
379 SET @@session.collation_database=7/*!*/;
380 LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-a-0' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`a`)
382 SET TIMESTAMP=1000000000/*!*/;
383 SET @@session.collation_database=DEFAULT/*!*/;
384 LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-b-0' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`a`)
386 SET TIMESTAMP=1000000000/*!*/;
387 LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-c-0' INTO TABLE `t1` CHARACTER SET koi8r FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`a`)
389 SET TIMESTAMP=1000000000/*!*/;
394 ROLLBACK /* added by mysqlbinlog */;
395 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
396 CREATE TABLE t1 (c1 CHAR(10));
398 INSERT INTO t1 VALUES ('0123456789');
401 We expect this value to be 1
402 The bug being tested was that 'Query' lines were not preceded by '#'
403 If the line is in the table, it had to have been preceded by a '#'
405 SELECT COUNT(*) AS `BUG#28293_expect_1` FROM patch WHERE a LIKE '%Query%';
410 CREATE TABLE t1(a INT);
411 INSERT INTO t1 VALUES(connection_id());
416 shell> mysqlbinlog std_data/corrupt-relay-bin.000624 > var/tmp/bug31793.sql
418 Bug#31611 Security risk with BINLOG statement
419 SET BINLOG_FORMAT=ROW;
420 CREATE DATABASE mysqltest1;
421 CREATE USER untrusted@localhost;
422 GRANT SELECT ON mysqltest1.* TO untrusted@localhost;
423 SHOW GRANTS FOR untrusted@localhost;
424 Grants for untrusted@localhost
425 GRANT USAGE ON *.* TO 'untrusted'@'localhost'
426 GRANT SELECT ON `mysqltest1`.* TO 'untrusted'@'localhost'
428 CREATE TABLE t1 (a INT, b CHAR(64));
430 INSERT INTO t1 VALUES (1,USER());
432 mysqlbinlog var/log/master-bin.000017 > var/tmp/bug31611.sql
433 mysql mysqltest1 -uuntrusted < var/tmp/bug31611.sql
434 INSERT INTO t1 VALUES (1,USER());
435 ERROR 42000: INSERT command denied to user 'untrusted'@'localhost' for table 't1'
439 DROP DATABASE mysqltest1;
440 DROP USER untrusted@localhost;
441 Bug#32580 mysqlbinlog cannot read binlog event with user variables
443 SET BINLOG_FORMAT = STATEMENT;
445 CREATE TABLE t1 (a_real FLOAT, an_int INT, a_decimal DECIMAL(5,2), a_string CHAR(32));
446 SET @a_real = rand(20) * 1000;
448 SET @a_decimal = CAST(rand(19) * 999 AS DECIMAL(5,2));
449 SET @a_string = 'Just a test';
450 INSERT INTO t1 VALUES (@a_real, @an_int, @a_decimal, @a_string);
458 >> mysqlbinlog var/log/master-bin.000019 > var/tmp/bug32580.sql
459 >> mysql test < var/tmp/bug32580.sql
466 SET @@global.server_id= 4294967295;
470 (@a:=LOAD_FILE("MYSQLTEST_VARDIR/tmp/mysqlbinlog_bug37313.binlog"))
472 (@a:=LOAD_FILE("MYSQLTEST_VARDIR/tmp/mysqlbinlog_bug37313.binlog"))
475 *** Unsigned server_id 4294967295 is found: 1 ***
476 SET @@global.server_id= 1;
482 # Test if the 'BEGIN', 'ROLLBACK' and 'COMMIT' are output if the database specified exists
483 /*!40019 SET @@session.max_insert_delayed_threads=0*/;
484 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
488 SET TIMESTAMP=1253783037/*!*/;
489 SET @@session.pseudo_thread_id=999999999/*!*/;
490 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
491 SET @@session.sql_mode=0/*!*/;
492 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
493 /*!\C latin1 *//*!*/;
494 SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
495 SET @@session.lc_time_names=0/*!*/;
496 SET @@session.collation_database=DEFAULT/*!*/;
497 create table t1(a int) engine= innodb
499 SET TIMESTAMP=1253783037/*!*/;
502 SET TIMESTAMP=1253783037/*!*/;
503 insert into t1 (a) values (1)
506 SET TIMESTAMP=1253783037/*!*/;
507 create table t3(a int) engine= innodb
509 SET TIMESTAMP=1253783037/*!*/;
512 SET TIMESTAMP=1253783037/*!*/;
513 insert into t3 (a) values (2)
515 SET TIMESTAMP=1253783037/*!*/;
518 SET TIMESTAMP=1253783037/*!*/;
519 create table t5(a int) engine= NDB
521 SET TIMESTAMP=1253783037/*!*/;
524 SET TIMESTAMP=1253783037/*!*/;
525 insert into t5 (a) values (3)
527 SET TIMESTAMP=1253783037/*!*/;
532 ROLLBACK /* added by mysqlbinlog */;
533 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
535 # Test if the 'BEGIN', 'ROLLBACK' and 'COMMIT' are output if the database specified does not exist
536 /*!40019 SET @@session.max_insert_delayed_threads=0*/;
537 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
540 SET TIMESTAMP=1253783037/*!*/;
541 SET @@session.pseudo_thread_id=999999999/*!*/;
542 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
543 SET @@session.sql_mode=0/*!*/;
544 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
545 /*!\C latin1 *//*!*/;
546 SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
547 SET @@session.lc_time_names=0/*!*/;
548 SET @@session.collation_database=DEFAULT/*!*/;
552 SET TIMESTAMP=1253783037/*!*/;
555 SET TIMESTAMP=1253783037/*!*/;
558 SET TIMESTAMP=1253783037/*!*/;
561 SET TIMESTAMP=1253783037/*!*/;
566 ROLLBACK /* added by mysqlbinlog */;
567 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
569 # Test if the 'SAVEPOINT', 'ROLLBACK TO' are output if the database specified exists
570 /*!40019 SET @@session.max_insert_delayed_threads=0*/;
571 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
573 SET TIMESTAMP=1266652094/*!*/;
574 SET @@session.pseudo_thread_id=999999999/*!*/;
575 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
576 SET @@session.sql_mode=0/*!*/;
577 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
578 /*!\C latin1 *//*!*/;
579 SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
580 SET @@session.lc_time_names=0/*!*/;
581 SET @@session.collation_database=DEFAULT/*!*/;
585 SET TIMESTAMP=1266652094/*!*/;
586 SavePoint mixed_cases
589 SET TIMESTAMP=1266652094/*!*/;
590 INSERT INTO db1.t2 VALUES("in savepoint mixed_cases")
592 SET TIMESTAMP=1266652094/*!*/;
593 INSERT INTO db1.t1 VALUES(40)
596 SET TIMESTAMP=1266652094/*!*/;
597 ROLLBACK TO mixed_cases
600 SET TIMESTAMP=1266652094/*!*/;
601 INSERT INTO db1.t2 VALUES("after rollback to")
603 SET TIMESTAMP=1266652094/*!*/;
604 INSERT INTO db1.t1 VALUES(50)
609 ROLLBACK /* added by mysqlbinlog */;
610 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
612 # Test if the 'SAVEPOINT', 'ROLLBACK TO' are output if the database specified does not exist
613 /*!40019 SET @@session.max_insert_delayed_threads=0*/;
614 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
616 SET TIMESTAMP=1266652094/*!*/;
617 SET @@session.pseudo_thread_id=999999999/*!*/;
618 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
619 SET @@session.sql_mode=0/*!*/;
620 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
621 /*!\C latin1 *//*!*/;
622 SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
623 SET @@session.lc_time_names=0/*!*/;
624 SET @@session.collation_database=DEFAULT/*!*/;
628 SET TIMESTAMP=1266652094/*!*/;
629 SavePoint mixed_cases
631 SET TIMESTAMP=1266652094/*!*/;
632 ROLLBACK TO mixed_cases
637 ROLLBACK /* added by mysqlbinlog */;
638 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
642 CREATE DATABASE test1;
644 CREATE TABLE t1(id int);
646 CREATE DATABASE test1;
648 CREATE TABLE t1(id int);
652 show binlog events in 'master-bin.000002' from <binlog_start>;
653 Log_name Pos Event_type Server_id End_log_pos Info
654 master-bin.000002 # Query # # CREATE DATABASE test1
655 master-bin.000002 # Query # # use `test1`; CREATE TABLE t1(id int)
656 master-bin.000002 # Query # # DROP DATABASE test1
657 master-bin.000002 # Query # # CREATE DATABASE test1
658 master-bin.000002 # Query # # use `test1`; CREATE TABLE t1(id int)
659 master-bin.000002 # Query # # use `test1`; DROP TABLE t1
660 master-bin.000002 # Query # # DROP DATABASE test1
663 CREATE TABLE t1 (a INT);
664 SET GLOBAL SERVER_ID = 2;
672 SET GLOBAL SERVER_ID = 1;