← Back to branch summary

~jlukas79/+junk/mysql-server

« back to all changes in this revision

Viewing changes to mysql-test/r/engine_condition_pushdown_basic.result

manual merge 6.0-main --> 6.0-bka-review

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/engine_condition_pushdown_basic.result
 
1
SET @session_start_value = @@session.engine_condition_pushdown;
 
2
SELECT @session_start_value;
 
3
@session_start_value
 
4
1
 
5
SET @global_start_value = @@global.engine_condition_pushdown;
 
6
SELECT @global_start_value;
 
7
@global_start_value
 
8
1
 
9
'#--------------------FN_DYNVARS_028_01------------------------#'
 
10
SET @@session.engine_condition_pushdown = 0;
 
11
SET @@session.engine_condition_pushdown = DEFAULT;
 
12
SELECT @@session.engine_condition_pushdown;
 
13
@@session.engine_condition_pushdown
 
14
1
 
15
SET @@global.engine_condition_pushdown = 0;
 
16
SET @@global.engine_condition_pushdown = DEFAULT;
 
17
SELECT @@global.engine_condition_pushdown;
 
18
@@global.engine_condition_pushdown
 
19
1
 
20
'#---------------------FN_DYNVARS_028_02-------------------------#'
 
21
SET engine_condition_pushdown = 1;
 
22
SELECT @@engine_condition_pushdown;
 
23
@@engine_condition_pushdown
 
24
1
 
25
SELECT session.engine_condition_pushdown;
 
26
ERROR 42S02: Unknown table 'session' in field list
 
27
SELECT local.engine_condition_pushdown;
 
28
ERROR 42S02: Unknown table 'local' in field list
 
29
SELECT global.engine_condition_pushdown;
 
30
ERROR 42S02: Unknown table 'global' in field list
 
31
SET session engine_condition_pushdown = 0;
 
32
SELECT @@session.engine_condition_pushdown;
 
33
@@session.engine_condition_pushdown
 
34
0
 
35
SET global engine_condition_pushdown = 0;
 
36
SELECT @@global.engine_condition_pushdown;
 
37
@@global.engine_condition_pushdown
 
38
0
 
39
'#--------------------FN_DYNVARS_028_03------------------------#'
 
40
SET @@session.engine_condition_pushdown = 0;
 
41
SELECT @@session.engine_condition_pushdown;
 
42
@@session.engine_condition_pushdown
 
43
0
 
44
SET @@session.engine_condition_pushdown = 1;
 
45
SELECT @@session.engine_condition_pushdown;
 
46
@@session.engine_condition_pushdown
 
47
1
 
48
SET @@global.engine_condition_pushdown = 0;
 
49
SELECT @@global.engine_condition_pushdown;
 
50
@@global.engine_condition_pushdown
 
51
0
 
52
SET @@global.engine_condition_pushdown = 1;
 
53
SELECT @@global.engine_condition_pushdown;
 
54
@@global.engine_condition_pushdown
 
55
1
 
56
'#--------------------FN_DYNVARS_028_04-------------------------#'
 
57
SET @@session.engine_condition_pushdown = -1;
 
58
ERROR 42000: Variable 'engine_condition_pushdown' can't be set to the value of '-1'
 
59
SET @@session.engine_condition_pushdown = 1.6;
 
60
ERROR 42000: Variable 'engine_condition_pushdown' can't be set to the value of '2'
 
61
SET @@session.engine_condition_pushdown = "T";
 
62
ERROR 42000: Variable 'engine_condition_pushdown' can't be set to the value of 'T'
 
63
SET @@session.engine_condition_pushdown = "Y";
 
64
ERROR 42000: Variable 'engine_condition_pushdown' can't be set to the value of 'Y'
 
65
SET @@session.engine_condition_pushdown = TR�E;
 
66
ERROR 42000: Variable 'engine_condition_pushdown' can't be set to the value of 'TRÜE'
 
67
SET @@session.engine_condition_pushdown = �N;
 
68
ERROR 42000: Variable 'engine_condition_pushdown' can't be set to the value of 'ÕN'
 
69
SET @@session.engine_condition_pushdown = OF;
 
70
SELECT @@session.engine_condition_pushdown;
 
71
@@session.engine_condition_pushdown
 
72
0
 
73
'Bug# 34828: OF is taken as OFF and a value of 0 is set.'
 
74
SET @@session.engine_condition_pushdown = �FF;
 
75
ERROR 42000: Variable 'engine_condition_pushdown' can't be set to the value of 'ÓFF'
 
76
SET @@global.engine_condition_pushdown = -1;
 
77
ERROR 42000: Variable 'engine_condition_pushdown' can't be set to the value of '-1'
 
78
SET @@global.engine_condition_pushdown = 2;
 
79
ERROR 42000: Variable 'engine_condition_pushdown' can't be set to the value of '2'
 
80
SET @@global.engine_condition_pushdown = "T";
 
81
ERROR 42000: Variable 'engine_condition_pushdown' can't be set to the value of 'T'
 
82
SET @@global.engine_condition_pushdown = "Y";
 
83
ERROR 42000: Variable 'engine_condition_pushdown' can't be set to the value of 'Y'
 
84
SET @@global.engine_condition_pushdown = TR�E;
 
85
ERROR 42000: Variable 'engine_condition_pushdown' can't be set to the value of 'TRÜE'
 
86
SET @@global.engine_condition_pushdown = �N;
 
87
ERROR 42000: Variable 'engine_condition_pushdown' can't be set to the value of 'ÕN'
 
88
SET @@global.engine_condition_pushdown = OF;
 
89
SELECT @@global.engine_condition_pushdown;
 
90
@@global.engine_condition_pushdown
 
91
0
 
92
'Bug# 34828: OF is taken as OFF and a value of 0 is set.'
 
93
SET @@global.engine_condition_pushdown = �FF;
 
94
ERROR 42000: Variable 'engine_condition_pushdown' can't be set to the value of 'ÓFF'
 
95
'#-------------------FN_DYNVARS_028_05----------------------------#'
 
96
SET @@global.engine_condition_pushdown = 0;
 
97
SET @@session.engine_condition_pushdown = 1;
 
98
SELECT @@global.engine_condition_pushdown AS res_is_0;
 
99
res_is_0
 
100
0
 
101
SET @@global.engine_condition_pushdown = 0;
 
102
SELECT @@session.engine_condition_pushdown AS res_is_1;
 
103
res_is_1
 
104
1
 
105
'#----------------------FN_DYNVARS_028_06------------------------#'
 
106
SELECT @@global.engine_condition_pushdown = VARIABLE_VALUE 
 
107
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 
 
108
WHERE VARIABLE_NAME='engine_condition_pushdown';
 
109
@@global.engine_condition_pushdown = VARIABLE_VALUE
 
110
1
 
111
SELECT @@global.engine_condition_pushdown;
 
112
@@global.engine_condition_pushdown
 
113
0
 
114
SELECT VARIABLE_VALUE 
 
115
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 
 
116
WHERE VARIABLE_NAME='engine_condition_pushdown';
 
117
VARIABLE_VALUE
 
118
OFF
 
119
'#----------------------FN_DYNVARS_028_07------------------------#'
 
120
SELECT @@session.engine_condition_pushdown = VARIABLE_VALUE 
 
121
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
 
122
WHERE VARIABLE_NAME='engine_condition_pushdown';
 
123
@@session.engine_condition_pushdown = VARIABLE_VALUE
 
124
0
 
125
SELECT @@session.engine_condition_pushdown;
 
126
@@session.engine_condition_pushdown
 
127
1
 
128
SELECT VARIABLE_VALUE 
 
129
FROM INFORMATION_SCHEMA.SESSION_VARIABLES 
 
130
WHERE VARIABLE_NAME='engine_condition_pushdown';
 
131
VARIABLE_VALUE
 
132
ON
 
133
'#---------------------FN_DYNVARS_028_08-------------------------#'
 
134
SET @@session.engine_condition_pushdown = OFF;
 
135
SELECT @@session.engine_condition_pushdown;
 
136
@@session.engine_condition_pushdown
 
137
0
 
138
SET @@session.engine_condition_pushdown = ON;
 
139
SELECT @@session.engine_condition_pushdown;
 
140
@@session.engine_condition_pushdown
 
141
1
 
142
SET @@global.engine_condition_pushdown = OFF;
 
143
SELECT @@global.engine_condition_pushdown;
 
144
@@global.engine_condition_pushdown
 
145
0
 
146
SET @@global.engine_condition_pushdown = ON;
 
147
SELECT @@global.engine_condition_pushdown;
 
148
@@global.engine_condition_pushdown
 
149
1
 
150
'#---------------------FN_DYNVARS_028_09----------------------#'
 
151
SET @@session.engine_condition_pushdown = TRUE;
 
152
SELECT @@session.engine_condition_pushdown;
 
153
@@session.engine_condition_pushdown
 
154
1
 
155
SET @@session.engine_condition_pushdown = FALSE;
 
156
SELECT @@session.engine_condition_pushdown;
 
157
@@session.engine_condition_pushdown
 
158
0
 
159
SET @@global.engine_condition_pushdown = TRUE;
 
160
SELECT @@global.engine_condition_pushdown;
 
161
@@global.engine_condition_pushdown
 
162
1
 
163
SET @@global.engine_condition_pushdown = FALSE;
 
164
SELECT @@global.engine_condition_pushdown;
 
165
@@global.engine_condition_pushdown
 
166
0
 
167
SET @@session.engine_condition_pushdown = @session_start_value;
 
168
SELECT @@session.engine_condition_pushdown;
 
169
@@session.engine_condition_pushdown
 
170
1
 
171
SET @@global.engine_condition_pushdown = @global_start_value;
 
172
SELECT @@global.engine_condition_pushdown;
 
173
@@global.engine_condition_pushdown
 
174
1