Lines Matching refs:z

44     CREATE TABLE t2(x,y,z COLLATE NOCASE);
46     INSERT INTO t2 VALUES('mad', 'Z', 'z');
52 } {{} U u mad Z z hare m M 5200000.0 X x -23 Y y}
68     SELECT a,b,c FROM t1 UNION ALL SELECT x,y,z FROM t2
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
285     ORDER BY y COLLATE NOCASE,x,z
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
291     ORDER BY y COLLATE NOCASE DESC,x,z
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
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
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
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
315     ORDER BY z COLLATE BINARY DESC,x,y
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}
511     EXCEPT SELECT x,y,z FROM t2
513     EXCEPT SELECT y,x,z FROM t2
521     SELECT a,b,c FROM t3 UNION SELECT x,y,z FROM t2
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
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
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
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
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
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
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
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
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
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
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
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
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
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
606     ORDER BY y COLLATE NOCASE,x,z
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
612     ORDER BY y COLLATE NOCASE DESC,x,z
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
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
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
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
636     ORDER BY z COLLATE BINARY DESC,x,y
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}
641     SELECT x,y,z FROM t2
648     ORDER BY y COLLATE NOCASE DESC,x,z
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}
653     SELECT upper((SELECT c FROM t1 UNION SELECT z FROM t2 ORDER BY 1));
658     SELECT lower((SELECT c FROM t1 UNION ALL SELECT z FROM t2 ORDER BY 1));
663     SELECT lower((SELECT c FROM t1 INTERSECT SELECT z FROM t2 ORDER BY 1));
668     SELECT lower((SELECT z FROM t2 EXCEPT SELECT c FROM t1 ORDER BY 1));
680     CREATE UNIQUE INDEX t2z ON t2(z);
686     SELECT a,b,c FROM t1 UNION ALL SELECT x,y,z FROM t2
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
897     ORDER BY y COLLATE NOCASE,x,z
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
903     ORDER BY y COLLATE NOCASE DESC,x,z
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
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
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
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
927     ORDER BY z COLLATE BINARY DESC,x,y
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}
1123     EXCEPT SELECT x,y,z FROM t2
1125     EXCEPT SELECT y,x,z FROM t2
1133     SELECT a,b,c FROM t3 UNION SELECT x,y,z FROM t2
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1218     ORDER BY y COLLATE NOCASE,x,z
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
1224     ORDER BY y COLLATE NOCASE DESC,x,z
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
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
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
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
1248     ORDER BY z COLLATE BINARY DESC,x,y
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}
1253     SELECT x,y,z FROM t2
1260     ORDER BY y COLLATE NOCASE DESC,x,z
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}
1265     SELECT upper((SELECT c FROM t1 UNION SELECT z FROM t2 ORDER BY 1));
1270     SELECT lower((SELECT c FROM t1 UNION ALL SELECT z FROM t2 ORDER BY 1));
1275     SELECT lower((SELECT c FROM t1 INTERSECT SELECT z FROM t2 ORDER BY 1));
1280     SELECT lower((SELECT z FROM t2 EXCEPT SELECT c FROM t1 ORDER BY 1));
1286       SELECT x,y,z FROM t2
1293       ORDER BY y COLLATE NOCASE DESC,x,z)))
1300         SELECT x,y,z FROM t2
1307         ORDER BY y COLLATE NOCASE DESC,x,z)))