Searched refs:UNION (Results 1 – 25 of 25) sorted by relevance
/illumos-gate/usr/src/lib/libsqlite/test/ |
H A D | select4.test | 50 UNION ALL 59 UNION ALL 70 UNION ALL 80 UNION ALL 105 UNION ALL 117 UNION 133 UNION 378 UNION 386 UNION 397 SELECT NULL UNION SELECT NULL UNION [all …]
|
H A D | sort.test | 302 SELECT a FROM t4 UNION SELECT a FROM v4 ORDER BY 1; 307 SELECT b FROM t4 UNION SELECT a FROM v4 ORDER BY 1; 312 SELECT a FROM t4 UNION SELECT b FROM v4 ORDER BY 1; 317 SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1; 322 SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE numeric; 327 SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE integer; 332 SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE text; 337 SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE blob; 342 SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE clob; 347 SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE varchar;
|
H A D | limit.test | 223 SELECT x FROM t2 LIMIT 5 UNION ALL SELECT a FROM t6; 225 } {1 {LIMIT clause should come after UNION ALL not before}} 228 SELECT x FROM t2 LIMIT 5 UNION SELECT a FROM t6; 230 } {1 {LIMIT clause should come after UNION not before}} 243 SELECT x FROM t2 UNION ALL SELECT a FROM t6 LIMIT 5; 248 SELECT x FROM t2 UNION ALL SELECT a FROM t6 LIMIT 3 OFFSET 1; 253 SELECT x FROM t2 UNION ALL SELECT a FROM t6 ORDER BY 1 LIMIT 3 OFFSET 1; 258 SELECT x FROM t2 UNION SELECT x+2 FROM t2 LIMIT 2 OFFSET 1; 263 SELECT x FROM t2 UNION SELECT x+2 FROM t2 ORDER BY 1 DESC LIMIT 2 OFFSET 1;
|
H A D | trigger1.test | 266 SELECT * FROM t1 UNION ALL SELECT * FROM t2; 274 SELECT * FROM t1 UNION ALL SELECT * FROM t2; 406 SELECT * FROM t3 UNION ALL SELECT 99, 99 UNION ALL SELECT * FROM t4; 412 SELECT * FROM t3 UNION ALL SELECT 99, 99 UNION ALL SELECT * FROM t4;
|
H A D | minmax.test | 129 (SELECT * FROM t1 UNION SELECT NULL as 'x', NULL as 'y') 135 (SELECT null, y+1 FROM t1 UNION SELECT * FROM t1) 142 (SELECT null, y+1 FROM t1 UNION SELECT * FROM t1) 268 SELECT max(rowid) FROM t4 UNION SELECT max(rowid) FROM t5
|
H A D | select1.test | 440 SELECT f1 FROM test1 UNION SELECT f2 FROM test1 447 SELECT f1 FROM test1 UNION SELECT f2+100 FROM test1 461 SELECT f1 FROM test1 UNION SELECT WHERE; 708 SELECT * FROM t3 UNION SELECT 3 AS 'a', 4 ORDER BY a; 713 SELECT 3, 4 UNION SELECT * FROM t3; 729 SELECT a,b FROM t3 UNION SELECT a AS 'x', b AS 'y' FROM t4 ORDER BY a,b 736 SELECT a,b FROM t3 UNION SELECT a AS 'x', b AS 'y' FROM t4 ORDER BY a,b
|
H A D | select6.test | 307 SELECT x AS 'a' FROM t1 UNION ALL SELECT x+10 AS 'a' FROM t1 314 SELECT x AS 'a' FROM t1 UNION ALL SELECT x+1 AS 'a' FROM t1 321 SELECT x AS 'a' FROM t1 UNION SELECT x+1 AS 'a' FROM t1
|
H A D | view.test | 146 CREATE VIEW v3 AS SELECT a FROM t1 UNION SELECT b FROM t1 ORDER BY b; 154 UNION
|
H A D | subselect.test | 109 INSERT INTO t3 SELECT a FROM t1 UNION ALL SELECT b FROM t1;
|
H A D | null.test | 146 # A UNION to two queries should treat NULL values
|
H A D | attach.test | 441 SELECT * FROM db2.t4 UNION ALL SELECT * FROM main.t4; 447 SELECT * FROM db2.t4 UNION ALL SELECT * FROM main.t4;
|
H A D | pragma.test | 225 SELECT d,e FROM t1 UNION SELECT a,c FROM t1
|
H A D | memdb.test | 303 SELECT a FROM t2 UNION SELECT b FROM t2 ORDER BY 1;
|
/illumos-gate/usr/src/cmd/eqn/ |
H A D | e.y | 38 %term SUM INT PROD UNION INTER 187 | UNION { funny(UNION); }
|
H A D | funny.c | 28 case UNION: in funny()
|
H A D | lookup.c | 46 "union", UNION,
|
/illumos-gate/usr/src/lib/libsqlite/tool/ |
H A D | space_used.tcl | 38 UNION ALL
|
H A D | spaceanal.tcl | 56 UNION ALL
|
/illumos-gate/usr/src/cmd/sgs/yacc/common/ |
H A D | y2.c | 47 #define UNION 270 macro 443 case UNION: in setup() 1236 return (UNION); in gettok()
|
/illumos-gate/usr/src/cmd/abi/spectrans/spec2trace/ |
H A D | parseproto.y | 110 %token <ds_val> STRUCT UNION 345 | UNION 662 { "union", UNION, TS_UNION }, in lookup_keyword()
|
/illumos-gate/usr/src/lib/libsqlite/src/ |
H A D | parse.y | 300 multiselect_op(A) ::= UNION. {A = TK_UNION;} 301 multiselect_op(A) ::= UNION ALL. {A = TK_ALL;}
|
/illumos-gate/usr/src/data/locale/data/ |
H A D | common.UTF-8.src | 17799 <UNION>;/
|
H A D | zh_CN.GB18030.src | 57298 <UNION>;/ 118829 <UNION>;/ 233031 <UNION> "<X0C94><X8E0…
|
H A D | GB18030.cm | 44073 <UNION> \xA1\xC8
|
H A D | UTF-8.cm | 7829 <UNION> \xE2\x88\xAA
|