2
DROP TABLE IF EXISTS t1,t2;
4
CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
5
CREATE TABLE t2(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
6
--source suite/engines/funcs/t/data1.inc
7
--source suite/engines/funcs/t/data2.inc
8
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
9
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
10
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
11
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
12
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
13
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
14
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
16
CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
17
CREATE TABLE t2(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
18
--source suite/engines/funcs/t/data1.inc
19
--source suite/engines/funcs/t/data2.inc
20
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
21
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
22
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
23
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
24
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
25
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
26
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
28
CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
29
CREATE TABLE t2(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
30
--source suite/engines/funcs/t/data1.inc
31
--source suite/engines/funcs/t/data2.inc
32
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
33
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
34
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
35
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
36
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
37
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
38
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
40
CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
41
CREATE TABLE t2(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
42
--source suite/engines/funcs/t/data1.inc
43
--source suite/engines/funcs/t/data2.inc
44
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
45
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
46
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
47
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
48
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
49
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
50
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
52
CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
53
CREATE TABLE t2(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
54
--source suite/engines/funcs/t/data1.inc
55
--source suite/engines/funcs/t/data2.inc
56
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
57
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
58
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
59
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
60
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
61
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
62
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
64
CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
65
CREATE TABLE t2(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
66
--source suite/engines/funcs/t/data1.inc
67
--source suite/engines/funcs/t/data2.inc
68
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
69
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
70
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
71
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
72
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
73
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
74
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
76
CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
77
CREATE TABLE t2(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
78
--source suite/engines/funcs/t/data1.inc
79
--source suite/engines/funcs/t/data2.inc
80
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
81
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
82
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
83
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
84
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
85
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
86
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
88
CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
89
CREATE TABLE t2(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
90
--source suite/engines/funcs/t/data1.inc
91
--source suite/engines/funcs/t/data2.inc
92
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
93
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
94
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
95
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
96
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
97
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
98
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
100
CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
101
CREATE TABLE t2(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
102
--source suite/engines/funcs/t/data1.inc
103
--source suite/engines/funcs/t/data2.inc
104
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
105
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
106
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
107
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
108
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
109
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
110
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
112
CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
113
CREATE TABLE t2(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
114
--source suite/engines/funcs/t/data1.inc
115
--source suite/engines/funcs/t/data2.inc
116
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
117
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
118
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
119
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
120
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
121
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
122
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
124
CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
125
CREATE TABLE t2(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
126
--source suite/engines/funcs/t/data1.inc
127
--source suite/engines/funcs/t/data2.inc
128
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
129
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
130
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
131
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
132
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
133
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
134
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
136
CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
137
CREATE TABLE t2(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
138
--source suite/engines/funcs/t/data1.inc
139
--source suite/engines/funcs/t/data2.inc
140
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
141
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
142
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
143
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
144
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
145
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
146
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
148
CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
149
CREATE TABLE t2(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
150
--source suite/engines/funcs/t/data1.inc
151
--source suite/engines/funcs/t/data2.inc
152
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
153
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
154
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
155
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
156
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
157
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
158
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
160
CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
161
CREATE TABLE t2(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
162
--source suite/engines/funcs/t/data1.inc
163
--source suite/engines/funcs/t/data2.inc
164
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
165
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
166
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
167
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
168
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
169
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
170
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
172
CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
173
CREATE TABLE t2(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
174
--source suite/engines/funcs/t/data1.inc
175
--source suite/engines/funcs/t/data2.inc
176
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
177
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
178
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
179
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
180
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
181
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
182
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
184
CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
185
CREATE TABLE t2(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
186
--source suite/engines/funcs/t/data1.inc
187
--source suite/engines/funcs/t/data2.inc
188
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
189
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
190
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
191
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
192
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
193
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
194
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
196
CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
197
CREATE TABLE t2(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
198
--source suite/engines/funcs/t/data1.inc
199
--source suite/engines/funcs/t/data2.inc
200
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
201
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
202
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
203
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
204
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
205
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
206
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
208
CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
209
CREATE TABLE t2(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
210
--source suite/engines/funcs/t/data1.inc
211
--source suite/engines/funcs/t/data2.inc
212
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
213
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
214
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
215
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
216
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
217
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
218
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
220
CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
221
CREATE TABLE t2(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
222
--source suite/engines/funcs/t/data1.inc
223
--source suite/engines/funcs/t/data2.inc
224
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
225
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
226
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
227
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
228
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
229
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
230
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
232
CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
233
CREATE TABLE t2(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
234
--source suite/engines/funcs/t/data1.inc
235
--source suite/engines/funcs/t/data2.inc
236
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
237
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
238
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
239
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
240
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
241
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
242
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
244
CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
245
CREATE TABLE t2(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
246
--source suite/engines/funcs/t/data1.inc
247
--source suite/engines/funcs/t/data2.inc
248
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
249
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
250
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
251
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
252
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
253
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
254
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
256
CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
257
CREATE TABLE t2(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
258
--source suite/engines/funcs/t/data1.inc
259
--source suite/engines/funcs/t/data2.inc
260
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
261
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
262
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
263
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
264
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
265
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
266
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
268
CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
269
CREATE TABLE t2(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
270
--source suite/engines/funcs/t/data1.inc
271
--source suite/engines/funcs/t/data2.inc
272
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
273
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
274
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
275
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
276
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
277
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
278
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
280
CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
281
CREATE TABLE t2(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
282
--source suite/engines/funcs/t/data1.inc
283
--source suite/engines/funcs/t/data2.inc
284
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
285
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
286
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
287
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
288
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
289
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
290
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
292
CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
293
CREATE TABLE t2(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
294
--source suite/engines/funcs/t/data1.inc
295
--source suite/engines/funcs/t/data2.inc
296
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
297
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
298
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
299
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
300
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
301
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
302
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
304
CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
305
CREATE TABLE t2(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
306
--source suite/engines/funcs/t/data1.inc
307
--source suite/engines/funcs/t/data2.inc
308
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
309
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
310
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
311
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
312
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
313
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
314
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
316
CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
317
CREATE TABLE t2(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
318
--source suite/engines/funcs/t/data1.inc
319
--source suite/engines/funcs/t/data2.inc
320
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
321
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
322
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
323
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
324
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
325
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
326
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
328
CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
329
CREATE TABLE t2(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
330
--source suite/engines/funcs/t/data1.inc
331
--source suite/engines/funcs/t/data2.inc
332
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
333
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
334
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
335
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
336
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
337
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
338
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
340
CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
341
CREATE TABLE t2(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
342
--source suite/engines/funcs/t/data1.inc
343
--source suite/engines/funcs/t/data2.inc
344
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
345
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
346
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
347
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
348
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
349
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
350
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
352
CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
353
CREATE TABLE t2(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
354
--source suite/engines/funcs/t/data1.inc
355
--source suite/engines/funcs/t/data2.inc
356
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
357
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
358
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
359
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
360
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
361
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
362
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
364
CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
365
CREATE TABLE t2(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
366
--source suite/engines/funcs/t/data1.inc
367
--source suite/engines/funcs/t/data2.inc
368
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
369
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
370
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
371
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
372
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
373
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
374
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
376
CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
377
CREATE TABLE t2(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
378
--source suite/engines/funcs/t/data1.inc
379
--source suite/engines/funcs/t/data2.inc
380
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
381
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
382
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
383
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
384
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
385
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
386
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
388
CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
389
CREATE TABLE t2(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
390
--source suite/engines/funcs/t/data1.inc
391
--source suite/engines/funcs/t/data2.inc
392
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
393
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
394
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
395
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
396
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
397
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
398
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
400
CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
401
CREATE TABLE t2(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
402
--source suite/engines/funcs/t/data1.inc
403
--source suite/engines/funcs/t/data2.inc
404
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
405
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
406
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
407
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
408
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
409
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
410
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
412
CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
413
CREATE TABLE t2(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
414
--source suite/engines/funcs/t/data1.inc
415
--source suite/engines/funcs/t/data2.inc
416
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
417
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
418
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
419
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
420
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
421
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
422
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
424
CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
425
CREATE TABLE t2(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
426
--source suite/engines/funcs/t/data1.inc
427
--source suite/engines/funcs/t/data2.inc
428
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
429
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
430
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
431
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
432
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
433
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
434
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
436
CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
437
CREATE TABLE t2(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
438
--source suite/engines/funcs/t/data1.inc
439
--source suite/engines/funcs/t/data2.inc
440
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
441
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
442
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
443
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
444
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
445
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
446
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
448
CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
449
CREATE TABLE t2(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
450
--source suite/engines/funcs/t/data1.inc
451
--source suite/engines/funcs/t/data2.inc
452
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
453
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
454
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
455
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
456
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
457
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
458
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
460
CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
461
CREATE TABLE t2(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
462
--source suite/engines/funcs/t/data1.inc
463
--source suite/engines/funcs/t/data2.inc
464
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
465
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
466
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
467
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
468
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
469
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
470
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
472
CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
473
CREATE TABLE t2(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
474
--source suite/engines/funcs/t/data1.inc
475
--source suite/engines/funcs/t/data2.inc
476
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
477
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
478
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
479
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
480
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
481
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
482
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
484
CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
485
CREATE TABLE t2(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
486
--source suite/engines/funcs/t/data1.inc
487
--source suite/engines/funcs/t/data2.inc
488
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
489
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
490
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
491
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
492
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
493
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
494
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
496
CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
497
CREATE TABLE t2(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
498
--source suite/engines/funcs/t/data1.inc
499
--source suite/engines/funcs/t/data2.inc
500
SELECT c1 FROM t1 UNION SELECT c1 FROM t2;
501
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
502
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
503
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;
504
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ;
505
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ;
506
SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ;