Lines Matching refs:a
4 # a legal notice, here is a blessing:
33 CREATE TABLE t1(a,b,c COLLATE NOCASE);
34 INSERT INTO t1 VALUES(1,'a','a');
41 } {1 a a 9.9 b B {} C c hello d D abc e e}
55 CREATE TABLE t3(a,b,c COLLATE NOCASE);
68 SELECT a,b,c FROM t1 UNION ALL SELECT x,y,z FROM t2
69 ORDER BY a,b,c
71 } {{} C c {} U u -23 Y y 1 a a 9.9 b B 5200000.0 X x hello d D mad Z z abc e e hare m M}
74 SELECT t1.a, t1.b, t1.c FROM t1 UNION ALL SELECT x,y,z FROM t2
75 ORDER BY a,b,c
77 } {{} C c {} U u -23 Y y 1 a a 9.9 b B 5200000.0 X x hello d D mad Z z abc e e hare m M}
80 SELECT a,b,c FROM t1 UNION ALL SELECT x,y,z FROM t2
81 ORDER BY t1.a, t1.b, t1.c
83 } {{} C c {} U u -23 Y y 1 a a 9.9 b B 5200000.0 X x hello d D mad Z z abc e e hare m M}
86 SELECT a,b,c FROM t1 UNION ALL SELECT x,y,z FROM t2
87 ORDER BY a DESC,b,c
89 } {hare m M abc e e mad Z z hello d D 5200000.0 X x 9.9 b B 1 a a -23 Y y {} C c {} U u}
92 SELECT a,b,c FROM t1 UNION ALL SELECT x,y,z FROM t2
93 ORDER BY a,c,b
95 } {{} C c {} U u -23 Y y 1 a a 9.9 b B 5200000.0 X x hello d D mad Z z abc e e hare m M}
98 SELECT a,b,c FROM t1 UNION ALL SELECT x,y,z FROM t2
99 ORDER BY b,a,c
101 } {{} C c {} U u 5200000.0 X x -23 Y y mad Z z 1 a a 9.9 b B hello d D abc e e hare m M}
104 SELECT a,b,c FROM t1 UNION ALL SELECT x,y,z FROM t2
105 ORDER BY b COLLATE NOCASE,a,c
107 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
110 SELECT a,b,c FROM t1 UNION ALL SELECT x,y,z FROM t2
111 ORDER BY b COLLATE NOCASE DESC,a,c
113 } {mad Z z -23 Y y 5200000.0 X x {} U u hare m M abc e e hello d D {} C c 9.9 b B 1 a a}
116 SELECT a,b,c FROM t1 UNION ALL SELECT x,y,z FROM t2
117 ORDER BY c,b,a
119 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
122 SELECT a,b,c FROM t1 UNION ALL SELECT x,y,z FROM t2
123 ORDER BY c,a,b
125 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
128 SELECT a,b,c FROM t1 UNION ALL SELECT x,y,z FROM t2
129 ORDER BY c DESC,a,b
131 } {mad Z z -23 Y y 5200000.0 X x {} U u hare m M abc e e hello d D {} C c 9.9 b B 1 a a}
134 SELECT a,b,c FROM t1 UNION ALL SELECT x,y,z FROM t2
135 ORDER BY c COLLATE BINARY DESC,a,b
137 } {mad Z z -23 Y y 5200000.0 X x {} U u abc e e {} C c 1 a a hare m M hello d D 9.9 b B}
140 SELECT x,y,z FROM t2 UNION ALL SELECT a,b,c FROM t1
141 ORDER BY a,b,c
143 } {{} C c {} U u -23 Y y 1 a a 9.9 b B 5200000.0 X x hello d D mad Z z abc e e hare m M}
146 SELECT x,y,z FROM t2 UNION ALL SELECT a,b,c FROM t1
147 ORDER BY a DESC,b,c
149 } {hare m M abc e e mad Z z hello d D 5200000.0 X x 9.9 b B 1 a a -23 Y y {} C c {} U u}
152 SELECT x,y,z FROM t2 UNION ALL SELECT a,b,c FROM t1
153 ORDER BY a,c,b
155 } {{} C c {} U u -23 Y y 1 a a 9.9 b B 5200000.0 X x hello d D mad Z z abc e e hare m M}
158 SELECT x,y,z FROM t2 UNION ALL SELECT a,b,c FROM t1
159 ORDER BY b,a,c
161 } {{} C c {} U u 5200000.0 X x -23 Y y mad Z z 1 a a 9.9 b B hello d D abc e e hare m M}
164 SELECT x,y,z FROM t2 UNION ALL SELECT a,b,c FROM t1
165 ORDER BY b COLLATE NOCASE,a,c
167 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
170 SELECT x,y,z FROM t2 UNION ALL SELECT a,b,c FROM t1
171 ORDER BY b COLLATE NOCASE DESC,a,c
173 } {mad Z z -23 Y y 5200000.0 X x {} U u hare m M abc e e hello d D {} C c 9.9 b B 1 a a}
176 SELECT x,y,z FROM t2 UNION ALL SELECT a,b,c FROM t1
177 ORDER BY c,b,a
179 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
182 SELECT x,y,z FROM t2 UNION ALL SELECT a,b,c FROM t1
183 ORDER BY c,a,b
185 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
188 SELECT x,y,z FROM t2 UNION ALL SELECT a,b,c FROM t1
189 ORDER BY c DESC,a,b
191 } {mad Z z -23 Y y 5200000.0 X x {} U u hare m M abc e e hello d D {} C c 9.9 b B 1 a a}
194 SELECT x,y,z FROM t2 UNION ALL SELECT a,b,c FROM t1
195 ORDER BY c COLLATE BINARY DESC,a,b
197 } {mad Z z -23 Y y 5200000.0 X x {} U u abc e e {} C c 1 a a hare m M hello d D 9.9 b B}
200 SELECT a,b,c FROM t1 UNION SELECT x,y,z FROM t2
201 ORDER BY a,b,c
203 } {{} C c {} U u -23 Y y 1 a a 9.9 b B 5200000.0 X x hello d D mad Z z abc e e hare m M}
206 SELECT a,b,c FROM t1 UNION SELECT x,y,z FROM t2
207 ORDER BY a DESC,b,c
209 } {hare m M abc e e mad Z z hello d D 5200000.0 X x 9.9 b B 1 a a -23 Y y {} C c {} U u}
212 SELECT a,b,c FROM t1 UNION SELECT x,y,z FROM t2
213 ORDER BY a,c,b
215 } {{} C c {} U u -23 Y y 1 a a 9.9 b B 5200000.0 X x hello d D mad Z z abc e e hare m M}
218 SELECT a,b,c FROM t1 UNION SELECT x,y,z FROM t2
219 ORDER BY b,a,c
221 } {{} C c {} U u 5200000.0 X x -23 Y y mad Z z 1 a a 9.9 b B hello d D abc e e hare m M}
224 SELECT a,b,c FROM t1 UNION SELECT x,y,z FROM t2
225 ORDER BY b COLLATE NOCASE,a,c
227 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
230 SELECT a,b,c FROM t1 UNION SELECT x,y,z FROM t2
231 ORDER BY b COLLATE NOCASE DESC,a,c
233 } {mad Z z -23 Y y 5200000.0 X x {} U u hare m M abc e e hello d D {} C c 9.9 b B 1 a a}
236 SELECT a,b,c FROM t1 UNION SELECT x,y,z FROM t2
237 ORDER BY c,b,a
239 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
242 SELECT a,b,c FROM t1 UNION SELECT x,y,z FROM t2
243 ORDER BY c,a,b
245 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
248 SELECT a,b,c FROM t1 UNION SELECT x,y,z FROM t2
249 ORDER BY c DESC,a,b
251 } {mad Z z -23 Y y 5200000.0 X x {} U u hare m M abc e e hello d D {} C c 9.9 b B 1 a a}
254 SELECT a,b,c FROM t1 UNION SELECT x,y,z FROM t2
255 ORDER BY c COLLATE BINARY DESC,a,b
257 } {mad Z z -23 Y y 5200000.0 X x {} U u abc e e {} C c 1 a a hare m M hello d D 9.9 b B}
260 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t1
261 ORDER BY a,b,c
263 } {{} C c {} U u -23 Y y 1 a a 9.9 b B 5200000.0 X x hello d D mad Z z abc e e hare m M}
266 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t1
267 ORDER BY a DESC,b,c
269 } {hare m M abc e e mad Z z hello d D 5200000.0 X x 9.9 b B 1 a a -23 Y y {} C c {} U u}
272 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t1
273 ORDER BY a,c,b
275 } {{} C c {} U u -23 Y y 1 a a 9.9 b B 5200000.0 X x hello d D mad Z z abc e e hare m M}
278 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t1
279 ORDER BY b,a,c
281 } {{} C c {} U u 5200000.0 X x -23 Y y mad Z z 1 a a 9.9 b B hello d D abc e e hare m M}
284 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t1
287 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
290 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t1
293 } {mad Z z -23 Y y 5200000.0 X x {} U u hare m M abc e e hello d D {} C c 9.9 b B 1 a a}
296 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t1
297 ORDER BY c,b,a
299 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
302 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t1
303 ORDER BY c,a,b
305 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
308 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t1
309 ORDER BY c DESC,a,b
311 } {mad Z z -23 Y y 5200000.0 X x {} U u hare m M abc e e hello d D {} C c 9.9 b B 1 a a}
314 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t1
317 } {mad Z z -23 Y y 5200000.0 X x {} U u abc e e {} C c 1 a a hare m M hello d D 9.9 b B}
320 SELECT a,b,c FROM t1 EXCEPT SELECT a,b,c FROM t1 WHERE b>='d'
321 ORDER BY a,b,c
323 } {{} C c 1 a a 9.9 b B}
326 SELECT a,b,c FROM t1 INTERSECT SELECT a,b,c FROM t1 WHERE b>='d'
327 ORDER BY a,b,c
332 SELECT a,b,c FROM t1 WHERE b>='d' INTERSECT SELECT a,b,c FROM t1
333 ORDER BY a,b,c
338 SELECT a,b,c FROM t1 EXCEPT SELECT a,b,c FROM t1 WHERE b<'d'
339 ORDER BY a,b,c
344 SELECT a,b,c FROM t1 INTERSECT SELECT a,b,c FROM t1 WHERE b<'d'
345 ORDER BY a,b,c
347 } {{} C c 1 a a 9.9 b B}
350 SELECT a,b,c FROM t1 WHERE b<'d' INTERSECT SELECT a,b,c FROM t1
351 ORDER BY a,b,c
353 } {{} C c 1 a a 9.9 b B}
356 SELECT a,b,c FROM t1 EXCEPT SELECT a,b,c FROM t1 WHERE b>='d'
357 ORDER BY a DESC
359 } {9.9 b B 1 a a {} C c}
362 SELECT a,b,c FROM t1 INTERSECT SELECT a,b,c FROM t1 WHERE b>='d'
363 ORDER BY a DESC
368 SELECT a,b,c FROM t1 WHERE b>='d' INTERSECT SELECT a,b,c FROM t1
369 ORDER BY a DESC
374 SELECT a,b,c FROM t1 EXCEPT SELECT a,b,c FROM t1 WHERE b<'d'
375 ORDER BY a DESC
380 SELECT a,b,c FROM t1 INTERSECT SELECT a,b,c FROM t1 WHERE b<'d'
381 ORDER BY a DESC
383 } {9.9 b B 1 a a {} C c}
386 SELECT a,b,c FROM t1 WHERE b<'d' INTERSECT SELECT a,b,c FROM t1
387 ORDER BY a DESC
389 } {9.9 b B 1 a a {} C c}
392 SELECT a,b,c FROM t1 EXCEPT SELECT a,b,c FROM t1 WHERE b>='d'
393 ORDER BY b, a DESC
395 } {{} C c 1 a a 9.9 b B}
398 SELECT a,b,c FROM t1 INTERSECT SELECT a,b,c FROM t1 WHERE b>='d'
404 SELECT a,b,c FROM t1 WHERE b>='d' INTERSECT SELECT a,b,c FROM t1
410 SELECT a,b,c FROM t1 EXCEPT SELECT a,b,c FROM t1 WHERE b<'d'
411 ORDER BY b, c DESC, a
416 SELECT a,b,c FROM t1 INTERSECT SELECT a,b,c FROM t1 WHERE b<'d'
419 } {1 a a 9.9 b B {} C c}
422 SELECT a,b,c FROM t1 WHERE b<'d' INTERSECT SELECT a,b,c FROM t1
425 } {{} C c 1 a a 9.9 b B}
428 SELECT a,b,c FROM t1 EXCEPT SELECT a,b,c FROM t1 WHERE b>='d'
429 ORDER BY c, a DESC
431 } {1 a a 9.9 b B {} C c}
434 SELECT a,b,c FROM t1 INTERSECT SELECT a,b,c FROM t1 WHERE b>='d'
440 SELECT a,b,c FROM t1 WHERE b>='d' INTERSECT SELECT a,b,c FROM t1
441 ORDER BY c COLLATE BINARY, b DESC, c, a, b, c, a, b, c
446 SELECT a,b,c FROM t1 EXCEPT SELECT a,b,c FROM t1 WHERE b<'d'
447 ORDER BY c DESC, a
452 SELECT a,b,c FROM t1 INTERSECT SELECT a,b,c FROM t1 WHERE b<'d'
455 } {1 a a 9.9 b B {} C c}
458 SELECT a,b,c FROM t1 WHERE b<'d' INTERSECT SELECT a,b,c FROM t1
461 } {1 a a 9.9 b B {} C c}
464 SELECT a,b,c FROM t3 INTERSECT SELECT a,b,c FROM t1 WHERE b<'d'
467 } {1 a a 9.9 b B {} C c}
470 SELECT a,b,c FROM t1 WHERE b<'d' INTERSECT SELECT a,b,c FROM t3
473 } {1 a a 9.9 b B {} C c}
476 SELECT a,b,c FROM t1 EXCEPT SELECT a,b,c FROM t3 WHERE b<'d'
477 ORDER BY c DESC, a
482 SELECT a,b,c FROM t1 EXCEPT SELECT a,b,c FROM t1 WHERE b<'d'
483 INTERSECT SELECT a,b,c FROM t3
484 EXCEPT SELECT b,c,a FROM t3
485 ORDER BY c DESC, a
490 SELECT a,b,c FROM t1 INTERSECT SELECT a,b,c FROM t1 WHERE b<'d'
491 INTERSECT SELECT a,b,c FROM t3
492 EXCEPT SELECT b,c,a FROM t3
495 } {1 a a 9.9 b B {} C c}
498 SELECT a,b,c FROM t1 WHERE b<'d' INTERSECT SELECT a,b,c FROM t1
499 INTERSECT SELECT a,b,c FROM t3
500 EXCEPT SELECT b,c,a FROM t3
503 } {1 a a 9.9 b B {} C c}
506 SELECT a,b,c FROM t1 WHERE b<'d'
507 INTERSECT SELECT a,b,c FROM t1
508 INTERSECT SELECT a,b,c FROM t3
509 EXCEPT SELECT b,c,a FROM t3
510 INTERSECT SELECT a,b,c FROM t1
512 INTERSECT SELECT a,b,c FROM t3
514 INTERSECT SELECT a,b,c FROM t1
515 EXCEPT SELECT c,b,a FROM t3
518 } {1 a a 9.9 b B {} C c}
521 SELECT a,b,c FROM t3 UNION SELECT x,y,z FROM t2
522 ORDER BY a,b,c
524 } {{} C c {} U u -23 Y y 1 a a 9.9 b B 5200000.0 X x hello d D mad Z z abc e e hare m M}
527 SELECT a,b,c FROM t3 UNION SELECT x,y,z FROM t2
528 ORDER BY a DESC,b,c
530 } {hare m M abc e e mad Z z hello d D 5200000.0 X x 9.9 b B 1 a a -23 Y y {} C c {} U u}
533 SELECT a,b,c FROM t3 UNION SELECT x,y,z FROM t2
534 ORDER BY a,c,b
536 } {{} C c {} U u -23 Y y 1 a a 9.9 b B 5200000.0 X x hello d D mad Z z abc e e hare m M}
539 SELECT a,b,c FROM t3 UNION SELECT x,y,z FROM t2
540 ORDER BY b,a,c
542 } {{} C c {} U u 5200000.0 X x -23 Y y mad Z z 1 a a 9.9 b B hello d D abc e e hare m M}
545 SELECT a,b,c FROM t3 UNION SELECT x,y,z FROM t2
546 ORDER BY b COLLATE NOCASE,a,c
548 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
551 SELECT a,b,c FROM t3 UNION SELECT x,y,z FROM t2
552 ORDER BY b COLLATE NOCASE DESC,a,c
554 } {mad Z z -23 Y y 5200000.0 X x {} U u hare m M abc e e hello d D {} C c 9.9 b B 1 a a}
557 SELECT a,b,c FROM t3 UNION SELECT x,y,z FROM t2
558 ORDER BY c,b,a
560 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
563 SELECT a,b,c FROM t3 UNION SELECT x,y,z FROM t2
564 ORDER BY c,a,b
566 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
569 SELECT a,b,c FROM t3 UNION SELECT x,y,z FROM t2
570 ORDER BY c DESC,a,b
572 } {mad Z z -23 Y y 5200000.0 X x {} U u hare m M abc e e hello d D {} C c 9.9 b B 1 a a}
575 SELECT a,b,c FROM t3 UNION SELECT x,y,z FROM t2
576 ORDER BY c COLLATE BINARY DESC,a,b
578 } {mad Z z -23 Y y 5200000.0 X x {} U u abc e e {} C c 1 a a hare m M hello d D 9.9 b B}
581 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t3
582 ORDER BY a,b,c
584 } {{} C c {} U u -23 Y y 1 a a 9.9 b B 5200000.0 X x hello d D mad Z z abc e e hare m M}
587 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t3
588 ORDER BY a DESC,b,c
590 } {hare m M abc e e mad Z z hello d D 5200000.0 X x 9.9 b B 1 a a -23 Y y {} C c {} U u}
593 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t3
594 ORDER BY a,c,b
596 } {{} C c {} U u -23 Y y 1 a a 9.9 b B 5200000.0 X x hello d D mad Z z abc e e hare m M}
599 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t3
600 ORDER BY b,a,c
602 } {{} C c {} U u 5200000.0 X x -23 Y y mad Z z 1 a a 9.9 b B hello d D abc e e hare m M}
605 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t3
608 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
611 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t3
614 } {mad Z z -23 Y y 5200000.0 X x {} U u hare m M abc e e hello d D {} C c 9.9 b B 1 a a}
617 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t3
618 ORDER BY c,b,a
620 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
623 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t3
624 ORDER BY c,a,b
626 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
629 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t3
630 ORDER BY c DESC,a,b
632 } {mad Z z -23 Y y 5200000.0 X x {} U u hare m M abc e e hello d D {} C c 9.9 b B 1 a a}
635 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t3
638 } {mad Z z -23 Y y 5200000.0 X x {} U u abc e e {} C c 1 a a hare m M hello d D 9.9 b B}
642 INTERSECT SELECT a,b,c FROM t3
643 EXCEPT SELECT c,b,a FROM t1
644 UNION SELECT a,b,c FROM t3
645 INTERSECT SELECT a,b,c FROM t3
646 EXCEPT SELECT c,b,a FROM t1
647 UNION SELECT a,b,c FROM t3
650 } {mad Z z -23 Y y 5200000.0 X x {} U u hare m M abc e e hello d D {} C c 9.9 b B 1 a a}
660 } {a}
675 CREATE UNIQUE INDEX t1a ON t1(a);
686 SELECT a,b,c FROM t1 UNION ALL SELECT x,y,z FROM t2
687 ORDER BY a,b,c
689 } {{} C c {} U u -23 Y y 1 a a 9.9 b B 5200000.0 X x hello d D mad Z z abc e e hare m M}
692 SELECT t1.a,b,t1.c FROM t1 UNION ALL SELECT x,y,z FROM t2
693 ORDER BY a,t1.b,t1.c
695 } {{} C c {} U u -23 Y y 1 a a 9.9 b B 5200000.0 X x hello d D mad Z z abc e e hare m M}
698 SELECT a,b,c FROM t1 UNION ALL SELECT x,y,z FROM t2
699 ORDER BY a DESC,b,c
701 } {hare m M abc e e mad Z z hello d D 5200000.0 X x 9.9 b B 1 a a -23 Y y {} C c {} U u}
704 SELECT a,b,c FROM t1 UNION ALL SELECT x,y,z FROM t2
705 ORDER BY a,c,b
707 } {{} C c {} U u -23 Y y 1 a a 9.9 b B 5200000.0 X x hello d D mad Z z abc e e hare m M}
710 SELECT a,b,c FROM t1 UNION ALL SELECT x,y,z FROM t2
711 ORDER BY b,a,c
713 } {{} C c {} U u 5200000.0 X x -23 Y y mad Z z 1 a a 9.9 b B hello d D abc e e hare m M}
716 SELECT a,b,c FROM t1 UNION ALL SELECT x,y,z FROM t2
717 ORDER BY b COLLATE NOCASE,a,c
719 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
722 SELECT a,b,c FROM t1 UNION ALL SELECT x,y,z FROM t2
723 ORDER BY b COLLATE NOCASE DESC,a,c
725 } {mad Z z -23 Y y 5200000.0 X x {} U u hare m M abc e e hello d D {} C c 9.9 b B 1 a a}
728 SELECT a,b,c FROM t1 UNION ALL SELECT x,y,z FROM t2
729 ORDER BY c,b,a
731 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
734 SELECT a,b,c FROM t1 UNION ALL SELECT x,y,z FROM t2
735 ORDER BY c,a,b
737 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
740 SELECT a,b,c FROM t1 UNION ALL SELECT x,y,z FROM t2
741 ORDER BY c DESC,a,b
743 } {mad Z z -23 Y y 5200000.0 X x {} U u hare m M abc e e hello d D {} C c 9.9 b B 1 a a}
746 SELECT a,b,c FROM t1 UNION ALL SELECT x,y,z FROM t2
747 ORDER BY c COLLATE BINARY DESC,a,b
749 } {mad Z z -23 Y y 5200000.0 X x {} U u abc e e {} C c 1 a a hare m M hello d D 9.9 b B}
752 SELECT x,y,z FROM t2 UNION ALL SELECT a,b,c FROM t1
753 ORDER BY a,b,c
755 } {{} C c {} U u -23 Y y 1 a a 9.9 b B 5200000.0 X x hello d D mad Z z abc e e hare m M}
758 SELECT x,y,z FROM t2 UNION ALL SELECT a,b,c FROM t1
759 ORDER BY a DESC,b,c
761 } {hare m M abc e e mad Z z hello d D 5200000.0 X x 9.9 b B 1 a a -23 Y y {} C c {} U u}
764 SELECT x,y,z FROM t2 UNION ALL SELECT a,b,c FROM t1
765 ORDER BY a,c,b
767 } {{} C c {} U u -23 Y y 1 a a 9.9 b B 5200000.0 X x hello d D mad Z z abc e e hare m M}
770 SELECT x,y,z FROM t2 UNION ALL SELECT a,b,c FROM t1
771 ORDER BY b,a,c
773 } {{} C c {} U u 5200000.0 X x -23 Y y mad Z z 1 a a 9.9 b B hello d D abc e e hare m M}
776 SELECT x,y,z FROM t2 UNION ALL SELECT a,b,c FROM t1
777 ORDER BY b COLLATE NOCASE,a,c
779 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
782 SELECT x,y,z FROM t2 UNION ALL SELECT a,b,c FROM t1
783 ORDER BY b COLLATE NOCASE DESC,a,c
785 } {mad Z z -23 Y y 5200000.0 X x {} U u hare m M abc e e hello d D {} C c 9.9 b B 1 a a}
788 SELECT x,y,z FROM t2 UNION ALL SELECT a,b,c FROM t1
789 ORDER BY c,b,a
791 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
794 SELECT x,y,z FROM t2 UNION ALL SELECT a,b,c FROM t1
795 ORDER BY c,a,b
797 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
800 SELECT x,y,z FROM t2 UNION ALL SELECT a,b,c FROM t1
801 ORDER BY c DESC,a,b
803 } {mad Z z -23 Y y 5200000.0 X x {} U u hare m M abc e e hello d D {} C c 9.9 b B 1 a a}
806 SELECT x,y,z FROM t2 UNION ALL SELECT a,b,c FROM t1
807 ORDER BY c COLLATE BINARY DESC,a,b
809 } {mad Z z -23 Y y 5200000.0 X x {} U u abc e e {} C c 1 a a hare m M hello d D 9.9 b B}
812 SELECT a,b,c FROM t1 UNION SELECT x,y,z FROM t2
813 ORDER BY a,b,c
815 } {{} C c {} U u -23 Y y 1 a a 9.9 b B 5200000.0 X x hello d D mad Z z abc e e hare m M}
818 SELECT a,b,c FROM t1 UNION SELECT x,y,z FROM t2
819 ORDER BY a DESC,b,c
821 } {hare m M abc e e mad Z z hello d D 5200000.0 X x 9.9 b B 1 a a -23 Y y {} C c {} U u}
824 SELECT a,b,c FROM t1 UNION SELECT x,y,z FROM t2
825 ORDER BY a,c,b
827 } {{} C c {} U u -23 Y y 1 a a 9.9 b B 5200000.0 X x hello d D mad Z z abc e e hare m M}
830 SELECT a,b,c FROM t1 UNION SELECT x,y,z FROM t2
831 ORDER BY b,a,c
833 } {{} C c {} U u 5200000.0 X x -23 Y y mad Z z 1 a a 9.9 b B hello d D abc e e hare m M}
836 SELECT a,b,c FROM t1 UNION SELECT x,y,z FROM t2
837 ORDER BY b COLLATE NOCASE,a,c
839 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
842 SELECT a,b,c FROM t1 UNION SELECT x,y,z FROM t2
843 ORDER BY b COLLATE NOCASE DESC,a,c
845 } {mad Z z -23 Y y 5200000.0 X x {} U u hare m M abc e e hello d D {} C c 9.9 b B 1 a a}
848 SELECT a,b,c FROM t1 UNION SELECT x,y,z FROM t2
849 ORDER BY c,b,a
851 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
854 SELECT a,b,c FROM t1 UNION SELECT x,y,z FROM t2
855 ORDER BY c,a,b
857 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
860 SELECT a,b,c FROM t1 UNION SELECT x,y,z FROM t2
861 ORDER BY c DESC,a,b
863 } {mad Z z -23 Y y 5200000.0 X x {} U u hare m M abc e e hello d D {} C c 9.9 b B 1 a a}
866 SELECT a,b,c FROM t1 UNION SELECT x,y,z FROM t2
867 ORDER BY c COLLATE BINARY DESC,a,b
869 } {mad Z z -23 Y y 5200000.0 X x {} U u abc e e {} C c 1 a a hare m M hello d D 9.9 b B}
872 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t1
873 ORDER BY a,b,c
875 } {{} C c {} U u -23 Y y 1 a a 9.9 b B 5200000.0 X x hello d D mad Z z abc e e hare m M}
878 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t1
879 ORDER BY a DESC,b,c
881 } {hare m M abc e e mad Z z hello d D 5200000.0 X x 9.9 b B 1 a a -23 Y y {} C c {} U u}
884 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t1
885 ORDER BY a,c,b
887 } {{} C c {} U u -23 Y y 1 a a 9.9 b B 5200000.0 X x hello d D mad Z z abc e e hare m M}
890 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t1
891 ORDER BY b,a,c
893 } {{} C c {} U u 5200000.0 X x -23 Y y mad Z z 1 a a 9.9 b B hello d D abc e e hare m M}
896 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t1
899 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
902 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t1
905 } {mad Z z -23 Y y 5200000.0 X x {} U u hare m M abc e e hello d D {} C c 9.9 b B 1 a a}
908 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t1
909 ORDER BY c,b,a
911 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
914 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t1
915 ORDER BY c,a,b
917 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
920 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t1
921 ORDER BY c DESC,a,b
923 } {mad Z z -23 Y y 5200000.0 X x {} U u hare m M abc e e hello d D {} C c 9.9 b B 1 a a}
926 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t1
929 } {mad Z z -23 Y y 5200000.0 X x {} U u abc e e {} C c 1 a a hare m M hello d D 9.9 b B}
932 SELECT a,b,c FROM t1 EXCEPT SELECT a,b,c FROM t1 WHERE b>='d'
933 ORDER BY a,b,c
935 } {{} C c 1 a a 9.9 b B}
938 SELECT a,b,c FROM t1 INTERSECT SELECT a,b,c FROM t1 WHERE b>='d'
939 ORDER BY a,b,c
944 SELECT a,b,c FROM t1 WHERE b>='d' INTERSECT SELECT a,b,c FROM t1
945 ORDER BY a,b,c
950 SELECT a,b,c FROM t1 EXCEPT SELECT a,b,c FROM t1 WHERE b<'d'
951 ORDER BY a,b,c
956 SELECT a,b,c FROM t1 INTERSECT SELECT a,b,c FROM t1 WHERE b<'d'
957 ORDER BY a,b,c
959 } {{} C c 1 a a 9.9 b B}
962 SELECT a,b,c FROM t1 WHERE b<'d' INTERSECT SELECT a,b,c FROM t1
963 ORDER BY a,b,c
965 } {{} C c 1 a a 9.9 b B}
968 SELECT a,b,c FROM t1 EXCEPT SELECT a,b,c FROM t1 WHERE b>='d'
969 ORDER BY a DESC
971 } {9.9 b B 1 a a {} C c}
974 SELECT a,b,c FROM t1 INTERSECT SELECT a,b,c FROM t1 WHERE b>='d'
975 ORDER BY a DESC
980 SELECT a,b,c FROM t1 WHERE b>='d' INTERSECT SELECT a,b,c FROM t1
981 ORDER BY a DESC
986 SELECT a,b,c FROM t1 EXCEPT SELECT a,b,c FROM t1 WHERE b<'d'
987 ORDER BY a DESC
992 SELECT a,b,c FROM t1 INTERSECT SELECT a,b,c FROM t1 WHERE b<'d'
993 ORDER BY a DESC
995 } {9.9 b B 1 a a {} C c}
998 SELECT a,b,c FROM t1 WHERE b<'d' INTERSECT SELECT a,b,c FROM t1
999 ORDER BY a DESC
1001 } {9.9 b B 1 a a {} C c}
1004 SELECT a,b,c FROM t1 EXCEPT SELECT a,b,c FROM t1 WHERE b>='d'
1005 ORDER BY b, a DESC
1007 } {{} C c 1 a a 9.9 b B}
1010 SELECT a,b,c FROM t1 INTERSECT SELECT a,b,c FROM t1 WHERE b>='d'
1016 SELECT a,b,c FROM t1 WHERE b>='d' INTERSECT SELECT a,b,c FROM t1
1022 SELECT a,b,c FROM t1 EXCEPT SELECT a,b,c FROM t1 WHERE b<'d'
1023 ORDER BY b, c DESC, a
1028 SELECT a,b,c FROM t1 INTERSECT SELECT a,b,c FROM t1 WHERE b<'d'
1031 } {1 a a 9.9 b B {} C c}
1034 SELECT a,b,c FROM t1 WHERE b<'d' INTERSECT SELECT a,b,c FROM t1
1037 } {{} C c 1 a a 9.9 b B}
1040 SELECT a,b,c FROM t1 EXCEPT SELECT a,b,c FROM t1 WHERE b>='d'
1041 ORDER BY c, a DESC
1043 } {1 a a 9.9 b B {} C c}
1046 SELECT a,b,c FROM t1 INTERSECT SELECT a,b,c FROM t1 WHERE b>='d'
1052 SELECT a,b,c FROM t1 WHERE b>='d' INTERSECT SELECT a,b,c FROM t1
1053 ORDER BY c COLLATE BINARY, b DESC, c, a, b, c, a, b, c
1058 SELECT a,b,c FROM t1 EXCEPT SELECT a,b,c FROM t1 WHERE b<'d'
1059 ORDER BY c DESC, a
1064 SELECT a,b,c FROM t1 INTERSECT SELECT a,b,c FROM t1 WHERE b<'d'
1067 } {1 a a 9.9 b B {} C c}
1070 SELECT a,b,c FROM t1 WHERE b<'d' INTERSECT SELECT a,b,c FROM t1
1073 } {1 a a 9.9 b B {} C c}
1076 SELECT a,b,c FROM t3 INTERSECT SELECT a,b,c FROM t1 WHERE b<'d'
1079 } {1 a a 9.9 b B {} C c}
1082 SELECT a,b,c FROM t1 WHERE b<'d' INTERSECT SELECT a,b,c FROM t3
1085 } {1 a a 9.9 b B {} C c}
1088 SELECT a,b,c FROM t1 EXCEPT SELECT a,b,c FROM t3 WHERE b<'d'
1089 ORDER BY c DESC, a
1094 SELECT a,b,c FROM t1 EXCEPT SELECT a,b,c FROM t1 WHERE b<'d'
1095 INTERSECT SELECT a,b,c FROM t3
1096 EXCEPT SELECT b,c,a FROM t3
1097 ORDER BY c DESC, a
1102 SELECT a,b,c FROM t1 INTERSECT SELECT a,b,c FROM t1 WHERE b<'d'
1103 INTERSECT SELECT a,b,c FROM t3
1104 EXCEPT SELECT b,c,a FROM t3
1107 } {1 a a 9.9 b B {} C c}
1110 SELECT a,b,c FROM t1 WHERE b<'d' INTERSECT SELECT a,b,c FROM t1
1111 INTERSECT SELECT a,b,c FROM t3
1112 EXCEPT SELECT b,c,a FROM t3
1115 } {1 a a 9.9 b B {} C c}
1118 SELECT a,b,c FROM t1 WHERE b<'d'
1119 INTERSECT SELECT a,b,c FROM t1
1120 INTERSECT SELECT a,b,c FROM t3
1121 EXCEPT SELECT b,c,a FROM t3
1122 INTERSECT SELECT a,b,c FROM t1
1124 INTERSECT SELECT a,b,c FROM t3
1126 INTERSECT SELECT a,b,c FROM t1
1127 EXCEPT SELECT c,b,a FROM t3
1130 } {1 a a 9.9 b B {} C c}
1133 SELECT a,b,c FROM t3 UNION SELECT x,y,z FROM t2
1134 ORDER BY a,b,c
1136 } {{} C c {} U u -23 Y y 1 a a 9.9 b B 5200000.0 X x hello d D mad Z z abc e e hare m M}
1139 SELECT a,b,c FROM t3 UNION SELECT x,y,z FROM t2
1140 ORDER BY a DESC,b,c
1142 } {hare m M abc e e mad Z z hello d D 5200000.0 X x 9.9 b B 1 a a -23 Y y {} C c {} U u}
1145 SELECT a,b,c FROM t3 UNION SELECT x,y,z FROM t2
1146 ORDER BY a,c,b
1148 } {{} C c {} U u -23 Y y 1 a a 9.9 b B 5200000.0 X x hello d D mad Z z abc e e hare m M}
1151 SELECT a,b,c FROM t3 UNION SELECT x,y,z FROM t2
1152 ORDER BY b,a,c
1154 } {{} C c {} U u 5200000.0 X x -23 Y y mad Z z 1 a a 9.9 b B hello d D abc e e hare m M}
1157 SELECT a,b,c FROM t3 UNION SELECT x,y,z FROM t2
1158 ORDER BY b COLLATE NOCASE,a,c
1160 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
1163 SELECT a,b,c FROM t3 UNION SELECT x,y,z FROM t2
1164 ORDER BY b COLLATE NOCASE DESC,a,c
1166 } {mad Z z -23 Y y 5200000.0 X x {} U u hare m M abc e e hello d D {} C c 9.9 b B 1 a a}
1169 SELECT a,b,c FROM t3 UNION SELECT x,y,z FROM t2
1170 ORDER BY c,b,a
1172 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
1175 SELECT a,b,c FROM t3 UNION SELECT x,y,z FROM t2
1176 ORDER BY c,a,b
1178 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
1181 SELECT a,b,c FROM t3 UNION SELECT x,y,z FROM t2
1182 ORDER BY c DESC,a,b
1184 } {mad Z z -23 Y y 5200000.0 X x {} U u hare m M abc e e hello d D {} C c 9.9 b B 1 a a}
1187 SELECT a,b,c FROM t3 UNION SELECT x,y,z FROM t2
1188 ORDER BY c COLLATE BINARY DESC,a,b
1190 } {mad Z z -23 Y y 5200000.0 X x {} U u abc e e {} C c 1 a a hare m M hello d D 9.9 b B}
1193 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t3
1194 ORDER BY a,b,c
1196 } {{} C c {} U u -23 Y y 1 a a 9.9 b B 5200000.0 X x hello d D mad Z z abc e e hare m M}
1199 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t3
1200 ORDER BY a DESC,b,c
1202 } {hare m M abc e e mad Z z hello d D 5200000.0 X x 9.9 b B 1 a a -23 Y y {} C c {} U u}
1205 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t3
1206 ORDER BY a,c,b
1208 } {{} C c {} U u -23 Y y 1 a a 9.9 b B 5200000.0 X x hello d D mad Z z abc e e hare m M}
1211 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t3
1212 ORDER BY b,a,c
1214 } {{} C c {} U u 5200000.0 X x -23 Y y mad Z z 1 a a 9.9 b B hello d D abc e e hare m M}
1217 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t3
1220 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
1223 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t3
1226 } {mad Z z -23 Y y 5200000.0 X x {} U u hare m M abc e e hello d D {} C c 9.9 b B 1 a a}
1229 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t3
1230 ORDER BY c,b,a
1232 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
1235 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t3
1236 ORDER BY c,a,b
1238 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z}
1241 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t3
1242 ORDER BY c DESC,a,b
1244 } {mad Z z -23 Y y 5200000.0 X x {} U u hare m M abc e e hello d D {} C c 9.9 b B 1 a a}
1247 SELECT x,y,z FROM t2 UNION SELECT a,b,c FROM t3
1250 } {mad Z z -23 Y y 5200000.0 X x {} U u abc e e {} C c 1 a a hare m M hello d D 9.9 b B}
1254 INTERSECT SELECT a,b,c FROM t3
1255 EXCEPT SELECT c,b,a FROM t1
1256 UNION SELECT a,b,c FROM t3
1257 INTERSECT SELECT a,b,c FROM t3
1258 EXCEPT SELECT c,b,a FROM t1
1259 UNION SELECT a,b,c FROM t3
1262 } {mad Z z -23 Y y 5200000.0 X x {} U u hare m M abc e e hello d D {} C c 9.9 b B 1 a a}
1272 } {a}
1287 INTERSECT SELECT a,b,c FROM t3
1288 EXCEPT SELECT c,b,a FROM t1
1289 UNION SELECT a,b,c FROM t3
1290 INTERSECT SELECT a,b,c FROM t3
1291 EXCEPT SELECT c,b,a FROM t1
1292 UNION SELECT a,b,c FROM t3
1301 INTERSECT SELECT a,b,c FROM t3
1302 EXCEPT SELECT c,b,a FROM t1
1303 UNION SELECT a,b,c FROM t3
1304 INTERSECT SELECT a,b,c FROM t3
1305 EXCEPT SELECT c,b,a FROM t1
1306 UNION SELECT a,b,c FROM t3
1315 # At one point the following code exposed a temp register reuse problem.
1321 CREATE TABLE t4(a, b);
1329 CREATE INDEX i1 ON t4(a);
1336 SELECT a, b FROM t4 WHERE f()==f()
1352 SELECT a, b FROM t4 WHERE f()==f()
1359 CREATE TABLE t6(a, b);
1369 CREATE INDEX i6 ON t6(a);
1376 SELECT a, b FROM t6
1396 CREATE TABLE t8(a, b);
1401 SELECT a, b FROM t8 INTERSECT SELECT c, d FROM t9 ORDER BY a;
1403 SELECT a, b FROM t8 INTERSECT SELECT c, d FROM t9 ORDER BY t8.a;
1405 SELECT a, b FROM t8 INTERSECT SELECT c, d FROM t9 ORDER BY 1;
1407 SELECT a, b FROM t8 INTERSECT SELECT c, d FROM t9 ORDER BY c;
1409 SELECT a, b FROM t8 INTERSECT SELECT c, d FROM t9 ORDER BY t9.c;
1413 SELECT a, b FROM t8 UNION SELECT c, d FROM t9 ORDER BY a COLLATE NOCASE
1415 SELECT a, b FROM t8 UNION SELECT c, d FROM t9 ORDER BY t8.a COLLATE NOCASE
1417 SELECT a, b FROM t8 UNION SELECT c, d FROM t9 ORDER BY 1 COLLATE NOCASE
1419 SELECT a, b FROM t8 UNION SELECT c, d FROM t9 ORDER BY c COLLATE NOCASE
1421 SELECT a, b FROM t8 UNION SELECT c, d FROM t9 ORDER BY t9.c COLLATE NOCASE
1425 SELECT a, b FROM t8 EXCEPT SELECT c, d FROM t9 ORDER BY b, c COLLATE NOCASE
1427 SELECT a, b FROM t8 EXCEPT SELECT c, d FROM t9 ORDER BY 2, 1 COLLATE NOCASE
1429 SELECT a, b FROM t8 EXCEPT SELECT c, d FROM t9 ORDER BY d, a COLLATE NOCASE
1431 SELECT a, b FROM t8 EXCEPT SELECT * FROM t9 ORDER BY t9.d, c COLLATE NOCASE
1433 SELECT * FROM t8 EXCEPT SELECT c, d FROM t9 ORDER BY d, t8.a COLLATE NOCASE
1437 SELECT * FROM t8 UNION SELECT * FROM t9 ORDER BY a+b COLLATE NOCASE
1443 CREATE TABLE t1(a INTEGER);
1446 SELECT * FROM (SELECT a FROM t1 UNION SELECT b FROM t2) WHERE a=a;
1466 CREATE TABLE a(b);
1467 CREATE VIEW c(d) AS SELECT b FROM a ORDER BY b;
1468 …SELECT sum(d) OVER( PARTITION BY(SELECT 0 FROM c JOIN a WHERE b =(SELECT b INTERSECT SELECT d FROM…
1475 CREATE TABLE t1(a, b, c, d);
1476 CREATE INDEX t1a ON t1(a);
1482 WHERE (a=? OR b=?)
1483 AND (0 OR (SELECT 'xyz' INTERSECT SELECT a ORDER BY 1))
1491 CREATE TABLE t1(a COLLATE nocase);
1499 SELECT a FROM t1 INTERSECT SELECT b FROM t2;
1504 SELECT a FROM t1 INTERSECT SELECT b FROM t2
1505 ) WHERE a||'' = 'ABC';