MySQL 5.6.14 Source Code Document
 All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Friends Macros Groups Pages
load_sp_tb.inc
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 
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;
20 CREATE DATABASE db_storedproc_1;
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;