Debian Codegraph @

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

raw
1 reset master;
2 create table t1 (a int);
3 insert into t1 values (1);
4 insert into t1 values (2);
5 insert into t1 values (3);
6 update t1 set a=a+2 where a=2;
7 update t1 set a=a+2 where a=3;
8 create table t2 (word varchar(20));
9 load data infile '../../std_data/words.dat' into table t2;
10 flush logs;
11 drop table t1;
12 drop table t2;
13 RESET MASTER;
14 select * from t1;
15 a
16 1
17 4
18 5
19 select * from t2;
20 word
21 Aarhus
22 Aaron
23 Ababa
24 aback
25 abaft
26 abandon
27 abandoned
28 abandoning
29 abandonment
30 abandons
31 Aarhus
32 Aaron
33 Ababa
34 aback
35 abaft
36 abandon
37 abandoned
38 abandoning
39 abandonment
40 abandons
41 abase
42 abased
43 abasement
44 abasements
45 abases
46 abash
47 abashed
48 abashes
49 abashing
50 abasing
51 abate
52 abated
53 abatement
54 abatements
55 abater
56 abates
57 abating
58 Abba
59 abbe
60 abbey
61 abbeys
62 abbot
63 abbots
64 Abbott
65 abbreviate
66 abbreviated
67 abbreviates
68 abbreviating
69 abbreviation
70 abbreviations
71 Abby
72 abdomen
73 abdomens
74 abdominal
75 abduct
76 abducted
77 abduction
78 abductions
79 abductor
80 abductors
81 abducts
82 Abe
83 abed
84 Abel
85 Abelian
86 Abelson
87 Aberdeen
88 Abernathy
89 aberrant
90 aberration
91 flush logs;
92 drop table t2;
93 create table t2 (word varchar(20));
94 load data infile '../../std_data/words.dat' into table t2;
95 insert into t2 select * from t2;
96 insert into t2 select * from t2;
97 insert into t2 select * from t2;
98 insert into t2 select * from t2;
99 insert into t2 select * from t2;
100 insert into t2 select * from t2;
101 insert into t2 select * from t2;
102 insert into t2 select * from t2;
103 insert into t2 select * from t2;
104 select count(*) from t2;
105 count(*)
106 35840
107 flush logs;
108 RESET MASTER;
109 select count(*) from t2;
110 count(*)
111 35840
112 drop table t1;
113 drop table t2;
114 RESET MASTER;
115 USE test;
116 SET @old_binlog_format= @@binlog_format;
117 Warnings:
118 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
119 SET SESSION binlog_format='ROW';
120 Warnings:
121 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
122 CREATE TABLE t1(c1 INT);
123 INSERT INTO t1 VALUES (1);
124 FLUSH LOGS;
125 DROP TABLE t1;
126 SET SESSION binlog_format= @old_binlog_format;
127 Warnings:
128 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
129 RESET MASTER;