Lines Matching refs:table
27 # This command returns the number of columns in table $tbl within the
86 } {1 {Too many columns for an rtree table}}
91 } {1 {Too many columns for an rtree table}}
96 # EVIDENCE-OF: R-16717-50504 Each R*Tree index is a virtual table with
99 1 "" "Too few columns for an rtree table"
100 2 "x" "Too few columns for an rtree table"
101 3 "x,y" "Too few columns for an rtree table"
102 4 "a,b,c,d" "Wrong number of columns for an rtree table"
103 5 "a,b,c,d,e,f" "Wrong number of columns for an rtree table"
104 6 "a,b,c,d,e,f,g,h" "Wrong number of columns for an rtree table"
105 7 "a,b,c,d,e,f,g,h,i,j" "Wrong number of columns for an rtree table"
106 8 "a,b,c,d,e,f,g,h,i,j,k,l" "Too many columns for an rtree table"
114 # similar to an integer primary key column of a normal SQLite table.
294 # EVIDENCE-OF: R-50130-53472 The virtual <name> table creates
331 table demo_index_rowid
333 table demo_index_node
335 table demo_index_parent
408 # EVIDENCE-OF: R-06893-30579 In an RTREE virtual table, the first column
421 # EVIDENCE-OF: R-06224-52418 In an RTREE_I32 virtual table, all columns
449 # Create a regular table and an rtree table. Perform INSERT, UPDATE and
639 # EVIDENCE-OF: R-22000-53613 The default virtual table ("rtree") stores
732 # Attempts to do so will fail with a SQLITE_LOCKED "database table is
751 } {6 1 {database table is locked}}
783 } {6 1 {database table is locked}}
829 } {1 {database table is locked}}
847 # auxiliary table as follows: CREATE TABLE demo_data( id INTEGER PRIMARY
934 # demo_data table.
943 # small subset of the entire table.
1010 # EVIDENCE-OF: R-01280-03635 An RTREE table can have no more than 100
1042 } {1 {Too many columns for an rtree table}}
1071 } {1 {Too many columns for an rtree table}}
1219 # the table using "rtree_i32" instead: CREATE VIRTUAL TABLE intrtree
1253 # i32 r-tree table. It decodes and returns a list of cells from the node
1327 # EVIDENCE-OF: R-07489-10051 The "%" in the name of each shadow table is
1328 # replaced by the name of the R*Tree virtual table. So, if the name of
1329 # the R*Tree table is "xyz" then the three shadow tables would be
1343 # EVIDENCE-OF: R-51070-59303 There is one entry in the %_node table for
1360 # in the %_parent shadow table that identifies the parent node.
1368 # EVIDENCE-OF: R-02358-35037 The %_rowid shadow table maps entry rowids
1390 # EVIDENCE-OF: R-65201-22208 Extra columns appended to the %_rowid table
1428 # rtreecheck(S,R) runs an integrity check on the rtree table named R
1454 # Corrupt the table in database 'main':
1461 # Corrupt the table in database 'aux':
1479 } {{Found (44 -> 44) in %_rowid table, expected (44 -> 4)}}
1526 # the %_rowid table corresponding to the cell's rowid value that points
1535 } {{Mapping (100 -> 6) missing from %_rowid table}}
1539 # an entry in the %_parent table mapping from the cell's child node to
1548 } {{Found (3 -> 123) in %_parent table, expected (3 -> 1)}}
1556 } {{Mapping (3 -> 1) missing from %_parent table}}
1560 # in the %_rowid table as there are leaf cells in the r-tree structure,
1562 # %_rowid table.
1567 } {{Wrong number of entries in %_rowid table - expected 200, actual 201}}
1571 # in the %_parent table as there are non-leaf cells in the r-tree
1573 # entry in the %_parent table.
1578 } {{Wrong number of entries in %_parent table - expected 9, actual 10}}