Debian Codegraph @

mysql-test/suite/sys_vars/r/local_infile_func.result

raw
1 '#--------------------FN_DYNVARS_037_01-------------------------#'
2 SET @@global.local_infile = 0;
3 'connect (con1,localhost,root,,,,)'
4 'connection con1'
5 SELECT @@global.local_infile;
6 @@global.local_infile
7 0
8 SET @@global.local_infile = 1;
9 'connect (con2,localhost,root,,,,)'
10 'connection con2'
11 SELECT @@global.local_infile;
12 @@global.local_infile
13 1
14 '#--------------------FN_DYNVARS_037_02-------------------------#'
15 'connection con1'
16 '-----Checking LOAD DATA when local_infile is 1-------'
17 SET @@global.local_infile = 1;
18 DROP TABLE IF EXISTS t1;
19 create table t1(a int);
20 LOAD DATA LOCAL INFILE
21 'MYSQLTEST_VARDIR/std_data/numbers.txt' INTO TABLE test.t1;
22 SELECT count(*) from t1;
23 count(*)
24 9
25 '-----Checking LOAD DATA when local_infile is 0-------'
26 SET @@global.local_infile = 0;
27 DROP TABLE IF EXISTS t1;
28 create table t1(a int);
29 LOAD DATA LOCAL INFILE
30 'MYSQLTEST_VARDIR/std_data/numbers.txt' INTO TABLE test.t1;
31 ERROR 42000: Loading local data is disabled; this must be enabled on both the client and server sides
32 SELECT count(*) from t1;
33 count(*)
34 0
35 DROP TABLE t1;
36 SET @@global.local_infile = 0;