Debian Codegraph @

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

raw
1 Verbose statements from : write-partial-row.binlog
2 select replace(txt,'\r', '') as stmt from raw_binlog_rows where txt like '###%';
3 stmt
4 ### INSERT INTO `mysql`.`ndb_apply_status`
5 ### SET
6 ### @1=1
7 ### @2=25769803786
8 ### @3=''
9 ### @4=0
10 ### @5=0
11 ### INSERT INTO `test`.`ba`
12 ### SET
13 ### @1=3
14 ### @2=3
15 ### @3=3
16 ### INSERT INTO `test`.`ba`
17 ### SET
18 ### @1=1
19 ### @2=1
20 ### @3=1
21 ### INSERT INTO `test`.`ba`
22 ### SET
23 ### @1=2
24 ### @2=2
25 ### @3=2
26 ### INSERT INTO `test`.`ba`
27 ### SET
28 ### @1=4
29 ### @2=4
30 ### @3=4
31 ### INSERT INTO `test`.`ba`
32 ### SET
33 ### @1=4
34 ### @3=40
35 ### DELETE FROM `test`.`ba`
36 ### WHERE
37 ### @1=2
38 drop table raw_binlog_rows;
39 Verbose statements from : write-full-row.binlog
40 select replace(txt,'\r', '') as stmt from raw_binlog_rows where txt like '###%';
41 stmt
42 ### INSERT INTO `mysql`.`ndb_apply_status`
43 ### SET
44 ### @1=2
45 ### @2=25769803786
46 ### @3=''
47 ### @4=0
48 ### @5=0
49 ### INSERT INTO `test`.`ba`
50 ### SET
51 ### @1=3
52 ### @2=3
53 ### @3=3
54 ### INSERT INTO `test`.`ba`
55 ### SET
56 ### @1=1
57 ### @2=1
58 ### @3=1
59 ### INSERT INTO `test`.`ba`
60 ### SET
61 ### @1=2
62 ### @2=2
63 ### @3=2
64 ### INSERT INTO `test`.`ba`
65 ### SET
66 ### @1=4
67 ### @2=4
68 ### @3=4
69 ### INSERT INTO `test`.`ba`
70 ### SET
71 ### @1=4
72 ### @2=4
73 ### @3=40
74 ### DELETE FROM `test`.`ba`
75 ### WHERE
76 ### @1=2
77 drop table raw_binlog_rows;
78 Verbose statements from : update-partial-row.binlog
79 select replace(txt,'\r', '') as stmt from raw_binlog_rows where txt like '###%';
80 stmt
81 ### INSERT INTO `mysql`.`ndb_apply_status`
82 ### SET
83 ### @1=3
84 ### @2=25769803786
85 ### @3=''
86 ### @4=0
87 ### @5=0
88 ### INSERT INTO `test`.`ba`
89 ### SET
90 ### @1=3
91 ### @2=3
92 ### @3=3
93 ### INSERT INTO `test`.`ba`
94 ### SET
95 ### @1=1
96 ### @2=1
97 ### @3=1
98 ### INSERT INTO `test`.`ba`
99 ### SET
100 ### @1=2
101 ### @2=2
102 ### @3=2
103 ### INSERT INTO `test`.`ba`
104 ### SET
105 ### @1=4
106 ### @2=4
107 ### @3=4
108 ### UPDATE `test`.`ba`
109 ### WHERE
110 ### @1=4
111 ### @3=4
112 ### SET
113 ### @1=4
114 ### @3=40
115 ### DELETE FROM `test`.`ba`
116 ### WHERE
117 ### @1=2
118 drop table raw_binlog_rows;
119 Verbose statements from : update-full-row.binlog
120 select replace(txt,'\r', '') as stmt from raw_binlog_rows where txt like '###%';
121 stmt
122 ### INSERT INTO `mysql`.`ndb_apply_status`
123 ### SET
124 ### @1=4
125 ### @2=25769803786
126 ### @3=''
127 ### @4=0
128 ### @5=0
129 ### INSERT INTO `test`.`ba`
130 ### SET
131 ### @1=3
132 ### @2=3
133 ### @3=3
134 ### INSERT INTO `test`.`ba`
135 ### SET
136 ### @1=1
137 ### @2=1
138 ### @3=1
139 ### INSERT INTO `test`.`ba`
140 ### SET
141 ### @1=2
142 ### @2=2
143 ### @3=2
144 ### INSERT INTO `test`.`ba`
145 ### SET
146 ### @1=4
147 ### @2=4
148 ### @3=4
149 ### UPDATE `test`.`ba`
150 ### WHERE
151 ### @1=4
152 ### @2=4
153 ### @3=4
154 ### SET
155 ### @1=4
156 ### @2=4
157 ### @3=40
158 ### DELETE FROM `test`.`ba`
159 ### WHERE
160 ### @1=2
161 drop table raw_binlog_rows;
162 SET @@SESSION.BINLOG_ROWS_QUERY_LOG_EVENTS = 1;
163 CREATE TABLE t1 (a VARCHAR(50));
164 INSERT INTO t1 VALUES ("
165 GRANT ALL ON *.* TO 'batman'/*!*/;
166 ")|
167 DROP TABLE t1;