Home
last modified time | relevance | path

Searched refs:root (Results 1 – 25 of 71) sorted by relevance

123

/sqlite-3.40.0/test/
H A Dclosure01.test84 WHERE root=16384
92 WHERE root=16384
173 # t2 root=10
177 # t2 root=11
181 # t2 root IN [10,12]
185 # t2 root IN [10,12] (sorted)
203 WHERE root=20
235 WHERE root=20
246 WHERE root=20
257 WHERE root=20
[all …]
H A DcorruptB.test55 # Set the right-child of a B-Tree rootpage to refer to the root-page itself.
58 set ::root [execsql {SELECT rootpage FROM sqlite_master}]
59 set ::offset [expr {($::root-1)*1024}]
60 hexio_write test.db [expr $offset+8] [hexio_render_int32 $::root]
68 # root-page itself.
100 # Set the right-child pointer of the right-child of the root page to point
101 # back to the root page.
107 hexio_write test.db [expr $c_offset+8] [hexio_render_int32 $::root]
115 # point back to the root page.
135 hexio_write test.db [expr $c_offset+8] [hexio_render_int32 $::root]
[all …]
H A Dtypes.test134 # Open the table with root-page $rootpage at the btree
211 set root [db eval {select rootpage from sqlite_master where name = 't1'}]
212 record_sizes $root
216 set root [db eval {select rootpage from sqlite_master where name = 't1'}]
217 record_sizes $root
240 record_sizes $root
245 record_sizes $root
264 set root [db eval {select rootpage from sqlite_master where name = 't3'}]
265 record_sizes $root
292 record_sizes $root
[all …]
H A Dfts4record.test35 SELECT quote(root) FROM t1_segdir
53 UPDATE t1_segdir SET root =
67 UPDATE t1_segdir SET root =
81 SELECT quote(root) FROM t1_segdir
87 UPDATE t1_segdir SET root =
101 SELECT quote(root) FROM t1_segdir
108 UPDATE t1_segdir SET root =
H A Dfordelete.test27 # Build a map from root page to table/index name.
45 set root $R(p2)
47 if {[info exists T($root)]} { set M($csr) $T($root) }
49 set obj $T($root)
130 set root [db one { SELECT rootpage FROM sqlite_master WHERE name = 'x1' }]
135 set csr [btree_cursor $bt $root 1]
146 set root [db one { SELECT rootpage FROM sqlite_master WHERE name = 'x2' }]
151 set csr [btree_cursor $bt $root 1]
H A DcorruptF.test29 # consists of page 2 (the root page) and pages 5 and 6 (leaf pages).
40 CREATE TABLE t1(x); /* root page = 2 */
41 CREATE TABLE t2(x); /* root page = 3 */
42 CREATE TABLE t3(x); /* root page = 4 */
73 # Now create a new table in the database file. The root of the new table
91 # t1 and the root of t4), it continues to iterate through the keys within
94 # root page of t4. Eventually, page 6 becomes full and the height of the
126 # Now create a new table in the database file. The root of the new table
H A Dautovacuum.test128 # Tests cases autovacuum-2.* test that root pages are allocated
134 # moved correctly to make space for new root-pages.
137 # the free root-page location.
139 # root-page it requires is on the free-list.
142 # indices/table btrees could move the root-page of another.
247 # (the sqlite_master root-page and the first pointer map page) on the
361 # If the root-pages in the internal schema are not updated correctly when
386 # root pages vacated. The operation proceeds as:
387 # Step 1: Delete av3_i1 (root-page 11). Move root-page of av4_i4 to page 11.
388 # Step 2: Delete av3 (root-page 10). Move root-page of av4_i3 to page 10.
[all …]
H A Dfts3corrupt.test32 set blob [db one {SELECT root from t1_segdir}]
34 execsql { UPDATE t1_segdir SET root = $blob }
67 set blob [db one {SELECT root from t1_segdir}]
69 execsql { UPDATE t1_segdir SET root = $blob }
85 set blob [db one {SELECT quote(root) from t1_segdir}]
87 execsql { UPDATE t1_segdir SET root = $blob }
115 UPDATE t1_segdir SET root = X'FFFFFFFFFFFFFFFF';
135 UPDATE t1_segdir SET root = $blob;
H A Dfts3prefix.test228 SELECT md5sum(quote(root)) FROM t1_segdir;
229 } [db eval {SELECT md5sum(quote(root)) FROM t2_segdir}]
239 SELECT md5sum(quote(root)) FROM t1_segdir;
240 } [db eval {SELECT md5sum(quote(root)) FROM t2_segdir}]
250 set one [db eval {SELECT md5sum(quote(root)) FROM t1_segdir}]
251 set two [db eval {SELECT md5sum(quote(root)) FROM t2_segdir}]
263 SELECT md5sum(quote(root)) FROM t1_segdir;
264 } [db eval {SELECT md5sum(quote(root)) FROM t2_segdir}]
274 SELECT md5sum(quote(root)) FROM t1_segdir;
275 } [db eval {SELECT md5sum(quote(root)) FROM t2_segdir}]
H A DcorruptI.test123 set root [db one {SELECT rootpage FROM sqlite_master}]
124 set offset [expr ($root-1) * 65536]
144 # * Database root table has a single leaf page.
147 # The db is then corrupted by adding the root table leaf page as a free-list
150 # Then, a new table is created. The new root page is the current free-list
151 # trunk. This means that the root table leaf page is made into the new
153 # inserted into the root table, things would get chaotic.
H A Dfts3corrupt3.test34 SELECT quote(root) from t1_segdir;
38 UPDATE t1_segdir SET root = X'00036F6E650EFFFFFFFFFFFFFFFFFFFFFFFF0200';
61 SELECT quote(root) from t2_segdir;
H A Dpageropt.test118 # Pages written are page 1 (for the freelist pointer), the root page
180 # a cold cache, only page 1, the root page of table t1, and the trunk
183 # page1, the root page of table t1, and an 11 page overflow chain.
195 # to be read, together with page1 and the root of the t1 table. 12
196 # reads total. But only page1, the t1 root, and the trunk of the
H A Dfts3corrupt2.test92 db eval {SELECT rowid, length(root), root FROM t2_segdir}
97 execsql { UPDATE t2_segdir SET root = $b2 WHERE rowid = $rowid }
103 execsql { UPDATE t2_segdir SET root = $blob WHERE rowid = $rowid }
H A DcorruptJ.test42 # Corrupt the root page of the t1 table such that the left-child pointer
43 # for the very first cell points back to the root. Then try to DROP the
68 # page so that it points back to the root page.
H A DcorruptH.test54 # Corrupt the file so that the root page of t1 is also linked into t2 as
112 # The trick here is that the root page of the tree scanned by the outer
115 # "INSERT INTO t2..." statements have recycled the root page of t1 and
117 # that the PgHdr object associated with said root page does not match
H A Dcorrupt.test198 # root page of index i1. After this cell is deleted it must be replaced
238 # The root page of t1 is 1024 bytes in size. The header is 8 bytes, and
275 # Corrupt the root page of table t1 so that the first offset in the
277 # record (rowid=10). The root page still passes the checks in btreeInitPage(),
283 # initialized the root page, so no corruption is detected.
286 # to run. After copying the contents of the root page to the new child,
H A Dfts3corrupt5.test39 SELECT quote(root) FROM ft_segdir;
50 do_execsql_test 1.3.$tn.1 "UPDATE ft_segdir SET root = $val"
H A Dfts3_common.tcl382 binary scan $root c c
384 foreach {t d} [fts3_readleaf $root] { lappend a($t) $d }
405 foreach {t d} [fts3_readleaf $root] { lappend a($t) $d }
H A Dio.test76 # This should completely fill the root-page of the table. Each
77 # INSERT causes 2 db pages to be written - the root-page of "abc"
92 # to be added to the root page of abc. 4 pages in total
93 # are written to the db file - the two leaf pages, the root
101 # the root-node, which is close to empty, and two leaf pages, both of
115 # write to 3 pages to do this: the change-counter, the root-page and
520 # (all pages in the database except page 1 and the root page of
H A DcorruptN.test252 -- Make "t1" a large table. Large enough that the children of the root
267 -- Set the root of table t2 to 137 - the leftmost child of the root of t1.
H A Dfts4growth.test40 execsql { SELECT end_block, length(root) FROM x1_segdir }
45 SELECT level, end_block, length(root) FROM x1_segdir;
61 SELECT level, end_block, length(root) FROM x1_segdir;
95 SELECT level, end_block, length(root) FROM x1_segdir;
H A Dfts3cov.test87 SELECT substr(hex(root), 1, 2) FROM t1_segdir;
94 set root [db one {SELECT root FROM t1_segdir}]
95 read_fts3varint [string range $root 1 end] left_child
425 UPDATE t17_segdir SET root = X'00036F6E65FFFFFFFFFFFFFFFFFFFFFF02030300'
/sqlite-3.40.0/tool/
H A Dstack_usage.tcl17 set root($curfunc) 1
28 unset -nocomplain root($curfunc)
57 proc all_descendents {root} { argument
59 set todo($root) $root
69 lappend recursive($root) [concat $path $root]
/sqlite-3.40.0/ext/lsm1/
H A Dlsm_tree.c546 TreeRoot *p = &pDb->treehdr.root; in dump_tree_contents()
934 pDb->treehdr.root.nHeight++; in treeInsert()
1091 pDb->treehdr.root.iRoot = 0; in lsmTreeMakeOld()
1092 pDb->treehdr.root.nHeight = 0; in lsmTreeMakeOld()
1093 pDb->treehdr.root.nByte = 0; in lsmTreeMakeOld()
1120 pDb->treehdr.root.iTransId = 1; in lsmTreeInit()
1233 db->treehdr.root.nHeight--; in treeRepairPtrs()
1248 db->treehdr.root.nHeight++; in treeRepairPtrs()
1592 TreeRoot *p = &db->treehdr.root; in treeDeleteEntry()
1649 db->treehdr.root.nHeight--; in treeDeleteEntry()
[all …]
/sqlite-3.40.0/
H A Dspec.template13 BuildRoot: %{_tmppath}/%{name}-%{version}-root
57 %defattr(-, root, root)
62 %defattr(-, root, root)

123