/ 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/rtree1.test

2019-01-11
17:41
Fix a problem handling a negative value in the "number-of-pages" database header field. Also a problem with running "REINDEX tbl" against a virtual table for which the SQL passed to sqlite3_declare_vtab() contains PRIMARY KEY or UNIQUE constraints. file: [7573134f] check-in: [556dd892] user: dan branch: trunk, size: 19490
2018-05-24
23:51
When doing a one-pass UPDATE or DELETE on virtual tables, close the cursor prior to running VUpdate. This allows one-pass to work on virtual tables that do not allow concurrent reads and writes. Enhance rtree to take advantage of this new capability. file: [309afc04] check-in: [b816023c] user: drh branch: trunk, size: 19222
2018-05-18
16:46
Fix a prepare-statement leak. file: [58788985] check-in: [95fd296f] user: drh branch: aux-data-in-rtree, size: 19222
15:21
Improved error messages. Limit the number of auxiliary columns to 100. file: [0300c431] check-in: [059d20ab] user: drh branch: aux-data-in-rtree, size: 18832
2018-02-07
18:02
In extensions rtree, fts3 and fts5, ensure that when dynamic buffers are bound to persistent SQL statements using SQLITE_STATIC, the binding is replaced with an SQL NULL before the buffer is freed. Otherwise, a user may obtain a pointer to the persistent statement using sqlite3_next_stmt() and attempt to access the freed buffer using sqlite3_expanded_sql() or similar. file: [47e2095b] check-in: [2a5f813b] user: dan branch: trunk, size: 18122
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: [82a35374] check-in: [dde0bb3e] user: dan branch: rtree-integrity-check, size: 18104
2017-07-19
18:01
Remove some 'breakpoint' commands in test files. file: [4fdd60ae] check-in: [d14fc621] user: mistachkin branch: trunk, size: 18109
2017-07-07
19:43
Change the error message text for SQLITE_ERROR to omit the part about "missing database" as that meaning is now obsolete (since approx SQLite 2.0). file: [d3a0c295] check-in: [732f90d6] user: drh branch: trunk, size: 18120
2017-04-08
13:52
Have the rtree module close any open blob-handle within the xSavepoint method. This prevents such an open blob handle from interfering with DROP TABLE operations. file: [d5f0ba21] check-in: [fa4416ad] user: dan branch: trunk, size: 18160
2016-05-23
16:16
Improve the error messages generated by the rtree module when a constraint fails. file: [42dadfc7] check-in: [3ad2531e] user: dan branch: trunk, size: 17719
2015-10-03
12:23
Add tests for the rtree module to verify that attempts to insert non-integer primary key values or non-numeric dimensions into an rtree table are handled correctly. file: [96a80c08] check-in: [f653fce9] user: dan branch: trunk, size: 17574
2014-07-29
11:54
Have calls to the xFilter() method of rtree virtual tables ensure that cursor is initialized before proceeding. Fix for [d2889096e7bdeac]. file: [541bbcab] check-in: [8cc41b0b] user: dan branch: trunk, size: 15939
2014-04-18
01:37
Further improvements to the RTREE_DECODE_COORD() method, to take advantage of known processor byte orders when available. This makes the code 3% faster, according to valgrind. Also add test cases to make sure the on-disk representation is correct. file: [e2da4aaa] check-in: [6f3e94f4] user: drh branch: rtree-enhancements, size: 15340
2013-04-10
02:56
Correct test numbering on several rtree tests. file: [cf679265] check-in: [0adf8a3a] user: mistachkin branch: trunk, size: 15100
2012-04-02
21:35
The SQLITE_RTREE_INT_ONLY compile-time option causes the RTree extension to use only integer math and store only integer coordinates. file: [e474a2b5] check-in: [02b7640f] user: drh branch: trunk, size: 15078
2011-04-28
18:46
Have r-tree virtual tables support on-conflict clauses. file: [28e1b8da] check-in: [822ab52f] user: dan branch: vtab-conflict, size: 14885
2010-08-26
14:15
Fix a couple of memory leaks in r-tree that can occur following an OOM condition. file: [dbd4250a] check-in: [1975a27c] user: dan branch: trunk, size: 11768
2010-03-19
19:02
Have the xUpdate() method of the rtree module virtual table implementation set the *pRowid output variable when inserting a row. Fix for [dd3ba6063a]. file: [51bb0cd0] check-in: [f31d2248] user: dan branch: trunk, size: 11761
2009-11-10
01:30
Remove the obsolete "$Id:$" RCS identifier strings from the source code. file: [f72885ed] check-in: [f6c045f6] user: drh branch: trunk, size: 11339
2009-07-17
16:54
Return a meaningful error message if a keyword is used as an rtree table column name. Ticket #3970. (CVS 6902) file: [207041ab] check-in: [046efe46] user: danielk1977 branch: trunk, size: 11404
2008-12-22
15:04
Fix a reference counting bug in rtree. Ticket #3549. (CVS 6054) file: [ebcef111] check-in: [bbdc0e9f] user: danielk1977 branch: trunk, size: 11093
2008-07-14
15:37
Have the rtree extension publish two virtual table types: "rtree" and "rtree_i32". rtree_i32 stores coordinate data as 32-bit signed integers. rtree uses 32-bit real (floating point) values. (CVS 5410) file: [62022388] check-in: [c060a9a6] user: danielk1977 branch: trunk, size: 10141
2008-06-23
16:53
Fix a bug causing the pager-cache size to be reset to its default value whenever the database schema was reloaded. (CVS 5283) file: [994da7f8] check-in: [6dbe67da] user: danielk1977 branch: trunk, size: 10078
15:55
Run (a subset of) the rtree tests from quick.test. (CVS 5282) file: [b7c40c53] check-in: [e872c78c] user: danielk1977 branch: trunk, size: 10048
2008-05-26
20:49
Use %w instead of %q when constructing shadow table names for rtree. (CVS 5161) file: [7504a4bd] check-in: [78f4ba97] user: drh branch: trunk, size: 10006
18:41
Import 'rtree' extension. (CVS 5159) file: [96563843] check-in: [b104dcd6] user: danielk1977 branch: trunk, size: 10015 Added