Debian Codegraph @

mysql-test/suite/innodb/t/bulk_load.test

raw
1 --source include/have_innodb.inc
2 --source include/have_sequence.inc
3 --source include/big_test.inc
4 --source include/not_embedded.inc
5
6 CREATE TABLE t1(f1 INT NOT NULL,f2 INT NOT NULL)ENGINE=InnoDB;
7 INSERT INTO t1 SELECT seq, seq from seq_1_to_131072;
8 INSERT INTO t1 VALUES(131073, 131073), (131074, 131073);
9 --replace_result $MYSQLTEST_VARDIR VARDIR
10 --disable_cursor_protocol
11 --disable_ps2_protocol
12 eval SELECT * INTO OUTFILE "$MYSQLTEST_VARDIR/tmp/t1.outfile" FROM t1;
13 --replace_result $MYSQLTEST_VARDIR VARDIR
14 eval SELECT * INTO OUTFILE "$MYSQLTEST_VARDIR/tmp/t.outfile" FROM t1 LIMIT 1;
15 --enable_ps2_protocol
16 --enable_cursor_protocol
17
18 --echo # successful load statement using bulk insert
19 CREATE TABLE t2(f1 INT NOT NULL PRIMARY KEY,
20 f2 INT NOT NULL)ENGINE=InnoDB;
21 SET unique_checks=0, foreign_key_checks=0;
22 --replace_result $MYSQLTEST_VARDIR VARDIR
23 eval LOAD DATA INFILE '$MYSQLTEST_VARDIR/tmp/t1.outfile' INTO TABLE t2;
24 SELECT COUNT(*) FROM t2;
25 CHECK TABLE t2 EXTENDED;
26 DROP TABLE t2;
27
28 CREATE TABLE t2(f1 INT NOT NULL, PRIMARY KEY(f1 DESC),
29 f2 INT NOT NULL)ENGINE=InnoDB;
30 --replace_result $MYSQLTEST_VARDIR VARDIR
31 eval LOAD DATA INFILE '$MYSQLTEST_VARDIR/tmp/t1.outfile' INTO TABLE t2;
32 SELECT COUNT(*) FROM t2;
33 CHECK TABLE t2 EXTENDED;
34 DROP TABLE t2;
35
36 --echo # load statement using bulk insert fails during secondary index
37 CREATE TABLE t2(f1 INT NOT NULL PRIMARY KEY,
38 f2 INT NOT NULL UNIQUE KEY)ENGINE=InnoDB;
39 --replace_result $MYSQLTEST_VARDIR VARDIR
40 --error ER_ERROR_DURING_COMMIT
41 eval LOAD DATA INFILE '$MYSQLTEST_VARDIR/tmp/t1.outfile' INTO TABLE t2;
42 SELECT COUNT(*) FROM t2;
43 CHECK TABLE t2 EXTENDED;
44 DROP TABLE t2;
45
46 --echo # load statement using bulk insert fails during primary index
47 CREATE TABLE t2(f1 INT NOT NULL,
48 f2 INT NOT NULL PRIMARY KEY)ENGINE=InnoDB;
49 --replace_result $MYSQLTEST_VARDIR VARDIR
50 --error ER_DUP_ENTRY
51 eval LOAD DATA INFILE '$MYSQLTEST_VARDIR/tmp/t1.outfile' INTO TABLE t2;
52 SELECT COUNT(*) FROM t2;
53 CHECK TABLE t2 EXTENDED;
54 --remove_file $MYSQLTEST_VARDIR/tmp/t1.outfile
55 DROP TABLE t2, t1;
56
57 --echo #
58 --echo # MDEV-37192 Crash recovery reports corruption after bulk load
59 --echo #
60 CREATE TABLE t2(f1 INT AUTO_INCREMENT, f2 INT NOT NULL,
61 PRIMARY KEY(f1))ENGINE=InnoDB;
62 BEGIN;
63 --replace_result $MYSQLTEST_VARDIR VARDIR
64 eval LOAD DATA INFILE '$MYSQLTEST_VARDIR/tmp/t.outfile' INTO TABLE t2;
65 --let $shutdown_timeout=0
66 --source include/restart_mysqld.inc
67 --remove_file $MYSQLTEST_VARDIR/tmp/t.outfile
68 DROP TABLE t2;