funcs/t/se_string_from.test

4 DROP TABLE IF EXISTS t1;
6 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
8 SELECT COUNT(*) FROM t1,t1 AS b;
9 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a';
10 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a';
11 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a' AND t1.c1 = b.c1;
12 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a' AND t1.c2 = b.c1;
13 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
14 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
15 DROP TABLE t1;
16 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
18 SELECT COUNT(*) FROM t1,t1 AS b;
19 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b';
20 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b';
21 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b' AND t1.c1 = b.c1;
22 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b' AND t1.c2 = b.c1;
23 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
24 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
25 DROP TABLE t1;
26 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
28 SELECT COUNT(*) FROM t1,t1 AS b;
29 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c';
30 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c';
31 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c' AND t1.c1 = b.c1;
32 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c' AND t1.c2 = b.c1;
33 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
34 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
35 DROP TABLE t1;
36 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
38 SELECT COUNT(*) FROM t1,t1 AS b;
39 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d';
40 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d';
41 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d' AND t1.c1 = b.c1;
42 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d' AND t1.c2 = b.c1;
43 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
44 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
45 DROP TABLE t1;
46 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
48 SELECT COUNT(*) FROM t1,t1 AS b;
49 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e';
50 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e';
51 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e' AND t1.c1 = b.c1;
52 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e' AND t1.c2 = b.c1;
53 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
54 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
55 DROP TABLE t1;
56 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
58 SELECT COUNT(*) FROM t1,t1 AS b;
59 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f';
60 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f';
61 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f' AND t1.c1 = b.c1;
62 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f' AND t1.c2 = b.c1;
63 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
64 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
65 DROP TABLE t1;
66 CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL);
68 SELECT COUNT(*) FROM t1,t1 AS b;
69 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y';
70 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y';
71 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y' AND t1.c1 = b.c1;
72 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y' AND t1.c2 = b.c1;
73 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
74 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
75 DROP TABLE t1;
76 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
78 SELECT COUNT(*) FROM t1,t1 AS b;
79 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a';
80 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a';
81 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a' AND t1.c1 = b.c1;
82 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a' AND t1.c2 = b.c1;
83 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
84 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
85 DROP TABLE t1;
86 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
88 SELECT COUNT(*) FROM t1,t1 AS b;
89 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b';
90 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b';
91 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b' AND t1.c1 = b.c1;
92 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b' AND t1.c2 = b.c1;
93 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
94 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
95 DROP TABLE t1;
96 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
98 SELECT COUNT(*) FROM t1,t1 AS b;
99 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c';
100 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c';
101 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c' AND t1.c1 = b.c1;
102 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c' AND t1.c2 = b.c1;
103 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
104 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
105 DROP TABLE t1;
106 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
108 SELECT COUNT(*) FROM t1,t1 AS b;
109 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d';
110 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d';
111 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d' AND t1.c1 = b.c1;
112 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d' AND t1.c2 = b.c1;
113 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
114 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
115 DROP TABLE t1;
116 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
118 SELECT COUNT(*) FROM t1,t1 AS b;
119 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e';
120 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e';
121 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e' AND t1.c1 = b.c1;
122 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e' AND t1.c2 = b.c1;
123 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
124 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
125 DROP TABLE t1;
126 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
128 SELECT COUNT(*) FROM t1,t1 AS b;
129 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f';
130 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f';
131 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f' AND t1.c1 = b.c1;
132 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f' AND t1.c2 = b.c1;
133 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
134 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
135 DROP TABLE t1;
136 CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL);
138 SELECT COUNT(*) FROM t1,t1 AS b;
139 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y';
140 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y';
141 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y' AND t1.c1 = b.c1;
142 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y' AND t1.c2 = b.c1;
143 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
144 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
145 DROP TABLE t1;
146 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
148 SELECT COUNT(*) FROM t1,t1 AS b;
149 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a';
150 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a';
151 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a' AND t1.c1 = b.c1;
152 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a' AND t1.c2 = b.c1;
153 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
154 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
155 DROP TABLE t1;
156 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
158 SELECT COUNT(*) FROM t1,t1 AS b;
159 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b';
160 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b';
161 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b' AND t1.c1 = b.c1;
162 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b' AND t1.c2 = b.c1;
163 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
164 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
165 DROP TABLE t1;
166 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
168 SELECT COUNT(*) FROM t1,t1 AS b;
169 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c';
170 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c';
171 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c' AND t1.c1 = b.c1;
172 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c' AND t1.c2 = b.c1;
173 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
174 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
175 DROP TABLE t1;
176 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
178 SELECT COUNT(*) FROM t1,t1 AS b;
179 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d';
180 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d';
181 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d' AND t1.c1 = b.c1;
182 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d' AND t1.c2 = b.c1;
183 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
184 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
185 DROP TABLE t1;
186 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
188 SELECT COUNT(*) FROM t1,t1 AS b;
189 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e';
190 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e';
191 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e' AND t1.c1 = b.c1;
192 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e' AND t1.c2 = b.c1;
193 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
194 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
195 DROP TABLE t1;
196 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
198 SELECT COUNT(*) FROM t1,t1 AS b;
199 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f';
200 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f';
201 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f' AND t1.c1 = b.c1;
202 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f' AND t1.c2 = b.c1;
203 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
204 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
205 DROP TABLE t1;
206 CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL);
208 SELECT COUNT(*) FROM t1,t1 AS b;
209 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y';
210 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y';
211 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y' AND t1.c1 = b.c1;
212 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y' AND t1.c2 = b.c1;
213 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
214 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
215 DROP TABLE t1;
216 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
218 SELECT COUNT(*) FROM t1,t1 AS b;
219 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a';
220 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a';
221 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a' AND t1.c1 = b.c1;
222 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a' AND t1.c2 = b.c1;
223 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
224 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
225 DROP TABLE t1;
226 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
228 SELECT COUNT(*) FROM t1,t1 AS b;
229 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b';
230 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b';
231 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b' AND t1.c1 = b.c1;
232 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b' AND t1.c2 = b.c1;
233 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
234 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
235 DROP TABLE t1;
236 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
238 SELECT COUNT(*) FROM t1,t1 AS b;
239 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c';
240 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c';
241 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c' AND t1.c1 = b.c1;
242 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c' AND t1.c2 = b.c1;
243 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
244 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
245 DROP TABLE t1;
246 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
248 SELECT COUNT(*) FROM t1,t1 AS b;
249 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d';
250 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d';
251 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d' AND t1.c1 = b.c1;
252 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d' AND t1.c2 = b.c1;
253 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
254 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
255 DROP TABLE t1;
256 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
258 SELECT COUNT(*) FROM t1,t1 AS b;
259 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e';
260 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e';
261 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e' AND t1.c1 = b.c1;
262 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e' AND t1.c2 = b.c1;
263 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
264 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
265 DROP TABLE t1;
266 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
268 SELECT COUNT(*) FROM t1,t1 AS b;
269 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f';
270 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f';
271 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f' AND t1.c1 = b.c1;
272 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f' AND t1.c2 = b.c1;
273 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
274 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
275 DROP TABLE t1;
276 CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL);
278 SELECT COUNT(*) FROM t1,t1 AS b;
279 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y';
280 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y';
281 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y' AND t1.c1 = b.c1;
282 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y' AND t1.c2 = b.c1;
283 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
284 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
285 DROP TABLE t1;
286 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
288 SELECT COUNT(*) FROM t1,t1 AS b;
289 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a';
290 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a';
291 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a' AND t1.c1 = b.c1;
292 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a' AND t1.c2 = b.c1;
293 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
294 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
295 DROP TABLE t1;
296 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
298 SELECT COUNT(*) FROM t1,t1 AS b;
299 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b';
300 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b';
301 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b' AND t1.c1 = b.c1;
302 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b' AND t1.c2 = b.c1;
303 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
304 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
305 DROP TABLE t1;
306 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
308 SELECT COUNT(*) FROM t1,t1 AS b;
309 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c';
310 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c';
311 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c' AND t1.c1 = b.c1;
312 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c' AND t1.c2 = b.c1;
313 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
314 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
315 DROP TABLE t1;
316 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
318 SELECT COUNT(*) FROM t1,t1 AS b;
319 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d';
320 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d';
321 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d' AND t1.c1 = b.c1;
322 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d' AND t1.c2 = b.c1;
323 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
324 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
325 DROP TABLE t1;
326 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
328 SELECT COUNT(*) FROM t1,t1 AS b;
329 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e';
330 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e';
331 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e' AND t1.c1 = b.c1;
332 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e' AND t1.c2 = b.c1;
333 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
334 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
335 DROP TABLE t1;
336 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
338 SELECT COUNT(*) FROM t1,t1 AS b;
339 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f';
340 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f';
341 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f' AND t1.c1 = b.c1;
342 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f' AND t1.c2 = b.c1;
343 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
344 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
345 DROP TABLE t1;
346 CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL);
348 SELECT COUNT(*) FROM t1,t1 AS b;
349 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y';
350 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y';
351 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y' AND t1.c1 = b.c1;
352 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y' AND t1.c2 = b.c1;
353 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
354 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
355 DROP TABLE t1;
356 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
358 SELECT COUNT(*) FROM t1,t1 AS b;
359 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a';
360 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a';
361 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a' AND t1.c1 = b.c1;
362 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a' AND t1.c2 = b.c1;
363 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
364 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
365 DROP TABLE t1;
366 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
368 SELECT COUNT(*) FROM t1,t1 AS b;
369 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b';
370 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b';
371 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b' AND t1.c1 = b.c1;
372 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b' AND t1.c2 = b.c1;
373 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
374 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
375 DROP TABLE t1;
376 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
378 SELECT COUNT(*) FROM t1,t1 AS b;
379 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c';
380 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c';
381 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c' AND t1.c1 = b.c1;
382 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c' AND t1.c2 = b.c1;
383 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
384 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
385 DROP TABLE t1;
386 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
388 SELECT COUNT(*) FROM t1,t1 AS b;
389 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d';
390 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d';
391 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d' AND t1.c1 = b.c1;
392 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d' AND t1.c2 = b.c1;
393 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
394 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
395 DROP TABLE t1;
396 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
398 SELECT COUNT(*) FROM t1,t1 AS b;
399 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e';
400 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e';
401 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e' AND t1.c1 = b.c1;
402 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e' AND t1.c2 = b.c1;
403 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
404 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
405 DROP TABLE t1;
406 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
408 SELECT COUNT(*) FROM t1,t1 AS b;
409 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f';
410 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f';
411 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f' AND t1.c1 = b.c1;
412 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f' AND t1.c2 = b.c1;
413 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
414 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
415 DROP TABLE t1;
416 CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL);
418 SELECT COUNT(*) FROM t1,t1 AS b;
419 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y';
420 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y';
421 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y' AND t1.c1 = b.c1;
422 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y' AND t1.c2 = b.c1;
423 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y' AND t1.c1 = b.c1 AND t1.c2 = b.c2;
424 SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y' AND t1.c2 = b.c1 AND t1.c1 = b.c2;
425 DROP TABLE t1;