Home
last modified time | relevance | path

Searched full:where (Results 1 – 25 of 3224) sorted by relevance

12345678910>>...129

/titanic_41/usr/src/lib/libsqlite/test/
H A Dwhere.test15 # focus of this file is testing the use of indices in WHERE clases.
17 # $Id: where.test,v 1.17 2003/06/15 23:42:25 drh Exp $
24 do_test where-1.0 {
57 do_test where-1.1 {
58 count {SELECT x, y FROM t1 WHERE w=10}
60 do_test where-1.2 {
61 count {SELECT x, y FROM t1 WHERE w=11}
63 do_test where-1.3 {
64 count {SELECT x, y FROM t1 WHERE 11=w}
66 do_test where-1.4 {
[all …]
H A Dupdate.test25 set v [catch {execsql {UPDATE test1 SET f2=5 WHERE f1<1}} msg]
33 {execsql {UPDATE sqlite_master SET name='xyz' WHERE name='123'}} msg]
51 set v [catch {execsql {UPDATE test1 SET f1=f3*2 WHERE f2==32}} msg]
55 set v [catch {execsql {UPDATE test1 SET f1=test2.f1*2 WHERE f2==32}} msg]
59 set v [catch {execsql {UPDATE test1 SET f3=f1*2 WHERE f2==32}} msg]
73 execsql {UPDATE test1 SET f2=f2/3 WHERE f1<=5}
79 execsql {UPDATE test1 SET f2=f2/3 WHERE f1>5}
106 DELETE FROM test1 WHERE f1<=5;
115 execsql {UPDATE test1 SET f2=f2+1 WHERE f1==8}
119 execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2>800}
[all …]
H A Drowid.test44 set sql "SELECT x FROM t1 WHERE rowid==$x2rowid(1)"
49 set sql "SELECT x FROM t1 WHERE rowid==$x2rowid(3)"
54 set sql "SELECT x FROM t1 WHERE oid==$x2rowid(1)"
59 set sql "SELECT x FROM t1 WHERE OID==$x2rowid(3)"
64 set sql "SELECT x FROM t1 WHERE _rowid_==$x2rowid(1)"
72 execsql "SELECT x FROM t1 WHERE rowid=$norow"
103 UPDATE t1 SET rowid=12345 WHERE x==1;
110 SELECT rowid, * FROM t1 WHERE rowid>1000;
115 UPDATE t1 SET oid=12346 WHERE x==1;
122 SELECT rowid, * FROM t1 WHERE rowid>1000;
[all …]
H A Din.test41 execsql {SELECT a FROM t1 WHERE b BETWEEN 10 AND 50 ORDER BY a}
44 execsql {SELECT a FROM t1 WHERE b NOT BETWEEN 10 AND 50 ORDER BY a}
47 execsql {SELECT a FROM t1 WHERE b BETWEEN a AND a*5 ORDER BY a}
50 execsql {SELECT a FROM t1 WHERE b NOT BETWEEN a AND a*5 ORDER BY a}
53 execsql {SELECT a FROM t1 WHERE b BETWEEN a AND a*5 OR b=512 ORDER BY a}
63 execsql {SELECT a FROM t1 WHERE b IN (8,12,16,24,32) ORDER BY a}
66 execsql {SELECT a FROM t1 WHERE b NOT IN (8,12,16,24,32) ORDER BY a}
69 execsql {SELECT a FROM t1 WHERE b IN (8,12,16,24,32) OR b=512 ORDER BY a}
72 execsql {SELECT a FROM t1 WHERE b NOT IN (8,12,16,24,32) OR b=512 ORDER BY a}
79 set v [catch {execsql {SELECT a FROM t1 WHERE b IN (b+10,20)}} msg]
[all …]
H A Dintpkey.test38 WHERE type='index' AND tbl_name='t1';
50 WHERE type='index' AND tbl_name='t1';
117 UPDATE t1 SET a=4 WHERE b='one';
127 SELECT * FROM t1 WHERE a==4;
168 SELECT * FROM t1 WHERE b=='y'
173 SELECT * FROM t1 WHERE b=='y' AND rowid<0
178 SELECT * FROM t1 WHERE b=='y' AND rowid<0 AND rowid>=-20
183 SELECT * FROM t1 WHERE b>='y'
188 SELECT * FROM t1 WHERE b>='y' AND rowid<10
194 UPDATE t1 SET a=8 WHERE b=='y';
[all …]
H A Dindex.test27 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
31 WHERE name='index1'}
37 WHERE name='index1'}
42 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
49 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
59 # Try adding an index on a column of a table where the table
89 WHERE type='index' AND tbl_name='test1'
99 WHERE type='index' AND tbl_name='test1'
117 execsql {SELECT name FROM sqlite_master WHERE type!='meta' ORDER BY name}
120 execsql {SELECT cnt FROM test1 WHERE power=4}
[all …]
H A Dselect4.test47 lsort [execsql {SELECT n FROM t1 WHERE log=3}]
53 SELECT n FROM t1 WHERE log=3
62 SELECT n FROM t1 WHERE log=3
73 SELECT n FROM t1 WHERE log=3
83 SELECT n FROM t1 WHERE log=2
91 SELECT n FROM t1 WHERE log=2;
98 SELECT log FROM t1 WHERE n IN
100 SELECT n FROM t1 WHERE log=3)
108 SELECT n FROM t1 WHERE log=3
120 SELECT n FROM t1 WHERE log=3
[all …]
H A Dformat3.test123 UPDATE t1 SET v='x-2b' where v=='x-0.123';
268 count {SELECT x, y FROM t1 WHERE w=10}
271 count {SELECT x, y FROM t1 WHERE w=11}
274 count {SELECT x, y FROM t1 WHERE 11=w}
277 count {SELECT x, y FROM t1 WHERE 11=w AND x>2}
280 count {SELECT x, y FROM t1 WHERE y<200 AND w=11 AND x>2}
283 count {SELECT x, y FROM t1 WHERE y<200 AND x>2 AND w=11}
286 count {SELECT x, y FROM t1 WHERE w=11 AND y<200 AND x>2}
289 count {SELECT x, y FROM t1 WHERE w>10 AND y=144 AND x=3}
292 count {SELECT x, y FROM t1 WHERE y=144 AND w>10 AND x=3}
[all …]
H A Dselect6.test53 execsql2 {SELECT * FROM (SELECT x, y FROM t1 WHERE x<2)}
73 WHERE a.y=b.y ORDER BY a.y
81 WHERE a.y=b.y ORDER BY a.y
89 WHERE q=s ORDER BY s
97 WHERE q=s ORDER BY s
109 execsql2 {SELECT * FROM (SELECT a, b FROM t2 WHERE a<2)}
129 WHERE a.b=b.b ORDER BY a.b
137 WHERE a.b=b.b ORDER BY a.b
145 WHERE q=s ORDER BY s
153 WHERE a.q=b.s ORDER BY a.q
[all …]
H A Dmisc1.test60 execsql {SELECT x75 FROM manycol WHERE x50=350}
63 execsql {SELECT x50 FROM manycol WHERE x99=599}
67 execsql {SELECT x50 FROM manycol WHERE x99=899}
73 execsql {DELETE FROM manycol WHERE x98=1234}
77 execsql {DELETE FROM manycol WHERE x98=998}
81 execsql {DELETE FROM manycol WHERE x99=500}
85 execsql {DELETE FROM manycol WHERE x99=599}
148 # before executing a command. Thus if "WHERE" is misspelled on an UPDATE,
271 # A WHERE clause is not allowed to contain more than 99 terms. Check to
278 set ::where {WHERE x0>=0}
[all …]
H A Dselect2.test42 set sql2 "SELECT f2 FROM tbl1 WHERE f1=$f1 ORDER BY f2"
51 set sql {SELECT DISTINCT f1 FROM tbl1 WHERE f1>3 AND f1<5}
56 set sql2 "SELECT f2 FROM tbl1 WHERE f1=$f1 ORDER BY f2"
82 execsql {SELECT count(*) FROM tbl2 WHERE f2>1000}
86 execsql {SELECT f1 FROM tbl2 WHERE 1000=f2}
94 execsql {SELECT f1 FROM tbl2 WHERE 1000=f2}
97 execsql {SELECT f1 FROM tbl2 WHERE f2=1000}
101 execsql {SELECT * FROM tbl2 WHERE 1000=f2}
106 execsql {SELECT * FROM tbl2 WHERE f2=1000}
115 execsql {SELECT f1 FROM tbl2 WHERE f2==2000}
[all …]
H A Dsubselect.test32 execsql {SELECT * FROM t1 WHERE a = (SELECT count(*) FROM t1)}
38 set v [catch {execsql {SELECT * FROM t1 WHERE a = (SELECT * FROM t1)}} msg]
45 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=2)}
48 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=4)}
51 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=6)}
54 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=8)}
61 execsql {SELECT b from t1 where a = coalesce((SELECT a FROM t1 WHERE b=5),1)}
76 WHERE x = (SELECT sum(b) FROM t1 where a notnull) - (SELECT sum(a) FROM t1)
80 # Try something useful. Delete every entry from t2 where the
84 execsql {DELETE FROM t2 WHERE x < 0.5*(SELECT max(x) FROM t2)}
H A Dnull.test109 # Check to see how WHERE clauses handle NULL values. A NULL value
110 # is the same as UNKNOWN. The WHERE clause should only select those
115 select a from t1 where b<10
120 select a from t1 where not b>10
125 select a from t1 where b<10 or c=1;
130 select a from t1 where b<10 and c=1;
135 select a from t1 where not (b<10 and c=1);
188 SELECT x FROM t4 WHERE y=NULL;
193 SELECT x FROM t4 WHERE y IN (33,NULL);
198 SELECT x FROM t4 WHERE y<33 ORDER BY x;
[all …]
H A Dtrans.test256 execsql {SELECT name FROM sqlite_master WHERE type='table' ORDER BY name}
260 execsql {SELECT name FROM sqlite_master WHERE type='table' ORDER BY name}
264 execsql {SELECT name FROM sqlite_master WHERE type='table' ORDER BY name}
275 execsql {SELECT name FROM sqlite_master WHERE type='table' ORDER BY name}
290 WHERE type='table' OR type='index'
299 WHERE type='table' OR type='index'
307 WHERE type='table' OR type='index'
315 WHERE type='table' OR type='index'
327 WHERE type='table' OR type='index'
335 WHERE type='table' OR type='index'
[all …]
H A Ddelete.test47 execsql {DELETE FROM table1 WHERE f1=3}
55 execsql {DELETE FROM 'table1' WHERE f1=3}
61 execsql {DELETE FROM table1 WHERE f1=2}
69 # Semantic errors in the WHERE clause
73 set v [catch {execsql {DELETE FROM table2 WHERE f3=5}} msg]
78 set v [catch {execsql {DELETE FROM table2 WHERE xyzzy(f1+4)}} msg]
127 execsql "DELETE FROM table1 WHERE f1==$i"
132 execsql "DELETE FROM table1 WHERE f1>50"
137 execsql "DELETE FROM table1 WHERE f1==$i"
143 execsql "DELETE FROM table1 WHERE f1==$i"
[all …]
H A Dtable.test32 SELECT sql FROM sqlite_master WHERE type!='meta'
43 execsql {SELECT name, tbl_name, type FROM sqlite_master WHERE type!='meta'}
52 execsql {SELECT name, tbl_name, type from sqlite_master WHERE type!='meta'}
59 execsql {SELECT * FROM sqlite_master WHERE type!='meta'}
68 execsql {SELECT name FROM sqlite_master WHERE type!='meta'}
75 execsql {SELECT name FROM sqlite_master WHERE type!='meta'}
79 execsql {SELECT name FROM "sqlite_master" WHERE type!='meta'}
83 execsql {SELECT name as "X" FROM sqlite_master WHERE type!='meta'}
87 execsql {SELECT name FROM "sqlite_master" WHERE type!='meta'}
110 execsql {DROP TABLE test2; SELECT name FROM sqlite_master WHERE type!='meta'}
[all …]
H A Dmisc2.test64 SELECT t1.b+t2.b AS a, t1.a, t2.a FROM t1, t2 WHERE a==10
74 SELECT a FROM t1 WHERE a>1;
81 SELECT a FROM t1 WHERE a>2147483647;
86 SELECT a FROM t1 WHERE a<2147483648;
91 SELECT a FROM t1 WHERE a<=2147483648;
96 SELECT a FROM t1 WHERE a<10000000000;
101 SELECT a FROM t1 WHERE a<1000000000000 ORDER BY 1;
114 SELECT x1.b AS p, x2.b AS q FROM x AS x1, x AS x2 WHERE x1.a=x2.a;
116 SELECT y1.p, y2.p FROM y AS y1, y AS y2 WHERE y1.q=y2.q;
149 db eval "DELETE FROM t1 WHERE rowid=$rowid"
[all …]
H A Dinsert.test111 execsql {SELECT * FROM test2 WHERE f1==-111}
115 execsql {SELECT * FROM test2 WHERE f1==77}
153 execsql {SELECT * FROM test2 WHERE f1=111 AND f2=-3.33}
157 execsql {SELECT * FROM test2 WHERE f1=111 AND f2=-3.33}
160 execsql {SELECT * FROM test2 WHERE f1=22 AND f2=-4.44}
187 INSERT INTO t3 VALUES((SELECT b FROM t3 WHERE a=0),6,7);
193 SELECT b,c FROM t3 WHERE a IS NULL;
204 SELECT * FROM t3 WHERE c=99;
235 SELECT rootpage FROM sqlite_master WHERE name='test1';
241 SELECT rootpage FROM sqlite_temp_master WHERE name='t4';
[all …]
/titanic_41/usr/src/cmd/rpcgen/
H A Drpc_scan.c51 #define startcomment(where) (where[0] == '/' && where[1] == '*') argument
52 #define endcomment(where) (where[-1] == '*' && where[0] == '/') argument
156 if (*where == 0) { in get_token()
170 *where = 0; in get_token()
185 where = curline; in get_token()
186 } else if (isspace(*where)) { in get_token()
187 while (isspace(*where)) { in get_token()
188 where++; /* eat */ in get_token()
191 for (where++; *where; where++) { in get_token()
192 if (endcomment(where)) { in get_token()
[all …]
/titanic_41/usr/src/grub/grub-0.97/netboot/
H A Dpci_io.c26 #define CONFIG_CMD(bus, device_fn, where) (0x80000000 | (bus << 16) | (device_fn << 8) | (where &… argument
29 unsigned int where, uint8_t *value) in pcibios_read_config_byte() argument
31 outl(CONFIG_CMD(bus,device_fn,where), 0xCF8); in pcibios_read_config_byte()
32 *value = inb(0xCFC + (where&3)); in pcibios_read_config_byte()
37 unsigned int device_fn, unsigned int where, uint16_t *value) in pcibios_read_config_word() argument
39 outl(CONFIG_CMD(bus,device_fn,where), 0xCF8); in pcibios_read_config_word()
40 *value = inw(0xCFC + (where&2)); in pcibios_read_config_word()
45 unsigned int where, uint32_t *value) in pcibios_read_config_dword() argument
47 outl(CONFIG_CMD(bus,device_fn,where), 0xCF8); in pcibios_read_config_dword()
53 unsigned int where, uint8_t value) in pcibios_write_config_byte() argument
[all …]
/titanic_41/usr/src/lib/libc/port/gen/
H A Dndbm.c125 off64_t where; in dbm_flushpag() local
128 where = (((off64_t)db->dbm_pagbno) * PBLKSIZ); in dbm_flushpag()
129 if ((lseek64(db->dbm_pagf, where, L_SET) != where) || in dbm_flushpag()
143 off64_t where; in dbm_flushdir() local
145 where = (((off64_t)db->dbm_dirbno) * DBLKSIZ); in dbm_flushdir()
146 if ((lseek64(db->dbm_dirf, where, L_SET) != where) || in dbm_flushdir()
274 off64_t where; in dbm_delete() local
291 where = (((off64_t)db->dbm_blkno) * PBLKSIZ); in dbm_delete()
292 if ((lseek64(db->dbm_pagf, where, L_SET) != where) || in dbm_delete()
309 off64_t where; in dbm_store() local
[all …]
/titanic_41/usr/src/lib/gss_mechs/mech_krb5/profile/
H A Dprof_solaris.c245 * where profile was the pointer passed back by __profile_init
275 * where profile was the pointer passed back by __profile_init
289 * where profile was the pointer passed back by __profile_init
290 * where domain is the domain name of the associated realm name
291 * where realm is the corresponding realm name for the domain
319 * where profile was the pointer passed back by __profile_init
320 * where domain is the domain name of the associated realm name
321 * where realm is the corresponding realm name for the domain
360 * where profile was the pointer passed back by __profile_init
361 * where realm is the target realm for lookup
[all …]
/titanic_41/usr/src/lib/libnisdb/
H A Ddb_table.cc59 * th inverse of 2**(N-1), where N is the number of bits in a
155 entryp found = head->where; in pop()
178 newentry->where = tabloc; in push()
216 answer[i] = current->where; in stats()
500 * 'where'. Return NULL in both if no next entry is found.
503 db_table::first_entry(entryp * where) in first_entry() argument
507 *where = NULL; in first_entry()
514 *where = i; in first_entry()
519 *where = NULL; in first_entry()
545 /* Return entry at location 'where', NULL if location is invalid. */
[all …]
/titanic_41/usr/src/lib/efcode/packages/
H A Dparse.c74 * where alias is:
84 line_error(char *where, int line, char *msg) in line_error() argument
86 log_message(MSG_ERROR, "%s:%d: %s\n", where, line, msg); in line_error()
90 make_builtin_hooks(fcode_env_t *env, char *where) in make_builtin_hooks() argument
96 if (where == NULL) in make_builtin_hooks()
97 where = "/fcode/aliases"; in make_builtin_hooks()
99 if ((fd = fopen(where, "r")) == NULL) { in make_builtin_hooks()
112 line_error(where, lnum, "Badly formed line"); in make_builtin_hooks()
117 line_error(where, lnum, "Badly formed alias"); in make_builtin_hooks()
121 line_error(where, lnum, "Badly formed target"); in make_builtin_hooks()
[all …]
/titanic_41/usr/src/uts/common/idmap/
H A Didmap_cache.c325 avl_index_t where; in kidmap_cache_lookup_uidbysid() local
334 result = avl_find(&cache->sid2pid.tree, &entry, &where); in kidmap_cache_lookup_uidbysid()
355 avl_index_t where; in kidmap_cache_lookup_gidbysid() local
364 result = avl_find(&cache->sid2pid.tree, &entry, &where); in kidmap_cache_lookup_gidbysid()
385 avl_index_t where; in kidmap_cache_lookup_pidbysid() local
394 result = avl_find(&cache->sid2pid.tree, &entry, &where); in kidmap_cache_lookup_pidbysid()
423 avl_index_t where; in kidmap_cache_lookup_sidbyuid() local
431 result = avl_find(&cache->uid2sid.tree, &entry, &where); in kidmap_cache_lookup_sidbyuid()
453 avl_index_t where; in kidmap_cache_lookup_sidbygid() local
461 result = avl_find(&cache->gid2sid.tree, &entry, &where); in kidmap_cache_lookup_sidbygid()
[all …]

12345678910>>...129