SQLite

All files named ”ext/rtree/rtree1.test”
Login

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

History for ext/rtree/rtree1.test

2024-03-06
12:28
[e0608db762] part of check-in [483fa2969e] Correction to the previous check-in. (check-in: [483fa2969e] user: drh branch: trunk, size: 25195)
11:35
[aa738f9956] part of check-in [027e5336ac] Fix handling of "id=?" corner cases in rtree when the value on the RHS is a real value. Problem reported by forum post 1bb055be17. (check-in: [027e5336ac] user: dan branch: trunk, size: 25063)
2023-10-27
18:16
[2b5b8c719c] part of check-in [fed4d6e90b] Disable two rtree test cases for Linux-i686. We do not have that platform available for testing. The test cases work on all other 64-bit and 32-bit platforms that we have at hand. So there is no way for us to debug this problem. Better to disable the test. forum post ffcbf789b5386573. (check-in: [fed4d6e90b] user: drh branch: trunk, size: 24751)
2023-10-14
17:14
[ecc881fdd1] part of check-in [b7b2e30b57] The rtreecheck() SQL function should not invoke BEGIN or COMMIT as this causes issues for statement transactions. (check-in: [b7b2e30b57] user: drh branch: trunk, size: 24663)
2023-05-22
16:35
[877d40b8b6] part of check-in [bfd8d91000] When a floating-point RTREE is presented with large integer constraints - integers that are too big to be represented exactly by a float - then take extra steps to ensure that all possibly relevant entries in the RTREE are returned, even in boundary cases. Fix for the problem identified by forum post da70ee0d0d. (check-in: [bfd8d91000] user: drh branch: trunk, size: 24320)
2023-05-19
11:48
[8cb77d2664] part of check-in [4ec0f0a31b] Change the RTREE engine so that equality comparisons of floating point values are duplicated in the byte-code so that the comparisons are done using 64-bit floats and consistent results are always obtained. Forum post da61c4a1b5b4af19. (check-in: [4ec0f0a31b] user: drh branch: trunk, size: 23862)
2023-04-26
20:41
[96271886cb] part of check-in [50e8a30be1] Fix some problems with the rtree module and existing tests on this branch. (check-in: [50e8a30be1] user: dan branch: rtree-batch-insert, size: 23598)
2022-06-20
17:04
[d47f588321] part of check-in [e615dbe02c] Do not allow an ON clause to references tables to its right if there is a RIGHT or FULL join anywhere in the query. Other RDBMSes prohibit this always, but SQLite must allow ON clauses to reference tables to their right for legacy compatibility, unless there is a RIGHT or FULL join someplace in the query, in which case there is no legacy to support. (check-in: [e615dbe02c] user: drh branch: trunk, size: 23440)
12:42
[70c092dcf3] part of check-in [fb0a23b678] The fix at [cab9b4cccd13bf0a] was incomplete, as demonstrated by forum post 57bdf2217d. This check-in should complete the fix. (check-in: [fb0a23b678] user: drh branch: trunk, size: 23088)
2021-09-21
17:26
[35c3bc0def] part of check-in [2c0e7ae541] Add the "PRAGMA table_list" command with its corresponding eponymous table-valued function: "pragma_table_list". (check-in: [2c0e7ae541] user: drh branch: trunk, size: 22677)
2020-02-28
16:04
[00792b030a] part of check-in [85a9b6a92f] 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: [85a9b6a92f] user: drh branch: trunk, size: 22542)
2019-12-06
19:07
[4092a8bd2b] part of check-in [ef73107f47] Early detection and reporting of too few columns in an rtree CREATE VIRTUAL TABLE statement. (check-in: [ef73107f47] user: drh branch: trunk, size: 22212)
13:10
[686216b418] part of check-in [97fb5a72f9] In the rtree extension, actively suppress extra tokens on the column names, and be pedantic about column affinities. Ticket [367a86e28859f1ff] (check-in: [97fb5a72f9] user: drh branch: trunk, size: 22093)
01:38
[891193aaf1] part of check-in [32772dfd50] 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: [32772dfd50] user: drh branch: trunk, size: 21880)
2019-12-05
13:34
[1b84301b15] part of check-in [d43e0efb96] Be strict about type enforcement on rowid look-ups in the RTREE extension. Ticket [30e2c183b6b356e4] (check-in: [d43e0efb96] user: drh branch: trunk, size: 21451)
00:44
[e3ce6e087f] part of check-in [f898d04cf2] Enhance the RTREE extension so that it give correct query results even if the query uses non-numeric constraints. Ticket [a55ab6d97d01ecbc] (check-in: [f898d04cf2] user: drh branch: trunk, size: 21136)
2019-01-11
17:41
[7573134f1b] part of check-in [556dd8922f] 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: [556dd8922f] user: dan branch: trunk, size: 19490)
2018-05-24
23:51
[309afc04d4] part of check-in [b816023ce0] 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: [b816023ce0] user: drh branch: trunk, size: 19222)
2018-05-18
16:46
[587889855b] part of check-in [95fd296ffc] Fix a prepare-statement leak. (check-in: [95fd296ffc] user: drh branch: aux-data-in-rtree, size: 19222)
15:21
[0300c431a6] part of check-in [059d20abd5] Improved error messages. Limit the number of auxiliary columns to 100. (check-in: [059d20abd5] user: drh branch: aux-data-in-rtree, size: 18832)
2018-02-07
18:02
[47e2095beb] part of check-in [2a5f813bc6] 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: [2a5f813bc6] user: dan branch: trunk, size: 18122)
2017-10-25
16:38
[82a353747f] part of check-in [dde0bb3eab] 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: [dde0bb3eab] user: dan branch: rtree-integrity-check, size: 18104)
2017-07-19
18:01
[4fdd60ae03] part of check-in [d14fc621e9] Remove some 'breakpoint' commands in test files. (check-in: [d14fc621e9] user: mistachkin branch: trunk, size: 18109)
2017-07-07
19:43
[d3a0c29512] part of check-in [732f90d632] 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: [732f90d632] user: drh branch: trunk, size: 18120)
2017-04-08
13:52
[d5f0ba215b] part of check-in [fa4416adc2] 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: [fa4416adc2] user: dan branch: trunk, size: 18160)
2016-05-23
16:16
[42dadfc7b4] part of check-in [3ad2531efb] Improve the error messages generated by the rtree module when a constraint fails. (check-in: [3ad2531efb] user: dan branch: trunk, size: 17719)
2015-10-03
12:23
[96a80c0844] part of check-in [f653fce908] 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: [f653fce908] user: dan branch: trunk, size: 17574)
2014-07-29
11:54
[541bbcab74] part of check-in [8cc41b0bf3] Have calls to the xFilter() method of rtree virtual tables ensure that cursor is initialized before proceeding. Fix for [d2889096e7bdeac]. (check-in: [8cc41b0bf3] user: dan branch: trunk, size: 15939)
2014-04-18
01:37
[e2da4aaa42] part of check-in [6f3e94f4b1] 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: [6f3e94f4b1] user: drh branch: rtree-enhancements, size: 15340)
2013-04-10
02:56
[cf679265ec] part of check-in [0adf8a3a4f] Correct test numbering on several rtree tests. (check-in: [0adf8a3a4f] user: mistachkin branch: trunk, size: 15100)
2012-04-02
21:35
[e474a2b5ef] part of check-in [02b7640f51] The SQLITE_RTREE_INT_ONLY compile-time option causes the RTree extension to use only integer math and store only integer coordinates. (check-in: [02b7640f51] user: drh branch: trunk, size: 15078)
2011-04-28
18:46
[28e1b8da4d] part of check-in [822ab52f10] Have r-tree virtual tables support on-conflict clauses. (check-in: [822ab52f10] user: dan branch: vtab-conflict, size: 14885)
2010-08-26
14:15
[dbd4250ac0] part of check-in [1975a27cde] Fix a couple of memory leaks in r-tree that can occur following an OOM condition. (check-in: [1975a27cde] user: dan branch: trunk, size: 11768)
2010-03-19
19:02
[51bb0cd040] part of check-in [f31d22489d] 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: [f31d22489d] user: dan branch: trunk, size: 11761)
2009-11-10
01:30
[f72885ed80] part of check-in [f6c045f649] Remove the obsolete "$Id:$" RCS identifier strings from the source code. (check-in: [f6c045f649] user: drh branch: trunk, size: 11339)
2009-07-17
16:54
[207041aba0] part of check-in [046efe46b5] Return a meaningful error message if a keyword is used as an rtree table column name. Ticket #3970. (CVS 6902) (check-in: [046efe46b5] user: danielk1977 branch: trunk, size: 11404)
2008-12-22
15:04
[ebcef11119] part of check-in [bbdc0e9f24] Fix a reference counting bug in rtree. Ticket #3549. (CVS 6054) (check-in: [bbdc0e9f24] user: danielk1977 branch: trunk, size: 11093)
2008-07-14
15:37
[620223886b] part of check-in [c060a9a6be] 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: [c060a9a6be] user: danielk1977 branch: trunk, size: 10141)
2008-06-23
16:53
[994da7f853] part of check-in [6dbe67da5c] 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: [6dbe67da5c] user: danielk1977 branch: trunk, size: 10078)
15:55
[b7c40c5358] part of check-in [e872c78c72] Run (a subset of) the rtree tests from quick.test. (CVS 5282) (check-in: [e872c78c72] user: danielk1977 branch: trunk, size: 10048)
2008-05-26
20:49
[7504a4bd3a] part of check-in [78f4ba974d] Use %w instead of %q when constructing shadow table names for rtree. (CVS 5161) (check-in: [78f4ba974d] user: drh branch: trunk, size: 10006)
18:41
Added: [9656384377] part of check-in [b104dcd6ad] Import 'rtree' extension. (CVS 5159) (check-in: [b104dcd6ad] user: danielk1977 branch: trunk, size: 10015)