Debian Codegraph @

mysql-test/suite/funcs_1/storedproc/load_sp_tb.inc

raw
1 --echo
2 --echo --source suite/funcs_1/storedproc/load_sp_tb.inc
3 --echo --------------------------------------------------------------------------------
4
5 # ==============================================================================
6 #
7 # This load script can be called multiple times inside a test script because it
8 # first cleans up all objects that will be created.
9 # Therefore the same script is used as it will be used at the end of a test.
10 #
11 # ==============================================================================
12
13 --disable_abort_on_error
14 --enable_query_log
15 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
16 # use the same .inc to cleanup before and after the test
17 --source suite/funcs_1/storedproc/cleanup_sp_tb.inc
18
19 CREATE DATABASE db_storedproc charset utf8mb4;
20 CREATE DATABASE db_storedproc_1 charset utf8mb4;
21
22 USE db_storedproc;
23
24 --replace_result $engine_type <engine_to_be_tested>
25 eval
26 create table t1(f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
27 engine = $engine_type;
28 --replace_result $MYSQLTEST_VARDIR <MYSQLTEST_VARDIR>
29 eval
30 load data infile '$MYSQLTEST_VARDIR/std_data/funcs_1/t4.txt' into table t1;
31
32 --replace_result $engine_type <engine_to_be_tested>
33 eval
34 create table t2(f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
35 engine = $engine_type;
36 --replace_result $MYSQLTEST_VARDIR <MYSQLTEST_VARDIR>
37 eval
38 load data infile '$MYSQLTEST_VARDIR/std_data/funcs_1/t4.txt' into table t2;
39
40 --replace_result $engine_type <engine_to_be_tested>
41 eval
42 create table t3(f1 char(20),f2 char(20),f3 integer) engine = $engine_type;
43 --replace_result $MYSQLTEST_VARDIR <MYSQLTEST_VARDIR>
44 eval
45 load data infile '$MYSQLTEST_VARDIR/std_data/funcs_1/t3.txt' into table t3;
46
47 --replace_result $engine_type <engine_to_be_tested>
48 eval
49 create table t4(f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
50 engine = $engine_type;
51 --replace_result $MYSQLTEST_VARDIR <MYSQLTEST_VARDIR>
52 eval
53 load data infile '$MYSQLTEST_VARDIR/std_data/funcs_1/t4.txt' into table t4;
54
55 USE db_storedproc_1;
56
57 --replace_result $engine_type <engine_to_be_tested>
58 eval
59 create table t6(f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
60 engine = $engine_type;
61 --replace_result $MYSQLTEST_VARDIR <MYSQLTEST_VARDIR>
62 eval
63 load data infile '$MYSQLTEST_VARDIR/std_data/funcs_1/t4.txt' into table t6;
64
65 USE db_storedproc;
66
67 --replace_result $engine_type <engine_to_be_tested>
68 eval
69 create table t7 (f1 char(20), f2 char(25), f3 date, f4 int)
70 engine = $engine_type;
71 --replace_result $MYSQLTEST_VARDIR <MYSQLTEST_VARDIR>
72 eval
73 load data infile '$MYSQLTEST_VARDIR/std_data/funcs_1/t7.txt' into table t7;
74
75 --replace_result $engine_type <engine_to_be_tested>
76 eval
77 create table t8 (f1 char(20), f2 char(25), f3 date, f4 int)
78 engine = $engine_type;
79 --replace_result $MYSQLTEST_VARDIR <MYSQLTEST_VARDIR>
80 eval
81 load data infile '$MYSQLTEST_VARDIR/std_data/funcs_1/t7.txt' into table t8;
82
83 --replace_result $engine_type <engine_to_be_tested>
84 eval
85 create table t9(f1 int, f2 char(25), f3 int) engine = $engine_type;
86 --replace_result $MYSQLTEST_VARDIR <MYSQLTEST_VARDIR>
87 eval
88 load data infile '$MYSQLTEST_VARDIR/std_data/funcs_1/t9.txt' into table t9;
89
90 --replace_result $engine_type <engine_to_be_tested>
91 eval
92 create table t10(f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
93 engine = $engine_type;
94 --replace_result $MYSQLTEST_VARDIR <MYSQLTEST_VARDIR>
95 eval
96 load data infile '$MYSQLTEST_VARDIR/std_data/funcs_1/t4.txt' into table t10;
97
98 --replace_result $engine_type <engine_to_be_tested>
99 eval
100 create table t11(f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
101 engine = $engine_type;
102 --replace_result $MYSQLTEST_VARDIR <MYSQLTEST_VARDIR>
103 eval
104 load data infile '$MYSQLTEST_VARDIR/std_data/funcs_1/t4.txt' into table t11;
105 SET sql_mode = default;