1'#--------------------FN_DYNVARS_037_01-------------------------#' 2SET @@global.local_infile = 0; 3connect con1,localhost,root,,,,; 4connection con1; 5SELECT @@global.local_infile; 6@@global.local_infile 70 8SET @@global.local_infile = 1; 9connect con2,localhost,root,,,,; 10connection con2; 11SELECT @@global.local_infile; 12@@global.local_infile 131 14disconnect con2; 15'#--------------------FN_DYNVARS_037_02-------------------------#' 16connection con1; 17'-----Checking LOAD DATA when local_infile is 1-------' 18SET @@global.local_infile = 1; 19DROP TABLE IF EXISTS t1; 20create table t1(a int); 21LOAD DATA LOCAL INFILE 22'MYSQLTEST_VARDIR/std_data/numbers.txt' INTO TABLE test.t1; 23SELECT count(*) from t1; 24count(*) 259 26'-----Checking LOAD DATA when local_infile is 0-------' 27SET @@global.local_infile = 0; 28DROP TABLE IF EXISTS t1; 29create table t1(a int); 30LOAD DATA LOCAL INFILE 31'MYSQLTEST_VARDIR/std_data/numbers.txt' INTO TABLE test.t1; 32ERROR 42000: The used command is not allowed with this MariaDB version 33SELECT count(*) from t1; 34count(*) 350 36DROP TABLE t1; 37SET @@global.local_infile = 1; 38