summaryrefslogtreecommitdiff
path: root/mysql-test/suite/rpl/r/rpl_innodb_mixed_dml.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_innodb_mixed_dml.result')
-rw-r--r--mysql-test/suite/rpl/r/rpl_innodb_mixed_dml.result208
1 files changed, 110 insertions, 98 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_innodb_mixed_dml.result b/mysql-test/suite/rpl/r/rpl_innodb_mixed_dml.result
index 5871e858d27..00b50df4a68 100644
--- a/mysql-test/suite/rpl/r/rpl_innodb_mixed_dml.result
+++ b/mysql-test/suite/rpl/r/rpl_innodb_mixed_dml.result
@@ -1,6 +1,6 @@
include/master-slave.inc
[connection master]
-==========MASTER==========
+connection master;
show global variables like 'binlog_format%';
Variable_name Value
binlog_format MIXED
@@ -10,7 +10,7 @@ binlog_format MIXED
select @@global.binlog_format, @@session.binlog_format;
@@global.binlog_format @@session.binlog_format
MIXED MIXED
-==========SLAVE===========
+connection slave;
show global variables like 'binlog_format%';
Variable_name Value
binlog_format MIXED
@@ -20,6 +20,7 @@ binlog_format MIXED
select @@global.binlog_format, @@session.binlog_format;
@@global.binlog_format @@session.binlog_format
MIXED MIXED
+connection master;
CREATE DATABASE test_rpl;
******************** PREPARE TESTING ********************
@@ -33,7 +34,6 @@ INSERT INTO t2 VALUES(1, 't2, text 1');
******************** DELETE ********************
DELETE FROM t1 WHERE a = 1;
DELETE FROM t2 WHERE b <> UUID();
-==========MASTER==========
SELECT COUNT(*) FROM t1;
COUNT(*)
1
@@ -45,7 +45,7 @@ COUNT(*)
0
SELECT * FROM t2 ORDER BY a;
a b
-==========SLAVE===========
+connection slave;
USE test_rpl;
SELECT COUNT(*) FROM t1;
COUNT(*)
@@ -58,6 +58,7 @@ COUNT(*)
0
SELECT * FROM t2 ORDER BY a;
a b
+connection master;
DELETE FROM t1;
DELETE FROM t2;
@@ -68,7 +69,6 @@ INSERT INTO t2 SELECT * FROM t1;
INSERT INTO t2 VALUES (1, 't1, text 1') ON DUPLICATE KEY UPDATE b = 't2, text 1';
DELETE FROM t1 WHERE a = 2;
DELETE FROM t2 WHERE a = 2;
-==========MASTER==========
SELECT COUNT(*) FROM t1;
COUNT(*)
1
@@ -81,7 +81,7 @@ COUNT(*)
SELECT * FROM t2 ORDER BY a;
a b
1 t2, text 1
-==========SLAVE===========
+connection slave;
USE test_rpl;
SELECT COUNT(*) FROM t1;
COUNT(*)
@@ -95,6 +95,7 @@ COUNT(*)
SELECT * FROM t2 ORDER BY a;
a b
1 t2, text 1
+connection master;
DELETE FROM t1;
DELETE FROM t2;
@@ -105,7 +106,6 @@ a b
10 line A
20 line B
30 line C
-==========MASTER==========
SELECT COUNT(*) FROM t1;
COUNT(*)
3
@@ -119,7 +119,7 @@ COUNT(*)
0
SELECT * FROM t2 ORDER BY a;
a b
-==========SLAVE===========
+connection slave;
USE test_rpl;
SELECT COUNT(*) FROM t1;
COUNT(*)
@@ -134,6 +134,7 @@ COUNT(*)
0
SELECT * FROM t2 ORDER BY a;
a b
+connection master;
DELETE FROM t1;
DELETE FROM t2;
@@ -145,7 +146,6 @@ REPLACE INTO t1 VALUES(1, 't1, text 11');
REPLACE INTO t1 VALUES(2, UUID());
REPLACE INTO t1 SET a=3, b='t1, text 33';
DELETE FROM t1 WHERE a = 2;
-==========MASTER==========
SELECT COUNT(*) FROM t1;
COUNT(*)
2
@@ -158,7 +158,7 @@ COUNT(*)
0
SELECT * FROM t2 ORDER BY a;
a b
-==========SLAVE===========
+connection slave;
USE test_rpl;
SELECT COUNT(*) FROM t1;
COUNT(*)
@@ -172,6 +172,7 @@ COUNT(*)
0
SELECT * FROM t2 ORDER BY a;
a b
+connection master;
DELETE FROM t1;
DELETE FROM t2;
@@ -211,7 +212,6 @@ DELETE FROM t2;
******************** TRUNCATE ********************
INSERT INTO t1 VALUES(1, 't1, text 1');
-==========MASTER==========
SELECT COUNT(*) FROM t1;
COUNT(*)
1
@@ -223,7 +223,7 @@ COUNT(*)
0
SELECT * FROM t2 ORDER BY a;
a b
-==========SLAVE===========
+connection slave;
USE test_rpl;
SELECT COUNT(*) FROM t1;
COUNT(*)
@@ -236,8 +236,8 @@ COUNT(*)
0
SELECT * FROM t2 ORDER BY a;
a b
+connection master;
TRUNCATE t1;
-==========MASTER==========
SELECT COUNT(*) FROM t1;
COUNT(*)
0
@@ -248,7 +248,7 @@ COUNT(*)
0
SELECT * FROM t2 ORDER BY a;
a b
-==========SLAVE===========
+connection slave;
USE test_rpl;
SELECT COUNT(*) FROM t1;
COUNT(*)
@@ -260,6 +260,7 @@ COUNT(*)
0
SELECT * FROM t2 ORDER BY a;
a b
+connection master;
DELETE FROM t1;
DELETE FROM t2;
@@ -267,7 +268,6 @@ DELETE FROM t2;
INSERT INTO t1 VALUES(1, 't1, text 1');
INSERT INTO t2 VALUES(1, 't2, text 1');
UPDATE t1 SET b = 't1, text 1 updated' WHERE a = 1;
-==========MASTER==========
SELECT COUNT(*) FROM t1;
COUNT(*)
1
@@ -280,7 +280,7 @@ COUNT(*)
SELECT * FROM t2 ORDER BY a;
a b
1 t2, text 1
-==========SLAVE===========
+connection slave;
USE test_rpl;
SELECT COUNT(*) FROM t1;
COUNT(*)
@@ -294,8 +294,8 @@ COUNT(*)
SELECT * FROM t2 ORDER BY a;
a b
1 t2, text 1
+connection master;
UPDATE t1, t2 SET t1.b = 'test', t2.b = 'test';
-==========MASTER==========
SELECT COUNT(*) FROM t1;
COUNT(*)
1
@@ -308,7 +308,7 @@ COUNT(*)
SELECT * FROM t2 ORDER BY a;
a b
1 test
-==========SLAVE===========
+connection slave;
USE test_rpl;
SELECT COUNT(*) FROM t1;
COUNT(*)
@@ -322,6 +322,7 @@ COUNT(*)
SELECT * FROM t2 ORDER BY a;
a b
1 test
+connection master;
DELETE FROM t1;
DELETE FROM t2;
@@ -341,7 +342,6 @@ USE test_rpl;
START TRANSACTION;
INSERT INTO t1 VALUES (1, 'start');
COMMIT;
-==========MASTER==========
SELECT COUNT(*) FROM t1;
COUNT(*)
1
@@ -353,7 +353,7 @@ COUNT(*)
0
SELECT * FROM t2 ORDER BY a;
a b
-==========SLAVE===========
+connection slave;
USE test_rpl;
SELECT COUNT(*) FROM t1;
COUNT(*)
@@ -366,10 +366,10 @@ COUNT(*)
0
SELECT * FROM t2 ORDER BY a;
a b
+connection master;
START TRANSACTION;
INSERT INTO t1 VALUES (2, 'rollback');
ROLLBACK;
-==========MASTER==========
SELECT COUNT(*) FROM t1;
COUNT(*)
1
@@ -381,7 +381,7 @@ COUNT(*)
0
SELECT * FROM t2 ORDER BY a;
a b
-==========SLAVE===========
+connection slave;
USE test_rpl;
SELECT COUNT(*) FROM t1;
COUNT(*)
@@ -394,12 +394,12 @@ COUNT(*)
0
SELECT * FROM t2 ORDER BY a;
a b
+connection master;
START TRANSACTION;
INSERT INTO t1 VALUES (3, 'before savepoint s1');
SAVEPOINT s1;
INSERT INTO t1 VALUES (4, 'after savepoint s1');
ROLLBACK TO SAVEPOINT s1;
-==========MASTER==========
SELECT COUNT(*) FROM t1;
COUNT(*)
2
@@ -412,7 +412,7 @@ COUNT(*)
0
SELECT * FROM t2 ORDER BY a;
a b
-==========SLAVE===========
+connection slave;
USE test_rpl;
SELECT COUNT(*) FROM t1;
COUNT(*)
@@ -425,6 +425,7 @@ COUNT(*)
0
SELECT * FROM t2 ORDER BY a;
a b
+connection master;
START TRANSACTION;
INSERT INTO t1 VALUES (5, 'before savepoint s2');
SAVEPOINT s2;
@@ -433,7 +434,6 @@ INSERT INTO t1 VALUES (7, CONCAT('with UUID() ',UUID()));
RELEASE SAVEPOINT s2;
COMMIT;
DELETE FROM t1 WHERE a = 7;
-==========MASTER==========
SELECT COUNT(*) FROM t1;
COUNT(*)
4
@@ -448,7 +448,7 @@ COUNT(*)
0
SELECT * FROM t2 ORDER BY a;
a b
-==========SLAVE===========
+connection slave;
USE test_rpl;
SELECT COUNT(*) FROM t1;
COUNT(*)
@@ -464,6 +464,7 @@ COUNT(*)
0
SELECT * FROM t2 ORDER BY a;
a b
+connection master;
DELETE FROM t1;
DELETE FROM t2;
@@ -479,73 +480,73 @@ SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
******************** CREATE USER ********************
CREATE USER 'user_test_rpl'@'localhost' IDENTIFIED BY PASSWORD '*1111111111111111111111111111111111111111';
-==========MASTER==========
-SELECT host, user, password, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
-host user password select_priv
-localhost user_test_rpl *1111111111111111111111111111111111111111 N
-==========SLAVE===========
+SELECT host, user, password, plugin, authentication_string, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
+host user password plugin authentication_string select_priv
+localhost user_test_rpl *1111111111111111111111111111111111111111 N
+connection slave;
USE test_rpl;
-SELECT host, user, password, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
-host user password select_priv
-localhost user_test_rpl *1111111111111111111111111111111111111111 N
+SELECT host, user, password, plugin, authentication_string, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
+host user password plugin authentication_string select_priv
+localhost user_test_rpl *1111111111111111111111111111111111111111 N
+connection master;
******************** GRANT ********************
GRANT SELECT ON *.* TO 'user_test_rpl'@'localhost';
-==========MASTER==========
-SELECT host, user, password, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
-host user password select_priv
-localhost user_test_rpl *1111111111111111111111111111111111111111 Y
-==========SLAVE===========
+SELECT host, user, password, plugin, authentication_string, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
+host user password plugin authentication_string select_priv
+localhost user_test_rpl *1111111111111111111111111111111111111111 Y
+connection slave;
USE test_rpl;
-SELECT host, user, password, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
-host user password select_priv
-localhost user_test_rpl *1111111111111111111111111111111111111111 Y
+SELECT host, user, password, plugin, authentication_string, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
+host user password plugin authentication_string select_priv
+localhost user_test_rpl *1111111111111111111111111111111111111111 Y
+connection master;
******************** REVOKE ********************
REVOKE SELECT ON *.* FROM 'user_test_rpl'@'localhost';
-==========MASTER==========
-SELECT host, user, password, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
-host user password select_priv
-localhost user_test_rpl *1111111111111111111111111111111111111111 N
-==========SLAVE===========
+SELECT host, user, password, plugin, authentication_string, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
+host user password plugin authentication_string select_priv
+localhost user_test_rpl *1111111111111111111111111111111111111111 N
+connection slave;
USE test_rpl;
-SELECT host, user, password, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
-host user password select_priv
-localhost user_test_rpl *1111111111111111111111111111111111111111 N
+SELECT host, user, password, plugin, authentication_string, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
+host user password plugin authentication_string select_priv
+localhost user_test_rpl *1111111111111111111111111111111111111111 N
+connection master;
******************** SET PASSWORD ********************
SET PASSWORD FOR 'user_test_rpl'@'localhost' = '*0000000000000000000000000000000000000000';
-==========MASTER==========
-SELECT host, user, password, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
-host user password select_priv
-localhost user_test_rpl *0000000000000000000000000000000000000000 N
-==========SLAVE===========
+SELECT host, user, password, plugin, authentication_string, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
+host user password plugin authentication_string select_priv
+localhost user_test_rpl *0000000000000000000000000000000000000000 mysql_native_password *0000000000000000000000000000000000000000 N
+connection slave;
USE test_rpl;
-SELECT host, user, password, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
-host user password select_priv
-localhost user_test_rpl *0000000000000000000000000000000000000000 N
+SELECT host, user, password, plugin, authentication_string, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
+host user password plugin authentication_string select_priv
+localhost user_test_rpl *0000000000000000000000000000000000000000 mysql_native_password *0000000000000000000000000000000000000000 N
+connection master;
******************** RENAME USER ********************
RENAME USER 'user_test_rpl'@'localhost' TO 'user_test_rpl_2'@'localhost';
-==========MASTER==========
-SELECT host, user, password, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
-host user password select_priv
-localhost user_test_rpl_2 *0000000000000000000000000000000000000000 N
-==========SLAVE===========
+SELECT host, user, password, plugin, authentication_string, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
+host user password plugin authentication_string select_priv
+localhost user_test_rpl_2 *0000000000000000000000000000000000000000 mysql_native_password *0000000000000000000000000000000000000000 N
+connection slave;
USE test_rpl;
-SELECT host, user, password, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
-host user password select_priv
-localhost user_test_rpl_2 *0000000000000000000000000000000000000000 N
+SELECT host, user, password, plugin, authentication_string, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
+host user password plugin authentication_string select_priv
+localhost user_test_rpl_2 *0000000000000000000000000000000000000000 mysql_native_password *0000000000000000000000000000000000000000 N
+connection master;
******************** DROP USER ********************
DROP USER 'user_test_rpl_2'@'localhost';
-==========MASTER==========
-SELECT host, user, password, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
-host user password select_priv
-==========SLAVE===========
+SELECT host, user, password, plugin, authentication_string, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
+host user password plugin authentication_string select_priv
+connection slave;
USE test_rpl;
-SELECT host, user, password, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
-host user password select_priv
+SELECT host, user, password, plugin, authentication_string, select_priv FROM mysql.user WHERE user LIKE 'user_test_rpl%';
+host user password plugin authentication_string select_priv
+connection master;
INSERT INTO t1 VALUES(100, 'test');
******************** ANALYZE ********************
@@ -580,14 +581,14 @@ SHOW VARIABLES LIKE 'test_rpl_var';
Variable_name Value
******************** SHOW ********************
-==========MASTER==========
SHOW DATABASES LIKE 'test_rpl%';
Database (test_rpl%)
test_rpl
-==========SLAVE===========
+connection slave;
SHOW DATABASES LIKE 'test_rpl%';
Database (test_rpl%)
test_rpl
+connection master;
******************** PROCEDURE ********************
CREATE PROCEDURE p1 ()
@@ -603,7 +604,6 @@ CALL p1();
INSERT INTO t1 VALUES(202, 'test 202');
CALL p2();
DELETE FROM t1 WHERE a = 202;
-==========MASTER==========
SELECT COUNT(*) FROM t1;
COUNT(*)
2
@@ -616,7 +616,7 @@ COUNT(*)
0
SELECT * FROM t2 ORDER BY a;
a b
-==========SLAVE===========
+connection slave;
USE test_rpl;
SELECT COUNT(*) FROM t1;
COUNT(*)
@@ -630,6 +630,7 @@ COUNT(*)
0
SELECT * FROM t2 ORDER BY a;
a b
+connection master;
ALTER PROCEDURE p1 COMMENT 'p1';
DROP PROCEDURE p1;
DROP PROCEDURE p2;
@@ -642,7 +643,6 @@ FOR EACH ROW BEGIN
INSERT INTO t2 SET a = NEW.a, b = NEW.b;
END|
INSERT INTO t1 VALUES (1, 'test');
-==========MASTER==========
SELECT COUNT(*) FROM t1;
COUNT(*)
1
@@ -655,7 +655,7 @@ COUNT(*)
SELECT * FROM t2 ORDER BY a;
a b
1 test
-==========SLAVE===========
+connection slave;
USE test_rpl;
SELECT COUNT(*) FROM t1;
COUNT(*)
@@ -669,6 +669,7 @@ COUNT(*)
SELECT * FROM t2 ORDER BY a;
a b
1 test
+connection master;
DELETE FROM t1;
DELETE FROM t2;
DROP TRIGGER tr1;
@@ -678,16 +679,15 @@ DROP TRIGGER tr1;
GRANT EVENT ON *.* TO 'root'@'localhost';
INSERT INTO t1 VALUES(1, 'test1');
CREATE EVENT e1 ON SCHEDULE EVERY '1' SECOND COMMENT 'e_second_comment' DO DELETE FROM t1;
-==========MASTER==========
SHOW EVENTS;
Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation
test_rpl e1 root@localhost SYSTEM RECURRING NULL 1 # # NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci
-==========SLAVE===========
+connection slave;
USE test_rpl;
SHOW EVENTS;
Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation
test_rpl e1 root@localhost SYSTEM RECURRING NULL 1 # # NULL SLAVESIDE_DISABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci
-==========MASTER==========
+connection master;
SELECT COUNT(*) FROM t1;
COUNT(*)
1
@@ -699,7 +699,7 @@ COUNT(*)
0
SELECT * FROM t2 ORDER BY a;
a b
-==========SLAVE===========
+connection slave;
USE test_rpl;
SELECT COUNT(*) FROM t1;
COUNT(*)
@@ -712,7 +712,7 @@ COUNT(*)
0
SELECT * FROM t2 ORDER BY a;
a b
-==========MASTER==========
+connection master;
SELECT COUNT(*) FROM t1;
COUNT(*)
1
@@ -724,7 +724,7 @@ COUNT(*)
0
SELECT * FROM t2 ORDER BY a;
a b
-==========SLAVE===========
+connection slave;
USE test_rpl;
SELECT COUNT(*) FROM t1;
COUNT(*)
@@ -737,17 +737,17 @@ COUNT(*)
0
SELECT * FROM t2 ORDER BY a;
a b
+connection master;
ALTER EVENT e1 RENAME TO e2;
-==========MASTER==========
SHOW EVENTS;
Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation
test_rpl e2 root@localhost SYSTEM RECURRING NULL 1 # # NULL ENABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci
-==========SLAVE===========
+connection slave;
USE test_rpl;
SHOW EVENTS;
Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation
test_rpl e2 root@localhost SYSTEM RECURRING NULL 1 # # NULL SLAVESIDE_DISABLED 1 latin1 latin1_swedish_ci latin1_swedish_ci
-==========MASTER==========
+connection master;
SELECT COUNT(*) FROM t1;
COUNT(*)
1
@@ -759,7 +759,7 @@ COUNT(*)
0
SELECT * FROM t2 ORDER BY a;
a b
-==========SLAVE===========
+connection slave;
USE test_rpl;
SELECT COUNT(*) FROM t1;
COUNT(*)
@@ -772,14 +772,15 @@ COUNT(*)
0
SELECT * FROM t2 ORDER BY a;
a b
+connection master;
DROP EVENT e2;
-==========MASTER==========
SHOW EVENTS;
Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation
-==========SLAVE===========
+connection slave;
USE test_rpl;
SHOW EVENTS;
Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation
+connection master;
DELETE FROM t1;
DELETE FROM t2;
@@ -788,37 +789,37 @@ INSERT INTO t1 VALUES(1, 'test1');
INSERT INTO t1 VALUES(2, 'test2');
CREATE VIEW v1 AS SELECT * FROM t1 WHERE a = 1;
CREATE VIEW v2 AS SELECT * FROM t1 WHERE b <> UUID();
-==========MASTER==========
SHOW CREATE VIEW v1;
View Create View character_set_client collation_connection
-v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`a` AS `a`,`t1`.`b` AS `b` from `t1` where (`t1`.`a` = 1) latin1 latin1_swedish_ci
+v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`a` AS `a`,`t1`.`b` AS `b` from `t1` where `t1`.`a` = 1 latin1 latin1_swedish_ci
SELECT * FROM v1 ORDER BY a;
a b
1 test1
-==========SLAVE===========
+connection slave;
USE test_rpl;
SHOW CREATE VIEW v1;
View Create View character_set_client collation_connection
-v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`a` AS `a`,`t1`.`b` AS `b` from `t1` where (`t1`.`a` = 1) latin1 latin1_swedish_ci
+v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`a` AS `a`,`t1`.`b` AS `b` from `t1` where `t1`.`a` = 1 latin1 latin1_swedish_ci
SELECT * FROM v1 ORDER BY a;
a b
1 test1
+connection master;
ALTER VIEW v1 AS SELECT * FROM t1 WHERE a = 2;
-==========MASTER==========
SHOW CREATE VIEW v1;
View Create View character_set_client collation_connection
-v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`a` AS `a`,`t1`.`b` AS `b` from `t1` where (`t1`.`a` = 2) latin1 latin1_swedish_ci
+v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`a` AS `a`,`t1`.`b` AS `b` from `t1` where `t1`.`a` = 2 latin1 latin1_swedish_ci
SELECT * FROM v1 ORDER BY a;
a b
2 test2
-==========SLAVE===========
+connection slave;
USE test_rpl;
SHOW CREATE VIEW v1;
View Create View character_set_client collation_connection
-v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`a` AS `a`,`t1`.`b` AS `b` from `t1` where (`t1`.`a` = 2) latin1 latin1_swedish_ci
+v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select `t1`.`a` AS `a`,`t1`.`b` AS `b` from `t1` where `t1`.`a` = 2 latin1 latin1_swedish_ci
SELECT * FROM v1 ORDER BY a;
a b
2 test2
+connection master;
DROP VIEW v1;
DROP VIEW v2;
DELETE FROM t1;
@@ -847,6 +848,7 @@ master-bin.000001 # Gtid # # BEGIN GTID #-#-#
master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t1 WHERE a = 1
master-bin.000001 # Xid # # COMMIT /* XID */
master-bin.000001 # Gtid # # BEGIN GTID #-#-#
+master-bin.000001 # Annotate_rows # # DELETE FROM t2 WHERE b <> UUID()
master-bin.000001 # Table_map # # table_id: # (test_rpl.t2)
master-bin.000001 # Delete_rows_v1 # # table_id: # flags: STMT_END_F
master-bin.000001 # Xid # # COMMIT /* XID */
@@ -860,10 +862,12 @@ master-bin.000001 # Gtid # # BEGIN GTID #-#-#
master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t1 VALUES(1, 't1, text 1')
master-bin.000001 # Xid # # COMMIT /* XID */
master-bin.000001 # Gtid # # BEGIN GTID #-#-#
+master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES(2, UUID())
master-bin.000001 # Table_map # # table_id: # (test_rpl.t1)
master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
master-bin.000001 # Xid # # COMMIT /* XID */
master-bin.000001 # Gtid # # BEGIN GTID #-#-#
+master-bin.000001 # Annotate_rows # # INSERT INTO t2 SELECT * FROM t1
master-bin.000001 # Table_map # # table_id: # (test_rpl.t2)
master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
master-bin.000001 # Xid # # COMMIT /* XID */
@@ -883,6 +887,7 @@ master-bin.000001 # Gtid # # BEGIN GTID #-#-#
master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t2
master-bin.000001 # Xid # # COMMIT /* XID */
master-bin.000001 # Gtid # # BEGIN GTID #-#-#
+master-bin.000001 # Annotate_rows # # LOAD DATA INFILE 'MYSQLTEST_VARDIR/std_data/rpl_mixed.dat' INTO TABLE t1 FIELDS TERMINATED BY '|'
master-bin.000001 # Table_map # # table_id: # (test_rpl.t1)
master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
master-bin.000001 # Xid # # COMMIT /* XID */
@@ -905,6 +910,7 @@ master-bin.000001 # Gtid # # BEGIN GTID #-#-#
master-bin.000001 # Query # # use `test_rpl`; REPLACE INTO t1 VALUES(1, 't1, text 11')
master-bin.000001 # Xid # # COMMIT /* XID */
master-bin.000001 # Gtid # # BEGIN GTID #-#-#
+master-bin.000001 # Annotate_rows # # REPLACE INTO t1 VALUES(2, UUID())
master-bin.000001 # Table_map # # table_id: # (test_rpl.t1)
master-bin.000001 # Update_rows_v1 # # table_id: # flags: STMT_END_F
master-bin.000001 # Xid # # COMMIT /* XID */
@@ -999,6 +1005,7 @@ master-bin.000001 # Gtid # # BEGIN GTID #-#-#
master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t1 VALUES (5, 'before savepoint s2')
master-bin.000001 # Query # # SAVEPOINT `s2`
master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t1 VALUES (6, 'after savepoint s2')
+master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (7, CONCAT('with UUID() ',UUID()))
master-bin.000001 # Table_map # # table_id: # (test_rpl.t1)
master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
master-bin.000001 # Xid # # COMMIT /* XID */
@@ -1052,6 +1059,7 @@ master-bin.000001 # Gtid # # BEGIN GTID #-#-#
master-bin.000001 # Query # # use `test_rpl`; INSERT INTO t1 VALUES(202, 'test 202')
master-bin.000001 # Xid # # COMMIT /* XID */
master-bin.000001 # Gtid # # BEGIN GTID #-#-#
+master-bin.000001 # Annotate_rows # # UPDATE t1 SET b = UUID() WHERE a = 202
master-bin.000001 # Table_map # # table_id: # (test_rpl.t1)
master-bin.000001 # Update_rows_v1 # # table_id: # flags: STMT_END_F
master-bin.000001 # Xid # # COMMIT /* XID */
@@ -1076,6 +1084,7 @@ FOR EACH ROW BEGIN
INSERT INTO t2 SET a = NEW.a, b = NEW.b;
END
master-bin.000001 # Gtid # # BEGIN GTID #-#-#
+master-bin.000001 # Annotate_rows # # INSERT INTO t2 SET a = NEW.a, b = NEW.b
master-bin.000001 # Table_map # # table_id: # (test_rpl.t1)
master-bin.000001 # Table_map # # table_id: # (test_rpl.t2)
master-bin.000001 # Write_rows_v1 # # table_id: #
@@ -1128,5 +1137,8 @@ master-bin.000001 # Xid # # COMMIT /* XID */
master-bin.000001 # Gtid # # BEGIN GTID #-#-#
master-bin.000001 # Query # # use `test_rpl`; DELETE FROM t2
master-bin.000001 # Xid # # COMMIT /* XID */
+connection slave;
+connection master;
drop database test_rpl;
+connection slave;
include/rpl_end.inc
View Lorry Controller Status