Debian Codegraph @

mysql-test/suite/engines/funcs/t/se_string_union.test

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