Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.optimizer_prune_level;
2 SELECT @start_global_value;
3 @start_global_value
4 1
5 SET @start_session_value = @@session.optimizer_prune_level;
6 SELECT @start_session_value;
7 @start_session_value
8 1
9 '#--------------------FN_DYNVARS_115_01-------------------------#'
10 SET @@global.optimizer_prune_level = 0;
11 SET @@global.optimizer_prune_level = DEFAULT;
12 SELECT @@global.optimizer_prune_level;
13 @@global.optimizer_prune_level
14 1
15 SET @@session.optimizer_prune_level = 0;
16 SET @@session.optimizer_prune_level = DEFAULT;
17 SELECT @@session.optimizer_prune_level;
18 @@session.optimizer_prune_level
19 1
20 '#--------------------FN_DYNVARS_115_02-------------------------#'
21 SET @@global.optimizer_prune_level = DEFAULT;
22 SELECT @@global.optimizer_prune_level = 1;
23 @@global.optimizer_prune_level = 1
24 1
25 SET @@session.optimizer_prune_level = DEFAULT;
26 SELECT @@session.optimizer_prune_level = 1;
27 @@session.optimizer_prune_level = 1
28 1
29 '#--------------------FN_DYNVARS_115_03-------------------------#'
30 SELECT @@global.optimizer_prune_level;
31 @@global.optimizer_prune_level
32 1
33 SET @@global.optimizer_prune_level = 0;
34 SELECT @@global.optimizer_prune_level;
35 @@global.optimizer_prune_level
36 0
37 SET @@global.optimizer_prune_level = 1;
38 SELECT @@global.optimizer_prune_level;
39 @@global.optimizer_prune_level
40 1
41 SET @@global.optimizer_prune_level = TRUE;
42 SELECT @@global.optimizer_prune_level;
43 @@global.optimizer_prune_level
44 1
45 SET @@global.optimizer_prune_level = FALSE;
46 SELECT @@global.optimizer_prune_level;
47 @@global.optimizer_prune_level
48 0
49 '#--------------------FN_DYNVARS_115_04-------------------------#'
50 SELECT @@session.optimizer_prune_level;
51 @@session.optimizer_prune_level
52 1
53 SET @@session.optimizer_prune_level = 0;
54 SELECT @@session.optimizer_prune_level;
55 @@session.optimizer_prune_level
56 0
57 SET @@session.optimizer_prune_level = 1;
58 SELECT @@session.optimizer_prune_level;
59 @@session.optimizer_prune_level
60 1
61 SET @@session.optimizer_prune_level = TRUE;
62 SELECT @@session.optimizer_prune_level;
63 @@session.optimizer_prune_level
64 1
65 SET @@session.optimizer_prune_level = FALSE;
66 SELECT @@session.optimizer_prune_level;
67 @@session.optimizer_prune_level
68 0
69 '#------------------FN_DYNVARS_115_05-----------------------#'
70 SET @@global.optimizer_prune_level = ON;
71 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
72 'Bug# 34840: Since it is a boolean variable, it should not give errors on 'ON' & 'OFF' values';
73 SET @@global.optimizer_prune_level = OFF;
74 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
75 SET @@global.optimizer_prune_level = 'ONN';
76 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
77 SET @@global.optimizer_prune_level = "OFFF";
78 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
79 SET @@global.optimizer_prune_level = TTRUE;
80 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
81 SET @@global.optimizer_prune_level = FELSE;
82 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
83 SET @@global.optimizer_prune_level = -1024;
84 Warnings:
85 Warning 1292 Truncated incorrect optimizer_prune_level value: '-1024'
86 SELECT @@global.optimizer_prune_level;
87 @@global.optimizer_prune_level
88 0
89 'Bug# 34840: Since it is a boolean variable, it should give errors on numeric values';
90 SET @@global.optimizer_prune_level = 65536;
91 Warnings:
92 Warning 1292 Truncated incorrect optimizer_prune_level value: '65536'
93 SET @@global.optimizer_prune_level = 65530.34;
94 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
95 SET @@global.optimizer_prune_level = test;
96 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
97 SET @@session.optimizer_prune_level = ON;
98 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
99 SET @@session.optimizer_prune_level = OFF;
100 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
101 SET @@session.optimizer_prune_level = ONN;
102 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
103 SET @@session.optimizer_prune_level = ONF;
104 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
105 SET @@session.optimizer_prune_level = ON;
106 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
107 SET @@session.optimizer_prune_level = OF;
108 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 'OF' at line 1
109 SET @@session.optimizer_prune_level = 'OFN';
110 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
111 SET @@session.optimizer_prune_level = -2;
112 Warnings:
113 Warning 1292 Truncated incorrect optimizer_prune_level value: '-2'
114 SELECT @@session.optimizer_prune_level;
115 @@session.optimizer_prune_level
116 0
117 SET @@session.optimizer_prune_level = 65530.34;
118 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
119 SET @@session.optimizer_prune_level = 65550;
120 Warnings:
121 Warning 1292 Truncated incorrect optimizer_prune_level value: '65550'
122 SELECT @@session.optimizer_prune_level;
123 @@session.optimizer_prune_level
124 1
125 SET @@session.optimizer_prune_level = test;
126 ERROR 42000: Incorrect argument type to variable 'optimizer_prune_level'
127 '#------------------FN_DYNVARS_115_06-----------------------#'
128 SELECT @@global.optimizer_prune_level = VARIABLE_VALUE
129 FROM performance_schema.global_variables
130 WHERE VARIABLE_NAME='optimizer_prune_level';
131 @@global.optimizer_prune_level = VARIABLE_VALUE
132 1
133 '#------------------FN_DYNVARS_115_07-----------------------#'
134 SELECT @@session.optimizer_prune_level = VARIABLE_VALUE
135 FROM performance_schema.session_variables
136 WHERE VARIABLE_NAME='optimizer_prune_level';
137 @@session.optimizer_prune_level = VARIABLE_VALUE
138 1
139 '#---------------------FN_DYNVARS_115_08----------------------#'
140 SET @@optimizer_prune_level = 0;
141 SET @@global.optimizer_prune_level = 1;
142 SELECT @@optimizer_prune_level = @@global.optimizer_prune_level;
143 @@optimizer_prune_level = @@global.optimizer_prune_level
144 0
145 '#---------------------FN_DYNVARS_115_09----------------------#'
146 SET @@optimizer_prune_level = 1;
147 SELECT @@optimizer_prune_level = @@local.optimizer_prune_level;
148 @@optimizer_prune_level = @@local.optimizer_prune_level
149 1
150 SELECT @@local.optimizer_prune_level = @@session.optimizer_prune_level;
151 @@local.optimizer_prune_level = @@session.optimizer_prune_level
152 1
153 '#---------------------FN_DYNVARS_115_10----------------------#'
154 SET optimizer_prune_level = 1;
155 SELECT @@optimizer_prune_level;
156 @@optimizer_prune_level
157 1
158 SELECT local.optimizer_prune_level;
159 ERROR 42S02: Unknown table 'local' in field list
160 SELECT session.optimizer_prune_level;
161 ERROR 42S02: Unknown table 'session' in field list
162 SELECT optimizer_prune_level = @@session.optimizer_prune_level;
163 ERROR 42S22: Unknown column 'optimizer_prune_level' in 'field list'
164 SET @@global.optimizer_prune_level = @start_global_value;
165 SELECT @@global.optimizer_prune_level;
166 @@global.optimizer_prune_level
167 1
168 SET @@session.optimizer_prune_level = @start_session_value;
169 SELECT @@session.optimizer_prune_level;
170 @@session.optimizer_prune_level
171 1