mysqlbinlog.result 6.74 KB
Newer Older
dlenev@mysql.com's avatar
dlenev@mysql.com committed
1
set timestamp=1000000000;
2
drop table if exists t1,t2;
dlenev@mysql.com's avatar
dlenev@mysql.com committed
3 4 5 6
create table t1 (word varchar(20));
create table t2 (id int auto_increment not null primary key);
insert into t1 values ("abirvalg");
insert into t2 values ();
7 8 9 10 11
load data infile '../std_data_ln/words.dat' into table t1;
load data infile '../std_data_ln/words.dat' into table t1;
load data infile '../std_data_ln/words.dat' into table t1;
load data infile '../std_data_ln/words.dat' into table t1;
load data infile '../std_data_ln/words.dat' into table t1;
dlenev@mysql.com's avatar
dlenev@mysql.com committed
12 13 14 15
insert into t1 values ("Alas");
flush logs;

--- Local --
16
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
17
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
18
ROLLBACK;
dlenev@mysql.com's avatar
dlenev@mysql.com committed
19
use test;
monty@mysql.com's avatar
monty@mysql.com committed
20
SET TIMESTAMP=1000000000;
guilhem@gbichot2's avatar
guilhem@gbichot2 committed
21 22
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1;
SET @@session.sql_mode=0;
23
/*!\C latin1 */;
24
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8;
25 26
drop table if exists t1,t2;
SET TIMESTAMP=1000000000;
dlenev@mysql.com's avatar
dlenev@mysql.com committed
27 28 29 30 31 32 33 34
create table t1 (word varchar(20));
SET TIMESTAMP=1000000000;
create table t2 (id int auto_increment not null primary key);
SET TIMESTAMP=1000000000;
insert into t1 values ("abirvalg");
SET INSERT_ID=1;
SET TIMESTAMP=1000000000;
insert into t2 values ();
35
SET TIMESTAMP=1000000000;
36
load data LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-1-0' INTO table t1;
37
SET TIMESTAMP=1000000000;
38
load data LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-2-0' INTO table t1;
39
SET TIMESTAMP=1000000000;
40
load data LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-3-0' INTO table t1;
41
SET TIMESTAMP=1000000000;
42
load data LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-4-0' INTO table t1;
43
# End of log file
44
ROLLBACK /* added by mysqlbinlog */;
45
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
dlenev@mysql.com's avatar
dlenev@mysql.com committed
46 47

--- Broken LOAD DATA --
48
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
49
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
dlenev@mysql.com's avatar
dlenev@mysql.com committed
50 51
use test;
SET TIMESTAMP=1000000000;
guilhem@gbichot2's avatar
guilhem@gbichot2 committed
52 53
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1;
SET @@session.sql_mode=0;
54
/*!\C latin1 */;
55
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8;
dlenev@mysql.com's avatar
dlenev@mysql.com committed
56
insert into t1 values ("Alas");
57
# End of log file
58
ROLLBACK /* added by mysqlbinlog */;
59
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
dlenev@mysql.com's avatar
dlenev@mysql.com committed
60 61

--- --database --
62
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
63
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
64
ROLLBACK;
dlenev@mysql.com's avatar
dlenev@mysql.com committed
65
SET INSERT_ID=1;
66
# End of log file
67
ROLLBACK /* added by mysqlbinlog */;
68
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
dlenev@mysql.com's avatar
dlenev@mysql.com committed
69 70

--- --position --
71
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
72
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
dlenev@mysql.com's avatar
dlenev@mysql.com committed
73 74
use test;
SET TIMESTAMP=1000000000;
guilhem@gbichot2's avatar
guilhem@gbichot2 committed
75 76
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1;
SET @@session.sql_mode=0;
77
/*!\C latin1 */;
78
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8;
dlenev@mysql.com's avatar
dlenev@mysql.com committed
79
insert into t1 values ("Alas");
80
# End of log file
81
ROLLBACK /* added by mysqlbinlog */;
82
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
dlenev@mysql.com's avatar
dlenev@mysql.com committed
83 84

--- Remote --
85
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
86
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
87
ROLLBACK;
dlenev@mysql.com's avatar
dlenev@mysql.com committed
88 89
use test;
SET TIMESTAMP=1000000000;
guilhem@gbichot2's avatar
guilhem@gbichot2 committed
90 91
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1;
SET @@session.sql_mode=0;
92
/*!\C latin1 */;
93
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8;
monty@mysql.com's avatar
monty@mysql.com committed
94 95
drop table if exists t1,t2;
SET TIMESTAMP=1000000000;
dlenev@mysql.com's avatar
dlenev@mysql.com committed
96 97 98 99 100 101 102 103
create table t1 (word varchar(20));
SET TIMESTAMP=1000000000;
create table t2 (id int auto_increment not null primary key);
SET TIMESTAMP=1000000000;
insert into t1 values ("abirvalg");
SET INSERT_ID=1;
SET TIMESTAMP=1000000000;
insert into t2 values ();
104
SET TIMESTAMP=1000000000;
105
load data LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-1-2' INTO table t1;
106
SET TIMESTAMP=1000000000;
107
load data LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-2-2' INTO table t1;
108
SET TIMESTAMP=1000000000;
109
load data LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-3-2' INTO table t1;
110
SET TIMESTAMP=1000000000;
111
load data LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-4-2' INTO table t1;
112
# End of log file
113
ROLLBACK /* added by mysqlbinlog */;
114
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
dlenev@mysql.com's avatar
dlenev@mysql.com committed
115 116

--- Broken LOAD DATA --
117
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
118
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
dlenev@mysql.com's avatar
dlenev@mysql.com committed
119 120
use test;
SET TIMESTAMP=1000000000;
guilhem@gbichot2's avatar
guilhem@gbichot2 committed
121 122
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1;
SET @@session.sql_mode=0;
123
/*!\C latin1 */;
124
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8;
dlenev@mysql.com's avatar
dlenev@mysql.com committed
125
insert into t1 values ("Alas");
126
# End of log file
127
ROLLBACK /* added by mysqlbinlog */;
128
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
dlenev@mysql.com's avatar
dlenev@mysql.com committed
129 130

--- --database --
131
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
132
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
133
ROLLBACK;
dlenev@mysql.com's avatar
dlenev@mysql.com committed
134
SET INSERT_ID=1;
135
# End of log file
136
ROLLBACK /* added by mysqlbinlog */;
137
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
dlenev@mysql.com's avatar
dlenev@mysql.com committed
138 139

--- --position --
140
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
141
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
dlenev@mysql.com's avatar
dlenev@mysql.com committed
142 143
use test;
SET TIMESTAMP=1000000000;
guilhem@gbichot2's avatar
guilhem@gbichot2 committed
144 145
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1;
SET @@session.sql_mode=0;
146
/*!\C latin1 */;
147
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8;
dlenev@mysql.com's avatar
dlenev@mysql.com committed
148
insert into t1 values ("Alas");
149
# End of log file
150
ROLLBACK /* added by mysqlbinlog */;
151
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
152 153 154

--- reading stdin --
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
155
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
156
ROLLBACK;
157
use test;
serg@serg.mylan's avatar
serg@serg.mylan committed
158
SET TIMESTAMP=1108844556;
159
BEGIN;
serg@serg.mylan's avatar
serg@serg.mylan committed
160 161
SET TIMESTAMP=1108844555;
insert t1 values (1);
162
# End of log file
163
ROLLBACK /* added by mysqlbinlog */;
164
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
165
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
166
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
167
use test;
serg@serg.mylan's avatar
serg@serg.mylan committed
168
SET TIMESTAMP=1108844556;
169
BEGIN;
serg@serg.mylan's avatar
serg@serg.mylan committed
170 171
SET TIMESTAMP=1108844555;
insert t1 values (1);
172
# End of log file
173
ROLLBACK /* added by mysqlbinlog */;
174
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191
flush logs;
create table t3 (f text character set utf8);
create table t4 (f text character set cp932);
flush logs;
rename table t3 to t03, t4 to t04;
select HEX(f) from t03;
HEX(f)
E382BD
select HEX(f) from t3;
HEX(f)
E382BD
select HEX(f) from t04;
HEX(f)
835C
select HEX(f) from t4;
HEX(f)
835C
192
flush logs;
193
drop table t1, t2, t03, t04, t3, t4;