Debian Codegraph @

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

raw
1 SET @start_value = @@global.local_infile;
2 SELECT @start_value;
3 @start_value
4 0
5 '#--------------------FN_DYNVARS_018_01------------------------#'
6 SET @@global.local_infile = 0;
7 SET @@global.local_infile = DEFAULT;
8 SELECT @@global.local_infile;
9 @@global.local_infile
10 0
11 '#---------------------FN_DYNVARS_018_02-------------------------#'
12 SET @@global.local_infile = DEFAULT;
13 SELECT @@global.local_infile = 1;
14 @@global.local_infile = 1
15 0
16 '#--------------------FN_DYNVARS_018_03------------------------#'
17 SET @@global.local_infile = 0;
18 SELECT @@global.local_infile;
19 @@global.local_infile
20 0
21 SET @@global.local_infile = 1;
22 SELECT @@global.local_infile;
23 @@global.local_infile
24 1
25 '#--------------------FN_DYNVARS_018_04-------------------------#'
26 SET @@global.local_infile = -1;
27 ERROR 42000: Variable 'local_infile' can't be set to the value of '-1'
28 SET @@global.local_infile = 2;
29 ERROR 42000: Variable 'local_infile' can't be set to the value of '2'
30 SET @@global.local_infile = 100;
31 ERROR 42000: Variable 'local_infile' can't be set to the value of '100'
32 SET @@global.local_infile = TRUEF;
33 ERROR 42000: Variable 'local_infile' can't be set to the value of 'TRUEF'
34 SET @@global.local_infile = TRUE_F;
35 ERROR 42000: Variable 'local_infile' can't be set to the value of 'TRUE_F'
36 SET @@global.local_infile = FALSE0;
37 ERROR 42000: Variable 'local_infile' can't be set to the value of 'FALSE0'
38 SET @@global.local_infile = OON;
39 ERROR 42000: Variable 'local_infile' can't be set to the value of 'OON'
40 SET @@global.local_infile = ONN;
41 ERROR 42000: Variable 'local_infile' can't be set to the value of 'ONN'
42 SET @@global.local_infile = OOFF;
43 ERROR 42000: Variable 'local_infile' can't be set to the value of 'OOFF'
44 SET @@global.local_infile = 0FF;
45 ERROR 42000: Variable 'local_infile' can't be set to the value of '0FF'
46 SET @@global.local_infile = ' ';
47 ERROR 42000: Variable 'local_infile' can't be set to the value of ' '
48 SET @@global.local_infile = " ";
49 ERROR 42000: Variable 'local_infile' can't be set to the value of ' '
50 '#-------------------FN_DYNVARS_018_05----------------------------#'
51 SET @@session.local_infile = 1;
52 ERROR HY000: Variable 'local_infile' is a GLOBAL variable and should be set with SET GLOBAL
53 SELECT @@session.local_infile = 1;
54 ERROR HY000: Variable 'local_infile' is a GLOBAL variable
55 '#----------------------FN_DYNVARS_018_06------------------------#'
56 SELECT IF(@@global.local_infile, "ON", "OFF") = VARIABLE_VALUE
57 FROM performance_schema.global_variables
58 WHERE VARIABLE_NAME='local_infile';
59 IF(@@global.local_infile, "ON", "OFF") = VARIABLE_VALUE
60 1
61 '#---------------------FN_DYNVARS_018_07----------------------#'
62 SET @@global.local_infile = OFF;
63 SELECT @@global.local_infile;
64 @@global.local_infile
65 0
66 SET @@global.local_infile = ON;
67 SELECT @@global.local_infile;
68 @@global.local_infile
69 1
70 '#---------------------FN_DYNVARS_018_08----------------------#'
71 SET @@global.local_infile = TRUE;
72 SELECT @@global.local_infile;
73 @@global.local_infile
74 1
75 SET @@global.local_infile = FALSE;
76 SELECT @@global.local_infile;
77 @@global.local_infile
78 0
79 '#---------------------FN_DYNVARS_018_09----------------------#'
80 SET @@global.local_infile = 1;
81 SELECT @@local_infile = @@global.local_infile;
82 @@local_infile = @@global.local_infile
83 1
84 '#---------------------FN_DYNVARS_018_10----------------------#'
85 SET local_infile = 1;
86 ERROR HY000: Variable 'local_infile' is a GLOBAL variable and should be set with SET GLOBAL
87 SELECT @@local_infile;
88 @@local_infile
89 1
90 SET global.local_infile = 1;
91 ERROR 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 'global.local_infile = 1' at line 1
92 SELECT global.local_infile;
93 ERROR 42S02: Unknown table 'global' in field list
94 SELECT local_infile;
95 ERROR 42S22: Unknown column 'local_infile' in 'field list'
96 SELECT @@session.local_infile;
97 ERROR HY000: Variable 'local_infile' is a GLOBAL variable
98 SET @@global.local_infile = @start_value;
99 SELECT @@global.local_infile;
100 @@global.local_infile
101 0