Home
last modified time | relevance | path

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

12345678910>>...19

/titanic_44/usr/src/lib/libsqlite/test/
H A Dselect6.test71 FROM (SELECT count(*),y FROM t1 GROUP BY y) AS a,
79 FROM (SELECT count(*),y FROM t1 GROUP BY y) AS a,
87 FROM (SELECT count(*) as p , y as q FROM t1 GROUP BY y) AS a,
95 FROM (SELECT count(*) as p , y as q FROM t1 GROUP BY y) AS a,
127 FROM (SELECT count(*),b FROM t2 GROUP BY b) AS a,
135 FROM (SELECT count(*),b FROM t2 GROUP BY b) AS a,
143 FROM (SELECT count(*) as p , b as q FROM t2 GROUP BY b) AS a,
151 FROM (SELECT count(*) as p , b as q FROM t2 GROUP BY q) AS a,
166 FROM (SELECT count(*) as p , b as q FROM t2 GROUP BY q) AS a,
254 (SELECT x AS 'a', y AS 'b', x+y AS 'c' FROM t1 WHERE y=4)
[all …]
H A Dview.test34 CREATE VIEW v1 AS SELECT a,b FROM t1;
46 CREATE VIEW v1 AS SELECT a,b FROM t1;
65 CREATE VIEW v1 AS SELECT a,b FROM t1;
94 CREATE VIEW v2 AS SELECT * FROM t1 WHERE a>5
142 CREATE VIEW v1 AS SELECT a AS 'xyz', b+c AS 'pqr', c-b FROM t1;
148 CREATE VIEW v3 AS SELECT a FROM t1 UNION SELECT b FROM t1 ORDER BY b;
154 CREATE VIEW v4 AS
157 SELECT b AS 'x', a AS 'y' FROM t1
202 CREATE VIEW v5 AS
203 SELECT t1.x AS v, t2.y AS w FROM t1 JOIN t2 USING(a);
[all …]
H A Dmisc2.test55 CREATE VIEW v1 AS SELECT * FROM t1, t2;
64 SELECT t1.b+t2.b AS a, t1.a, t2.a FROM t1, t2 WHERE a==10
113 CREATE VIEW y AS
114 SELECT x1.b AS p, x2.b AS q FROM x AS x1, x AS x2 WHERE x1.a=x2.a;
115 CREATE VIEW z AS
116 SELECT y1.p, y2.p FROM y AS y1, y AS y2 WHERE y1.q=y2.q;
207 CREATE TEMP TABLE x AS
209 FROM counts AS dim1, counts AS dim2, counts AS dim3
218 CREATE TEMP TABLE x AS
220 FROM counts AS dim1, counts AS dim2, counts AS dim3
[all …]
H A Dattach.test48 ATTACH DATABASE 'test2.db' AS two;
75 ATTACH DATABASE 'test3.db' AS three;
90 ATTACH 'test.db' AS db2;
91 ATTACH 'test.db' AS db3;
92 ATTACH 'test.db' AS db4;
93 ATTACH 'test.db' AS db5;
94 ATTACH 'test.db' AS db6;
95 ATTACH 'test.db' AS db7;
96 ATTACH 'test.db' AS db8;
97 ATTACH 'test.db' AS db9;
[all …]
H A Dselect1.test92 execsql {SELECT * FROM test1 AS a, test1 AS b}
564 # Check for ORDER BY clauses that refer to an AS name in the column list
568 SELECT f1 AS x FROM test1 ORDER BY x
573 SELECT f1 AS x FROM test1 ORDER BY -x
578 SELECT f1-23 AS x FROM test1 ORDER BY abs(x)
583 SELECT f1-23 AS x FROM test1 ORDER BY -abs(x)
588 SELECT f1-22 AS x, f2-22 as y FROM test1
593 SELECT f1-22 AS x, f2-22 as y FROM test1 WHERE x>0 AND y<50
615 SELECT * FROM t3 AS x, t4 AS y;
635 SELECT x.*, y.b FROM t3 AS x, t4 AS y;
[all …]
H A Dvacuum.test48 CREATE TABLE t2 AS SELECT * FROM t1;
68 CREATE TABLE t2 AS SELECT * FROM t1;
69 CREATE TABLE t3 AS SELECT * FROM t1;
70 CREATE VIEW v1 AS SELECT b, c FROM t3;
103 CREATE TABLE t4 AS SELECT * FROM t1;
104 CREATE TABLE t5 AS SELECT * FROM t1;
158 CREATE VIEW viewTest AS SELECT * FROM Test;
H A Dlimit.test65 execsql {SELECT * FROM t1 AS a, t1 AS b ORDER BY a.x, b.x LIMIT 5}
68 execsql {SELECT * FROM t1 AS a, t1 AS b ORDER BY a.x, b.x LIMIT 5 OFFSET 32}
73 CREATE VIEW v1 AS SELECT * FROM t1 LIMIT 2;
79 CREATE TABLE t2 AS SELECT * FROM t1 LIMIT 2;
91 SELECT z FROM (SELECT y*10+x AS z FROM t1 ORDER BY x LIMIT 10)
122 CREATE TABLE t4 AS SELECT x,
127 'abcdefghijklmnopqrstuvwyxz ABCDEFGHIJKLMNOPQRSTUVWYXZ' || x AS y
164 INSERT INTO t5 SELECT a.x*100+b.x, a.y*100+b.y FROM t1 AS a, t1 AS b
H A Dselect4.test59 CREATE TABLE t2 AS
70 CREATE TABLE t2 AS
88 CREATE TABLE t2 AS
154 CREATE TABLE t2 AS
165 CREATE TABLE t2 AS
212 CREATE TABLE t2 AS
223 CREATE TABLE t2 AS
263 SELECT DISTINCT log AS "xyzzy" FROM t1
272 SELECT DISTINCT log AS xyzzy FROM t1
400 SELECT 1 UNION SELECT 2 AS 'x'
[all …]
H A Dselect3.test82 SELECT log*2+1 AS x, count(*) AS y FROM t1 GROUP BY x ORDER BY y
87 SELECT log*2+1 AS x, count(*) AS y FROM t1 GROUP BY x ORDER BY 10-(x+y)
151 SELECT log AS x, count(*) AS y FROM t1
159 SELECT log AS x FROM t1
H A Dattach2.test40 ATTACH 'test2.db' AS t2;
58 ATTACH 'test2.db' AS t2;
69 ATTACH 'test2.db' AS t2;
130 set rc [catch {sqlite_compile $DB "ATTACH 'test2.db' AS t2" TAIL} VM]
H A Dmisuse.test37 sqlite_exec_printf $::DB {SELECT x_coalesce(NULL,a) AS 'xyz' FROM t1} {}
41 sqlite_exec_printf $::DB {SELECT x_coalesce(NULL,a) AS 'xyz' FROM t1} {}
53 SELECT x_sqlite_exec('SELECT * FROM t1') AS xyz;
H A Dbigfile.test82 CREATE TABLE t2 AS SELECT * FROM t1;
114 CREATE TABLE t3 AS SELECT * FROM t1;
151 CREATE TABLE t4 AS SELECT * FROM t1;
/titanic_44/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
/titanic_44/usr/src/lib/libsec/common/
H A Dacl_lex.l72 %s TS NS PS AIS AS US ES
420 <AS>allow/[:,\n] {
433 <AS>deny/[:,\n] {
447 <AS>audit/[:,\n] {
460 <AS>alarm/[:,\n] {
473 <AS>: {
482 <AS>"\n" {
488 <AS>. {
612 BEGIN AS; variable
/titanic_44/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
/titanic_44/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
/titanic_44/usr/src/uts/i86xpv/
H A DMakefile.rules214 $(AS) $(DBOOT_ASFLAGS) $(DBOOT_DEFS) $(DBOOT_AS_INCL) -o $@ $<
217 $(AS) $(DBOOT_ASFLAGS) $(DBOOT_DEFS) $(DBOOT_AS_INCL) -o $@ $<
220 $(AS) $(DBOOT_ASFLAGS) $(DBOOT_DEFS) $(DBOOT_AS_INCL) -o $@ $<
223 $(AS) $(DBOOT_ASFLAGS) $(DBOOT_DEFS) $(DBOOT_AS_INCL) -o $@ $<
/titanic_44/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
/titanic_44/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
/titanic_44/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
/titanic_44/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
H A DCOPYING.Ylonen55 PROVIDE THE PROGRAM "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED
57 MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE ENTIRE RISK AS
64 REDISTRIBUTE THE PROGRAM AS PERMITTED ABOVE, BE LIABLE TO YOU FOR DAMAGES,
/titanic_44/usr/src/ucblib/libucb/sparc/
H A DMakefile33 BUILD.s= $(AS) $(ASFLAGS) $< -o $@
/titanic_44/usr/src/
H A DMakefile.master.6457 # Override Makefile.master's settings of CC, CCC, AS and LINT
62 AS= $($(MACH64)_AS)
/titanic_44/usr/src/cmd/cmd-inet/usr.bin/nc/
H A DTHIRDPARTYLICENSE17 THIS SOFTWARE IS PROVIDED BY THE AUTHOR ``AS IS'' AND ANY EXPRESS OR
42 THIS SOFTWARE IS PROVIDED BY THE AUTHOR ``AS IS'' AND ANY EXPRESS OR
63 THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES

12345678910>>...19