Debian Codegraph @

mysql-test/suite/storage_engine/loaddata.test

raw
1 #
2 # Basic LOAD DATA statements
3 #
4
5 --source have_engine.inc
6
7 --disable_warnings
8 DROP TABLE IF EXISTS t1;
9 --enable_warnings
10
11 --source create_table.inc
12
13 let $datadir = `SELECT @@datadir`;
14
15 --write_file $datadir/se_loaddata.dat
16 1,foo,
17 2,bar,
18 3,,
19 4,abc,
20 EOF
21
22 --replace_result $datadir <DATADIR>
23 eval
24 LOAD DATA INFILE '$datadir/se_loaddata.dat' INTO TABLE t1
25 FIELDS TERMINATED BY ',' (a,b);
26 if ($mysql_errname)
27 {
28 --source unexpected_result.inc
29 --remove_file $datadir/se_loaddata.dat
30 }
31 if (!$mysql_errname)
32 {
33 --sorted_result
34 SELECT a,b FROM t1;
35
36 --replace_result $datadir <DATADIR>
37 eval
38 LOAD DATA LOCAL INFILE '$datadir/se_loaddata.dat' INTO TABLE t1
39 CHARACTER SET utf8 COLUMNS TERMINATED BY ','
40 ESCAPED BY '/' (a,b);
41 --sorted_result
42 SELECT a,b FROM t1;
43
44 --remove_file $datadir/se_loaddata.dat
45 --write_file $datadir/se_loaddata.dat
46 5;YYY;
47 102;'zzz';
48 0;'test';
49 EOF
50
51 --replace_result $datadir <DATADIR>
52 eval
53 LOAD DATA LOCAL INFILE '$datadir/se_loaddata.dat' INTO TABLE t1
54 FIELDS TERMINATED BY ';'
55 (a) SET b='loaded';
56
57 --sorted_result
58 SELECT a,b FROM t1;
59
60 --remove_file $datadir/se_loaddata.dat
61 --write_file $datadir/se_loaddata.dat
62 prefix:5;'foo';
63 prefix:6;'';
64 prefix:100;foo;
65 prefix:7;'test';suffix
66 101;abc;
67 102;'z';
68 prefix:0;;
69 EOF
70
71 --replace_result $datadir <DATADIR>
72 eval
73 LOAD DATA INFILE '$datadir/se_loaddata.dat' INTO TABLE t1
74 FIELDS TERMINATED BY ';'
75 OPTIONALLY ENCLOSED BY ''''
76 LINES STARTING BY 'prefix:'
77 IGNORE 2 LINES (a,b);
78
79 --sorted_result
80 SELECT a,b FROM t1;
81
82 --remove_file $datadir/se_loaddata.dat
83 --write_file $datadir/se_loaddata.dat
84 1 foo
85 2 bar
86 3
87 4 abc
88 EOF
89
90 --replace_result $datadir <DATADIR>
91 eval
92 LOAD DATA INFILE '$datadir/se_loaddata.dat' INTO TABLE t1;
93 --sorted_result
94 SELECT a,b FROM t1;
95
96 --remove_file $datadir/se_loaddata.dat
97
98 }
99
100 # Cleanup
101 DROP TABLE t1;
102
103 --source cleanup_engine.inc
104