Home
last modified time | relevance | path

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

12

/titanic_50/usr/src/lib/libsqlite/test/
H A Dselect4.test15 # focus of this file is testing UNION, INTERSECT and EXCEPT operators
52 UNION ALL
61 UNION ALL
72 UNION ALL
82 UNION ALL
90 UNION ALL
99 (SELECT DISTINCT log FROM t1 UNION ALL
107 UNION ALL
112 } {1 {ORDER BY clause should come after UNION ALL not before}}
119 UNION
[all …]
H A Dsort.test304 SELECT a FROM t4 UNION SELECT a FROM v4 ORDER BY 1;
309 SELECT b FROM t4 UNION SELECT a FROM v4 ORDER BY 1;
314 SELECT a FROM t4 UNION SELECT b FROM v4 ORDER BY 1;
319 SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1;
324 SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE numeric;
329 SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE integer;
334 SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE text;
339 SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE blob;
344 SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE clob;
349 SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE varchar;
H A Dlimit.test225 SELECT x FROM t2 LIMIT 5 UNION ALL SELECT a FROM t6;
227 } {1 {LIMIT clause should come after UNION ALL not before}}
230 SELECT x FROM t2 LIMIT 5 UNION SELECT a FROM t6;
232 } {1 {LIMIT clause should come after UNION not before}}
245 SELECT x FROM t2 UNION ALL SELECT a FROM t6 LIMIT 5;
250 SELECT x FROM t2 UNION ALL SELECT a FROM t6 LIMIT 3 OFFSET 1;
255 SELECT x FROM t2 UNION ALL SELECT a FROM t6 ORDER BY 1 LIMIT 3 OFFSET 1;
260 SELECT x FROM t2 UNION SELECT x+2 FROM t2 LIMIT 2 OFFSET 1;
265 SELECT x FROM t2 UNION SELECT x+2 FROM t2 ORDER BY 1 DESC LIMIT 2 OFFSET 1;
H A Dtrigger1.test268 SELECT * FROM t1 UNION ALL SELECT * FROM t2;
276 SELECT * FROM t1 UNION ALL SELECT * FROM t2;
408 SELECT * FROM t3 UNION ALL SELECT 99, 99 UNION ALL SELECT * FROM t4;
414 SELECT * FROM t3 UNION ALL SELECT 99, 99 UNION ALL SELECT * FROM t4;
H A Dminmax.test131 (SELECT * FROM t1 UNION SELECT NULL as 'x', NULL as 'y')
137 (SELECT null, y+1 FROM t1 UNION SELECT * FROM t1)
144 (SELECT null, y+1 FROM t1 UNION SELECT * FROM t1)
270 SELECT max(rowid) FROM t4 UNION SELECT max(rowid) FROM t5
H A Dselect1.test442 SELECT f1 FROM test1 UNION SELECT f2 FROM test1
449 SELECT f1 FROM test1 UNION SELECT f2+100 FROM test1
463 SELECT f1 FROM test1 UNION SELECT WHERE;
710 SELECT * FROM t3 UNION SELECT 3 AS 'a', 4 ORDER BY a;
715 SELECT 3, 4 UNION SELECT * FROM t3;
731 SELECT a,b FROM t3 UNION SELECT a AS 'x', b AS 'y' FROM t4 ORDER BY a,b
738 SELECT a,b FROM t3 UNION SELECT a AS 'x', b AS 'y' FROM t4 ORDER BY a,b
H A Dselect6.test309 SELECT x AS 'a' FROM t1 UNION ALL SELECT x+10 AS 'a' FROM t1
316 SELECT x AS 'a' FROM t1 UNION ALL SELECT x+1 AS 'a' FROM t1
323 SELECT x AS 'a' FROM t1 UNION SELECT x+1 AS 'a' FROM t1
H A Dview.test148 CREATE VIEW v3 AS SELECT a FROM t1 UNION SELECT b FROM t1 ORDER BY b;
156 UNION
H A Dsubselect.test111 INSERT INTO t3 SELECT a FROM t1 UNION ALL SELECT b FROM t1;
/titanic_50/usr/src/cmd/eqn/
H A De.y38 %term SUM INT PROD UNION INTER
187 | UNION { funny(UNION); }
H A Dfunny.c30 case UNION: in funny()
H A Dlookup.c48 "union", UNION,
/titanic_50/usr/src/tools/stabs/
H A Dsquander.c51 if (tdp->type == UNION) in squander_do_sou()
H A Dstabs.h68 UNION, enumerator
H A Dmain.c243 if (tdp->type != STRUCT && tdp->type != UNION) in find_member()
408 case UNION: in printnode()
H A Dstabs.c390 soudef(cp, UNION, rtdp); in tagdecl()
533 cp = soudef(cp, (type == 'u') ? UNION : STRUCT, rtdp); in tdefdecl()
756 if (tdp->type == STRUCT || tdp->type == UNION || in lookupname()
H A Dgenassym.c160 case UNION: in switch_on_type()
H A Dforth.c137 case UNION: in switch_on_type()
/titanic_50/usr/src/lib/libsqlite/tool/
H A Dspace_used.tcl41 UNION ALL
/titanic_50/usr/src/tools/ctf/cvt/
H A Dctftools.h139 UNION, enumerator
H A Dst_parse.c387 (void) soudef(cp, UNION, &rtdp); in parse_sou()
765 cp = soudef(cp, (type == 'u') ? UNION : STRUCT, rtdp); in tdefdecl()
1061 if (tdp->t_type == STRUCT || tdp->t_type == UNION || in lookup_name()
H A Dstabs.c88 if (!new || (new->t_type != STRUCT && new->t_type != UNION)) in resolve_fwd_node()
H A Dtdata.c82 case UNION: in tdesc_layouthash()
H A Dctf.c315 case UNION: in write_type()
1025 tdp->t_type = (kind == CTF_K_STRUCT ? STRUCT : UNION); in resurrect_types()
1143 if (tdp->t_type == STRUCT || tdp->t_type == UNION || in resurrect_types()
/titanic_50/usr/src/cmd/sgs/yacc/common/
H A Dy2.c49 #define UNION 270 macro
449 case UNION:
1244 return (UNION); in gettok()

12