mysqlbinlog.result 5.47 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 7 8 9 10 11 12 13 14 15 16
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 ();
load data infile '../../std_data/words.dat' into table t1;
load data infile '../../std_data/words.dat' into table t1;
load data infile '../../std_data/words.dat' into table t1;
load data infile '../../std_data/words.dat' into table t1;
load data infile '../../std_data/words.dat' into table t1;
load data infile '../../std_data/words.dat' into table t1;
insert into t1 values ("Alas");
flush logs;

--- Local --
17
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
unknown's avatar
unknown committed
18
use test;
unknown's avatar
unknown committed
19
SET TIMESTAMP=1000000000;
unknown's avatar
unknown committed
20 21
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1;
SET @@session.sql_mode=0;
22
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8;
23 24
drop table if exists t1,t2;
SET TIMESTAMP=1000000000;
unknown's avatar
unknown committed
25 26 27 28 29 30 31 32
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 ();
33 34 35 36 37
LOAD DATA LOCAL INFILE 'MYSQL_TEST_DIR/var/tmp/words.dat-1-0' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' STARTING BY '' (word);
LOAD DATA LOCAL INFILE 'MYSQL_TEST_DIR/var/tmp/words.dat-2-0' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' STARTING BY '' (word);
LOAD DATA LOCAL INFILE 'MYSQL_TEST_DIR/var/tmp/words.dat-3-0' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' STARTING BY '' (word);
LOAD DATA LOCAL INFILE 'MYSQL_TEST_DIR/var/tmp/words.dat-4-0' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' STARTING BY '' (word);
LOAD DATA LOCAL INFILE 'MYSQL_TEST_DIR/var/tmp/words.dat-5-0' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' STARTING BY '' (word);
unknown's avatar
unknown committed
38 39

--- Broken LOAD DATA --
40
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
unknown's avatar
unknown committed
41 42
use test;
SET TIMESTAMP=1000000000;
unknown's avatar
unknown committed
43 44
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1;
SET @@session.sql_mode=0;
45
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8;
unknown's avatar
unknown committed
46 47 48
insert into t1 values ("Alas");

--- --database --
49
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
unknown's avatar
unknown committed
50 51 52
SET INSERT_ID=1;

--- --position --
53
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
unknown's avatar
unknown committed
54 55
use test;
SET TIMESTAMP=1000000000;
unknown's avatar
unknown committed
56 57
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1;
SET @@session.sql_mode=0;
58
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8;
unknown's avatar
unknown committed
59 60 61
insert into t1 values ("Alas");

--- Remote --
62
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
unknown's avatar
unknown committed
63 64
use test;
SET TIMESTAMP=1000000000;
unknown's avatar
unknown committed
65 66
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1;
SET @@session.sql_mode=0;
67
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8;
unknown's avatar
unknown committed
68 69
drop table if exists t1,t2;
SET TIMESTAMP=1000000000;
unknown's avatar
unknown committed
70 71 72 73 74 75 76 77
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 ();
78 79 80 81 82
LOAD DATA LOCAL INFILE 'MYSQL_TEST_DIR/var/tmp/words.dat-1-1' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' STARTING BY '' (word);
LOAD DATA LOCAL INFILE 'MYSQL_TEST_DIR/var/tmp/words.dat-2-1' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' STARTING BY '' (word);
LOAD DATA LOCAL INFILE 'MYSQL_TEST_DIR/var/tmp/words.dat-3-1' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' STARTING BY '' (word);
LOAD DATA LOCAL INFILE 'MYSQL_TEST_DIR/var/tmp/words.dat-4-1' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' STARTING BY '' (word);
LOAD DATA LOCAL INFILE 'MYSQL_TEST_DIR/var/tmp/words.dat-5-1' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' STARTING BY '' (word);
unknown's avatar
unknown committed
83 84

--- Broken LOAD DATA --
85
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
unknown's avatar
unknown committed
86 87
use test;
SET TIMESTAMP=1000000000;
unknown's avatar
unknown committed
88 89
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1;
SET @@session.sql_mode=0;
90
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8;
unknown's avatar
unknown committed
91 92 93
insert into t1 values ("Alas");

--- --database --
94
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
unknown's avatar
unknown committed
95 96 97
SET INSERT_ID=1;

--- --position --
98
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
unknown's avatar
unknown committed
99 100
use test;
SET TIMESTAMP=1000000000;
unknown's avatar
unknown committed
101 102
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1;
SET @@session.sql_mode=0;
103
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8;
unknown's avatar
unknown committed
104
insert into t1 values ("Alas");
105 106 107 108 109 110

--- reading stdin --
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
use test;
SET TIMESTAMP=1065204671;
BEGIN;
unknown's avatar
unknown committed
111
ROLLBACK;
112 113 114 115
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
use test;
SET TIMESTAMP=1065204671;
BEGIN;
unknown's avatar
unknown committed
116
ROLLBACK;
unknown's avatar
unknown committed
117
drop table t1, t2;