Home
last modified time | relevance | path

Searched refs:where (Results 1 – 25 of 237) sorted by relevance

12345678910

/sqlite-3.40.0/test/
H A Dwhere.test20 do_test where-1.0 {
64 do_test where-1.1.1 {
76 do_test where-1.1.3 {
79 do_test where-1.1.4 {
82 do_test where-1.1.5 {
88 do_test where-1.1.7 {
130 do_test where-1.5 {
136 do_test where-1.6 {
139 do_test where-1.7 {
142 do_test where-1.8 {
[all …]
H A Drandexpr1.test215 …where exists(select 1 from t1 where (select count(distinct 11) from t1) between coalesce((select m…
1022 …where (t1.a<=coalesce((select - -coalesce((select max(case case 19 when t1.d then t1.e else t1.a …
1025 …where (t1.a<=coalesce((select - -coalesce((select max(case case 19 when t1.d then t1.e else t1.a …
1808 …where coalesce((select max((select abs(cast(avg( -t1.f*17) AS integer))+count(*) from t1)-19*coale…
1811 …where coalesce((select max((select abs(cast(avg( -t1.f*17) AS integer))+count(*) from t1)-19*coale…
2096 …1 where 17* -b+t1.e=13),coalesce((select +t1.f*coalesce((select b from t1 where 19 between -a and…
2099 …1 where 17* -b+t1.e=13),coalesce((select +t1.f*coalesce((select b from t1 where 19 between -a and…
2102 …1 where 17* -b+t1.e=13),coalesce((select +t1.f*coalesce((select b from t1 where 19 between -a and…
4241 …where e-coalesce((select 13 from t1 where exists(select 1 from t1 where ((+(case when d*t1.b not i…
4244 …where e-coalesce((select 13 from t1 where exists(select 1 from t1 where ((+(case when d*t1.b not i…
[all …]
H A Dtrigger4.test61 update test1 set a=NEW.a where id=NEW.id;
62 update test2 set b=NEW.b where id=NEW.id;
64 update test set a=22 where id=1;
77 update test set b=66 where id=4;
102 update test set a=222 where id=1;
126 update test set b=99 where id=7;
141 delete from tbl where a = old.a;
144 update tbl set a=new.a, b=new.b where a = old.a;
161 execsql {select a, b from vw where a<103 or a>226 order by a}
166 catchsql {delete from vw where a>101 and a<2000}
[all …]
H A Dlaststmtchanges.test50 update t0 set x=3 where x=1;
67 execsql {update t0 set x=3 where x=4}
69 update t0 set x=x+changes() where x=3;
70 select count() from t0 where x=8;
77 update t0 set x=77 where x=88;
85 delete from t0 where x=2;
233 update t0 set x=x*10 where x=1;
237 update t0 set x=x*10 where x=0;
245 update t0 set x=x*100 where x=0;
247 delete from t0 where x=2;
[all …]
H A Dfts3_common.tcl259 proc fts3_terms {tbl where} { argument
260 fts3_read $tbl $where a
282 proc fts3_doclist {tbl term where} { argument
283 fts3_read $tbl $where a
313 if {$where != "1" || [llength $lCol]>0} {
374 proc fts3_read2 {tbl where varname} {
378 FROM ${tbl}_segdir WHERE $where
397 proc fts3_read {tbl where varname} {
401 FROM ${tbl}_segdir WHERE $where
H A Dlastinsert.test53 update t1 set k=4 where k=2;
61 delete from t1 where k=4;
141 update t1 set k=14 where k=3;
225 delete from t1 where k=1;
266 update v set k=16 where k=14;
309 update rid set rin=last_insert_rowid() where k=1;
315 update rid set rin=last_insert_rowid() where k=2;
333 select rin from rid where k=1;
339 select rout from rid where k=1;
345 select rin from rid where k=2;
[all …]
H A Dtkt2192.test42 select * from records where type = 'D/D';
53 where description like '%NPOWER%'
59 where description like '%BT DIRECT%'
66 from direct_debits where description like '%VISA%'
80 where date like '%-01';
84 where date like '%-11';
H A Dbestindex6.test27 return [db one {SELECT sql FROM sqlite_master where name = $src}]
97 select * from t2 left join t1 on t1.id=t2.ctx where t1.value is null;
101 select * from vt2 left join vt1 on vt1.id=vt2.ctx where vt1.value is null;
106 select * from vt2 left join vt1 on vt1.id=vt2.ctx where vt1.value is $xxx;
110 select * from t2 left join vt1 on vt1.id=t2.ctx where vt1.value = 3
H A Dsubselect.test48 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=2)}
51 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=4)}
54 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=6)}
57 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=8)}
72 execsql {SELECT b from t1 where a = coalesce((SELECT a FROM t1 WHERE b=5),1)}
87 WHERE x = (SELECT sum(b) FROM t1 where a notnull) - (SELECT sum(a) FROM t1)
91 # Try something useful. Delete every entry from t2 where the
H A Danalyze5.test88 foreach {testid where index rows} {
177 # set x [lindex [eqp "SELECT * FROM t1 WHERE $where"] 3]
187 set w2 [string map {y +y z +z} $where]
190 set a2 [db eval "SELECT rowid FROM t1 WHERE $where ORDER BY +rowid"]
211 foreach {testid where index rows} {
224 # set x [lindex [eqp "SELECT * FROM t1 WHERE $where"] 3]
234 set w2 [string map {y +y z +z} $where]
237 set a2 [db eval "SELECT rowid FROM t1 WHERE $where ORDER BY +rowid"]
H A Dconflict3.test46 # Insert two rows where the second conflicts on C. The first row show go
76 # Insert two rows where the second conflicts on C. The first row show go
106 # Insert two rows where the second conflicts on C. The first row show go
136 # Insert two rows where the second conflicts on C. The first row show go
166 # Insert two rows where the second conflicts on C. The first row show go
196 # Insert two rows where the second conflicts on C. The first row show go
226 # Insert two rows where the second conflicts on C. The first row show go
256 # Insert two rows where the second conflicts on C. The first row show go
286 # Insert two rows where the second conflicts on C. The first row show go
316 # Insert two rows where the second conflicts on C. The first row show go
[all …]
H A Djoin4.test35 select * from t1 left outer join t2 on t1.a=t2.x where t2.z='ok'
52 select * from t1 left outer join t2 on t1.a=t2.x where t2.z='ok'
66 select * from t1 left outer join t2 on t1.a=t2.x where t2.z='ok'
76 select * from t1 left outer join t2 on t1.a=t2.x where t2.z>='ok'
87 select * from t1 left outer join t2 on t1.a=t2.x where t2.z IN ('ok')
H A Dtkt-fc7bd6358f.test48 unset -nocomplain where
56 foreach {b where} {
68 db eval "SELECT t1.textid, i.intid, t2.textid $from $where"
72 db eval "SELECT t1.textid, i.intid, t2.textid $from $where"
H A Dtypes.test211 set root [db eval {select rootpage from sqlite_master where name = 't1'}]
216 set root [db eval {select rootpage from sqlite_master where name = 't1'}]
239 set root [db eval {select rootpage from sqlite_master where name = 't2'}]
244 set root [db eval {select rootpage from sqlite_master where name = 't2'}]
264 set root [db eval {select rootpage from sqlite_master where name = 't3'}]
291 set root [db eval {select rootpage from sqlite_master where name = 't4'}]
296 set root [db eval {select rootpage from sqlite_master where name = 't4'}]
H A DanalyzeF.test48 foreach {tn where idx} {
66 do_eqp_test 1.$tn "SELECT * FROM t1 WHERE $where" $res
88 foreach {tn where idx} {
96 do_eqp_test 3.$tn "SELECT * FROM t1 WHERE $where" $res
136 UPDATE t1 SET b='xyz' where a>=9998;
H A DvtabJ.test107 SELECT name, value FROM tclvar where name = 'xx';
112 SELECT name, value FROM tclvar where name = 'xx';
117 SELECT name, value FROM tclvar where name = 'xx';
122 SELECT name, value FROM tclvar where name = 'xx';
H A Drandexpr1.tcl65 {coalesce((select max(EXPR) from t1 where BOOL),EXPR)}
69 {coalesce((select EXPR from t1 where BOOL),EXPR)}
109 {exists(select 1 from t1 where BOOL)}
113 {not exists(select 1 from t1 where BOOL)}
H A Dtkt1443.test133 where
140 where
165 where
172 where
H A Dnull.test119 select a from t1 where b<10
124 select a from t1 where not b>10
129 select a from t1 where b<10 or c=1;
134 select a from t1 where b<10 and c=1;
139 select a from t1 where not (b<10 and c=1);
H A Dnormalize.test22 {select*from t1 where a in(?,?,?)and b=?;}
26 {select a,b+?,c from t1 where d not in(select x from t2);}
34 {select?,b from t1 where d in(with t(a)as(values(?))select a from t)or e=?;}
44 {select?,b from t1 where d in(with t(a)as(values(?))select a from t)or e=?;}
62 {select a,?,b from t1 where c is not null or d is null or e=?;}
67 {select*from t1 where x in(?,?,?);}
H A Dblob.test110 set blobs [execsql {SELECT * FROM t1 where a = X'123456'}]
116 set blobs [execsql {SELECT * FROM t1 where a = X'CDEF12'}]
122 set blobs [execsql {SELECT * FROM t1 where a = X'CD12'}]
/sqlite-3.40.0/ext/rtree/
H A Drtree4.test127 set where {}
133 set where "WHERE [join $where { AND }]"
140 set where {}
146 set where "WHERE [join $where { AND }]"
154 set where {}
163 set where "WHERE [join $where { AND }]"
180 set where "WHERE [join $where { AND }]"
196 set where "WHERE [join $where { AND }]"
212 set where "WHERE [join $where { AND }]"
228 set where "WHERE [join [scramble $where] { AND }]"
[all …]
H A Drtree2.test90 set where [list]
100 lappend where "$col $op $val"
102 set where [join $where " AND "]
104 set t1 [execsql "SELECT * FROM t1 WHERE $where ORDER BY ii"]
105 set t2 [execsql "SELECT * FROM t2 WHERE $where ORDER BY ii"]
108 #puts $where
113 #set t1 [execsql "SELECT * FROM t1 WHERE $where ORDER BY ii"]
/sqlite-3.40.0/ext/rbu/
H A Drbu5.test105 set where [list]
106 foreach c $pk { lappend where "main.$tbl.$c IS orig.$tbl.$c" }
107 set where [join $where " AND "]
127 SELECT 1 FROM orig.$tbl WHERE $where
136 SELECT 1 FROM main.$tbl WHERE $where
148 WHERE $where AND NOT ($where2)
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5phrase.test97 set where [list]
98 foreach c $cols { lappend where "pmatch($c, '$tokens')" }
99 set where [join $where " OR "]
101 set res [db eval "SELECT rowid FROM t3 WHERE $where"]

12345678910