funcs/t/se_string_from.test

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