mysqlbinlog.result 6.32 KB
Newer Older
unknown's avatar
unknown committed
1
set timestamp=1000000000;
2
drop table if exists t1,t2;
unknown's avatar
unknown 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;
unknown's avatar
unknown 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;
unknown's avatar
unknown committed
19
use test;
unknown's avatar
unknown committed
20
SET TIMESTAMP=1000000000;
unknown's avatar
unknown 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
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8;
24 25
drop table if exists t1,t2;
SET TIMESTAMP=1000000000;
unknown's avatar
unknown committed
26 27 28 29 30 31 32 33
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 ();
unknown's avatar
unknown committed
34
SET TIMESTAMP=1000000000;
35
load data LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-1-0' INTO table t1;
unknown's avatar
unknown committed
36
SET TIMESTAMP=1000000000;
37
load data LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-2-0' INTO table t1;
unknown's avatar
unknown committed
38
SET TIMESTAMP=1000000000;
39
load data LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-3-0' INTO table t1;
unknown's avatar
unknown committed
40
SET TIMESTAMP=1000000000;
41
load data LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-4-0' INTO table t1;
42
# End of log file
43
ROLLBACK /* added by mysqlbinlog */;
44
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
unknown's avatar
unknown committed
45 46

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

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

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

--- Remote --
82
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
83
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
84
ROLLBACK;
unknown's avatar
unknown committed
85 86
use test;
SET TIMESTAMP=1000000000;
unknown's avatar
unknown committed
87 88
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1;
SET @@session.sql_mode=0;
89
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8;
unknown's avatar
unknown committed
90 91
drop table if exists t1,t2;
SET TIMESTAMP=1000000000;
unknown's avatar
unknown committed
92 93 94 95 96 97 98 99
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 ();
unknown's avatar
unknown committed
100
SET TIMESTAMP=1000000000;
101
load data LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-1-2' INTO table t1;
unknown's avatar
unknown committed
102
SET TIMESTAMP=1000000000;
103
load data LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-2-2' INTO table t1;
unknown's avatar
unknown committed
104
SET TIMESTAMP=1000000000;
105
load data LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-3-2' INTO table t1;
unknown's avatar
unknown committed
106
SET TIMESTAMP=1000000000;
107
load data LOCAL INFILE 'MYSQLTEST_VARDIR/tmp/SQL_LOAD_MB-4-2' INTO table t1;
108
# End of log file
109
ROLLBACK /* added by mysqlbinlog */;
110
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
unknown's avatar
unknown committed
111 112

--- Broken LOAD DATA --
113
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
114
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
unknown's avatar
unknown committed
115 116
use test;
SET TIMESTAMP=1000000000;
unknown's avatar
unknown committed
117 118
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1;
SET @@session.sql_mode=0;
119
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8;
unknown's avatar
unknown committed
120
insert into t1 values ("Alas");
121
# End of log file
122
ROLLBACK /* added by mysqlbinlog */;
123
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
unknown's avatar
unknown committed
124 125

--- --database --
126
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
127
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
128
ROLLBACK;
unknown's avatar
unknown committed
129
SET INSERT_ID=1;
130
# End of log file
131
ROLLBACK /* added by mysqlbinlog */;
132
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
unknown's avatar
unknown committed
133 134

--- --position --
135
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
136
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
unknown's avatar
unknown committed
137 138
use test;
SET TIMESTAMP=1000000000;
unknown's avatar
unknown committed
139 140
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1;
SET @@session.sql_mode=0;
141
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8;
unknown's avatar
unknown committed
142
insert into t1 values ("Alas");
143
# End of log file
144
ROLLBACK /* added by mysqlbinlog */;
145
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
146 147 148

--- reading stdin --
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
149
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
150
ROLLBACK;
151
use test;
unknown's avatar
unknown committed
152
SET TIMESTAMP=1108844556;
153
BEGIN;
unknown's avatar
unknown committed
154 155
SET TIMESTAMP=1108844555;
insert t1 values (1);
156
# End of log file
157
ROLLBACK /* added by mysqlbinlog */;
158
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
159
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
160
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
161
use test;
unknown's avatar
unknown committed
162
SET TIMESTAMP=1108844556;
163
BEGIN;
unknown's avatar
unknown committed
164 165
SET TIMESTAMP=1108844555;
insert t1 values (1);
166
# End of log file
167
ROLLBACK /* added by mysqlbinlog */;
168
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
unknown's avatar
unknown committed
169
drop table t1, t2;