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 select * from t1;
14 a
15 1
16 4
17 5
18 select * from t2;
19 word
20 Aarhus
21 Aaron
22 Ababa
23 aback
24 abaft
25 abandon
26 abandoned
27 abandoning
28 abandonment
29 abandons
30 Aarhus
31 Aaron
32 Ababa
33 aback
34 abaft
35 abandon
36 abandoned
37 abandoning
38 abandonment
39 abandons
40 abase
41 abased
42 abasement
43 abasements
44 abases
45 abash
46 abashed
47 abashes
48 abashing
49 abasing
50 abate
51 abated
52 abatement
53 abatements
54 abater
55 abates
56 abating
57 Abba
58 abbe
59 abbey
60 abbeys
61 abbot
62 abbots
63 Abbott
64 abbreviate
65 abbreviated
66 abbreviates
67 abbreviating
68 abbreviation
69 abbreviations
70 Abby
71 abdomen
72 abdomens
73 abdominal
74 abduct
75 abducted
76 abduction
77 abductions
78 abductor
79 abductors
80 abducts
81 Abe
82 abed
83 Abel
84 Abelian
85 Abelson
86 Aberdeen
87 Abernathy
88 aberrant
89 aberration
90 flush logs;
91 drop table t2;
92 create table t2 (word varchar(20));
93 load data infile '../../std_data/words.dat' into table t2;
94 insert into t2 select * from 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 select count(*) from t2;
104 count(*)
105 35840
106 flush logs;
107 select count(*) from t2;
108 count(*)
109 35840
110 drop table t1;
111 drop table t2;
112 RESET MASTER;
113 USE test;
114 SET @old_binlog_format= @@binlog_format;
115 SET SESSION binlog_format=ROW;
116 CREATE TABLE t1(c1 INT);
117 INSERT INTO t1 VALUES (1);
118 FLUSH LOGS;
119 DROP TABLE t1;
120 SET SESSION binlog_format= @old_binlog_format;
121 RESET MASTER;