Home
last modified time | relevance | path

Searched refs:index (Results 1 – 25 of 273) sorted by relevance

1234567891011

/sqlite-3.40.0/test/
H A Dindex.test21 do_test index-1.1 {
26 do_test index-1.1b {
30 do_test index-1.1c {
36 do_test index-1.1d {
44 do_test index-1.2 {
51 do_test index-2.1 {
59 do_test index-2.1b {
67 do_test index-2.2 {
79 do_test index-3.1 {
100 do_test index-3.3 {
[all …]
H A Dpragma.test375 } {{row 1 missing from index i2} {row 2 missing from index i2} {wrong # of entries in index i2}}
384 …index i2} {row 2 missing from index i2} {wrong # of entries in index i2} {row 1 missing from index…
389 …} {{row 1 missing from index i2} {row 2 missing from index i2} {wrong # of entries in index i2} {r…
395 …} {0 {{row 1 missing from index i2} {row 2 missing from index i2} {wrong # of entries in index i2}…
403 …index i2} {row 2 missing from index i2} {wrong # of entries in index i2} {row 1 missing from index…
438 Page 6 is never used} {row 1 missing from index i2} {row 2 missing from index i2} {wrong # of entri…
441 } {{row 1 missing from index i2} {row 2 missing from index i2} {wrong # of entries in index i2}}
458 Page 6 is never used} {row 1 missing from index i2} {row 2 missing from index i2}}
490 Page 6 is never used} {row 1 missing from index i2} {row 2 missing from index i2} {wrong # of entri…
493 Page 6 is never used} {row 1 missing from index i2} {row 2 missing from index i2} {wrong # of entri…
[all …]
H A DcorruptM.test45 } {table t1 t1 | index i1 t1 | view v2 v2 | trigger r1 t1 |}
50 } {table t1 {} | index i1 t1 | view v2 v2 | trigger r1 t1 |}
60 } {table t1 tx | index i1 t1 | view v2 v2 | trigger r1 t1 |}
69 } {tabl t1 t1 | index i1 t1 | view v2 v2 | trigger r1 t1 |}
78 } {table t9 t9 | index i1 t1 | view v2 v2 | trigger r1 t1 |}
88 } {table t1 T1 | index i1 t1 | view v2 v2 | trigger r1 t1 |}
99 } {view t1 T1 | index i1 t1 | view v2 v2 | trigger r1 t1 |}
111 } {table t1 t1 | index i1 tx | view v2 v2 | trigger r1 t1 |}
156 } {table t1 t1 | index i1 t1 | view v3 v3 | trigger r1 t1 |}
168 } {table t1 t1 | index i1 t1 | view v2 v2 | view r1 t1 |}
[all …]
H A Dindexedby.test59 # SQL view. Also test that specifying an index that does not exist or
64 # EVIDENCE-OF: R-58230-57098 The "INDEXED BY index-name" phrase
84 # optimizer hints about which index to use; it gives the optimizer a
85 # requirement of which index to use.
91 } {1 {no such index: i3}}
102 } {1 {no such index: i5}}
108 } {1 {no such index: i1}}
114 # index shall be used when accessing the preceding table, including
160 } {1 {no such index: sqlite_autoindex_t3_2}}
190 # also tests that nothing bad happens if an index refered to by
[all …]
H A Dfts2p.test107 # level/index. _all version does same but for entire index.
108 proc check_terms {test level index terms} {
110 # $level and $index directly.
112 set ::index $index
115 SELECT dump_terms(t1, $::level, $::index) FROM t1 LIMIT 1;
128 # segment level/index. _all version does same for entire index.
129 proc check_doclist {test level index term doclist} {
133 set ::index $index
136 SELECT dump_doclist(t1, $::term, $::level, $::index) FROM t1 LIMIT 1;
175 # Logical view of entire index.
H A Dautoindex3.test13 # focus of this script is testing automatic index creation logic,
14 # and specifically that an automatic index will not be created that
15 # shadows a declared index.
26 # automatic index cannot be any more selective than the real index.
80 # on the basis that the real index "uab" must be better than the automatic
81 # index. This is not right - a skip-scan is not necessarily better than an
82 # automatic index scan.
H A Ddelete2.test16 # removed an index entry by not the main table entry. To recreate the
19 # (1) Create a table with an index. Insert some data into that table.
25 # index entry was deleted first, before the table entry. And the index
26 # delete worked. Thus an entry was deleted from the index but not from
30 # before the index entry is deleted.
38 # Create a table that has an index.
59 # Start a query on the table. The query should not use the index.
H A Dalter.test133 index t1i1 -t1- \
134 index t1i2 -t1- \
136 index i3 T2 \
137 index {sqlite_autoindex_T2_1} T2 \
138 index {sqlite_autoindex_T2_2} T2 \
140 index i2 {TempTab} \
141 index {sqlite_autoindex_TempTab_1} {TempTab} \
166 index i3 T2 \
167 index {sqlite_autoindex_T2_1} T2 \
168 index {sqlite_autoindex_T2_2} T2 \
[all …]
H A Dfts2q.test44 # level/index. _all version does same but for entire index.
45 proc check_terms {test level index terms} {
47 # $level and $index directly.
49 set ::index $index
52 SELECT dump_terms(t1, $::level, $::index) FROM t1 LIMIT 1;
65 # segment level/index. _all version does same for entire index.
66 proc check_doclist {test level index term doclist} {
70 set ::index $index
73 SELECT dump_doclist(t1, $::term, $::level, $::index) FROM t1 LIMIT 1;
88 # Previously older segments would continue to exist, but now the index
H A Ddate2.test13 # check constraints and index expressions.
55 } {1 {non-deterministic use of date() in an index}}
68 } {1 {non-deterministic use of datetime() in an index}}
94 } {1 {non-deterministic use of date() in an index}}
102 } {1 {non-deterministic use of date() in an index}}
131 } {1 {non-deterministic use of datetime() in an index}}
134 } {1 {non-deterministic use of datetime() in an index}}
161 } {1 {non-deterministic use of julianday() in an index}}
169 } {1 {non-deterministic use of julianday() in an index}}
H A De_reindex.test54 INSERT INTO saved SELECT * FROM sqlite_master WHERE type = 'index';
56 DELETE FROM sqlite_master WHERE type = 'index';
76 {row 3 missing from index i2} \
77 {row 3 missing from index i1} \
78 {row 4 missing from index i2} \
79 {row 4 missing from index i1} \
80 {wrong # of entries in index i2} \
81 {wrong # of entries in index i1}
223 # EVIDENCE-OF: R-58823-28748 If it identifies a specific database index,
224 # then just that index is recreated.
[all …]
H A Dfts3c.test28 # level/index. _all version does same but for entire index.
29 proc check_terms {test level index terms} {
30 set where "level = $level AND idx = $index"
38 # segment level/index. _all version does same for entire index.
39 proc check_doclist {test level index term doclist} {
40 set where "level = $level AND idx = $index"
73 # Logical view of entire index.
H A Dindex8.test12 # Test cases for ORDER BY and LIMIT on an index scan.
26 # for index scans by taking into account WHERE clause constraints that can
27 # be handled by the index and do not require a table lookup.
39 # rather than an index scan.
46 # If we change the index so that it no longer covers the WHERE clause,
H A Danalyze5.test88 foreach {testid where index rows} {
174 # Verify that the expected index is used with the expected row count
182 # } [list $index $rows]
185 # the index is used
211 foreach {testid where index rows} {
221 # Verify that the expected index is used with the expected row count
229 # } [list $index $rows]
232 # the index is used
H A Din3.test117 # collation sequence used for the index on "t1.a" does not match the
177 # correctly handled in cases where an index might be used to optimise
205 # the index can be used (the comparison is false, text!=number).
210 # the comparison. Therefore it is possible to use index t1_i2.
215 # it possible to use index t1_i3.
221 # takes place. Therefore we cannot use index t1_i1, which has no affinity.
226 # the comparison. Therefore it is possible to use index t1_i2.
231 # Making it impossible to use index t1_i3.
237 # Test using a multi-column index.
H A Dtypes2.test22 # types2-1.*: The '=' operator in the absence of an index.
23 # types2-2.*: The '=' operator implemented using an index.
24 # types2-3.*: The '<' operator implemented using an index.
25 # types2-4.*: The '>' operator in the absence of an index.
26 # types2-5.*: The 'IN(x, y...)' operator in the absence of an index.
27 # types2-6.*: The 'IN(x, y...)' operator with an index.
28 # types2-7.*: The 'IN(SELECT...)' operator in the absence of an index.
29 # types2-8.*: The 'IN(SELECT...)' operator with an index.
200 # types2-5.* - The 'IN (x, y....)' operator with no index.
283 # "x IN (SELECT...)" with no index.
H A Dwalcrash2.test22 # This test case demonstrates a flaw in the wal-index manipulation that
24 # already added some entries to one of the hash-tables in the wal-index.
43 # wal-index).
46 # to the wal-index hash-table, then crash. Repeat this 1023
47 # times (so that the wal-index contains 8192 entries - all
H A Dimposter1.test43 # And create an imposter table for the t1c index.
101 } {/row # missing from index t1b/}
104 } {/row # missing from index t1c/}
108 # and NULL values into the UNIQUE index.
116 } {/row # missing from index t1c/}
128 } {/non-unique entry in index t1c/}
H A Dindexexpr1.test190 } {1 {non-deterministic functions prohibited in index expressions}}
193 } {1 {non-deterministic use of julianday() in an index}}
196 } {1 {subqueries prohibited in index expressions}}
221 } {1 {UNIQUE constraint failed: index 't3abc'}}
291 } {1 {UNIQUE constraint failed: index 't8bx'}}
299 # UNIQUE index that includes rowid and expression terms.
312 } {1 {UNIQUE constraint failed: index 't9x1'}}
332 # index as they are suppose to do.
388 # Assertion fault using an index on a constant
409 # A REPLACE into a table that uses an index on an expression causes
[all …]
H A Davtrans.test283 WHERE type='table' OR type='index'
292 WHERE type='table' OR type='index'
300 WHERE type='table' OR type='index'
308 WHERE type='table' OR type='index'
320 WHERE type='table' OR type='index'
328 WHERE type='table' OR type='index'
337 WHERE type='table' OR type='index'
345 WHERE type='table' OR type='index'
358 WHERE type='table' OR type='index'
366 WHERE type='table' OR type='index'
[all …]
/sqlite-3.40.0/doc/
H A Dvfs-shm.txt11 The wal-index file has a similar locking hierarchy implemented using
13 states. Each connection to a wal-index file must be in one of
26 there is an extra RECOVER state used for wal-index reconstruction.
28 The meanings of the various wal-index locking states is as follows:
30 UNLOCKED - The wal-index is not in use.
32 READ - Some prefix of the wal-index is being read. Additional
40 that are available anywhere in the wal-index.
54 RECOVER - Held during wal-index recovery. Used to prevent a
85 file that is contained anywhere in the wal-index.
88 will the size of the wal-index grow without holding a WRITE or
[all …]
/sqlite-3.40.0/ext/fts3/
H A DREADME.content4 Normally, in order to create a full-text index on a dataset, the FTS4
18 the full-text index, the content option can sometimes be used to achieve
73 to the content table does not affect the full-text index. It is the
75 full-text index are consistent.
105 -- The query uses the full-text index to discover that the MATCH
114 -- full-text index still indicates that the row with docid=3 matches
130 This is so that FTS4 can update the full-text index entries for each token
140 some users may wish to use database triggers to keep the full-text index
160 values in order to update the full-text index. And the INSERT trigger must
167 deletes the entire full-text index and rebuilds it based on the current
[all …]
/sqlite-3.40.0/contrib/
H A Dsqlitecon.tcl139 scan [$w index insert] %d.%d row col
149 scan [$w index insert] %d.%d row col
159 scan [$w index insert] %d.%d row col
181 scan [$w index insert] %d.%d row col
213 scan [$w index insert] %d.%d row col
423 scan [$w index insert] %d.%d row col
440 scan [$w index insert] %d.%d ix iy
453 set p [$w index @$x,$y]
457 $w index "$p + 1 char"
465 if {[catch {$w index anchor}]} {
[all …]
/sqlite-3.40.0/tool/
H A Dspeedtest.tcl159 runtest {100 SELECTs without an index}
176 runtest {Creating an index}
187 runtest {5000 SELECTs with an index}
200 runtest {1000 UPDATEs without an index}
212 runtest {25000 UPDATEs with an index}
223 runtest {25000 text UPDATEs with an index}
240 runtest {DELETE without an index}
247 runtest {DELETE with an index}
H A DGetFile.cs199 int index = pathAndQuery.LastIndexOf('/'); in GetFileName()
201 if ((index < 0) || (index == pathAndQuery.Length)) in GetFileName()
204 return pathAndQuery.Substring(index + 1); in GetFileName()

1234567891011