diff options
Diffstat (limited to 'mysql-test/t/local_infile_func.test')
| -rw-r--r-- | mysql-test/t/local_infile_func.test | 94 |
1 files changed, 0 insertions, 94 deletions
diff --git a/mysql-test/t/local_infile_func.test b/mysql-test/t/local_infile_func.test deleted file mode 100644 index 166149ad9aa..00000000000 --- a/mysql-test/t/local_infile_func.test +++ /dev/null @@ -1,94 +0,0 @@ -############## mysql-test\t\local_infile_func.test ############################ -# # -# Variable Name: local_infile # -# Scope: GLOBAL # -# Access Type: Dynamic # -# Data Type: Boolean # -# Default Value: 1 # -# Valid Values: # -# # -# # -# Creation Date: 2008-03-08 # -# Author: Rizwan Maredia # -# # -# Description: Test Cases of Dynamic System Variable "local_infile" # -# that checks behavior of this variable # -# # -# Reference: http://dev.mysql.com/doc/refman/5.1/en/ # -# server-system-variables.html#option_mysqld_local_infile # -# # -################################################################################ - ---source include/not_embedded.inc - ---echo '#--------------------FN_DYNVARS_037_01-------------------------#' -#################################################################### -# Check if setting local_infile is changed in every new connection # -#################################################################### - -SET @@global.local_infile = 0; - -# con1 will be default connection from now on ---echo 'connect (con1,localhost,root,,,,)' -connect (con1,localhost,root,,,,); ---echo 'connection con1' -connection con1; -SELECT @@global.local_infile; -SET @@global.local_infile = 1; - ---echo 'connect (con2,localhost,root,,,,)' -connect (con2,localhost,root,,,,); ---echo 'connection con2' -connection con2; -SELECT @@global.local_infile; -disconnect con2; - - ---echo '#--------------------FN_DYNVARS_037_02-------------------------#' -###################################################### -# Begin the functionality Testing of local_infile # -###################################################### - ---echo 'connection con1' -connection con1; - -#============================================================= ---echo '-----Checking LOAD DATA when local_infile is 1-------' -#============================================================= -SET @@global.local_infile = 1; ---disable_warnings -DROP TABLE IF EXISTS t1; ---enable_warnings - -create table t1(a int); - ---replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR -eval LOAD DATA LOCAL INFILE -'$MYSQLTEST_VARDIR/std_data_ln/numbers.txt' INTO TABLE test.t1; - -SELECT count(*) from t1; - -#============================================================= ---echo '-----Checking LOAD DATA when local_infile is 0-------' -#============================================================= -SET @@global.local_infile = 0; - ---disable_warnings -DROP TABLE IF EXISTS t1; ---enable_warnings -create table t1(a int); - ---replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR ---Error ER_NOT_ALLOWED_COMMAND -eval LOAD DATA LOCAL INFILE -'$MYSQLTEST_VARDIR/std_data_ln/numbers.txt' INTO TABLE test.t1; - -SELECT count(*) from t1; - -# clean up and restore -DROP TABLE t1; -SET @@global.local_infile = 1; -###################################################### -# Endo of functionality Testing for local_infile # -###################################################### - |