Home
last modified time | relevance | path

Searched refs:level (Results 1 – 25 of 67) sorted by relevance

123

/sqlite-3.40.0/test/
H A Dfts4opt.test49 1024*(o.level / 1024) + 32, -- level
50 sum(o.level<i.level OR (o.level=i.level AND o.idx>i.idx)), -- idx
53 WHERE (o.level / 1024) = (i.level / 1024)
72 SELECT level, count(*) FROM t2_segdir GROUP BY level
85 SELECT level, count(*) FROM t2_segdir GROUP BY level
100 execsql { SELECT level, count(*) FROM t2_segdir GROUP BY level }
106 SELECT level, count(*) FROM t2_segdir GROUP BY level;
133 SELECT level, count(*) FROM t2_segdir GROUP BY level
146 SELECT level, count(*) FROM t2_segdir GROUP BY level
161 execsql { SELECT level, count(*) FROM t2_segdir GROUP BY level }
[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.test125 SELECT count(*) FROM x2_segdir WHERE level=2;
126 SELECT count(*) FROM x2_segdir WHERE level=3;
131 SELECT count(*) FROM x2_segdir WHERE level=2;
132 SELECT count(*) FROM x2_segdir WHERE level=3;
146 AND level=3
157 AND level=3
241 execsql { SELECT level, idx, second(end_block) FROM x3_segdir WHERE level=1 }
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;
[all …]
H A Dfts2q.test48 set ::level $level
69 set ::level $level
104 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;
239 # 2 segments in level 0, 1 in level 1 (18 segments created, 16
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;
[all …]
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;
199 # 2 segments in level 0, 1 in level 1 (18 segments created, 16
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;
[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.
111 set ::level $level
115 SELECT dump_terms(t1, $::level, $::index) FROM t1 LIMIT 1;
129 proc check_doclist {test level index term doclist} {
132 set ::level $level
162 SELECT level, idx FROM t1_segdir ORDER BY level, idx;
218 SELECT level, idx FROM t1_segdir ORDER BY level, idx;
274 SELECT level, idx FROM t1_segdir ORDER BY level, idx;
[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"
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 Dtrace2.test131 "-- DELETE FROM 'main'.'x1_segdir' WHERE level = ?"
136 "-- SELECT (SELECT max(idx) FROM 'main'.'x1_segdir' WHERE level = ?) + 1"
139 …"-- SELECT level, idx, end_block FROM 'main'.'x1_segdir' WHERE level BETWEEN ? AND ? ORDER BY leve…
146 "-- SELECT ? UNION SELECT level / (1024 * ?) FROM 'main'.'x1_segdir'"
147 …s_end_block, end_block, root FROM 'main'.'x1_segdir' WHERE level BETWEEN ? AND ?ORDER BY level DES…
148 "-- SELECT max(level) FROM 'main'.'x1_segdir' WHERE level BETWEEN ? AND ?"
150 "-- DELETE FROM 'main'.'x1_segdir' WHERE level BETWEEN ? AND ?"
H A Dfts4merge3.test52 SELECT level, count(*) FROM t2_segdir GROUP BY level ORDER BY 1
64 SELECT level, count(*) FROM t2_segdir GROUP BY level ORDER BY 1
75 SELECT level, count(*) FROM t2_segdir GROUP BY level ORDER BY 1
99 SELECT level, count(*) FROM t2_segdir GROUP BY level ORDER BY 1
H A Dfts4growth2.test32 puts [ db eval {SELECT level, count(*) FROM x1_segdir GROUP BY level} ]
56 SELECT max(level) FROM x1_segdir;
57 SELECT count(*) FROM x1_segdir WHERE level=2;
66 SELECT max(level) FROM x1_segdir;
67 SELECT count(*) FROM x1_segdir WHERE level=2;
87 execsql { SELECT max(level) FROM x1_segdir }
H A Dfts4check.test64 DELETE FROM t1_segdir WHERE level=0 AND idx=(
65 SELECT max(idx) FROM t1_segdir WHERE level=0
99 DELETE FROM t2_segdir WHERE level=0 AND idx=(
100 SELECT max(idx) FROM t2_segdir WHERE level=1024
H A Dwith1.test732 under_alice(name,level) AS (
735 SELECT org.name, under_alice.level+1
740 SELECT group_concat(substr('...............',1,level*3) || name,x'0a')
758 # The previous query used "ORDER BY level" to yield a breath-first search.
759 # Change that to "ORDER BY level DESC" for a depth-first search.
763 under_alice(name,level) AS (
766 SELECT org.name, under_alice.level+1
771 SELECT group_concat(substr('...............',1,level*3) || name,x'0a')
794 under_alice(name,level) AS (
797 SELECT org.name, under_alice.level+1
[all …]
H A Dfts4merge4.test96 execsql { SELECT level, count(*) FROM t2_segdir GROUP BY level }
H A Dfts3corrupt4.test193 | 3648: 74 31 5f 73 65 67 64 69 72 27 28 6c 65 76 65 6c t1_segdir'(level
200 | 3760: 49 4d 41 52 59 20 4b 45 59 28 6c 65 76 65 6c 2c IMARY KEY(level,
303 | 3648: 28 6c 65 76 65 6c 20 49 4e 54 45 47 45 52 2c 69 (level INTEGER,i
310 | 3760: 6c 65 76 65 6c 2c 20 69 64 78 29 29 31 05 06 17 level, idx))1...
594 | 3648: 28 6c 65 76 65 6c 20 49 4e 54 45 47 45 52 2c 69 (level INTEGER,i
601 | 3760: 6c 65 76 65 6c 2c 20 69 64 78 29 29 31 05 06 17 level, idx))1...
785 | 3584: 72 27 28 6c 65 76 65 6c 20 49 4e 54 45 47 45 52 r'(level INTEGER
792 | 3696: 59 28 6c 65 76 65 6c 2c 20 69 64 78 29 29 31 06 Y(level, idx))1.
1008 | 3584: 72 27 28 6c 65 76 65 6c 20 49 4e 54 45 47 45 52 r'(level INTEGER
5792 UPDATE f_segdir SET level = 0 WHERE level IN (
[all …]
H A Dfts2e.test25 # (over the first 16) and the termSelect() merge (over the level-1
26 # segment and 14 level-0 segments).
H A Dfts1e.test25 # (over the first 16) and the termSelect() merge (over the level-1
26 # segment and 14 level-0 segments).
H A Dfts1f.test26 # (over the level-1 segment and 15 level-0 segments).
H A Dfts3fuzz001.test40 | 3648: 74 31 5f 73 65 67 64 69 72 27 28 6c 65 76 65 6c t1_segdir'(level
47 | 3760: 49 4d 41 52 59 20 4b 45 59 28 6c 65 76 65 6c 2c IMARY KEY(level,
H A Dfts3ae.test25 # (over the first 16) and the termSelect() merge (over the level-1
26 # segment and 14 level-0 segments).
H A Dfts2f.test26 # (over the level-1 segment and 15 level-0 segments).
H A Dfts3af.test26 # (over the level-1 segment and 15 level-0 segments).
H A Dtkt2854.test85 # at the b-tree level, not the schema level.
H A Dbackcompat.test417 SELECT level, group_concat(idx, ' ') FROM t2_segdir GROUP BY level;
436 SELECT level, group_concat(idx, ' ') FROM t2_segdir GROUP BY level;
/sqlite-3.40.0/ext/wasm/api/
H A DREADME.md49 flesh out low-level parts of `sqlite3-api-prologue.js`. Most of
56 Provides a high-level object-oriented wrapper to the lower-level C
58 high-level sqlite3 JS wrappers and should feel relatively familiar
/sqlite-3.40.0/autoconf/
H A DREADME.first4 To build the autoconf amalgamation, run from the top-level:

123