1
--disable_abort_on_error
6
DROP TABLE IF EXISTS t1, t2, t4, t10, t11;
8
eval CREATE TABLE t1 (f1 char(20), f2 char(25), f3 date, f4 int, f5 char(25), f6 int) ENGINE = $engine_type;
9
eval CREATE TABLE t2 (f1 char(20), f2 char(25), f3 date, f4 int, f5 char(25), f6 int) ENGINE = $engine_type;
10
eval CREATE TABLE t4 (f1 char(20), f2 char(25), f3 date, f4 int, f5 char(25), f6 int) ENGINE = $engine_type;
11
eval CREATE TABLE t10 (f1 char(20), f2 char(25), f3 date, f4 int, f5 char(25), f6 int) ENGINE = $engine_type;
12
eval CREATE TABLE t11 (f1 char(20), f2 char(25), f3 date, f4 int, f5 char(25), f6 int) ENGINE = $engine_type;
13
--replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
14
eval LOAD DATA INFILE '$MYSQL_TEST_DIR/suite/funcs_1/data/t4.txt' INTO TABLE t1;
15
--replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
16
eval LOAD DATA INFILE '$MYSQL_TEST_DIR/suite/funcs_1/data/t4.txt' INTO TABLE t2;
17
--replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
18
eval LOAD DATA INFILE '$MYSQL_TEST_DIR/suite/funcs_1/data/t4.txt' INTO TABLE t4;
19
--replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
20
eval LOAD DATA INFILE '$MYSQL_TEST_DIR/suite/funcs_1/data/t4.txt' INTO TABLE t10;
21
--replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
22
eval LOAD DATA INFILE '$MYSQL_TEST_DIR/suite/funcs_1/data/t4.txt' INTO TABLE t11;
26
drop TABLE if exists t3;
28
eval CREATE TABLE t3 (f1 char(20), f2 char(20), f3 integer) ENGINE = $engine_type;
29
--replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
30
eval LOAD DATA INFILE '$MYSQL_TEST_DIR/suite/funcs_1/data/t3.txt' INTO TABLE t3;
32
#---------------------------
35
drop database if exists test4;
37
CREATE database test4;
40
eval CREATE TABLE t6 (f1 char(20), f2 char(25), f3 date, f4 int, f5 char(25), f6 int) ENGINE = $engine_type;
41
--replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
42
eval LOAD DATA INFILE '$MYSQL_TEST_DIR/suite/funcs_1/data/t4.txt' INTO TABLE t6;
43
#---------------------------
48
drop TABLE if exists t7, t8;
50
eval CREATE TABLE t7 (f1 char(20), f2 char(25), f3 date, f4 int) ENGINE = $engine_type;
51
eval CREATE TABLE t8 (f1 char(20), f2 char(25), f3 date, f4 int) ENGINE = $engine_type;
52
--replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
53
eval LOAD DATA INFILE '$MYSQL_TEST_DIR/suite/funcs_1/data/t7.txt' INTO TABLE t7;
54
--replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
55
eval LOAD DATA INFILE '$MYSQL_TEST_DIR/suite/funcs_1/data/t7.txt' INTO TABLE t8;
59
drop TABLE if exists t9;
61
eval CREATE TABLE t9 (f1 int, f2 char(25), f3 int) ENGINE = $engine_type;
62
--replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR
63
eval LOAD DATA INFILE '$MYSQL_TEST_DIR/suite/funcs_1/data/t9.txt' INTO TABLE t9;