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.test13 # focus of this file is testing UNION, INTERSECT and EXCEPT operators
50 UNION ALL
59 UNION ALL
70 UNION ALL
80 UNION ALL
88 UNION ALL
97 (SELECT DISTINCT log FROM t1 UNION ALL
105 UNION ALL
110 } {1 {ORDER BY clause should come after UNION ALL not before}}
117 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()
1211 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