Home
last modified time | relevance | path

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

12345678910>>...28

/illumos-gate/usr/src/lib/libsqlite/test/
H A Dselect6.test69 FROM (SELECT count(*),y FROM t1 GROUP BY y) AS a,
77 FROM (SELECT count(*),y FROM t1 GROUP BY y) AS a,
85 FROM (SELECT count(*) as p , y as q FROM t1 GROUP BY y) AS a,
93 FROM (SELECT count(*) as p , y as q FROM t1 GROUP BY y) AS a,
125 FROM (SELECT count(*),b FROM t2 GROUP BY b) AS a,
133 FROM (SELECT count(*),b FROM t2 GROUP BY b) AS a,
141 FROM (SELECT count(*) as p , b as q FROM t2 GROUP BY b) AS a,
149 FROM (SELECT count(*) as p , b as q FROM t2 GROUP BY q) AS a,
164 FROM (SELECT count(*) as p , b as q FROM t2 GROUP BY q) AS a,
252 (SELECT x AS 'a', y AS 'b', x+y AS 'c' FROM t1 WHERE y=4)
[all …]
H A Dview.test32 CREATE VIEW v1 AS SELECT a,b FROM t1;
44 CREATE VIEW v1 AS SELECT a,b FROM t1;
63 CREATE VIEW v1 AS SELECT a,b FROM t1;
92 CREATE VIEW v2 AS SELECT * FROM t1 WHERE a>5
140 CREATE VIEW v1 AS SELECT a AS 'xyz', b+c AS 'pqr', c-b FROM t1;
146 CREATE VIEW v3 AS SELECT a FROM t1 UNION SELECT b FROM t1 ORDER BY b;
152 CREATE VIEW v4 AS
155 SELECT b AS 'x', a AS 'y' FROM t1
200 CREATE VIEW v5 AS
201 SELECT t1.x AS v, t2.y AS w FROM t1 JOIN t2 USING(a);
[all …]
H A Dmisc2.test53 CREATE VIEW v1 AS SELECT * FROM t1, t2;
62 SELECT t1.b+t2.b AS a, t1.a, t2.a FROM t1, t2 WHERE a==10
111 CREATE VIEW y AS
112 SELECT x1.b AS p, x2.b AS q FROM x AS x1, x AS x2 WHERE x1.a=x2.a;
113 CREATE VIEW z AS
114 SELECT y1.p, y2.p FROM y AS y1, y AS y2 WHERE y1.q=y2.q;
205 CREATE TEMP TABLE x AS
207 FROM counts AS dim1, counts AS dim2, counts AS dim3
216 CREATE TEMP TABLE x AS
218 FROM counts AS dim1, counts AS dim2, counts AS dim3
[all …]
H A Dattach.test46 ATTACH DATABASE 'test2.db' AS two;
73 ATTACH DATABASE 'test3.db' AS three;
88 ATTACH 'test.db' AS db2;
89 ATTACH 'test.db' AS db3;
90 ATTACH 'test.db' AS db4;
91 ATTACH 'test.db' AS db5;
92 ATTACH 'test.db' AS db6;
93 ATTACH 'test.db' AS db7;
94 ATTACH 'test.db' AS db8;
95 ATTACH 'test.db' AS db9;
[all …]
H A Dselect1.test90 execsql {SELECT * FROM test1 AS a, test1 AS b}
562 # Check for ORDER BY clauses that refer to an AS name in the column list
566 SELECT f1 AS x FROM test1 ORDER BY x
571 SELECT f1 AS x FROM test1 ORDER BY -x
576 SELECT f1-23 AS x FROM test1 ORDER BY abs(x)
581 SELECT f1-23 AS x FROM test1 ORDER BY -abs(x)
586 SELECT f1-22 AS x, f2-22 as y FROM test1
591 SELECT f1-22 AS x, f2-22 as y FROM test1 WHERE x>0 AND y<50
613 SELECT * FROM t3 AS x, t4 AS y;
633 SELECT x.*, y.b FROM t3 AS x, t4 AS y;
[all …]
H A Dvacuum.test46 CREATE TABLE t2 AS SELECT * FROM t1;
66 CREATE TABLE t2 AS SELECT * FROM t1;
67 CREATE TABLE t3 AS SELECT * FROM t1;
68 CREATE VIEW v1 AS SELECT b, c FROM t3;
101 CREATE TABLE t4 AS SELECT * FROM t1;
102 CREATE TABLE t5 AS SELECT * FROM t1;
156 CREATE VIEW viewTest AS SELECT * FROM Test;
H A Dlimit.test63 execsql {SELECT * FROM t1 AS a, t1 AS b ORDER BY a.x, b.x LIMIT 5}
66 execsql {SELECT * FROM t1 AS a, t1 AS b ORDER BY a.x, b.x LIMIT 5 OFFSET 32}
71 CREATE VIEW v1 AS SELECT * FROM t1 LIMIT 2;
77 CREATE TABLE t2 AS SELECT * FROM t1 LIMIT 2;
89 SELECT z FROM (SELECT y*10+x AS z FROM t1 ORDER BY x LIMIT 10)
120 CREATE TABLE t4 AS SELECT x,
125 'abcdefghijklmnopqrstuvwyxz ABCDEFGHIJKLMNOPQRSTUVWYXZ' || x AS y
162 INSERT INTO t5 SELECT a.x*100+b.x, a.y*100+b.y FROM t1 AS a, t1 AS b
H A Dselect4.test57 CREATE TABLE t2 AS
68 CREATE TABLE t2 AS
86 CREATE TABLE t2 AS
152 CREATE TABLE t2 AS
163 CREATE TABLE t2 AS
210 CREATE TABLE t2 AS
221 CREATE TABLE t2 AS
261 SELECT DISTINCT log AS "xyzzy" FROM t1
270 SELECT DISTINCT log AS xyzzy FROM t1
398 SELECT 1 UNION SELECT 2 AS 'x'
[all …]
H A Dselect3.test80 SELECT log*2+1 AS x, count(*) AS y FROM t1 GROUP BY x ORDER BY y
85 SELECT log*2+1 AS x, count(*) AS y FROM t1 GROUP BY x ORDER BY 10-(x+y)
149 SELECT log AS x, count(*) AS y FROM t1
157 SELECT log AS x FROM t1
H A Dattach2.test38 ATTACH 'test2.db' AS t2;
56 ATTACH 'test2.db' AS t2;
67 ATTACH 'test2.db' AS t2;
128 set rc [catch {sqlite_compile $DB "ATTACH 'test2.db' AS t2" TAIL} VM]
H A Dmisuse.test35 sqlite_exec_printf $::DB {SELECT x_coalesce(NULL,a) AS 'xyz' FROM t1} {}
39 sqlite_exec_printf $::DB {SELECT x_coalesce(NULL,a) AS 'xyz' FROM t1} {}
51 SELECT x_sqlite_exec('SELECT * FROM t1') AS xyz;
H A Dbigfile.test80 CREATE TABLE t2 AS SELECT * FROM t1;
112 CREATE TABLE t3 AS SELECT * FROM t1;
149 CREATE TABLE t4 AS SELECT * FROM t1;
H A Dpragma.test214 SELECT 1+2 AS X, 'hello' || 5 AS Y, NULL AS Z
219 CREATE VIEW v1 AS SELECT a+b, b||c, * FROM t1;
/illumos-gate/usr/src/cmd/make/bin/
H A Dsvr4.make.rules.file32 AS=as
63 $(AS) $(ASFLAGS) $< -o $@ $(LDFLAGS)
66 $(AS) $(ASFLAGS) $*.s -o $* $(LDFLAGS)
138 $(AS) $(ASFLAGS) -o $*.o $*.s
141 $(AS) $(ASFLAGS) -o $@ $<
144 $(AS) $(ASFLAGS) -o $*.o $*.s
149 $(AS) $(ASFLAGS) -o $*.o $*.s
/illumos-gate/usr/src/uts/i86xpv/
H A DMakefile.rules168 $(AS) $(DBOOT_ASFLAGS) $(DBOOT_DEFS) $(DBOOT_AS_INCL) -c -o $@ $<
171 $(AS) $(DBOOT_ASFLAGS) $(DBOOT_DEFS) $(DBOOT_AS_INCL) -c -o $@ $<
174 $(AS) $(DBOOT_ASFLAGS) $(DBOOT_DEFS) $(DBOOT_AS_INCL) -c -o $@ $<
177 $(AS) $(DBOOT_ASFLAGS) $(DBOOT_DEFS) $(DBOOT_AS_INCL) -c -o $@ $<
/illumos-gate/usr/src/lib/libsec/common/
H A Dacl_lex.l74 %s TS NS PS AIS AS US ES
422 <AS>allow/[:,\n] {
435 <AS>deny/[:,\n] {
449 <AS>audit/[:,\n] {
462 <AS>alarm/[:,\n] {
475 <AS>: {
484 <AS>"\n" {
490 <AS>. {
614 BEGIN AS; variable
/illumos-gate/usr/src/uts/common/io/arn/
H A DLICENSE8 * THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES
25 * THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES
43 * THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES
/illumos-gate/usr/src/cmd/cmd-inet/usr.bin/pppd/
H A DTHIRDPARTYLICENSE12 * THIS SOFTWARE IS PROVIDED ``AS IS'' AND WITHOUT ANY EXPRESS OR
35 * ON AN "AS IS" BASIS, AND THE AUSTRALIAN NATIONAL UNIVERSITY HAS NO
50 * THIS SOFTWARE IS PROVIDED ``AS IS'' AND WITHOUT ANY EXPRESS OR
66 * THIS SOFTWARE IS PROVIDED ``AS IS'' AND WITHOUT ANY EXPRESS OR
82 * THIS SOFTWARE IS PROVIDED ``AS IS'' AND WITHOUT ANY EXPRESS OR
100 * THIS SOFTWARE IS PROVIDED ``AS IS'' AND WITHOUT ANY EXPRESS OR
112 THIS SOFTWARE IS PROVIDED ``AS IS'' AND WITHOUT ANY EXPRESS OR
183 * THIS SOFTWARE IS PROVIDED ``AS IS'' AND WITHOUT ANY EXPRESS OR
238 THIS SOFTWARE IS PROVIDED BY THE REGENTS AND CONTRIBUTORS ``AS
262 THIS SOFTWARE IS PROVIDED ``AS IS'' AND WITHOUT ANY EXPRESS OR
/illumos-gate/usr/src/lib/libresolv2/
H A DTHIRDPARTYLICENSE7 * THE SOFTWARE IS PROVIDED "AS IS" AND INTERNET SOFTWARE CONSORTIUM DISCLAIMS
32 * THE SOFTWARE IS PROVIDED "AS IS", AND IBM DISCLAIMS ALL WARRANTIES,
48 * THE SOFTWARE IS PROVIDED "AS IS" AND DIGITAL EQUIPMENT CORP. DISCLAIMS ALL
76 * THIS SOFTWARE IS PROVIDED BY THE REGENTS AND CONTRIBUTORS ``AS IS'' AND
129 THE DNSSAFE SOFTWARE IS PROVIDED "AS IS" WITHOUT ANY WARRANTY
132 IMPLIED OR STATUTORY, AS TO ANY MATTER WHATSOEVER, INCLUDING ALL
147 * THE SOFTWARE IS PROVIDED "AS IS" AND TRUSTED INFORMATION SYSTEMS
175 * THIS SOFTWARE IS PROVIDED BY THE PROJECT AND CONTRIBUTORS ``AS IS'' AND
/illumos-gate/usr/src/cmd/ssh/doc/
H A DLICENCE61 PROVIDE THE PROGRAM "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED
63 MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE ENTIRE RISK AS
70 REDISTRIBUTE THE PROGRAM AS PERMITTED ABOVE, BE LIABLE TO YOU FOR DAMAGES,
99 * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESS OR IMPLIED
130 * THIS SOFTWARE IS PROVIDED BY THE REGENTS AND CONTRIBUTORS ``AS IS'' AND
154 * THIS SOFTWARE IS PROVIDED BY THE REGENTS AND CONTRIBUTORS ``AS IS'' AND
185 * THIS SOFTWARE IS PROVIDED BY THE AUTHOR ``AS IS'' AND ANY EXPRESS OR
/illumos-gate/usr/src/common/ficl/test/
H A Dtester.fr6 \ MAY BE DISTRIBUTED FREELY AS LONG AS THIS COPYRIGHT NOTICE REMAINS.
/illumos-gate/usr/src/boot/efi/include/
H A DREADME22 THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESS OR IMPLIED
33 OTHER INFORMATION ON THIS WEB SITE ARE PROVIDED "AS IS" WITH NO
/illumos-gate/usr/src/uts/common/io/rwd/
H A DTHIRDPARTYLICENSE9 * THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES
26 * THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES
/illumos-gate/usr/src/uts/common/io/rum/
H A DTHIRDPARTYLICENSE9 * THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES
26 * THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES
/illumos-gate/usr/src/ucblib/libucb/sparc/
H A DMakefile35 BUILD.s= $(AS) $(ASFLAGS) $< -o $@

12345678910>>...28