diff options
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_mdev382.result')
-rw-r--r-- | mysql-test/suite/rpl/r/rpl_mdev382.result | 193 |
1 files changed, 97 insertions, 96 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_mdev382.result b/mysql-test/suite/rpl/r/rpl_mdev382.result index bbc57006d0d..e43ff4303f6 100644 --- a/mysql-test/suite/rpl/r/rpl_mdev382.result +++ b/mysql-test/suite/rpl/r/rpl_mdev382.result @@ -14,20 +14,21 @@ Warnings: Warning 1196 Some non-transactional changed tables couldn't be rolled back insert into t1 values (3); commit; -show binlog events from <binlog_start>; +show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; create table t1 (a int primary key) engine=innodb -master-bin.000001 # Query # # use `test`; create table t2 (a int primary key) engine=myisam -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; insert into t2 values (1) -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; insert into t1 values (1) -master-bin.000001 # Query # # SAVEPOINT "a`; create database couldbebadthingshere; savepoint `dummy" -master-bin.000001 # Query # # use `test`; insert into t1 values (2) -master-bin.000001 # Query # # ROLLBACK TO `a``; create database couldbebadthingshere; savepoint ``dummy` -master-bin.000001 # Query # # use `test`; insert into t1 values (3) -master-bin.000001 # Xid # # COMMIT /* XID */ +master-bin.000001 # Binlog_checkpoint 1 # master-bin.000001 +master-bin.000001 # Query 1 # use `test`; create table t1 (a int primary key) engine=innodb +master-bin.000001 # Query 1 # use `test`; create table t2 (a int primary key) engine=myisam +master-bin.000001 # Query 1 # BEGIN +master-bin.000001 # Query 1 # use `test`; insert into t2 values (1) +master-bin.000001 # Query 1 # COMMIT +master-bin.000001 # Query 1 # BEGIN +master-bin.000001 # Query 1 # use `test`; insert into t1 values (1) +master-bin.000001 # Query 1 # SAVEPOINT "a`; create database couldbebadthingshere; savepoint `dummy" +master-bin.000001 # Query 1 # use `test`; insert into t1 values (2) +master-bin.000001 # Query 1 # ROLLBACK TO `a``; create database couldbebadthingshere; savepoint ``dummy` +master-bin.000001 # Query 1 # use `test`; insert into t1 values (3) +master-bin.000001 # Xid 1 # COMMIT /* XID */ BEGIN; insert into t1 values(10); set sql_mode = 'ANSI_QUOTES'; @@ -54,27 +55,27 @@ savepoint `d``d`; insert into t1 values(18); COMMIT; set sql_quote_show_create = 1; -show binlog events from <binlog_start>; +show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; insert into t1 values(10) -master-bin.000001 # Query # # SAVEPOINT "a" -master-bin.000001 # Query # # use `test`; insert into t1 values(11) -master-bin.000001 # Query # # SAVEPOINT "a""a" -master-bin.000001 # Query # # use `test`; insert into t1 values(12) -master-bin.000001 # Query # # SAVEPOINT b -master-bin.000001 # Query # # use `test`; insert into t1 values(13) -master-bin.000001 # Query # # SAVEPOINT "b""b" -master-bin.000001 # Query # # use `test`; insert into t1 values(14) -master-bin.000001 # Query # # SAVEPOINT `c` -master-bin.000001 # Query # # use `test`; insert into t1 values(15) -master-bin.000001 # Query # # SAVEPOINT `c``c` -master-bin.000001 # Query # # use `test`; insert into t1 values(16) -master-bin.000001 # Query # # SAVEPOINT d -master-bin.000001 # Query # # use `test`; insert into t1 values(17) -master-bin.000001 # Query # # SAVEPOINT `d``d` -master-bin.000001 # Query # # use `test`; insert into t1 values(18) -master-bin.000001 # Xid # # COMMIT /* XID */ +master-bin.000001 # Query 1 # BEGIN +master-bin.000001 # Query 1 # use `test`; insert into t1 values(10) +master-bin.000001 # Query 1 # SAVEPOINT "a" +master-bin.000001 # Query 1 # use `test`; insert into t1 values(11) +master-bin.000001 # Query 1 # SAVEPOINT "a""a" +master-bin.000001 # Query 1 # use `test`; insert into t1 values(12) +master-bin.000001 # Query 1 # SAVEPOINT b +master-bin.000001 # Query 1 # use `test`; insert into t1 values(13) +master-bin.000001 # Query 1 # SAVEPOINT "b""b" +master-bin.000001 # Query 1 # use `test`; insert into t1 values(14) +master-bin.000001 # Query 1 # SAVEPOINT `c` +master-bin.000001 # Query 1 # use `test`; insert into t1 values(15) +master-bin.000001 # Query 1 # SAVEPOINT `c``c` +master-bin.000001 # Query 1 # use `test`; insert into t1 values(16) +master-bin.000001 # Query 1 # SAVEPOINT d +master-bin.000001 # Query 1 # use `test`; insert into t1 values(17) +master-bin.000001 # Query 1 # SAVEPOINT `d``d` +master-bin.000001 # Query 1 # use `test`; insert into t1 values(18) +master-bin.000001 # Xid 1 # COMMIT /* XID */ *** Test correct USE statement in SHOW BINLOG EVENTS *** set sql_mode = 'ANSI_QUOTES'; CREATE DATABASE "db1`; select 'oops!'"; @@ -83,40 +84,40 @@ CREATE TABLE t1 (a INT PRIMARY KEY) engine=MyISAM; INSERT INTO t1 VALUES (1); set sql_mode = ''; INSERT INTO t1 VALUES (2); -set sql_mode = 'ANSI_QUOTES'; -show binlog events from <binlog_start>; +set sql_mode = 'ANSI_QUOTES'; +show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # CREATE DATABASE "db1`; select 'oops!'" -master-bin.000001 # Query # # use "db1`; select 'oops!'"; CREATE TABLE t1 (a INT PRIMARY KEY) engine=MyISAM -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use "db1`; select 'oops!'"; INSERT INTO t1 VALUES (1) -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use "db1`; select 'oops!'"; INSERT INTO t1 VALUES (2) -master-bin.000001 # Query # # COMMIT +master-bin.000001 # Query 1 # CREATE DATABASE "db1`; select 'oops!'" +master-bin.000001 # Query 1 # use "db1`; select 'oops!'"; CREATE TABLE t1 (a INT PRIMARY KEY) engine=MyISAM +master-bin.000001 # Query 1 # BEGIN +master-bin.000001 # Query 1 # use "db1`; select 'oops!'"; INSERT INTO t1 VALUES (1) +master-bin.000001 # Query 1 # COMMIT +master-bin.000001 # Query 1 # BEGIN +master-bin.000001 # Query 1 # use "db1`; select 'oops!'"; INSERT INTO t1 VALUES (2) +master-bin.000001 # Query 1 # COMMIT set sql_mode = ''; set sql_quote_show_create = 0; -show binlog events from <binlog_start>; +show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # CREATE DATABASE "db1`; select 'oops!'" -master-bin.000001 # Query # # use `db1``; select 'oops!'`; CREATE TABLE t1 (a INT PRIMARY KEY) engine=MyISAM -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `db1``; select 'oops!'`; INSERT INTO t1 VALUES (1) -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `db1``; select 'oops!'`; INSERT INTO t1 VALUES (2) -master-bin.000001 # Query # # COMMIT +master-bin.000001 # Query 1 # CREATE DATABASE "db1`; select 'oops!'" +master-bin.000001 # Query 1 # use `db1``; select 'oops!'`; CREATE TABLE t1 (a INT PRIMARY KEY) engine=MyISAM +master-bin.000001 # Query 1 # BEGIN +master-bin.000001 # Query 1 # use `db1``; select 'oops!'`; INSERT INTO t1 VALUES (1) +master-bin.000001 # Query 1 # COMMIT +master-bin.000001 # Query 1 # BEGIN +master-bin.000001 # Query 1 # use `db1``; select 'oops!'`; INSERT INTO t1 VALUES (2) +master-bin.000001 # Query 1 # COMMIT set sql_quote_show_create = 1; -show binlog events from <binlog_start>; +show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # CREATE DATABASE "db1`; select 'oops!'" -master-bin.000001 # Query # # use `db1``; select 'oops!'`; CREATE TABLE t1 (a INT PRIMARY KEY) engine=MyISAM -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `db1``; select 'oops!'`; INSERT INTO t1 VALUES (1) -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `db1``; select 'oops!'`; INSERT INTO t1 VALUES (2) -master-bin.000001 # Query # # COMMIT +master-bin.000001 # Query 1 # CREATE DATABASE "db1`; select 'oops!'" +master-bin.000001 # Query 1 # use `db1``; select 'oops!'`; CREATE TABLE t1 (a INT PRIMARY KEY) engine=MyISAM +master-bin.000001 # Query 1 # BEGIN +master-bin.000001 # Query 1 # use `db1``; select 'oops!'`; INSERT INTO t1 VALUES (1) +master-bin.000001 # Query 1 # COMMIT +master-bin.000001 # Query 1 # BEGIN +master-bin.000001 # Query 1 # use `db1``; select 'oops!'`; INSERT INTO t1 VALUES (2) +master-bin.000001 # Query 1 # COMMIT DROP TABLE t1; use test; ***Test LOAD DATA INFILE with various identifiers that need correct quoting *** @@ -141,19 +142,19 @@ LOAD DATA INFILE 'MYSQLTEST_VARDIR/tmp/f''le.txt' SELECT * FROM `db1``; select 'oops!'`.`t``1`; a`1 b`2 c`3 fo\o bar |b"a'z! -show binlog events from <binlog_start>; +show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `db1``; select 'oops!'`; CREATE TABLE `t``1` (`a``1` VARCHAR(4) PRIMARY KEY, `b``2` VARCHAR(3), +master-bin.000001 # Query 1 # use `db1``; select 'oops!'`; CREATE TABLE `t``1` (`a``1` VARCHAR(4) PRIMARY KEY, `b``2` VARCHAR(3), `c``3` VARCHAR(7)) -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Begin_load_query # # ;file_id=#;block_len=# -master-bin.000001 # Execute_load_query # # use `db1``; select 'oops!'`; LOAD DATA INFILE 'MYSQLTEST_VARDIR/tmp/f\'le.txt' INTO TABLE `t``1` FIELDS TERMINATED BY ',' ENCLOSED BY '\'' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`a``1`, @`b```) SET `b``2`= @`b```, `c``3`= concat('|', "b""a'z", "!") ;file_id=# -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # use `db1``; select 'oops!'`; truncate `t``1` -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Begin_load_query # # ;file_id=#;block_len=# -master-bin.000001 # Execute_load_query # # use `test`; LOAD DATA INFILE 'MYSQLTEST_VARDIR/tmp/f\'le.txt' INTO TABLE `db1``; select 'oops!'`.`t``1` FIELDS TERMINATED BY ',' ENCLOSED BY '\'' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`a``1`, `b``2`) SET `c``3`= concat('|', "b""a'z", "!") ;file_id=# -master-bin.000001 # Query # # COMMIT +master-bin.000001 # Query 1 # BEGIN +master-bin.000001 # Begin_load_query 1 # ;file_id=#;block_len=14 +master-bin.000001 # Execute_load_query 1 # use `db1``; select 'oops!'`; LOAD DATA INFILE 'MYSQLTEST_VARDIR/tmp/f\'le.txt' INTO TABLE `t``1` FIELDS TERMINATED BY ',' ENCLOSED BY '\'' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`a``1`, @`b```) SET `b``2`= @`b```, `c``3`= concat('|', "b""a'z", "!") ;file_id=# +master-bin.000001 # Query 1 # COMMIT +master-bin.000001 # Query 1 # use `db1``; select 'oops!'`; truncate `t``1` +master-bin.000001 # Query 1 # BEGIN +master-bin.000001 # Begin_load_query 1 # ;file_id=#;block_len=14 +master-bin.000001 # Execute_load_query 1 # use `test`; LOAD DATA INFILE 'MYSQLTEST_VARDIR/tmp/f\'le.txt' INTO TABLE `db1``; select 'oops!'`.`t``1` FIELDS TERMINATED BY ',' ENCLOSED BY '\'' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`a``1`, `b``2`) SET `c``3`= concat('|', "b""a'z", "!") ;file_id=# +master-bin.000001 # Query 1 # COMMIT /*!40019 SET @@session.max_insert_delayed_threads=0*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; @@ -211,12 +212,12 @@ SELECT * FROM t1 ORDER BY a; a b 1 X| 123456789A123456789B123456789C123456789D123456789E123456789F123456789G123456789H123456789I123456789J123456789K123456789L123456789M123456789N123456789O123456789P123456789Q123456789R123456789123456789T123456789U123456789V123456789W123456789X123456789Y123456789Z123456789|X 2 A| 123456789A123456789B123456789C123456789D123456789E123456789F123456789G123456789H123456789I123456789J123456789K123456789L123456789M123456789N123456789O123456789P123456789Q123456789R123456789123456789T123456789U123456789V123456789W123456789X123456789Y123456789Z123456789|A -show binlog events from <binlog_start>; +show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Begin_load_query # # ;file_id=#;block_len=# -master-bin.000001 # Execute_load_query # # use `test`; LOAD DATA INFILE 'MYSQLTEST_VARDIR/tmp/file.txt' INTO TABLE `t1` FIELDS TERMINATED BY ',' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`a`, @`b`) SET `b`= CONCAT(@b, '| 123456789A123456789B123456789C123456789D123456789E123456789F123456789G123456789H123456789I123456789J123456789K123456789L123456789M123456789N123456789O123456789P123456789Q123456789R123456789123456789T123456789U123456789V123456789W123456789X123456789Y123456789Z123456789|', @b) ;file_id=# -master-bin.000001 # Query # # COMMIT +master-bin.000001 # Query 1 # BEGIN +master-bin.000001 # Begin_load_query 1 # ;file_id=#;block_len=8 +master-bin.000001 # Execute_load_query 1 # use `test`; LOAD DATA INFILE 'MYSQLTEST_VARDIR/tmp/file.txt' INTO TABLE `t1` FIELDS TERMINATED BY ',' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`a`, @`b`) SET `b`= CONCAT(@b, '| 123456789A123456789B123456789C123456789D123456789E123456789F123456789G123456789H123456789I123456789J123456789K123456789L123456789M123456789N123456789O123456789P123456789Q123456789R123456789123456789T123456789U123456789V123456789W123456789X123456789Y123456789Z123456789|', @b) ;file_id=# +master-bin.000001 # Query 1 # COMMIT SELECT * FROM t1 ORDER BY a; a b 1 X| 123456789A123456789B123456789C123456789D123456789E123456789F123456789G123456789H123456789I123456789J123456789K123456789L123456789M123456789N123456789O123456789P123456789Q123456789R123456789123456789T123456789U123456789V123456789W123456789X123456789Y123456789Z123456789|X @@ -230,22 +231,22 @@ SELECT @`a``1`:=a1, @`a``2`:=a2, @`a``3`:=a3, @`a``4`:=a4, @`b```:=b, @```c`:=c, @`a``1`:=a1 @`a``2`:=a2 @`a``3`:=a3 @`a``4`:=a4 @`b```:=b @```c`:=c @```d```:=d -9223372036854775808 42 9223372036854775807 18446744073709551615 -1.234560123456789e125 -1234501234567890123456789012345678901234567890123456789.0123456789 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx INSERT INTO t1 VALUES (@`a``1`+1, @`a``2`*100, @`a``3`-1, @`a``4`-1, @`b```/2, @```c`, substr(@```d```, 2, 98)); -show binlog events from <binlog_start>; +show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `db1``; select 'oops!'`; CREATE TABLE t1 (a1 BIGINT PRIMARY KEY, a2 BIGINT, a3 BIGINT, a4 BIGINT UNSIGNED, b DOUBLE, c DECIMAL(65,10), d VARCHAR(100)) -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `db1``; select 'oops!'`; INSERT INTO t1 VALUES (-9223372036854775808,42,9223372036854775807,18446744073709551615,-1234560123456789e110, -1234501234567890123456789012345678901234567890123456789.0123456789, REPEAT("x", 100)) -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # User var # # @`a``1`=-9223372036854775808 -master-bin.000001 # User var # # @`a``2`=42 -master-bin.000001 # User var # # @`a``3`=9223372036854775807 -master-bin.000001 # User var # # @`a``4`=18446744073709551615 -master-bin.000001 # User var # # @`b```=-1.234560123456789e125 -master-bin.000001 # User var # # @```c`=-1234501234567890123456789012345678901234567890123456789.0123456789 -master-bin.000001 # User var # # @```d```=_latin1 0x78787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878 COLLATE latin1_swedish_ci -master-bin.000001 # Query # # use `db1``; select 'oops!'`; INSERT INTO t1 VALUES (@`a``1`+1, @`a``2`*100, @`a``3`-1, @`a``4`-1, @`b```/2, @```c`, substr(@```d```, 2, 98)) -master-bin.000001 # Query # # COMMIT +master-bin.000001 # Query 1 # use `db1``; select 'oops!'`; CREATE TABLE t1 (a1 BIGINT PRIMARY KEY, a2 BIGINT, a3 BIGINT, a4 BIGINT UNSIGNED, b DOUBLE, c DECIMAL(65,10), d VARCHAR(100)) +master-bin.000001 # Query 1 # BEGIN +master-bin.000001 # Query 1 # use `db1``; select 'oops!'`; INSERT INTO t1 VALUES (-9223372036854775808,42,9223372036854775807,18446744073709551615,-1234560123456789e110, -1234501234567890123456789012345678901234567890123456789.0123456789, REPEAT("x", 100)) +master-bin.000001 # Query 1 # COMMIT +master-bin.000001 # Query 1 # BEGIN +master-bin.000001 # User var 1 # @`a``1`=-9223372036854775808 +master-bin.000001 # User var 1 # @`a``2`=42 +master-bin.000001 # User var 1 # @`a``3`=9223372036854775807 +master-bin.000001 # User var 1 # @`a``4`=18446744073709551615 +master-bin.000001 # User var 1 # @`b```=-1.234560123456789e125 +master-bin.000001 # User var 1 # @```c`=-1234501234567890123456789012345678901234567890123456789.0123456789 +master-bin.000001 # User var 1 # @```d```=_latin1 0x78787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878 COLLATE latin1_swedish_ci +master-bin.000001 # Query 1 # use `db1``; select 'oops!'`; INSERT INTO t1 VALUES (@`a``1`+1, @`a``2`*100, @`a``3`-1, @`a``4`-1, @`b```/2, @```c`, substr(@```d```, 2, 98)) +master-bin.000001 # Query 1 # COMMIT /*!40019 SET @@session.max_insert_delayed_threads=0*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; @@ -321,7 +322,7 @@ a` # The DELETE statement should be correctly quoted show binlog events in 'master-bin.000002' from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000002 # Query # # DELETE FROM `db1``; select 'oops!'`.`t``1` +master-bin.000002 # Query 1 # DELETE FROM `db1``; select 'oops!'`.`t``1` include/start_slave.inc # The table should be empty on the slave also. SELECT * FROM `db1``; select 'oops!'`.`t``1`; @@ -334,9 +335,9 @@ CREATE TABLE t1 (a INT PRIMARY KEY); INSERT INTO t1 VALUES(1); show binlog events in 'master-bin.000002' from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000002 # Query # # BEGIN -master-bin.000002 # Query # # use `test`; INSERT INTO t1 VALUES(1) -master-bin.000002 # Query # # COMMIT +master-bin.000002 # Query 1 # BEGIN +master-bin.000002 # Query 1 # use `test`; INSERT INTO t1 VALUES(1) +master-bin.000002 # Query 1 # COMMIT /*!40019 SET @@session.max_insert_delayed_threads=0*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; |