Edit File: local_infile_func.result
'#--------------------FN_DYNVARS_037_01-------------------------#' SET @@global.local_infile = 0; 'connect (con1,localhost,root,,,,)' 'connection con1' SELECT @@global.local_infile; @@global.local_infile 0 SET @@global.local_infile = 1; 'connect (con2,localhost,root,,,,)' 'connection con2' SELECT @@global.local_infile; @@global.local_infile 1 '#--------------------FN_DYNVARS_037_02-------------------------#' 'connection con1' '-----Checking LOAD DATA when local_infile is 1-------' SET @@global.local_infile = 1; DROP TABLE IF EXISTS t1; create table t1(a int); LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/std_data/numbers.txt' INTO TABLE test.t1; SELECT count(*) from t1; count(*) 9 '-----Checking LOAD DATA when local_infile is 0-------' SET @@global.local_infile = 0; DROP TABLE IF EXISTS t1; create table t1(a int); LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/std_data/numbers.txt' INTO TABLE test.t1; ERROR 42000: The used command is not allowed with this MySQL version SELECT count(*) from t1; count(*) 0 DROP TABLE t1; SET @@global.local_infile = 1;
Back to File Manager