/external/chromium_org/third_party/sqlite/src/test/ |
D | tkt1473.test | 36 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 …]
|
D | shared4.test | 78 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 …]
|
D | selectB.test | 71 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 …]
|
D | select4.test | 12 # 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 …]
|
D | tkt2927.test | 43 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 …]
|
D | tkt-38cb5df375.test | 33 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 …]
|
D | tkt2339.test | 38 UNION 45 UNION ALL 52 UNION ALL 59 UNION ALL 66 UNION 80 UNION 87 UNION 94 UNION
|
D | selectA.test | 15 # 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 …]
|
D | select9.test | 97 # 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 …]
|
D | tkt1444.test | 25 # 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;
|
D | e_select.test | 264 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 …]
|
D | tkt2822.test | 84 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 …]
|
D | eqp.test | 83 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 …]
|
D | collate5.test | 13 # 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 …]
|
D | limit.test | 257 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 …]
|
D | e_delete.test | 179 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 …]
|
D | sort.test | 303 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;
|
D | fuzz2.test | 93 …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…
|
D | fts3cov.test | 158 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 …]
|
D | select7.test | 49 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}
|
D | where9.test | 483 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 …]
|
D | vtab_shared.test | 130 SELECT * FROM t1 UNION ALL 131 SELECT * FROM t2 UNION ALL 139 SELECT * FROM t1 UNION ALL 140 SELECT * FROM t2 UNION ALL
|
D | alias.test | 119 SELECT 4 UNION SELECT 1 ORDER BY 1 124 SELECT 4 UNION SELECT 1 UNION SELECT 9 ORDER BY 1
|
D | fuzz.test | 136 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/ |
D | static-assert.c | 31 #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}}
|