/ File History
Login

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

History of ext/rtree/rtree1.test

2020-02-28
16:04
[00792b03] part of check-in [85a9b6a9] The RTREE extension behaves as if data columns have type REAL, so we should actually declare them as REAL so that automatic indexes handle them correctly. Ticket [e63b4d1a65546532] (check-in: [85a9b6a9] user: drh branch: trunk, size: 22542)
2019-12-06
19:07
[4092a8bd] part of check-in [ef73107f] Early detection and reporting of too few columns in an rtree CREATE VIRTUAL TABLE statement. (check-in: [ef73107f] user: drh branch: trunk, size: 22212)
13:10
[686216b4] part of check-in [97fb5a72] In the rtree extension, actively suppress extra tokens on the column names, and be pedantic about column affinities. Ticket [367a86e28859f1ff] (check-in: [97fb5a72] user: drh branch: trunk, size: 22093)
01:38
[891193aa] part of check-in [32772dfd] Further enhancements to RTREE, following up to check-in [f898d04cf272ef01] so that constraints are allowed to be compared to strings that look like numbers. Ticket [aa573a787b8f1fdf] (check-in: [32772dfd] user: drh branch: trunk, size: 21880)
2019-12-05
13:34
[1b84301b] part of check-in [d43e0efb] Be strict about type enforcement on rowid look-ups in the RTREE extension. Ticket [30e2c183b6b356e4] (check-in: [d43e0efb] user: drh branch: trunk, size: 21451)
00:44
[e3ce6e08] part of check-in [f898d04c] Enhance the RTREE extension so that it give correct query results even if the query uses non-numeric constraints. Ticket [a55ab6d97d01ecbc] (check-in: [f898d04c] user: drh branch: trunk, size: 21136)
2019-01-11
17:41
[7573134f] part of check-in [556dd892] 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. (check-in: [556dd892] user: dan branch: trunk, size: 19490)
2018-05-24
23:51
[309afc04] part of check-in [b816023c] 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. (check-in: [b816023c] user: drh branch: trunk, size: 19222)
2018-05-18
16:46
[58788985] part of check-in [95fd296f] Fix a prepare-statement leak. (check-in: [95fd296f] user: drh branch: aux-data-in-rtree, size: 19222)
15:21
[0300c431] part of check-in [059d20ab] Improved error messages. Limit the number of auxiliary columns to 100. (check-in: [059d20ab] user: drh branch: aux-data-in-rtree, size: 18832)
2018-02-07
18:02
[47e2095b] part of check-in [2a5f813b] 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. (check-in: [2a5f813b] user: dan branch: trunk, size: 18122)
2017-10-25
16:38
[82a35374] part of check-in [dde0bb3e] 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. (check-in: [dde0bb3e] user: dan branch: rtree-integrity-check, size: 18104)
2017-07-19
18:01
[4fdd60ae] part of check-in [d14fc621] Remove some 'breakpoint' commands in test files. (check-in: [d14fc621] user: mistachkin branch: trunk, size: 18109)
2017-07-07
19:43
[d3a0c295] part of check-in [732f90d6] 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). (check-in: [732f90d6] user: drh branch: trunk, size: 18120)
2017-04-08
13:52
[d5f0ba21] part of check-in [fa4416ad] 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. (check-in: [fa4416ad] user: dan branch: trunk, size: 18160)
2016-05-23
16:16
[42dadfc7] part of check-in [3ad2531e] Improve the error messages generated by the rtree module when a constraint fails. (check-in: [3ad2531e] user: dan branch: trunk, size: 17719)
2015-10-03
12:23
[96a80c08] part of check-in [f653fce9] 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. (check-in: [f653fce9] user: dan branch: trunk, size: 17574)
2014-07-29
11:54
[541bbcab] part of check-in [8cc41b0b] Have calls to the xFilter() method of rtree virtual tables ensure that cursor is initialized before proceeding. Fix for [d2889096e7bdeac]. (check-in: [8cc41b0b] user: dan branch: trunk, size: 15939)
2014-04-18
01:37
[e2da4aaa] part of check-in [6f3e94f4] 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. (check-in: [6f3e94f4] user: drh branch: rtree-enhancements, size: 15340)
2013-04-10
02:56
[cf679265] part of check-in [0adf8a3a] Correct test numbering on several rtree tests. (check-in: [0adf8a3a] user: mistachkin branch: trunk, size: 15100)
2012-04-02
21:35
[e474a2b5] part of check-in [02b7640f] The SQLITE_RTREE_INT_ONLY compile-time option causes the RTree extension to use only integer math and store only integer coordinates. (check-in: [02b7640f] user: drh branch: trunk, size: 15078)
2011-04-28
18:46
[28e1b8da] part of check-in [822ab52f] Have r-tree virtual tables support on-conflict clauses. (check-in: [822ab52f] user: dan branch: vtab-conflict, size: 14885)
2010-08-26
14:15
[dbd4250a] part of check-in [1975a27c] Fix a couple of memory leaks in r-tree that can occur following an OOM condition. (check-in: [1975a27c] user: dan branch: trunk, size: 11768)
2010-03-19
19:02
[51bb0cd0] part of check-in [f31d2248] Have the xUpdate() method of the rtree module virtual table implementation set the *pRowid output variable when inserting a row. Fix for [dd3ba6063a]. (check-in: [f31d2248] user: dan branch: trunk, size: 11761)
2009-11-10
01:30
[f72885ed] part of check-in [f6c045f6] Remove the obsolete "$Id:$" RCS identifier strings from the source code. (check-in: [f6c045f6] user: drh branch: trunk, size: 11339)
2009-07-17
16:54
[207041ab] part of check-in [046efe46] Return a meaningful error message if a keyword is used as an rtree table column name. Ticket #3970. (CVS 6902) (check-in: [046efe46] user: danielk1977 branch: trunk, size: 11404)
2008-12-22
15:04
[ebcef111] part of check-in [bbdc0e9f] Fix a reference counting bug in rtree. Ticket #3549. (CVS 6054) (check-in: [bbdc0e9f] user: danielk1977 branch: trunk, size: 11093)
2008-07-14
15:37
[62022388] part of check-in [c060a9a6] 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) (check-in: [c060a9a6] user: danielk1977 branch: trunk, size: 10141)
2008-06-23
16:53
[994da7f8] part of check-in [6dbe67da] Fix a bug causing the pager-cache size to be reset to its default value whenever the database schema was reloaded. (CVS 5283) (check-in: [6dbe67da] user: danielk1977 branch: trunk, size: 10078)
15:55
[b7c40c53] part of check-in [e872c78c] Run (a subset of) the rtree tests from quick.test. (CVS 5282) (check-in: [e872c78c] user: danielk1977 branch: trunk, size: 10048)
2008-05-26
20:49
[7504a4bd] part of check-in [78f4ba97] Use %w instead of %q when constructing shadow table names for rtree. (CVS 5161) (check-in: [78f4ba97] user: drh branch: trunk, size: 10006)
18:41
[96563843] part of check-in [b104dcd6] Import 'rtree' extension. (CVS 5159) (check-in: [b104dcd6] user: danielk1977 branch: trunk, size: 10015) Added