/ File History
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History of ext/rtree/rtreeC.test

2018-10-05
20:09
When the left-hand side of a WHERE clause contraint is a UNIQUE column, and that term of the WHERE clause is not used for indexing, assume that the term reduces the number of output rows by half. This is one proposed fix for ticket [e8b674241947eb3ba4] file: [c5339c91] check-in: [5c243eec] user: drh branch: unique-constraint-weights, size: 9364
2018-05-16
19:07
Do not allow auxiliary columns in the rtree to interfere with query planning. Begin adding test cases. file: [12892854] check-in: [9abe023e] user: drh branch: aux-data-in-rtree, size: 9365
2018-05-02
19:42
More test case updates. Tests are all running now. file: [55e40c4b] check-in: [dab5e529] user: drh branch: rework-EQP, size: 9340
2017-10-25
16:38
Add SQL scalar function rtreecheck() to the rtree module. For running checks to ensure the shadow tables used by an rtree virtual table are internally consistent. file: [d9d06dda] check-in: [dde0bb3e] user: dan branch: rtree-integrity-check, size: 9323
2016-05-23
18:06
Remove an extra "finish_test" from the end of rtreeC.test. file: [c0a9c67f] check-in: [bfbb6dd8] user: drh branch: tree-stat1-fix, size: 9227
2015-06-08
18:05
Avoid passing constraints that are unusable due to LEFT or CROSS joins to virtual table xBestIndex() methods. file: [90aaaffe] check-in: [80ee56dd] user: dan branch: vtab-left-join, size: 9242
2014-04-17
13:15
Refactor the constraint checking logic in RTree. The new-style constraint callbacks created by sqlite3_rtree_query_callback() are now hooked up from end to end, though still untested. file: [df158dcc] check-in: [32a13870] user: drh branch: rtree-enhancements, size: 7075
2014-03-12
19:38
Fix an obscure bug causing sqlite3_close() to fail if there are virtual tables on the disconnect list when it is called. file: [16d7aa86] check-in: [6504aa47] user: dan branch: trunk, size: 7076
12:44
Prevent the rtree module from reading sqlite_stat1 data from the wrong database. file: [afe930ac] check-in: [7ce03c1b] user: dan branch: trunk, size: 6419
2013-11-12
12:17
Fix for [4065ac8595]: Do not order CROSS or LEFT joins, even if the right-hand-side is a virtual table. file: [03975565] check-in: [e2684ece] user: dan branch: trunk, size: 4055
2013-11-11
19:01
Add a way for virtual tables to return the expected number of rows for a scan (not just the overall cost) to SQLite. Have the rtree module make use of this. file: [0c3dcd37] check-in: [5a3cfd74] user: dan branch: trunk, size: 2748 Added