Home
last modified time | relevance | path

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

/illumos-gate/usr/src/lib/libsqlite/test/
H A Dselect4.test50 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 Dsort.test302 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 Dlimit.test223 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 Dtrigger1.test266 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 Dminmax.test129 (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 Dselect1.test440 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 Dselect6.test307 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 Dview.test146 CREATE VIEW v3 AS SELECT a FROM t1 UNION SELECT b FROM t1 ORDER BY b;
154 UNION
H A Dsubselect.test109 INSERT INTO t3 SELECT a FROM t1 UNION ALL SELECT b FROM t1;
H A Dnull.test146 # A UNION to two queries should treat NULL values
H A Dattach.test441 SELECT * FROM db2.t4 UNION ALL SELECT * FROM main.t4;
447 SELECT * FROM db2.t4 UNION ALL SELECT * FROM main.t4;
H A Dpragma.test225 SELECT d,e FROM t1 UNION SELECT a,c FROM t1
H A Dmemdb.test303 SELECT a FROM t2 UNION SELECT b FROM t2 ORDER BY 1;
/illumos-gate/usr/src/cmd/eqn/
H A De.y38 %term SUM INT PROD UNION INTER
187 | UNION { funny(UNION); }
H A Dfunny.c28 case UNION: in funny()
H A Dlookup.c46 "union", UNION,
/illumos-gate/usr/src/lib/libsqlite/tool/
H A Dspace_used.tcl38 UNION ALL
H A Dspaceanal.tcl56 UNION ALL
/illumos-gate/usr/src/cmd/sgs/yacc/common/
H A Dy2.c47 #define UNION 270 macro
443 case UNION: in setup()
1236 return (UNION); in gettok()
/illumos-gate/usr/src/cmd/abi/spectrans/spec2trace/
H A Dparseproto.y110 %token <ds_val> STRUCT UNION
345 | UNION
662 { "union", UNION, TS_UNION }, in lookup_keyword()
/illumos-gate/usr/src/lib/libsqlite/src/
H A Dparse.y300 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 Dcommon.UTF-8.src17799 <UNION>;/
H A Dzh_CN.GB18030.src57298 <UNION>;/
118829 <UNION>;/
233031 <UNION> "<X0C94><X8E0…
H A DGB18030.cm44073 <UNION> \xA1\xC8
H A DUTF-8.cm7829 <UNION> \xE2\x88\xAA