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