Debian Codegraph @

mysql-test/suite/sys_vars/t/local_infile_func.test

raw
1 ############## mysql-test\t\local_infile_func.test ############################
2 # #
3 # Variable Name: local_infile #
4 # Scope: GLOBAL #
5 # Access Type: Dynamic #
6 # Data Type: Boolean #
7 # Default Value: 1 #
8 # Valid Values: #
9 # #
10 # #
11 # Creation Date: 2008-03-08 #
12 # Author: Rizwan Maredia #
13 # #
14 # Description: Test Cases of Dynamic System Variable "local_infile" #
15 # that checks behavior of this variable #
16 # #
17 # Reference: http://dev.mysql.com/doc/refman/5.1/en/ #
18 # server-system-variables.html#option_mysqld_local_infile #
19 # #
20 ################################################################################
21
22
23 --echo '#--------------------FN_DYNVARS_037_01-------------------------#'
24 ####################################################################
25 # Check if setting local_infile is changed in every new connection #
26 ####################################################################
27
28 SET @@global.local_infile = 0;
29
30 # con1 will be default connection from now on
31 --echo 'connect (con1,localhost,root,,,,)'
32 connect (con1,localhost,root,,,,);
33 --echo 'connection con1'
34 connection con1;
35 SELECT @@global.local_infile;
36 SET @@global.local_infile = 1;
37
38 --echo 'connect (con2,localhost,root,,,,)'
39 connect (con2,localhost,root,,,,);
40 --echo 'connection con2'
41 connection con2;
42 SELECT @@global.local_infile;
43 disconnect con2;
44
45
46 --echo '#--------------------FN_DYNVARS_037_02-------------------------#'
47 ######################################################
48 # Begin the functionality Testing of local_infile #
49 ######################################################
50
51 --echo 'connection con1'
52 connection con1;
53
54 #=============================================================
55 --echo '-----Checking LOAD DATA when local_infile is 1-------'
56 #=============================================================
57 SET @@global.local_infile = 1;
58 --disable_warnings
59 DROP TABLE IF EXISTS t1;
60 --enable_warnings
61
62 create table t1(a int);
63
64 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
65 eval LOAD DATA LOCAL INFILE
66 '$MYSQLTEST_VARDIR/std_data/numbers.txt' INTO TABLE test.t1;
67
68 SELECT count(*) from t1;
69
70 #=============================================================
71 --echo '-----Checking LOAD DATA when local_infile is 0-------'
72 #=============================================================
73 SET @@global.local_infile = 0;
74
75 --disable_warnings
76 DROP TABLE IF EXISTS t1;
77 --enable_warnings
78 create table t1(a int);
79
80 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
81 --Error ER_CLIENT_LOCAL_FILES_DISABLED
82 eval LOAD DATA LOCAL INFILE
83 '$MYSQLTEST_VARDIR/std_data/numbers.txt' INTO TABLE test.t1;
84
85 SELECT count(*) from t1;
86
87 # clean up and restore
88 DROP TABLE t1;
89 SET @@global.local_infile = 0;
90 ######################################################
91 # Endo of functionality Testing for local_infile #
92 ######################################################
93