Home
last modified time | relevance | path

Searched refs:idx (Results 1 – 25 of 130) sorted by relevance

123456

/sqlite-3.40.0/test/
H A Danalyze.test144 SELECT idx, stat FROM sqlite_stat1 ORDER BY idx;
152 SELECT idx, stat FROM sqlite_stat1 ORDER BY idx;
159 SELECT idx, stat FROM sqlite_stat1 ORDER BY idx;
169 SELECT idx, stat FROM sqlite_stat1 ORDER BY idx;
176 SELECT idx, stat FROM sqlite_stat1 ORDER BY idx;
182 SELECT idx, stat FROM sqlite_stat1 ORDER BY idx;
189 SELECT idx, stat FROM sqlite_stat1 ORDER BY idx;
200 SELECT idx, stat FROM sqlite_stat1 ORDER BY idx;
206 SELECT idx, stat FROM sqlite_stat1 ORDER BY idx;
218 SELECT idx, stat FROM sqlite_stat1 ORDER BY idx;
[all …]
H A Dautoanalyze1.test45 SELECT idx, flgs FROM pragma_stats
46 WHERE idx IS NOT NULL
47 ORDER BY idx;
54 SELECT (flgs & 0x0100)!=0 FROM pragma_stats WHERE tbl='t1' AND idx IS NULL;
63 SELECT (flgs & 0x0100)!=0 FROM pragma_stats WHERE tbl='t1' AND idx IS NULL;
70 SELECT (flgs & 0x0100)!=0 FROM pragma_stats WHERE tbl='t1' AND idx IS NULL;
77 SELECT (flgs & 0x0100)!=0 FROM pragma_stats WHERE tbl='t1' AND idx IS NULL;
87 SELECT (flgs & 0x0100)!=0 FROM pragma_stats WHERE tbl='t1' AND idx IS NULL;
95 SELECT (flgs & 0x0100)!=0 FROM pragma_stats WHERE tbl='t1' AND idx IS NULL;
103 SELECT (flgs & 0x0100)!=0 FROM pragma_stats WHERE tbl='t1' AND idx IS NULL;
[all …]
H A Dfts4merge.test40 SELECT level, group_concat(idx, ' ') FROM t1_segdir GROUP BY level
56 SELECT level, group_concat(idx, ' ') FROM t1_segdir GROUP BY level
70 SELECT level, group_concat(idx, ' ') FROM t1_segdir GROUP BY level
106 SELECT level, group_concat(idx, ' ') FROM t2_segdir GROUP BY level
116 SELECT level, group_concat(idx, ' ') FROM t2_segdir GROUP BY level
163 SELECT level, group_concat(idx, ' ') FROM t4_segdir GROUP BY level;
187 SELECT level, group_concat(idx, ' ') FROM t1_segdir GROUP BY level;
197 SELECT level, group_concat(idx, ' ') FROM t1_segdir GROUP BY level;
213 SELECT level, group_concat(idx, ' ') FROM t1_segdir GROUP BY level;
225 SELECT level, group_concat(idx, ' ') FROM t1_segdir GROUP BY level;
[all …]
H A Dfts4growth.test308 SELECT level, idx, end_block FROM x2_segdir
319 SELECT level, idx, end_block FROM x2_segdir
325 SELECT level, idx, end_block FROM x2_segdir
353 SELECT level, idx, end_block FROM x5_segdir;
358 SELECT level, idx, end_block FROM x5_segdir;
366 SELECT level, idx, end_block FROM x5_segdir;
371 SELECT level, idx, end_block FROM x5_segdir;
389 SELECT level, idx, end_block FROM x6_segdir;
397 SELECT level, idx, end_block FROM x6_segdir;
406 SELECT level, idx, end_block FROM x6_segdir;
[all …]
H A Dshmlock.test125 proc random_lock_test {idx} {
130 if {[lindex $L($idx) $iSlot]!="n"} {
131 vfs_shmlock db$idx main [lindex $L($idx) $iSlot] unlock $iSlot 1
132 lset L($idx) $iSlot n
136 if {[lindex $L($idx) $iSlot]=="n"} {
140 for {set l $iSlot} {$l<8 && [lindex $L($idx) $l]=="n"} {incr l} {}
146 # puts "iSlot=$iSlot l=$l L=$L($idx)"
149 set res [vfs_shmlock db$idx main $locktype lock $iSlot $n]
153 set other [lindex $L([expr ($idx+1)%2]) $i]
164 lset L($idx) $i $locktype
H A Dzipfile2.test39 while { [set idx [string first $needle $haystack $start]]>=0 } {
40 lappend L $idx
41 set start [expr $idx+1]
103 set idx [lindex $L $i]
104 set a [string replace $archive $idx [expr $idx+3] 0000]
114 set idx [lindex $L $i]
115 set a [string replace $archive $idx [expr $idx+3] 1234]
126 set idx [lindex $L $i]
127 set a [string replace $archive [expr $idx+8] [expr $idx+9] 00]
H A Dindex7.test125 SELECT idx, stat FROM sqlite_stat1 ORDER BY idx;
137 SELECT idx, stat FROM sqlite_stat1 ORDER BY idx;
147 SELECT idx, stat FROM sqlite_stat1 ORDER BY idx;
157 SELECT idx, stat FROM sqlite_stat1 ORDER BY idx;
166 SELECT idx, stat FROM sqlite_stat1 ORDER BY idx;
175 SELECT idx, stat FROM sqlite_stat1 ORDER BY idx;
184 SELECT idx, stat FROM sqlite_stat1 ORDER BY idx;
295 SELECT stat+0 FROM sqlite_stat1 WHERE idx='t3b';
H A Dbestindex1.test89 set idx 0
90 for {set idx 0} {$idx < [llength $clist]} {incr idx} {
92 array set C [lindex $clist $idx]
96 return [list omit $idx rows 10 cost 10 idxstr $SQL_FILTER]
99 return [list use $idx rows 10 cost 10 idxstr $SQL_FILTER]
102 return [list use $idx rows 10 cost 10 idxstr $SQL_SCAN]
195 for {set idx 0} {$idx < [llength $clist]} {incr idx} {
196 array set c [lindex $clist $idx]
199 lappend U use $idx
H A Dfts3d.test29 set where "level = $level AND idx = $index"
39 set where "level = $level AND idx = $index"
64 SELECT level, idx FROM t1_segdir ORDER BY level, idx;
107 SELECT level, idx FROM t1_segdir ORDER BY level, idx;
144 SELECT level, idx FROM t1_segdir ORDER BY level, idx;
203 SELECT level, idx FROM t1_segdir ORDER BY level, idx;
260 SELECT level, idx FROM t1_segdir ORDER BY level, idx;
294 SELECT level, idx FROM t1_segdir ORDER BY level, idx;
302 UPDATE t1_segdir SET level = 2 WHERE level = 1 AND idx = 0;
304 SELECT level, idx FROM t1_segdir ORDER BY level, idx;
H A Dfts2q.test104 SELECT level, idx FROM t1_segdir ORDER BY level, idx;
147 SELECT level, idx FROM t1_segdir ORDER BY level, idx;
184 SELECT level, idx FROM t1_segdir ORDER BY level, idx;
243 SELECT level, idx FROM t1_segdir ORDER BY level, idx;
299 SELECT level, idx FROM t1_segdir ORDER BY level, idx;
333 SELECT level, idx FROM t1_segdir ORDER BY level, idx;
340 UPDATE t1_segdir SET level = 2 WHERE level = 1 AND idx = 0;
342 SELECT level, idx FROM t1_segdir ORDER BY level, idx;
H A Dtkt-cbd054fa6b.test61 SELECT tbl,idx,neq,nlt,ndlt,test_extract(sample,0) AS sample
68 SELECT tbl,idx,group_concat(s(sample),' ')
70 WHERE idx = 't1_x'
71 GROUP BY tbl,idx
100 SELECT tbl,idx,group_concat(s(sample),' ')
102 WHERE idx = 't1_x'
103 GROUP BY tbl,idx
H A Danalyze4.test54 SELECT idx, stat FROM sqlite_stat1 WHERE tbl='t1' ORDER BY idx;
66 SELECT idx, stat FROM sqlite_stat1 WHERE tbl='t1' ORDER BY idx;
84 SELECT idx, stat FROM sqlite_stat1 WHERE tbl='t1' ORDER BY idx;
113 SELECT idx, stat FROM sqlite_stat1 WHERE tbl='t2' ORDER BY idx;
H A Dfts3c.test30 set where "level = $level AND idx = $index"
40 set where "level = $level AND idx = $index"
60 SELECT level, idx FROM t1_segdir ORDER BY level, idx;
116 SELECT level, idx FROM t1_segdir ORDER BY level, idx;
172 SELECT level, idx FROM t1_segdir ORDER BY level, idx;
233 SELECT level, idx FROM t1_segdir ORDER BY level, idx;
H A Drowvalue9.test165 foreach {tn idx} {
167 2 { CREATE INDEX idx ON d1(a) }
168 3 { CREATE INDEX idx ON d1(a, c) }
169 4 { CREATE INDEX idx ON d1(c) }
170 5 { CREATE INDEX idx ON d1(c, a) }
173 CREATE INDEX idx ON d1(c, a) ;
178 CREATE INDEX idx ON d1(c, a) ;
183 CREATE INDEX idx ON d1(c) ;
188 execsql { DROP INDEX IF EXISTS idx }
191 execsql $idx
H A Danalyze5.test72 FROM sqlite_stat4 WHERE idx='t1u' ORDER BY nlt;
79 FROM sqlite_stat4 WHERE idx='t1v' ORDER BY 1
83 db eval {SELECT idx, count(*) FROM sqlite_stat4 GROUP BY 1 ORDER BY 1}
178 # set idx {}
179 # regexp {INDEX (t1.) } $x all idx
181 # list $idx $nrow
225 # set idx {}
226 # regexp {INDEX (t1.) } $x all idx
228 # list $idx $nrow
H A Dindex6.test81 SELECT idx, stat FROM sqlite_stat1 ORDER BY idx;
93 SELECT idx, stat FROM sqlite_stat1 ORDER BY idx;
103 SELECT idx, stat FROM sqlite_stat1 ORDER BY idx;
113 SELECT idx, stat FROM sqlite_stat1 ORDER BY idx;
122 SELECT idx, stat FROM sqlite_stat1 ORDER BY idx;
131 SELECT idx, stat FROM sqlite_stat1 ORDER BY idx;
140 SELECT idx, stat FROM sqlite_stat1 ORDER BY idx;
252 SELECT stat+0 FROM sqlite_stat1 WHERE idx='t3b';
H A DanalyzeC.test38 INSERT INTO sqlite_stat1(tbl,idx,stat)
63 UPDATE sqlite_stat1 SET stat='12345 2 unordered' WHERE idx='t1a';
87 WHERE idx='t1a';
114 INSERT INTO sqlite_stat1(tbl,idx,stat)
125 INSERT INTO sqlite_stat1(tbl,idx,stat)
155 INSERT INTO sqlite_stat1(tbl,idx,stat)
167 INSERT INTO sqlite_stat1(tbl,idx,stat)
H A Dfts4opt.test44 level, idx, start_block, leaves_end_block, end_block, root
50 sum(o.level<i.level OR (o.level=i.level AND o.idx>i.idx)), -- idx
54 GROUP BY o.level, o.idx;
187 SELECT level, idx FROM fts_segdir;
/sqlite-3.40.0/src/
H A Dvdbetrace.c77 int idx = 0; /* Index of a host parameter */ in sqlite3VdbeExpandSql() local
111 sqlite3GetInt32(&zRawSql[1], &idx); in sqlite3VdbeExpandSql()
113 idx = nextIndex; in sqlite3VdbeExpandSql()
122 idx = sqlite3VdbeParameterIndex(p, zRawSql, nToken); in sqlite3VdbeExpandSql()
123 assert( idx>0 ); in sqlite3VdbeExpandSql()
126 nextIndex = MAX(idx + 1, nextIndex); in sqlite3VdbeExpandSql()
127 assert( idx>0 && idx<=p->nVar ); in sqlite3VdbeExpandSql()
128 pVar = &p->aVar[idx-1]; in sqlite3VdbeExpandSql()
H A Dprintf.c222 int idx; /* A general purpose loop counter */ in sqlite3_str_vappendf() local
385 for(idx=0; idx<ArraySize(fmtinfo); idx++){ in sqlite3_str_vappendf()
386 if( c==fmtinfo[idx].fmttype ){ in sqlite3_str_vappendf()
387 infop = &fmtinfo[idx]; in sqlite3_str_vappendf()
501 for(idx=0; nn>0; idx++){ in sqlite3_str_vappendf()
502 bufpt[idx] = bufpt[idx+nn]; in sqlite3_str_vappendf()
505 bufpt[++idx] = cThousand; in sqlite3_str_vappendf()
545 idx = precision & 0xfff; in sqlite3_str_vappendf()
546 rounder = arRound[idx%10]; in sqlite3_str_vappendf()
547 while( idx>=10 ){ rounder *= 1.0e-10; idx -= 10; } in sqlite3_str_vappendf()
/sqlite-3.40.0/ext/fts5/tool/
H A Dfts5txt2db.tcl104 set idx(-$nm) $o
108 set idx(-$nm) $o
122 set c [array names idx "${opt}*"]
126 if {[llength $idx($c)]==3} {
131 set A([lindex $idx($c) 0]) [lindex $lArgs $i]
133 set A([lindex $idx($c) 0]) 1
/sqlite-3.40.0/ext/misc/
H A Dexplain.c240 int idx = -1; /* Index of a usable == constraint against SQL */ in explainBestIndex() local
250 idx = i; in explainBestIndex()
253 if( idx>=0 ){ in explainBestIndex()
257 pIdxInfo->aConstraintUsage[idx].argvIndex = 1; in explainBestIndex()
258 pIdxInfo->aConstraintUsage[idx].omit = 1; in explainBestIndex()
H A Dfuzzer.c977 int idx; in fuzzerFilter() local
981 idx = 0; in fuzzerFilter()
984 idx++; in fuzzerFilter()
987 pCur->rLimit = (fuzzer_cost)sqlite3_value_int(argv[idx]); in fuzzerFilter()
988 idx++; in fuzzerFilter()
991 pCur->iRuleset = (fuzzer_cost)sqlite3_value_int(argv[idx]); in fuzzerFilter()
992 idx++; in fuzzerFilter()
1126 int idx = 1; in fuzzerBestIndex() local
1127 if( iPlan & 1 ) idx++; in fuzzerBestIndex()
1128 if( iPlan & 2 ) idx++; in fuzzerBestIndex()
[all …]
H A Dclosure.c828 int idx = 1; in closureBestIndex() local
851 iPlan |= idx<<4; in closureBestIndex()
852 pIdxInfo->aConstraintUsage[i].argvIndex = ++idx; in closureBestIndex()
860 iPlan |= idx<<8; in closureBestIndex()
861 pIdxInfo->aConstraintUsage[i].argvIndex = ++idx; in closureBestIndex()
869 iPlan |= idx<<12; in closureBestIndex()
870 pIdxInfo->aConstraintUsage[i].argvIndex = ++idx; in closureBestIndex()
877 iPlan |= idx<<16; in closureBestIndex()
878 pIdxInfo->aConstraintUsage[i].argvIndex = ++idx; in closureBestIndex()
/sqlite-3.40.0/ext/repair/test/
H A Dcheckfreelist01.test36 proc set_int {blob idx newval} {
38 lset ints $idx $newval
43 proc get_int {blob idx} {
45 lindex $ints $idx

123456