1SET @start_value = @@global.local_infile;
2SELECT @start_value;
3@start_value
41
5'#--------------------FN_DYNVARS_018_01------------------------#'
6SET @@global.local_infile = 0;
7SET @@global.local_infile = DEFAULT;
8SELECT @@global.local_infile;
9@@global.local_infile
101
11'#---------------------FN_DYNVARS_018_02-------------------------#'
12SET @@global.local_infile = DEFAULT;
13SELECT @@global.local_infile = 1;
14@@global.local_infile = 1
151
16'#--------------------FN_DYNVARS_018_03------------------------#'
17SET @@global.local_infile = 0;
18SELECT @@global.local_infile;
19@@global.local_infile
200
21SET @@global.local_infile = 1;
22SELECT @@global.local_infile;
23@@global.local_infile
241
25'#--------------------FN_DYNVARS_018_04-------------------------#'
26SET @@global.local_infile = -1;
27ERROR 42000: Variable 'local_infile' can't be set to the value of '-1'
28SET @@global.local_infile = 2;
29ERROR 42000: Variable 'local_infile' can't be set to the value of '2'
30SET @@global.local_infile = 100;
31ERROR 42000: Variable 'local_infile' can't be set to the value of '100'
32SET @@global.local_infile = TRUEF;
33ERROR 42000: Variable 'local_infile' can't be set to the value of 'TRUEF'
34SET @@global.local_infile = TRUE_F;
35ERROR 42000: Variable 'local_infile' can't be set to the value of 'TRUE_F'
36SET @@global.local_infile = FALSE0;
37ERROR 42000: Variable 'local_infile' can't be set to the value of 'FALSE0'
38SET @@global.local_infile = OON;
39ERROR 42000: Variable 'local_infile' can't be set to the value of 'OON'
40SET @@global.local_infile = ONN;
41ERROR 42000: Variable 'local_infile' can't be set to the value of 'ONN'
42SET @@global.local_infile = OOFF;
43ERROR 42000: Variable 'local_infile' can't be set to the value of 'OOFF'
44SET @@global.local_infile = 0FF;
45ERROR 42000: Variable 'local_infile' can't be set to the value of '0FF'
46SET @@global.local_infile = ' ';
47ERROR 42000: Variable 'local_infile' can't be set to the value of ' '
48SET @@global.local_infile = " ";
49ERROR 42000: Variable 'local_infile' can't be set to the value of ' '
50'#-------------------FN_DYNVARS_018_05----------------------------#'
51SET @@session.local_infile = 1;
52ERROR HY000: Variable 'local_infile' is a GLOBAL variable and should be set with SET GLOBAL
53SELECT @@session.local_infile = 1;
54ERROR HY000: Variable 'local_infile' is a GLOBAL variable
55'#----------------------FN_DYNVARS_018_06------------------------#'
56SELECT IF(@@global.local_infile, "ON", "OFF") = VARIABLE_VALUE
57FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
58WHERE VARIABLE_NAME='local_infile';
59IF(@@global.local_infile, "ON", "OFF") = VARIABLE_VALUE
601
61'#---------------------FN_DYNVARS_018_07----------------------#'
62SET @@global.local_infile = OFF;
63SELECT @@global.local_infile;
64@@global.local_infile
650
66SET @@global.local_infile = ON;
67SELECT @@global.local_infile;
68@@global.local_infile
691
70'#---------------------FN_DYNVARS_018_08----------------------#'
71SET @@global.local_infile = TRUE;
72SELECT @@global.local_infile;
73@@global.local_infile
741
75SET @@global.local_infile = FALSE;
76SELECT @@global.local_infile;
77@@global.local_infile
780
79'#---------------------FN_DYNVARS_018_09----------------------#'
80SET @@global.local_infile = 1;
81SELECT @@local_infile = @@global.local_infile;
82@@local_infile = @@global.local_infile
831
84'#---------------------FN_DYNVARS_018_10----------------------#'
85SET local_infile = 1;
86ERROR HY000: Variable 'local_infile' is a GLOBAL variable and should be set with SET GLOBAL
87SELECT @@local_infile;
88@@local_infile
891
90SET global.local_infile = 1;
91ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'local_infile = 1' at line 1
92SELECT global.local_infile;
93ERROR 42S02: Unknown table 'global' in field list
94SELECT local_infile = @@session.local_infile;
95ERROR 42S22: Unknown column 'local_infile' in 'field list'
96SET @@global.local_infile = @start_value;
97SELECT @@global.local_infile;
98@@global.local_infile
991
100