← Back to branch summary

~ubuntu-branches/ubuntu/trusty/mysql-5.6/trusty

« back to all changes in this revision

Viewing changes to mysql-test/suite/sys_vars/t/local_infile_func.test

  • Committer: Package Import Robot
  • Author(s): James Page
  • Date: 2014-02-12 11:54:27 UTC
  • Revision ID: package-import@ubuntu.com-20140212115427-oq6tfsqxl1wuwehi
Tags: upstream-5.6.15
Import upstream version 5.6.15

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/sys_vars/t/local_infile_func.test
 
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
--source include/not_embedded.inc
 
23
 
 
24
--echo '#--------------------FN_DYNVARS_037_01-------------------------#'
 
25
####################################################################
 
26
# Check if setting local_infile is changed in every new connection #
 
27
####################################################################
 
28
 
 
29
SET @@global.local_infile = 0;
 
30
 
 
31
# con1 will be default connection from now on
 
32
--echo 'connect (con1,localhost,root,,,,)'
 
33
connect (con1,localhost,root,,,,);
 
34
--echo 'connection con1'
 
35
connection con1;
 
36
SELECT @@global.local_infile;
 
37
SET @@global.local_infile = 1;
 
38
 
 
39
--echo 'connect (con2,localhost,root,,,,)'
 
40
connect (con2,localhost,root,,,,);
 
41
--echo 'connection con2'
 
42
connection con2;
 
43
SELECT @@global.local_infile;
 
44
disconnect con2;
 
45
 
 
46
 
 
47
--echo '#--------------------FN_DYNVARS_037_02-------------------------#'
 
48
######################################################
 
49
# Begin the functionality Testing of local_infile    #
 
50
######################################################
 
51
 
 
52
--echo 'connection con1'
 
53
connection con1;
 
54
 
 
55
#=============================================================
 
56
--echo '-----Checking LOAD DATA when local_infile is 1-------'
 
57
#=============================================================
 
58
SET @@global.local_infile = 1;
 
59
--disable_warnings
 
60
DROP TABLE IF EXISTS t1;
 
61
--enable_warnings
 
62
 
 
63
create table t1(a int);
 
64
 
 
65
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
 
66
eval LOAD DATA LOCAL INFILE
 
67
'$MYSQLTEST_VARDIR/std_data/numbers.txt' INTO TABLE test.t1;
 
68
 
 
69
SELECT count(*) from t1;
 
70
 
 
71
#=============================================================
 
72
--echo '-----Checking LOAD DATA when local_infile is 0-------'
 
73
#=============================================================
 
74
SET @@global.local_infile = 0;
 
75
 
 
76
--disable_warnings
 
77
DROP TABLE IF EXISTS t1;
 
78
--enable_warnings
 
79
create table t1(a int);
 
80
 
 
81
--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
 
82
--Error ER_NOT_ALLOWED_COMMAND
 
83
eval LOAD DATA LOCAL INFILE
 
84
'$MYSQLTEST_VARDIR/std_data/numbers.txt' INTO TABLE test.t1;
 
85
 
 
86
SELECT count(*) from t1;
 
87
 
 
88
# clean up and restore
 
89
DROP TABLE t1;
 
90
SET @@global.local_infile = 1;
 
91
######################################################
 
92
# Endo of functionality Testing for local_infile     #
 
93
######################################################
 
94