############## 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 connect (con1,localhost,root,,,,); connection con1; SELECT @@global.local_infile; SET @@global.local_infile = 1; connect (con2,localhost,root,,,,); connection con2; SELECT @@global.local_infile; disconnect con2; --echo '#--------------------FN_DYNVARS_037_02-------------------------#' ###################################################### # Begin the functionality Testing of local_infile # ###################################################### 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/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_LOAD_INFILE_CAPABILITY_DISABLED eval LOAD DATA LOCAL INFILE '$MYSQLTEST_VARDIR/std_data/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 # ######################################################