diff options
| author | Horst Hunger <horst@mysql.com> | 2008-12-19 16:03:32 +0100 |
|---|---|---|
| committer | Horst Hunger <horst@mysql.com> | 2008-12-19 16:03:32 +0100 |
| commit | 357b5009409ed6666bf1df48a80d76cd42a482c8 (patch) | |
| tree | 7a2fa9b404ffb20d1572c51a0bca7ecc64992310 /mysql-test/t/local_infile_func.test | |
| parent | ba816c14a9bc8012759da9d58f858f1e73bec708 (diff) | |
| download | mariadb-git-357b5009409ed6666bf1df48a80d76cd42a482c8.tar.gz | |
WL#4681: Took the system variable tests out of the main test suite, put them into "sys_vars", updated some reult files and tests.
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 # -###################################################### - |