Debian Codegraph @

mysql-test/suite/binlog/r/binlog_mysqlbinlog_require_row_format_errors.result

raw
1 #
2 # 0. Execute a RESET MASTER to clean old binary logs
3 # Add suppressions for the test.
4 # Create a test include.
5 RESET MASTER;
6 CALL mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
7 #
8 # 1. Log a DML transaction using statement based logging (T1)
9 CREATE TABLE t1 (c01 BIT);
10 INSERT INTO t1 VALUES (0);
11 DROP TABLE t1;
12 FLUSH LOGS;
13 #
14 # 1.1 Check mysqlbinlog errors out (T1)
15 include/mysqlbinlog.inc
16 include/assert_grep.inc [There was an error when executing mysqlbinlog]
17 include/assert_grep.inc [The INSERT query is not written with --require_row_format]
18 include/mysqlbinlog.inc
19 include/assert_grep.inc [There was an error when executing mysqlbinlog remotely]
20 include/assert_grep.inc [The INSERT query is not written with --require_row_format]
21 include/mysqlbinlog.inc
22 include/assert_grep.inc [The INSERT query is written without --require_row_format]
23 RESET MASTER;
24 #
25 # 2. Log a transaction with a LOAD DATA event (T2)
26 CREATE TABLE tload (c1 TEXT);
27 LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE tload;
28 DROP TABLE tload;
29 FLUSH LOGS;
30 #
31 # 2.1 Check mysqlbinlog errors out (T2)
32 include/mysqlbinlog.inc
33 include/assert_grep.inc [There was an error when executing mysqlbinlog]
34 include/assert_grep.inc [The LOAD DATA event is not written with --require_row_format]
35 include/mysqlbinlog.inc
36 include/assert_grep.inc [There was an error when executing mysqlbinlog remotely]
37 include/assert_grep.inc [The LOAD DATA event is not written with --require_row_format]
38 include/mysqlbinlog.inc
39 include/assert_grep.inc [The LOAD DATA event is written without --require_row_format]
40 RESET MASTER;
41 #
42 # 3. Log a transaction with a USER_VAR event (T2)
43 CREATE TABLE t1(i INT) ENGINE=InnoDB;
44 SET @v= 10;
45 INSERT INTO t1 VALUES (@v);
46 FLUSH LOGS;
47 #
48 # 3.1 Check mysqlbinlog errors out (T2)
49 include/mysqlbinlog.inc
50 include/assert_grep.inc [There was an error when executing mysqlbinlog]
51 include/assert_grep.inc [The USER_VAR event is not written with --require_row_format]
52 include/mysqlbinlog.inc
53 include/assert_grep.inc [There was an error when executing mysqlbinlog remotely]
54 include/assert_grep.inc [The USER_VAR event is not written with --require_row_format]
55 include/mysqlbinlog.inc
56 include/assert_grep.inc [The USER_VAR event is written without --require_row_format]
57 RESET MASTER;
58 #
59 # 4. Log a transaction with a RAND event (T2)
60 INSERT INTO t1 VALUES (Rand());
61 Warnings:
62 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica.
63 DROP TABLE t1;
64 FLUSH LOGS;
65 #
66 # 4.1 Check mysqlbinlog errors out (T2)
67 include/mysqlbinlog.inc
68 include/assert_grep.inc [There was an error when executing mysqlbinlog]
69 include/assert_grep.inc [The RAND event is not written with --require_row_format]
70 include/mysqlbinlog.inc
71 include/assert_grep.inc [There was an error when executing mysqlbinlog remotely]
72 include/assert_grep.inc [The RAND event is not written with --require_row_format]
73 include/mysqlbinlog.inc
74 include/assert_grep.inc [The RAND event is written without --require_row_format]
75 RESET MASTER;
76 #
77 # 5. Log a transaction with a INTVAR event (T2)
78 CREATE TABLE t2 (j INT PRIMARY KEY AUTO_INCREMENT);
79 INSERT INTO t2 VALUES();
80 DROP TABLE t2;
81 FLUSH LOGS;
82 #
83 # 5.1 Check mysqlbinlog errors out (T2)
84 include/mysqlbinlog.inc
85 include/assert_grep.inc [There was an error when executing mysqlbinlog]
86 include/assert_grep.inc [The INTVAR event is not written with --require_row_format]
87 include/mysqlbinlog.inc
88 include/assert_grep.inc [There was an error when executing mysqlbinlog remotely]
89 include/assert_grep.inc [The INTVAR event is not written with --require_row_format]
90 include/mysqlbinlog.inc
91 include/assert_grep.inc [The INTVAR event is written without --require_row_format]
92 RESET MASTER;
93 #
94 # 6. Log a transaction with a CREATE TEMPORARY TABLE query (T3)
95 CREATE TEMPORARY TABLE t1 (k INT PRIMARY KEY);
96 FLUSH LOGS;
97 #
98 # 6.1 Check mysqlbinlog errors out (T3)
99 include/mysqlbinlog.inc
100 include/assert_grep.inc [There was an error when executing mysqlbinlog]
101 include/assert_grep.inc [The CREATE TEMPORARY TABLE is not written with --require_row_format]
102 include/mysqlbinlog.inc
103 include/assert_grep.inc [There was an error when executing mysqlbinlog remotely]
104 include/assert_grep.inc [The CREATE TEMPORARY TABLE is not written with --require_row_format]
105 include/mysqlbinlog.inc
106 include/assert_grep.inc [The CREATE TEMPORARY TABLE is written without --require_row_format]
107 RESET MASTER;
108 #
109 # 7. Log a transaction with a DROP TEMPORARY TABLE query (T3)
110 DROP TEMPORARY TABLE t1;
111 FLUSH LOGS;
112 #
113 # 7.1 Check mysqlbinlog errors out (T3)
114 include/mysqlbinlog.inc
115 include/assert_grep.inc [There was an error when executing mysqlbinlog]
116 include/assert_grep.inc [The DROP TEMPORARY TABLE is not written with --require_row_format]
117 include/mysqlbinlog.inc
118 include/assert_grep.inc [There was an error when executing mysqlbinlog remotely]
119 include/assert_grep.inc [The DROP TEMPORARY TABLE is not written with --require_row_format]
120 include/mysqlbinlog.inc
121 include/assert_grep.inc [The DROP TEMPORARY TABLE is written without --require_row_format]
122 RESET MASTER;
123 #
124 # 8. Cleanup