Home
last modified time | relevance | path

Searched refs:UNION (Results 1 – 25 of 117) sorted by relevance

12345

/external/chromium_org/third_party/sqlite/src/test/
Dtkt1473.test36 SELECT 1 FROM t1 WHERE a=1 UNION ALL SELECT 2 FROM t1 WHERE b=0
41 SELECT 1 FROM t1 WHERE a=1 UNION SELECT 2 FROM t1 WHERE b=0
46 SELECT 1 FROM t1 WHERE a=1 UNION ALL SELECT 2 FROM t1 WHERE b=4
51 SELECT 1 FROM t1 WHERE a=1 UNION SELECT 2 FROM t1 WHERE b=4
56 SELECT 1 FROM t1 WHERE a=0 UNION ALL SELECT 2 FROM t1 WHERE b=4
61 SELECT 1 FROM t1 WHERE a=0 UNION SELECT 2 FROM t1 WHERE b=4
66 SELECT 1 FROM t1 WHERE a=0 UNION ALL SELECT 2 FROM t1 WHERE b=0
71 SELECT 1 FROM t1 WHERE a=0 UNION SELECT 2 FROM t1 WHERE b=0
84 SELECT (SELECT 1 FROM t1 WHERE a=1 UNION ALL SELECT 2 FROM t1 WHERE b=0)
89 SELECT (SELECT 1 FROM t1 WHERE a=1 UNION SELECT 2 FROM t1 WHERE b=0)
[all …]
Dshared4.test78 SELECT a FROM t1 UNION ALL
79 SELECT b FROM t2 UNION ALL
80 SELECT c FROM t3 UNION ALL
86 SELECT a FROM t1 UNION ALL
87 SELECT b FROM t2 UNION ALL
88 SELECT d FROM t4 UNION ALL
94 SELECT a FROM t1 UNION ALL
95 SELECT c FROM t3 UNION ALL
96 SELECT b FROM t2 UNION ALL
102 SELECT a FROM t1 UNION ALL
[all …]
DselectB.test71 SELECT * FROM (SELECT a FROM t1 UNION ALL SELECT d FROM t2)
73 SELECT a FROM t1 UNION ALL SELECT d FROM t2
77 SELECT * FROM (SELECT a FROM t1 UNION ALL SELECT d FROM t2) ORDER BY 1
79 SELECT a FROM t1 UNION ALL SELECT d FROM t2 ORDER BY 1
84 (SELECT a FROM t1 UNION ALL SELECT d FROM t2)
87 SELECT a FROM t1 WHERE a>10 UNION ALL SELECT d FROM t2 WHERE d>10 ORDER BY 1
92 (SELECT a FROM t1 UNION ALL SELECT d FROM t2)
96 UNION ALL
103 (SELECT a FROM t1 UNION ALL SELECT d FROM t2 WHERE d > 12)
107 UNION ALL
[all …]
Dselect4.test12 # focus of this file is testing UNION, INTERSECT and EXCEPT operators
54 UNION ALL
63 UNION ALL
74 UNION ALL
84 UNION ALL
92 UNION ALL
102 (SELECT DISTINCT log FROM t1 UNION ALL
111 UNION ALL
116 } {1 {ORDER BY clause should come after UNION ALL not before}}
123 UNION
[all …]
Dtkt2927.test43 UNION ALL
51 UNION ALL
58 UNION ALL
65 UNION ALL
72 UNION ALL
79 UNION ALL
86 UNION ALL
93 UNION ALL
100 UNION ALL
107 UNION ALL
[all …]
Dtkt-38cb5df375.test33 UNION ALL SELECT 9 FROM (SELECT a FROM t1)
42 UNION ALL SELECT a FROM (SELECT a FROM t1 ORDER BY a)
51 UNION ALL SELECT a FROM (SELECT a FROM t1 ORDER BY a)
60 UNION ALL SELECT 9 FROM (SELECT a FROM t1)
69 UNION SELECT 9 FROM (SELECT a FROM t1)
79 UNION ALL SELECT 9 FROM (SELECT a FROM t1)
88 UNION ALL SELECT a FROM (SELECT a FROM t1 ORDER BY a LIMIT 3)
97 UNION ALL SELECT a FROM (SELECT a FROM t1 ORDER BY a LIMIT 3)
106 UNION ALL SELECT 9 FROM (SELECT a FROM t1 LIMIT 3)
116 UNION ALL SELECT 9 FROM (SELECT a FROM t1)
[all …]
Dtkt2339.test38 UNION
45 UNION ALL
52 UNION ALL
59 UNION ALL
66 UNION
80 UNION
87 UNION
94 UNION
DselectA.test15 # possible combinations of UNION, UNION ALL, EXCEPT, and
67 SELECT a,b,c FROM t1 UNION ALL SELECT x,y,z FROM t2
73 SELECT t1.a, t1.b, t1.c FROM t1 UNION ALL SELECT x,y,z FROM t2
79 SELECT a,b,c FROM t1 UNION ALL SELECT x,y,z FROM t2
85 SELECT a,b,c FROM t1 UNION ALL SELECT x,y,z FROM t2
91 SELECT a,b,c FROM t1 UNION ALL SELECT x,y,z FROM t2
97 SELECT a,b,c FROM t1 UNION ALL SELECT x,y,z FROM t2
103 SELECT a,b,c FROM t1 UNION ALL SELECT x,y,z FROM t2
109 SELECT a,b,c FROM t1 UNION ALL SELECT x,y,z FROM t2
115 SELECT a,b,c FROM t1 UNION ALL SELECT x,y,z FROM t2
[all …]
Dselect9.test97 # and <compound op> is one of "INTERSECT", "UNION ALL" or "UNION".
107 set RE {(.*)(UNION ALL|INTERSECT|UNION)(.*)(ORDER BY.*)}
174 # Test some 2-way UNION ALL queries. No WHERE clauses.
177 SELECT a, b FROM t1 UNION ALL SELECT d, e FROM t2
180 SELECT a, b FROM t1 UNION ALL SELECT d, e FROM t2 ORDER BY 1
183 SELECT a, b FROM t1 UNION ALL SELECT d, e FROM t2 ORDER BY 2
186 SELECT a, b FROM t1 UNION ALL SELECT d, e FROM t2 ORDER BY 1, 2
189 SELECT a, b FROM t1 UNION ALL SELECT d, e FROM t2 ORDER BY 2, 1
192 # Test some 2-way UNION queries.
195 SELECT a, b FROM t1 UNION SELECT d, e FROM t2
[all …]
Dtkt1444.test25 # The use of a VIEW that contained an ORDER BY clause within a UNION ALL
35 SELECT * FROM DemoTable UNION ALL SELECT * FROM DemoView ORDER BY 1;
40 SELECT * FROM DemoTable UNION ALL SELECT * FROM DemoView;
47 SELECT * FROM DemoTable UNION ALL SELECT * FROM DemoView ORDER BY 1;
52 SELECT * FROM DemoTable UNION ALL SELECT * FROM DemoView;
De_select.test264 1 "SELECT rowid FROM t1 UNION ALL SELECT rowid+2 FROM t4" {1 2 3 3 4}
265 2 "SELECT rowid FROM t1 UNION SELECT rowid+2 FROM t4" {1 2 3 4}
294 10 "SELECT * FROM t1 UNION SELECT b, a FROM t1"
296 11 "SELECT * FROM t1 UNION SELECT b, a FROM t1 ORDER BY b"
298 12 "SELECT * FROM t1 UNION SELECT b, a FROM t1 ORDER BY b, a"
300 13 "SELECT * FROM t1 UNION SELECT b, a FROM t1 LIMIT 10"
302 14 "SELECT * FROM t1 UNION SELECT b, a FROM t1 LIMIT 10 OFFSET 5"
304 15 "SELECT * FROM t1 UNION SELECT b, a FROM t1 LIMIT 10, 5"
306 16 "SELECT * FROM t1 UNION SELECT b, a FROM t1 ORDER BY a LIMIT 10"
308 17 "SELECT * FROM t1 UNION SELECT b, a FROM t1 ORDER BY b LIMIT 10 OFFSET 5"
[all …]
Dtkt2822.test84 SELECT a, b, c FROM t1 UNION ALL SELECT a, b, c FROM t2 ORDER BY 1;
90 UNION ALL
100 SELECT a, b, c FROM t1 UNION ALL SELECT a, b, c FROM t2 ORDER BY a;
107 UNION ALL
114 SELECT t1.a, b, c FROM t1 UNION ALL SELECT t2.a, b, c FROM t2 ORDER BY a;
123 UNION ALL
130 SELECT t1.a, b, c FROM t1 UNION ALL SELECT t2.a, b, c FROM t2 ORDER BY t1.a;
139 SELECT a, b, c FROM t1 UNION ALL SELECT a AS x, b, c FROM t2 ORDER BY x;
146 UNION ALL
154 UNION ALL
[all …]
Deqp.test83 SELECT * FROM t3 JOIN (SELECT 1 UNION SELECT 2)
85 1 0 0 {COMPOUND SUBQUERIES 2 AND 3 USING TEMP B-TREE (UNION)}
107 SELECT * FROM t3 JOIN (SELECT 1 UNION ALL SELECT a FROM t3 LIMIT 17)
110 1 0 0 {COMPOUND SUBQUERIES 2 AND 3 (UNION ALL)}
254 SELECT * FROM t1 UNION ALL SELECT * FROM t2
258 0 0 0 {COMPOUND SUBQUERIES 1 AND 2 (UNION ALL)}
261 SELECT * FROM t1 UNION ALL SELECT * FROM t2 ORDER BY 2
267 0 0 0 {COMPOUND SUBQUERIES 1 AND 2 (UNION ALL)}
270 SELECT * FROM t1 UNION SELECT * FROM t2 ORDER BY 2
276 0 0 0 {COMPOUND SUBQUERIES 1 AND 2 (UNION)}
[all …]
Dcollate5.test13 # focus of this file is testing DISTINCT, UNION, INTERSECT and EXCEPT
103 # Tests named collate5-2.* focus on UNION, EXCEPT and INTERSECT
106 # collate5-2.1.* - UNION
123 SELECT a FROM collate5t1 UNION select a FROM collate5t2;
128 SELECT a FROM collate5t2 UNION select a FROM collate5t1;
133 SELECT a, b FROM collate5t1 UNION select a, b FROM collate5t2;
138 SELECT a, b FROM collate5t2 UNION select a, b FROM collate5t1;
186 # This test ensures performs a UNION operation with a bunch of different
208 SELECT * FROM collate5t3 UNION SELECT * FROM collate5t3;
222 SELECT a FROM collate5t1 UNION ALL SELECT a FROM collate5t2 ORDER BY 1;
[all …]
Dlimit.test257 SELECT x FROM t2 LIMIT 5 UNION ALL SELECT a FROM t6;
259 } {1 {LIMIT clause should come after UNION ALL not before}}
262 SELECT x FROM t2 LIMIT 5 UNION SELECT a FROM t6;
264 } {1 {LIMIT clause should come after UNION not before}}
277 SELECT x FROM t2 UNION ALL SELECT a FROM t6 LIMIT 5;
282 SELECT x FROM t2 UNION ALL SELECT a FROM t6 LIMIT 3 OFFSET 1;
287 SELECT x FROM t2 UNION ALL SELECT a FROM t6 ORDER BY 1 LIMIT 3 OFFSET 1;
292 SELECT x FROM t2 UNION SELECT x+2 FROM t2 LIMIT 2 OFFSET 1;
297 SELECT x FROM t2 UNION SELECT x+2 FROM t2 ORDER BY 1 DESC LIMIT 2 OFFSET 1;
379 UNION
[all …]
De_delete.test179 UNION ALL
190 UNION ALL
192 UNION ALL
194 UNION ALL
215 SELECT count(*) FROM temp.t7 UNION ALL SELECT count(*) FROM main.t7 UNION ALL
216 SELECT count(*) FROM aux.t7 UNION ALL SELECT count(*) FROM aux2.t7;
218 SELECT count(*) FROM main.t8 UNION ALL SELECT count(*) FROM aux.t8
219 UNION ALL SELECT count(*) FROM aux2.t8;
221 SELECT count(*) FROM aux.t9 UNION ALL SELECT count(*) FROM aux2.t9;
235 SELECT count(*) FROM temp.t7 UNION ALL SELECT count(*) FROM main.t7 UNION ALL
[all …]
Dsort.test303 SELECT a FROM t4 UNION SELECT a FROM v4 ORDER BY 1;
308 SELECT b FROM t4 UNION SELECT a FROM v4 ORDER BY 1;
313 SELECT a FROM t4 UNION SELECT b FROM v4 ORDER BY 1;
318 SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1;
327 # SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE numeric;
332 # SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE integer;
337 # SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE text;
342 # SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE blob;
347 # SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE clob;
352 # SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE varchar;
Dfuzz2.test93 …RDER BY "AAAAAA" . AAAAAA ASC , NULL IN ( SELECT UNION ALL SELECT ALL WHERE HAVING ORDER BY LIMIT
96 …RDER BY "AAAAAA" . AAAAAA ASC , NULL IN ( SELECT UNION ALL SELECT ALL WHERE HAVING ORDER BY LIMIT
99 … AAAAAA . "AAAAAA" ASC LIMIT AAAAAA . "AAAAAA" , RAISE ( ABORT , AAAAAA ) UNION ALL SELECT DISTINC…
Dfts3cov.test158 SELECT 1, 'Then Christabel stretched forth her hand,' UNION ALL
159 SELECT 3, 'And comforted fair Geraldine:' UNION ALL
160 SELECT 4, '''O well, bright dame, may you command' UNION ALL
161 SELECT 5, 'The service of Sir Leoline;' UNION ALL
162 SELECT 2, 'And gladly our stout chivalry' UNION ALL
163 SELECT 7, 'Will he send forth, and friends withal,' UNION ALL
164 SELECT 8, 'To guide and guard you safe and free' UNION ALL
194 SELECT 'ItisanancientMarinerAndhestoppethoneofthreeAA' UNION ALL
195 SELECT 'ItisanancientMarinerAndhestoppethoneofthreeBB' UNION ALL
196 SELECT 'ItisanancientMarinerAndhestoppethoneofthreeCC' UNION ALL
[all …]
Dselect7.test49 CREATE VIEW tv2 AS SELECT * FROM tv1 UNION SELECT * FROM tv1b;
126 SELECT 5 IN (SELECT a,b FROM t2 UNION SELECT b,a FROM t2);
132 SELECT 5 IN (SELECT * FROM t2 UNION SELECT * FROM t2);
146 append sql " UNION ALL SELECT $i"
152 append sql { UNION ALL SELECT 99999999}
Dwhere9.test483 db eval {SELECT count(*) FROM t1 UNION ALL SELECT a FROM t1 WHERE a>=85}
498 SELECT count(*) FROM t1 UNION ALL
516 SELECT count(*) FROM t1 UNION ALL
536 SELECT count(*) FROM t1 UNION ALL
555 SELECT count(*) FROM t1 UNION ALL SELECT a FROM t1 WHERE a>=85;
571 SELECT count(*) FROM t1 UNION ALL
588 SELECT count(*) FROM t1 UNION ALL
605 SELECT count(*) FROM t1 UNION ALL
622 SELECT count(*) FROM t1 UNION ALL
638 SELECT count(*) FROM t1 UNION ALL
[all …]
Dvtab_shared.test130 SELECT * FROM t1 UNION ALL
131 SELECT * FROM t2 UNION ALL
139 SELECT * FROM t1 UNION ALL
140 SELECT * FROM t2 UNION ALL
Dalias.test119 SELECT 4 UNION SELECT 1 ORDER BY 1
124 SELECT 4 UNION SELECT 1 UNION SELECT 9 ORDER BY 1
Dfuzz.test136 SELECT 1 IN ( SELECT b UNION SELECT 1 ) FROM (SELECT b FROM abc);
153 SELECT 'abcd' UNION SELECT 'efgh' ORDER BY 1 ASC, 1 ASC;
168 GROUP BY c HAVING EXISTS (SELECT a UNION SELECT 123);
210 SELECT DISTINCT 2147483647 UNION ALL SELECT -2147483648
231 UNION ALL
234 UNION ALL
/external/clang/test/Sema/
Dstatic-assert.c31 #define UNION(T1, T2) union { \ macro
39 typedef UNION(unsigned, struct A) U1;
40 UNION(char[2], short) u2 = { .one = { 'a', 'b' } };
41 typedef UNION(char, short) U3; // expected-error {{static_assert failed "type size mismatch"}}
42 typedef UNION(float, 0.5f) U4; // expected-error {{expected a type}}

12345