/ History for ext/rtree/rtree.c
Login

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

History for ext/rtree/rtree.c

2020-04-09
18:51
[7b961078] part of check-in [d6fda470] Merge recent trunk changes into the apple-osx branch. (check-in: [d6fda470] user: drh branch: apple-osx, size: 142112)
2020-02-28
16:04
[0ee39cc7] 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: 142092)
2020-01-15
12:49
[c3cd872b] part of check-in [dadedf41] Merge all recent enhancements and fixes from trunk into the apple-osx branch. (check-in: [dadedf41] user: drh branch: apple-osx, size: 142010)
2020-01-07
14:51
[1430dc66] part of check-in [e6f5c0e0] Provide the ability to tag an application-defined function as "testonly". (check-in: [e6f5c0e0] user: drh branch: testonly-functions, size: 142040)
2019-12-23
20:41
[84b939a9] part of check-in [4c50afaf] Thoroughly reset the rtree cursor at the start of each VFilter operation, including clearing its cache. This prevents left over pages in the cache which can cause problems on shutdown after a LEFT JOIN. Ticket [5eadca17c4dde90c] (check-in: [4c50afaf] user: drh branch: trunk, size: 141990)
2019-12-07
12:13
[26fcb3f7] part of check-in [7fa664ea] Ignore type affinity for auxiliary columns in RTREE as it is too error-prone to try to parse out the type from other constraints. Ticket [8bf76328ac940d52] (check-in: [7fa664ea] user: drh branch: trunk, size: 142019)
2019-12-06
19:07
[cb9d3634] 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: 141991)
13:10
[f1dace13] 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: 141969)
01:38
[1f08e535] 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: 141633)
2019-12-05
14:42
[a71937b3] part of check-in [7ae8c0d5] Make sure the rowid of an RTREE virtual table has integer affinity. Ticket [9fe487ba3c064b4e] (check-in: [7ae8c0d5] user: drh branch: trunk, size: 141625)
13:34
[61543428] 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: 141621)
00:44
[32fa0d48] 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: 141402)
2019-09-16
12:02
[23838ee4] part of check-in [a95191de] Merge the latest changes from trunk into the apple-osx branch. (check-in: [a95191de] user: drh branch: apple-osx, size: 140382)
2019-09-03
18:04
[88b43ba0] part of check-in [8452fd54] Disable the undocumented rtreenode() SQL function that is only used for testing, except when doing a build that is specifically intended for testing. (check-in: [8452fd54] user: drh branch: branch-3.22, size: 132970)
17:55
[fa370616] part of check-in [34cd2d92] Disable the undocumented rtreenode() SQL function that is only used for testing, except when doing a build that is specifically intended for testing. (check-in: [34cd2d92] user: drh branch: branch-3.19, size: 118308)
17:46
[ec7e8d76] part of check-in [0a1cce49] Disable the undocumented rtreenode() SQL function that is only used for testing, except when doing a build that is specifically intended for testing. (check-in: [0a1cce49] user: drh branch: branch-3.18, size: 117346)
17:39
[1877268d] part of check-in [7b4583f9] Disable the undocumented rtreenode() SQL function that is only used for testing, except when doing a build that is specifically intended for testing. (check-in: [7b4583f9] user: drh branch: branch-3.9, size: 108774)
2019-07-29
17:18
[f8d9ea7d] part of check-in [48b518eb] Convert an assert() in R-Tree into a database corruption detection case. (check-in: [48b518eb] user: drh branch: trunk, size: 140362)
2019-07-20
18:00
[2bc0cec6] part of check-in [2bf5a4c1] Early detection of a corrupt R-Tree in the R-Tree search algorithm. (check-in: [2bf5a4c1] user: drh branch: trunk, size: 140296)
17:43
[f3ec2d1e] part of check-in [4e34e361] Performance optimizations in the rtreeStepToLeaf() routine of RTree. (check-in: [4e34e361] user: drh branch: trunk, size: 140111)
2019-07-10
17:58
[bc1bfc20] part of check-in [87aa1d70] Merge the 3.29.0 release into the apple-osx branch. (check-in: [87aa1d70] user: drh branch: apple-osx, size: 140029)
2019-07-09
17:36
[78c0d989] part of check-in [b6e17f01] Update rtree.c so that SQLITE_DEBUG is required to turn on assert() statements, even if it is compiled separately from the amalgamation. (check-in: [b6e17f01] user: dan branch: trunk, size: 140009)
2019-03-26
12:37
[117214a6] part of check-in [dc3c0b8b] Merge recent enhancements from trunk. (check-in: [dc3c0b8b] user: drh branch: apple-osx, size: 139890)
2019-03-20
11:16
[f2ce9012] part of check-in [90acdbfc] Enhance the rtreenode() function of rtree (used for testing) so that it uses the newer sqlite3_str object for better performance and improved error reporting. Test cases added to TH3. (check-in: [90acdbfc] user: drh branch: trunk, size: 139870)
2019-01-29
19:17
[4f225bba] part of check-in [31efcc37] Merge enhancements from trunk. (check-in: [31efcc37] user: drh branch: apple-osx, size: 139879)
2019-01-18
18:52
[57729cc1] part of check-in [b352f159] Avoid integer overflow when computing the array of a bounding box with the rtree_i32 virtual table. (check-in: [b352f159] user: drh branch: trunk, size: 139859)
2019-01-17
15:47
[68cc2046] part of check-in [475a179a] Sync up with the latest enhancements on trunk. (check-in: [475a179a] user: drh branch: apple-osx, size: 139829)
2019-01-08
20:02
[1e0fd7e8] part of check-in [ca67f2ec] Use 64-bit math to compute the sizes of memory allocations in extensions. (check-in: [ca67f2ec] user: drh branch: trunk, size: 139809)
14:28
[1fb8a71a] part of check-in [63eb803d] Fix a possible memory leak when trying to UPDATE a corrupt RTREE index. (check-in: [63eb803d] user: drh branch: trunk, size: 139767)
2018-12-21
22:08
[fae9943b] part of check-in [b39bf435] Improved detection of shadow table corruption in RTREE. (check-in: [b39bf435] user: drh branch: trunk, size: 139767)
19:55
[9b7bd1f7] part of check-in [82a2ae71] Use SQLITE_PREPARE_NO_VTAB in rtree as well. (check-in: [82a2ae71] user: dan branch: prepare-no-vtab, size: 139345)
18:17
[0a478953] part of check-in [0bf4c70a] Fix the node hash function in RTREE to ensure that it always returns a non-negative value. (check-in: [0bf4c70a] user: drh branch: trunk, size: 139389)
17:51
[382898f6] part of check-in [1fdd3604] Fix a potential NULL-pointer deference in RTREE due to corrupt shadow tables. (check-in: [1fdd3604] user: drh branch: trunk, size: 139368)
16:53
[631b16a3] part of check-in [08566718] Prevent an infinite loop in rtree that can result from a corrupt shadow table. (check-in: [08566718] user: drh branch: trunk, size: 139280)
15:13
[07b93ef2] part of check-in [ed8531e5] Fix the RTree extension so that it correctly ignores constraints that it does not understand, even if they are against a dimension column. (check-in: [ed8531e5] user: drh branch: trunk, size: 138705)
13:30
[e687520f] part of check-in [99bce435] In RTREE, turn an assert() into an if() because the condition can sometimes be false when dealing with a corrupt database. (check-in: [99bce435] user: drh branch: trunk, size: 138626)
2018-11-10
20:07
[073289c3] part of check-in [977fc44e] Merge the read-only shadow table and defensive mode enhancments from trunk. (check-in: [977fc44e] user: drh branch: apple-osx, size: 138656)
2018-11-06
14:03
[7125183b] part of check-in [d890c658] Only allow shadow table to be written from within a recursive SQL call. Omit the SQLITE_PREPARE_SHADOW flag. Some tests are failing because the tests depend on being able to write to shadow tables. (check-in: [d890c658] user: drh branch: read-only-shadow, size: 138636)
2018-11-05
23:01
[8367dc4a] part of check-in [31942b3d] Initial code to make shadow tables read-only to ordinary SQL. The now xShadowName method is added to the sqlite3_module object and is used to identify potential shadow tables. The SQLITE_PREPARE_SHADOW argument to sqlite3_prepare_v3() is defined. It is designed to permit writing to shadow tables, but is currently an unused placeholder. (check-in: [31942b3d] user: drh branch: read-only-shadow, size: 138690)
2018-10-09
22:50
[b697b382] part of check-in [ddf6a54e] Merge changes for the 3.25.0 release. (check-in: [ddf6a54e] user: drh branch: apple-osx, size: 138245)
2018-09-12
01:05
[6cc2e673] part of check-in [78862252] Fix some harmless compiler warnings seen with MSVC. (check-in: [78862252] user: mistachkin branch: trunk, size: 138225)
2018-08-29
20:52
[ce94cbb3] part of check-in [7c3cee0a] Fixes to the UPDATE logic in Geopoly. (check-in: [7c3cee0a] user: drh branch: trunk, size: 138226)
2018-06-04
14:10
[a1444c00] part of check-in [95fbac39] Merge changes from trunk. (check-in: [95fbac39] user: drh branch: apple-osx, size: 137826)
2018-05-28
23:59
[f3c2f1b5] part of check-in [4288f1ad] The geopoly virtual table seems to be working. But only thinly tested so far. (check-in: [4288f1ad] user: drh branch: rtree-geopoly, size: 138017)
2018-05-25
19:22
[2fd3c149] part of check-in [0593aac8] Forward port the geopoly extension functions into the r-tree extension, with the idea of creating a new spatial index based on simply polygons. (check-in: [0593aac8] user: drh branch: rtree-geopoly, size: 138007)
14:39
[1a11f26c] part of check-in [6f7cfeff] This is an untested proof-of-concept for enhancements to RTree that attempt to use sqlite3_value_nochange() to reduce the amount of work associated with UPDATE operations in cases where either the coordinates or the auxiliary data is unchanged. (check-in: [6f7cfeff] user: drh branch: rtree-update-optimization, size: 139475)
2018-05-24
23:51
[cb6d4bd4] 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: 137806)
22:31
[204ddbb7] part of check-in [d4ce6661] Do not allow RTree writes when a read cursor is active on the same virtual table, as the writes might rebalance and disrupt the read cursors. Return the new SQLITE_LOCKED_VTAB error code if this happens. (check-in: [d4ce6661] user: drh branch: trunk, size: 137753)
2018-05-18
16:53
[148ae743] part of check-in [16f71032] Avoid unnecessary sqlite3_finalize() operations. (check-in: [16f71032] user: drh branch: aux-data-in-rtree, size: 137209)
16:46
[22f70cfd] part of check-in [95fd296f] Fix a prepare-statement leak. (check-in: [95fd296f] user: drh branch: aux-data-in-rtree, size: 137170)
15:21
[b590972c] 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: 137134)
2018-05-16
19:56
[90c35907] part of check-in [46715136] Fix an issue with rtreecheck() and auxiliary data columns. (check-in: [46715136] user: drh branch: aux-data-in-rtree, size: 136968)
19:07
[76282349] part of check-in [9abe023e] Do not allow auxiliary columns in the rtree to interfere with query planning. Begin adding test cases. (check-in: [9abe023e] user: drh branch: aux-data-in-rtree, size: 136610)
18:18
[8176ca2b] part of check-in [c489d8e4] Fix the OOM issue mentioned in the previous check-in. (check-in: [c489d8e4] user: drh branch: aux-data-in-rtree, size: 136479)
17:57
[74c1157c] part of check-in [0c87fec9] Initial implementation of the ability to have auxiliary columns in an rtree virtual table that store arbitrary content. It mostly works, but there are some minor issues in OOM corner cases. (check-in: [0c87fec9] user: drh branch: aux-data-in-rtree, size: 136469)
2018-05-14
15:26
[11dc450e] part of check-in [fd8b8c41] Convert the schema creation logic in the rtree extension to use the new sqlite3_str interface. (check-in: [fd8b8c41] user: drh branch: trunk, size: 132934)
2018-03-14
17:17
[91716a27] part of check-in [a658f80c] Merge the latest enhancements from trunk. (check-in: [a658f80c] user: drh branch: apple-osx, size: 132943)
2018-02-07
18:02
[bc61010e] 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: 132923)
2018-01-22
19:04
[d794ab6a] part of check-in [27e20d69] Merge all version-3.22.0 changes. (check-in: [27e20d69] user: drh branch: apple-osx, size: 132914)
2018-01-20
15:48
[d941e44a] part of check-in [136bf323] Allow the shell to be built from the configure script with SQLITE_OMIT_VIRTUALTABLE defined. (check-in: [136bf323] user: dan branch: trunk, size: 132894)
2018-01-15
21:59
[cc7c46b0] part of check-in [c9d2ec51] Merge the enhancements associated with the first 3.22.0 beta. (check-in: [c9d2ec51] user: drh branch: apple-osx, size: 132870)
2018-01-12
00:30
[5db4eb1a] part of check-in [8b8314cb] Enable the one-pass optimization for DELETE and UPDATE on RTree. This is parked in a branch because is seems to make no measureable performance difference. (check-in: [8b8314cb] user: drh branch: rtree-one-pass, size: 132903)
2017-12-16
04:37
[2111f685] part of check-in [64487d65] Add unnecessary initializations to some local variables in the rtree module to suppress false-positive compiler warnings coming out of MSVC. (check-in: [64487d65] user: drh branch: trunk, size: 132850)
2017-11-14
20:00
[34fdbe3d] part of check-in [1754faef] Merge all changes from trunk prior to the read-only WAL enhancement. (check-in: [1754faef] user: drh branch: apple-osx, size: 132862)
2017-10-25
18:17
[cc91b690] part of check-in [d6130cd2] Add tests cases and fix minor issues in the rtreecheck() function. (check-in: [d6130cd2] user: dan branch: trunk, size: 132842)
18:00
[49ced717] part of check-in [61870b42] Fix compilation issue (C99-ism) seen with MSVC. (check-in: [61870b42] user: mistachkin branch: rtree-integrity-check, size: 131213)
16:38
[7941c428] 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: 131207)
2017-10-24
19:12
[7afe34b0] part of check-in [13be3a44] Merge all enhancements and fixes from the 3.21.0 release. (check-in: [13be3a44] user: drh branch: apple-osx, size: 117455)
2017-09-21
13:11
[f2fd34db] part of check-in [fd4ec0cd] Fix a potential use of an uninitialized pointer in RTree following an OOM error. (check-in: [fd4ec0cd] user: drh branch: trunk, size: 117435)
2017-09-09
06:10
[99370124] part of check-in [6a0b9d9d] Merge trunk enhancements (check-in: [6a0b9d9d] user: drh branch: apple-osx, size: 117455)
2017-08-17
18:17
[cf84d529] part of check-in [0712f057] The RTREE extension should return SQLITE_CORRUPT_VTAB, not just SQLITE_CORRUPT when it encounters incorrectly formatted shadow tables. (check-in: [0712f057] user: drh branch: trunk, size: 117435)
2017-07-27
03:48
[4f1804b8] part of check-in [3d9e841f] Add a destructor argument to sqlite3_bind_pointer() and sqlite3_result_pointer(). (check-in: [3d9e841f] user: drh branch: pointer-with-destructor, size: 117430)
00:27
[497a3040] part of check-in [24c9cd46] Do now allow the geometry object in the right operand of a MATCH operator in the RTREE extension to be inpersonated by a BLOB literal. (check-in: [24c9cd46] user: drh branch: branch-3.19, size: 118232)
2017-07-07
22:58
[970d4bac] part of check-in [7f48f6ab] Merge in all the latest trunk enhancements. (check-in: [7f48f6ab] user: drh branch: apple-osx, size: 118332)
2017-07-01
15:21
[c5886d4b] part of check-in [66de6f4a] Enhance the RTree module to detect node truncation early and report an error. (check-in: [66de6f4a] user: drh branch: trunk, size: 118312)
2017-06-28
17:29
[f47c18a7] part of check-in [942c3ef8] Instead of the new sqlite3_prepare_v3() interface, provide the SQLITE_DBCONFIG_PREPARE_FLAGS interface which sets the flags on the single next call to sqlite3_prepare_v2() or its cousins. (check-in: [942c3ef8] user: drh branch: dbconfig-prepare-flags, size: 118182)
2017-06-01
00:54
[9c55ff73] part of check-in [4a25c588] Add interfaces sqlite3_prepare_v3() and sqlite3_prepare16_v3() with the extra prepFlags argument. Add the SQLITE_PREPARE_PERSISTENT option as one bit in that argument. (check-in: [4a25c588] user: drh branch: prepare_v3, size: 118123)
2017-05-11
18:49
[00dabe6c] part of check-in [b55c0f14] Merge recent enhancements from trunk. (check-in: [b55c0f14] user: drh branch: apple-osx, size: 118086)
2017-05-06
17:12
[8205d6e4] part of check-in [198ff4c0] Fix requirements marks and harmless compiler warnings. (check-in: [198ff4c0] user: drh branch: trunk, size: 118066)
2017-04-08
18:24
[50946312] part of check-in [c23ef5e2] Merge all recent changes from trunk. (check-in: [c23ef5e2] user: drh branch: apple-osx, size: 118054)
13:52
[37c603c6] 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: 118034)
01:09
[fb7c0e62] part of check-in [1cdae2db] Make sure the RTree sqlite3_blob handle is reset prior to renaming the table. (check-in: [1cdae2db] user: drh branch: trunk, size: 117297)
2017-03-30
20:26
[3be16f2e] part of check-in [ed28f15e] Merge all changes from the 3.18.0 release. (check-in: [ed28f15e] user: drh branch: apple-osx, size: 117290)
2017-03-20
19:26
[0acd285b] part of check-in [a144875f] Avoid a technically undefined right-shift of a signed value in rtree.c. (check-in: [a144875f] user: dan branch: trunk, size: 117270)
2017-03-06
20:00
[d99720f7] part of check-in [1650c3f4] Merge all pending 3.18 enhancements from trunk. (check-in: [1650c3f4] user: drh branch: apple-osx, size: 117285)
2017-02-15
15:09
[3f3a595d] part of check-in [810d2932] Remove the CLANG_VERSION macro, since we have learned that version numbers in clang are "marketing" and are inconsistent and unreliable. Builds using clang will still use the GCC_VERSION macro since clang works hard to be gcc compatible. (check-in: [810d2932] user: drh branch: trunk, size: 117265)
2017-02-13
16:17
[e1bb8d04] part of check-in [1913a758] Merge all changes up through the 3.17.0 release. (check-in: [1913a758] user: drh branch: apple-osx, size: 117554)
2017-02-09
17:12
[358796a3] part of check-in [798fb9d7] Cleanup the usage of the SQLITE_DISABLE_INTRINSIC compile-time option. Remove the SQLITE_RUNTIME_BYTEORDER compile-time option. Use -DSQLITE_BYTEORDER=0 instead. Fix a bug in R-Tree that occurs when compiling on a known little-endian machine without the use of intrinsic byteswapping functions. (check-in: [798fb9d7] user: drh branch: trunk, size: 117534)
2017-02-08
16:55
[e83711f6] part of check-in [92dbd875] Merge the 3.17.0beta changes from trunk. (check-in: [92dbd875] user: drh branch: apple-osx, size: 117688)
2017-02-07
14:45
[d92be99e] part of check-in [bb7f445b] Fix a build problem affecting non-amalgamation rtree builds. (check-in: [bb7f445b] user: dan branch: trunk, size: 117668)
13:51
[97b6560b] part of check-in [a136609c] Fix SQLITE_BYTEORDER #defines in R-Tree when compiled separately from the amalgamation. (check-in: [a136609c] user: drh branch: trunk, size: 117640)
12:58
[773fbf12] part of check-in [07fe6228] Make the cellMargin() routine of R-Tree slightly smaller and faster while also fixing a harmless compiler warning. (check-in: [07fe6228] user: drh branch: trunk, size: 117639)
00:55
[76311736] part of check-in [f77ee9e9] Fix a minor typo in a comment in R-Tree. No changes to code. (check-in: [f77ee9e9] user: drh branch: trunk, size: 117675)
2017-02-06
16:52
[2f7785ee] part of check-in [e5aea894] Remove a small amount of unnecessary code from R-Tree. (check-in: [e5aea894] user: drh branch: trunk, size: 117674)
01:19
[d40feeee] part of check-in [853a58a7] Remove incorrect testcase() macros from R-Tree. (check-in: [853a58a7] user: drh branch: trunk, size: 118110)
2017-02-04
15:29
[f6aedbf7] part of check-in [6c3f0902] Merge recent trunk enhancements. (check-in: [6c3f0902] user: drh branch: apple-osx, size: 118525)
14:24
[0c229d23] part of check-in [97ccf3e4] In RTREE, use an sqlite3_blob object rather than an sqlite3_stmt object for reading content out of the %_node shadow table. (check-in: [97ccf3e4] user: drh branch: trunk, size: 118505)
13:12
[ed39c157] part of check-in [95ee745f] Close sqlite3_blob objects on xSync rather than waiting until xCommit. (check-in: [95ee745f] user: drh branch: rtree-blob-agressive-release, size: 118504)
2017-02-02
16:30
[be9d44f5] part of check-in [e51dc0ec] Remove the unused pReadNode prepared statement from each RTREE object. (check-in: [e51dc0ec] user: drh branch: rtree-sqlite3_blob, size: 118504)
16:08
[e1b77d0f] part of check-in [a1c74e09] Fix a potential uninitialized (though harmless) variable in RTREE. (check-in: [a1c74e09] user: drh branch: rtree-sqlite3_blob, size: 118673)
15:35
[93fd417d] part of check-in [88333441] The sqlite3_blob_close() interface can cause recursive invocations of nodeBlobReset() in RTREE. Make sure that does not cause problems. (check-in: [88333441] user: drh branch: rtree-sqlite3_blob, size: 118715)
14:40
[df33d86d] part of check-in [9bb4eafe] Change RTREE so that the sqlite3_blob object is closed whenever the cursor count drops to zero and there is not a pending write transaction. (check-in: [9bb4eafe] user: drh branch: rtree-sqlite3_blob, size: 118682)
02:28
[73c43085] part of check-in [fc4917d7] Use the sqlite3_blob interface for reading values from the %_node shadow table in RTREE. This is a work in progress. There are still some minor problems. (check-in: [fc4917d7] user: drh branch: rtree-sqlite3_blob, size: 118234)
2017-02-01
23:06
[70f2488e] part of check-in [0c66cf0f] Fix harmless compiler warnings seen with MSVC. (check-in: [0c66cf0f] user: mistachkin branch: trunk, size: 116938)
22:59
[58d3fa51] part of check-in [54d28546] Fix C99-style variable declaration issue seen with older versions of MSVC. (check-in: [54d28546] user: mistachkin branch: trunk, size: 116902)
22:43
[880edfc9] part of check-in [997f765b] Fix harmless compiler warnings seen with MSVC. (check-in: [997f765b] user: mistachkin branch: msvcWarn, size: 116701)
17:08
[f2c8604f] part of check-in [4854ea9c] Unwind the RTREE dimension loop inside of rtreeCallbackConstraint(). (check-in: [4854ea9c] user: drh branch: trunk, size: 116665)
16:41
[60df707c] part of check-in [3c4c0126] Completely unroll the dimension loop inside of cellArea() in RTREE. (check-in: [3c4c0126] user: drh branch: trunk, size: 115498)
15:49
[bc73bae0] part of check-in [f1f3c8cc] Precompute the nDim2 value in the Rtree object and use that to make loops over coordinates faster. (check-in: [f1f3c8cc] user: drh branch: trunk, size: 114871)
15:24
[d8ef14e9] part of check-in [82fcd54a] Use compiler intrinsic functions (when available) for byteswapping in RTREE. (check-in: [82fcd54a] user: drh branch: trunk, size: 114686)
02:25
[f66b3d23] part of check-in [c5395e74] More RTREE performance optimizations related to decoding values. (check-in: [c5395e74] user: drh branch: trunk, size: 111041)
2017-01-31
21:22
[81fea8b1] part of check-in [0bf7b518] R-TREE optimization: unwrap the coordinate decode loop in rtreeCallbackConstraint(). (check-in: [0bf7b518] user: drh branch: trunk, size: 110577)
2016-11-04
19:09
[0f08a7e3] part of check-in [0e5ffd91] Merge recent trunk changes, including all the fixes that appeared in version 3.15.1. (check-in: [0e5ffd91] user: drh branch: apple-osx, size: 110496)
2016-10-10
10:06
[078fc274] part of check-in [788f86be] Fix a case in which the rtree module was ignoring an OOM while generating an error message. (check-in: [788f86be] user: dan branch: trunk, size: 110476)
2016-09-07
18:20
[cd7e3d8f] part of check-in [00759af0] Merge recent enhancements from trunk. (check-in: [00759af0] user: drh branch: apple-osx, size: 110463)
2016-08-27
20:21
[0b450226] part of check-in [a07269f2] Fix typos in comments. No changes to running code. (check-in: [a07269f2] user: drh branch: trunk, size: 110443)
2016-06-15
10:21
[45c6bec2] part of check-in [0f707d15] Merge changes from trunk. (check-in: [0f707d15] user: drh branch: apple-osx, size: 110467)
2016-05-23
18:12
[d26a815b] part of check-in [48526a2f] Fix RTREE so that it does not run queries against the sqlite_stat1 if that table does not exist. (check-in: [48526a2f] user: drh branch: tree-stat1-fix, size: 110447)
16:16
[7ebca7d1] 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: 110270)
2016-03-07
20:48
[428878f7] part of check-in [84f09f00] Merge recent enhancements from trunk. (check-in: [84f09f00] user: drh branch: apple-osx, size: 108717)
2016-03-05
20:28
[0b870ccb] part of check-in [fd7cd060] Adjust the cost estimates for RTREE such that the expected number of rows and expected cost is halved for each additional constraint. (check-in: [fd7cd060] user: drh branch: xbestindex-fix, size: 108697)
2015-08-28
02:12
[65a024af] part of check-in [da864658] Merge trunk enhancements into the apple-osx branch. Most tests works, but there are yet a few issues to be resolved. (check-in: [da864658] user: drh branch: apple-osx, size: 108718)
2015-05-22
23:17
[0f9b595b] part of check-in [10cc44f5] Fix incorrect validation of the size of the BLOB returned by a geometry function on the RHS of a MATCH operator in RTree. The old code worked for 64-bit systems (by chance) but fails on 32-bit. (check-in: [10cc44f5] user: drh branch: trunk, size: 108698)
16:08
[9d9302a6] part of check-in [b9fb9519] Have r-tree prefer to use the constraint "col MATCH ?" over "rowid = ?". (check-in: [b9fb9519] user: dan branch: trunk, size: 108248)
2015-05-21
20:26
[00c95369] part of check-in [b9e45596] Have r-tree prefer to use the constraint "col MATCH ?" over "rowid = ?". drh added later: All changes on this branch have been cherrypicked to trunk and will be merged into sessions from trunk. So this branch can close. (check-in: [b9e45596] user: dan branch: sessions-value-dup, size: 108762)
2015-05-20
21:28
[50d9df06] part of check-in [a7ee40c4] Add the sqlite3_value_dup() and sqlite3_value_free() interfaces. Use these interfaces to enhance R-Tree to add the sqlite3_rtree_query_info.apSqlParam field. (check-in: [a7ee40c4] user: drh branch: value-dup, size: 108260)
2015-05-19
22:20
[60ec0a71] part of check-in [b271ed56] Allow R-Tree geometry functions to take 8-byte BLOB arguments which are passed directly through to the underlying callback, and which can be used to pass pointers into the callback. (check-in: [b271ed56] user: drh branch: trunk, size: 107746)
2015-05-01
18:00
[0c207fd8] part of check-in [9a45409c] Fix an assert in RTREE that would fire if the rtree table is misdeclared. (check-in: [9a45409c] user: drh branch: trunk, size: 107488)
2015-01-16
12:24
[dd251a63] part of check-in [518621f8] Merge the 3.8.8 release changes from trunk. (check-in: [518621f8] user: drh branch: apple-osx, size: 107154)
2015-01-13
21:26
[14e62394] part of check-in [882181ff] Simplify some code in rtree, to avoid confusing the optimizer in GCC on some macs: gcc version 4.2.1 (Based on Apple Inc. build 5658) (LLVM build 2335.15.00). Prior to these changes, compiling with -O3 would cause incorrect code to be generated. The change to the nodeGetCell() routine is key. The other changes are merely cosmetic details discovered while bug hunting. (check-in: [882181ff] user: drh branch: trunk, size: 107134)
2015-01-12
18:52
[b61e9eab] part of check-in [c8725fa5] Get things compiling cleanly with MSVC and W4. (check-in: [c8725fa5] user: mistachkin branch: msvcW4, size: 107183)
2015-01-02
19:17
[072d7c54] part of check-in [df3cdf9f] Merge the latest changes from trunk into the apple-osx branch. (check-in: [df3cdf9f] user: drh branch: apple-osx, size: 107135)
2015-01-01
16:47
[a03ebd24] part of check-in [30891c6b] Fix a harmless compiler warning in rtree. (check-in: [30891c6b] user: drh branch: trunk, size: 107115)
2014-07-30
11:49
[8f4190b3] part of check-in [654c6c65] Merge all recent trunk changes, and especially the R-Tree IN operator fix of ticket [d2889096e7bdeac]. (check-in: [654c6c65] user: drh branch: apple-osx, size: 107148)
2014-07-29
11:54
[57bec53e] 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: 107128)
2014-05-08
23:01
[8884ffb0] part of check-in [9411d7dc] Initial attempt to merge in all trunk changes over the previous 1.5 years. This check-in compiles but there are compiler warnings and "make test" segfaults after only running a few test modules. (check-in: [9411d7dc] user: drh branch: apple-osx, size: 106962)
2014-04-25
16:29
[6f70db93] part of check-in [f7dad408] Enhance the sqlite3_rtree_query_info object to report on the number of elements in the priority queue at each level. (check-in: [f7dad408] user: drh branch: rtree-enhancements, size: 106942)
2014-04-21
18:13
[77fdd459] part of check-in [eba95ead] Fix the generation of sqlite3_rtree_query_info.iRowid and add test cases to verify that it is fixed. (check-in: [eba95ead] user: drh branch: rtree-enhancements, size: 106444)
15:53
[2474c438] part of check-in [43946938] Be sure to initialize the sqlite3_rtree_query_info.iRowid field for the leaves of the R-Tree when doing a query callback search. (check-in: [43946938] user: drh branch: rtree-enhancements, size: 106444)
15:21
[09000d72] part of check-in [d708f159] Fix an off-by-one error in setting the "iLevel" field of the sqlite3_rtree_query_info structure passed into the RTree query callback. (check-in: [d708f159] user: drh branch: rtree-enhancements, size: 106338)
2014-04-18
01:37
[b8357523] 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: 106334)
2014-04-17
23:23
[5cf5ae21] part of check-in [444084fd] Performance optimization on byte-swapping in R-Tree. (check-in: [444084fd] user: drh branch: rtree-enhancements, size: 105744)
14:52
[6a47918e] part of check-in [1ccaaed6] Test cases and bug fixes for the sqlite3_rtree_query_callback() mechanism. (check-in: [1ccaaed6] user: drh branch: rtree-enhancements, size: 105007)
13:15
[117aaebe] part of check-in [32a13870] 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. (check-in: [32a13870] user: drh branch: rtree-enhancements, size: 103994)
2014-04-16
21:02
[1a59db35] part of check-in [5d20ff9e] Performance optimization on nodeGetCell() in R-Tree. (check-in: [5d20ff9e] user: drh branch: rtree-enhancements, size: 103196)
17:15
[142d70dc] part of check-in [f864bacc] TCL tests now all pass. (check-in: [f864bacc] user: drh branch: rtree-queue, size: 103070)
14:45
[4702eae3] part of check-in [5b0e6ba4] Fix a bug in rowid=? query handling. More problems remain. (check-in: [5b0e6ba4] user: drh branch: rtree-queue, size: 102944)
13:00
[3105c551] part of check-in [a439ddd6] Bug fixes to the priority-queue implementation for R-Trees. Improved tracing capability. Some queries work now, but still many problems. (check-in: [a439ddd6] user: drh branch: rtree-queue, size: 102938)
2014-04-15
21:06
[2f4d35a0] part of check-in [53688a25] Initial attempt at getting R-Tree queries to work using a priority queue. This check-in compiles, but R-Trees do not work well. And there are debugging printf()s left in the code. This is an incremental check-in. (check-in: [53688a25] user: drh branch: rtree-queue, size: 101963)
2014-04-14
14:43
[07630c25] part of check-in [ade5b986] Fix comments on the rtreenode() and rtreedepth() test function in the R-Tree module. (check-in: [ade5b986] user: drh branch: rtree-enhancements, size: 94828)
12:18
[d7fbe473] part of check-in [3ba5f295] Remove over 300 lines of unused code, code that implemented the older Guttman insertion algorithms that are no longer used. (check-in: [3ba5f295] user: drh branch: rtree-enhancements, size: 94360)
2014-04-13
16:10
[527490ab] part of check-in [ca7357e6] Continuing work on the new custom query mechanism for r-tree. (check-in: [ca7357e6] user: drh branch: rtree-enhancements, size: 102165)
2014-04-12
17:44
[8778f55e] part of check-in [66c858f2] Continuing clean-up of the R-Tree module in preparation for cutting in the new generalized query mechanism. (check-in: [66c858f2] user: drh branch: rtree-enhancements, size: 101939)
2014-04-11
23:14
[541016f8] part of check-in [0b702759] Add the new interfaces to rtree, though they do not yet work. Add the "show_speedtest1_rtree.tcl" script for showing the test data used for the R-Tree tests of speedtest1. Change speedtest1 to generate better R-Tree test data. (check-in: [0b702759] user: drh branch: rtree-enhancements, size: 101001)
16:14
[043f16a6] part of check-in [20a73ec0] Update comments in the R-Tree module in preparation for some big changes. Add an "rtree" performance test to speedtest1. (check-in: [20a73ec0] user: drh branch: rtree-enhancements, size: 99879)
2014-03-12
19:38
[2d9f95da] part of check-in [6504aa47] Fix an obscure bug causing sqlite3_close() to fail if there are virtual tables on the disconnect list when it is called. (check-in: [6504aa47] user: dan branch: trunk, size: 98383)
12:44
[d963b961] part of check-in [7ce03c1b] Prevent the rtree module from reading sqlite_stat1 data from the wrong database. (check-in: [7ce03c1b] user: dan branch: trunk, size: 98325)
2013-11-11
19:56
[a4e18b2c] part of check-in [f58d5701] Fix typos in compile and run-time tests of the sqlite library version number in rtree.c. (check-in: [f58d5701] user: dan branch: trunk, size: 98208)
19:01
[1ec67e64] part of check-in [5a3cfd74] 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. (check-in: [5a3cfd74] user: dan branch: trunk, size: 98206)
2013-07-04
23:53
[db516d7e] part of check-in [f2ab8747] Modify several extensions to use the new exported function naming. Fix some shared library compilation issues. (check-in: [f2ab8747] user: mistachkin branch: extRefactor, size: 96161)
2013-03-21
21:20
[757abea5] part of check-in [6f6e2d50] Many spelling fixes in comments. No changes to code. (check-in: [6f6e2d50] user: mistachkin branch: trunk, size: 96122)
2013-01-17
03:18
[ebd07d0f] part of check-in [652233d6] Enhance RTree virtual table creation error messages that involve the getNodeSize() function. (check-in: [652233d6] user: mistachkin branch: rtreeErrMsg, size: 96122)
2012-10-01
20:12
[47064ee2] part of check-in [8b5f617c] Fix several compiler warnings seen with MSVC. (check-in: [8b5f617c] user: mistachkin branch: msvcWarnings, size: 95890)
2012-06-08
01:13
[950e43bc] part of check-in [9d1b8515] Merge trunk changes into the apple-osx branch. (check-in: [9d1b8515] user: drh branch: apple-osx, size: 95906)
2012-05-29
00:30
[d17aecb7] part of check-in [f607ad27] Refactor the float-to-double rounding routines so that they compile without warnings. (check-in: [f607ad27] user: drh branch: rtree-32bit-rounding, size: 95886)
2012-05-28
20:16
[529aad20] part of check-in [df24072d] Simplification to the coordinate rounding logic in RTree. (check-in: [df24072d] user: drh branch: rtree-32bit-rounding, size: 95755)
19:19
[b8d6cb92] part of check-in [f4e8ff03] When converting 64-bit floating point coordinates to 32-bit in RTree, take care to round the values such that the size of the bounding box is enlarged. (check-in: [f4e8ff03] user: drh branch: rtree-32bit-rounding, size: 95849)
2012-04-19
20:43
[d918e173] part of check-in [b72f07b4] Update the apple-osx branch so that it includes all of the latest trunk changes. (check-in: [b72f07b4] user: drh branch: apple-osx, size: 95135)
2012-04-02
21:35
[73502e53] 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: 95115)
2012-03-19
16:21
[4e69b25b] part of check-in [f999197b] Merge latest trunk changes into apple-osx branch. (check-in: [f999197b] user: dan branch: apple-osx, size: 93551)
14:51
[4c187881] part of check-in [4fd68647] Suppress harmless compiler warnings on windows in FTS4 and RTREE. (check-in: [4fd68647] user: drh branch: trunk, size: 93531)
2012-01-03
21:54
[418543c3] part of check-in [8a048423] Pull all the latest trunk changes over into the apple-osx branch. (check-in: [8a048423] user: drh branch: apple-osx, size: 93531)
2011-12-22
18:44
[eec44ad2] part of check-in [a61786e7] Backport the fixes for Coverity-discovered problems in [1c27d84216], [676acce274], and [f9c4a7c8f4] from trunk to the 3.7.6 branch. (check-in: [a61786e7] user: drh branch: branch-3.7.6, size: 91836)
17:31
[b92ab2e9] part of check-in [1c27d842] Fix minor issues with FTS and RTREE discovered by coverity. (check-in: [1c27d842] user: drh branch: trunk, size: 93511)
2011-10-21
17:18
[f1ce5409] part of check-in [be62ef05] Merge the latest trunk changes into the apple-osx branch. (check-in: [be62ef05] user: drh branch: apple-osx, size: 93532)
2011-10-15
00:16
[692e9192] part of check-in [39408702] Added the tool/warnings-clang.sh script. Changes so that there are no warnings with either gcc or clang even including FTS4 and RTREE and both with and without SQLITE_THREADSAFE=0. (check-in: [39408702] user: drh branch: trunk, size: 93512)
2011-10-14
22:57
[1ac5f6dc] part of check-in [b3324f6c] Fix a few minor and harmless clang warnings in FTS3 and RTREE. (check-in: [b3324f6c] user: drh branch: trunk, size: 93484)
2011-06-21
01:30
[c64b78b1] part of check-in [76005fdc] Merge the latest trunk changes into the apple-osx branch. (check-in: [76005fdc] user: drh branch: apple-osx, size: 93433)
2011-06-20
19:00
[b431c54d] part of check-in [ed2dda93] More compiler warning fixes. (check-in: [ed2dda93] user: drh branch: trunk, size: 93413)
17:24
[19ed115b] part of check-in [fe62179e] Fix various harmless compiler warnings in FTS3 and RTREE. (check-in: [fe62179e] user: drh branch: trunk, size: 93337)
2011-06-02
13:07
[bd21acad] part of check-in [ce5f95de] Merge the latest trunk changes, including the read-only shared memory enhancement, into the apple-osx branch. (check-in: [ce5f95de] user: drh branch: apple-osx, size: 93297)
2011-05-25
23:18
[4b843844] part of check-in [a4755e70] Fix some minor and harmless compiler warnings. (check-in: [a4755e70] user: drh branch: trunk, size: 93277)
2011-05-19
01:51
[d3741cde] part of check-in [8d1a6bb0] Pull all the latest trunk changes, and especially the fix for WAL cache spills causing transactions to disappear, into the apple-osx branch. (check-in: [8d1a6bb0] user: drh branch: apple-osx, size: 93156)
2011-05-17
15:56
[2445bec9] part of check-in [8844e8bf] Add extended return code SQLITE_CORRUPT_VTAB. Returned when the tcontents of the sqlite tables used internally by a virtual table module are invalid or inconsistent. (check-in: [8844e8bf] user: dan branch: trunk, size: 93136)
2011-05-05
15:52
[15361dc2] part of check-in [f9b149e5] Merge the latest trunk changes into the apple-osx branch. (check-in: [f9b149e5] user: drh branch: apple-osx, size: 93121)
2011-04-28
18:46
[829c6901] part of check-in [822ab52f] Have r-tree virtual tables support on-conflict clauses. (check-in: [822ab52f] user: dan branch: vtab-conflict, size: 93101)
2011-04-05
22:10
[b159d6a5] part of check-in [c77a767c] Merge the latest trunk changes into the apple-osx branch. (check-in: [c77a767c] user: drh branch: apple-osx, size: 91857)
22:08
[f5fa951e] part of check-in [3eeb0ff7] Suppress many harmless compiler warnings, mostly signed/unsigned comparisons within asserts or unused parameters in extensions. (check-in: [3eeb0ff7] user: drh branch: trunk, size: 91837)
2011-04-04
13:11
[155c420f] part of check-in [6d78a25d] Merge in the latest changes from trunk. (check-in: [6d78a25d] user: drh branch: apple-osx, size: 91847)
2011-03-23
10:38
[48705ee8] part of check-in [387b55aa] Change the rtree module to support queries with multiple comparison operators (i.e. > or <) of the same type on a single column. (check-in: [387b55aa] user: dan branch: trunk, size: 91827)
2011-03-02
15:44
[115b4994] part of check-in [24602557] Make sure the rtreenode() testing and analysis routine in the RTREE extension can handle 64-bit rowids. This fix is in response to a message on the mailing list. (check-in: [24602557] user: drh branch: trunk, size: 92894)
2010-12-07
15:49
[cc46316f] part of check-in [d2ccf7fc] Merge in all changes to the trunk through version 3.7.4rc3. (check-in: [d2ccf7fc] user: drh branch: apple-osx, size: 92912)
2010-12-02
11:24
[05b293c8] part of check-in [a94b9a39] Fix a (harmless) valgrind warning in the rtree extension. (check-in: [a94b9a39] user: dan branch: trunk, size: 92892)
2010-11-26
16:49
[e1a2d0fd] part of check-in [c412f612] Fix various compiler warnings. (check-in: [c412f612] user: drh branch: trunk, size: 92913)
2010-11-19
23:50
[d818635f] part of check-in [c8bc057c] Merge all the latest changes from the trunk into the apple-osx branch. (check-in: [c8bc057c] user: drh branch: apple-osx, size: 92707)
2010-11-18
13:47
[1a155468] part of check-in [6c4f1d5c] Fix compiler warnings. (check-in: [6c4f1d5c] user: drh branch: trunk, size: 92684)
2010-10-01
20:45
[f9acfe69] part of check-in [854b23c1] Backport the RTree implementation from the trunk into the 3.6.23 branch. The code for the application-defined query boxes is still present but is disabled. The reason for this backport is to take advantage of recent enhancements to robustness to database corruption. (check-in: [854b23c1] user: drh branch: branch-3.6.23, size: 92877)
2010-09-23
18:47
[7dffd6d9] part of check-in [fab3b383] Add tests to e_delete.test. (check-in: [fab3b383] user: dan branch: trunk, size: 92840)
2010-09-22
19:06
[4e2bda4a] part of check-in [7ff3574b] Further tests and changes to make the r-tree module more robust. (check-in: [7ff3574b] user: dan branch: trunk, size: 92095)
14:19
[3733ff12] part of check-in [68a305fd] Add new file rtreeA.test, to test that the r-tree extension doesn't crash if it encounters a corrupt or inconsistent database. (check-in: [68a305fd] user: dan branch: trunk, size: 91246)
2010-09-11
05:15
[a1a1202a] part of check-in [5b63e981] When building from the amalgamation with ENABLE_RTREE defined, do not try to include sqlite3rtree.h. (check-in: [5b63e981] user: dan branch: trunk, size: 89006)
2010-08-31
15:54
[e26735d5] part of check-in [7c4f80ad] Changes to comments and type names in rtree.c. (check-in: [7c4f80ad] user: dan branch: trunk, size: 89007)
2010-08-30
18:39
[556479bc] part of check-in [fc4d7537] When generating sqlite3.h, append the contents of sqlite3rtree.h. (check-in: [fc4d7537] user: dan branch: trunk, size: 88585)
15:43
[2d86907e] part of check-in [b06f4695] Add tests (and associated fixes) to restore coverage of rtree.c. (check-in: [b06f4695] user: dan branch: trunk, size: 87665)
2010-08-28
18:58
[d1a00cf3] part of check-in [782ca3b7] Add code to allow user-defined searches of r-tree tables. Still largely untested. (check-in: [782ca3b7] user: dan branch: trunk, size: 87660)
2010-08-26
14:15
[2e87d4f4] 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: 81361)
11:27
[536070b2] part of check-in [90f40cd3] Remove unreachable condition from rtree.c. (check-in: [90f40cd3] user: dan branch: trunk, size: 81231)
07:59
[e26a7570] part of check-in [bee1959d] Improve coverage of rtree.c some more. (check-in: [bee1959d] user: dan branch: trunk, size: 81246)
2010-08-25
19:04
[586c8d6a] part of check-in [05f6c1ae] Further test coverage improvements for rtree.c. (check-in: [05f6c1ae] user: dan branch: trunk, size: 81143)
17:53
[73a4df9b] part of check-in [865cec04] Test cases to improve coverage of rtree module. Fixes associated with the same. (check-in: [865cec04] user: dan branch: trunk, size: 80831)
2010-08-24
12:05
[18a405b9] part of check-in [bcbdecd8] Pull the incremental_vacuum bug fix ([255f1eefa373153942c67b18b]) and the R-tree segfault bug fix ([7f2f71cc9e3c39093f09231f44]) into the 3.6.23 branch. Increase the version number to 3.6.23.3. (check-in: [bcbdecd8] user: drh branch: branch-3.6.23, size: 80296)
02:10
[2e5810ef] part of check-in [68103d91] Cherrypick the R-tree invalid shadow-table big fix of [7f2f71cc9e3c39093f09231f44] into the apple-osx 3.6.23 branch. (check-in: [68103d91] user: drh branch: apple-osx-3623, size: 80326)
01:51
[4646fb3f] part of check-in [02ee0bd5] Merge in the R-tree fix from the trunk. (check-in: [02ee0bd5] user: drh branch: apple-osx, size: 80320)
01:49
[1a39ad56] part of check-in [7f2f71cc] The R-tree module should not assume that its shadow tables are consistent. If a problem is found in a shadow table, return SQLITE_CORRUPT. (check-in: [7f2f71cc] user: drh branch: trunk, size: 80290)
2010-08-18
00:24
[f76dba3e] part of check-in [866e9286] Merge the 3.7.1 pre-release snapshot changes as of 2010-08-18 into the apple-osx branch. (check-in: [866e9286] user: drh branch: apple-osx, size: 80311)
2010-08-11
12:26
[f2fbb647] part of check-in [eaaca669] Update an r-tree extension test case to account for recent changes to the query planner. Also fix a comment in rtree.c. (check-in: [eaaca669] user: dan branch: trunk, size: 80281)
2010-08-07
11:46
[99ce980d] part of check-in [f88c6367] Merge in all changes up to the 3.7.0.1 release. (check-in: [f88c6367] user: drh branch: apple-osx, size: 80344)
2010-06-16
19:48
[dc26ef90] part of check-in [21ca87f6] Merge in changes up to and including the 3.6.23.1 release. (check-in: [21ca87f6] user: drh branch: apple-osx, size: 80317)
2010-03-19
19:02
[c7a18311] 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: 80314)
2010-02-24
18:25
[a354f6be] part of check-in [8e60d399] Remove an unused variable from rtree. (check-in: [8e60d399] user: drh branch: trunk, size: 80287)
2010-02-17
19:34
[8bb9addf] part of check-in [4b72e39b] Merge latest changes from the trunk into the apple-osx branch. (check-in: [4b72e39b] user: drh branch: apple-osx, size: 80338)
2010-02-16
10:59
[b82403b0] part of check-in [ebc9433f] Fix for [e9a9fde1f4]. When opening an existing rtree, determine the node size by inspecting the root node of the r-tree structure (instead of assuming it is a function of the page-size). (check-in: [ebc9433f] user: dan branch: trunk, size: 80308)
2009-12-07
23:53
[823d089f] part of check-in [ad08794d] Merge all changes associated with the version 3.6.21 release into the OS-X branch. (check-in: [ad08794d] user: drh branch: apple-osx, size: 79025)
2009-11-10
01:30
[038d59b0] part of check-in [f6c045f6] Remove the obsolete "$Id:$" RCS identifier strings from the source code. (check-in: [f6c045f6] user: drh branch: trunk, size: 78995)
2009-11-03
22:34
[375a762b] part of check-in [941a01eb] Customizations for OSX contributed by Apple. (check-in: [941a01eb] user: adam branch: apple-osx, size: 79089)
2009-10-05
05:40
[5275d8f8] part of check-in [64bad00b] Fix some errors in the guttman versions (disabled by default) of the algorithms in rtree.c. (check-in: [64bad00b] user: dan branch: trunk, size: 79059)
2009-08-06
18:36
[833ab284] part of check-in [b6bdfdc6] Mark the rtreeUpdate function as static. (CVS 6961) (check-in: [b6bdfdc6] user: danielk1977 branch: trunk, size: 78981)
2009-07-17
16:54
[95eca5dd] 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: 78974)
2008-12-22
15:04
[a1c43d0f] part of check-in [bbdc0e9f] Fix a reference counting bug in rtree. Ticket #3549. (CVS 6054) (check-in: [bbdc0e9f] user: danielk1977 branch: trunk, size: 78884)
2008-11-12
15:24
[05d51773] part of check-in [f41dd205] Do not redefine the MIN and MAX macros if they are already defined. (CVS 5896) (check-in: [f41dd205] user: drh branch: trunk, size: 78827)
2008-10-25
17:10
[250b7209] part of check-in [3224ea59] Remove unused parameter from function rtreeInit() (part of the r-tree extension). (CVS 5842) (check-in: [3224ea59] user: danielk1977 branch: trunk, size: 78795)
2008-09-08
11:07
[9a9ef98e] part of check-in [8b600ed0] Fix a bug in r-tree related to internal nodes with one or more dimensions of size zero. Ticket #3363. (CVS 5682) (check-in: [8b600ed0] user: danielk1977 branch: trunk, size: 78865)
2008-09-01
12:47
[5e372fdb] part of check-in [483932c4] Have the rtree module set the estimatedCost output variable. Ticket #3312. (CVS 5649) (check-in: [483932c4] user: danielk1977 branch: trunk, size: 78344)
2008-07-16
14:43
[d60b28f4] part of check-in [5c26f63e] Allow the r-tree extension to be compiled as part of the amalgamation. (CVS 5424) (check-in: [5c26f63e] user: drh branch: trunk, size: 77939)
2008-07-14
15:37
[f00cabbe] 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: 77912)
2008-06-23
15:55
[20b87410] 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: 75854)
2008-05-27
00:06
[28b8650c] part of check-in [54b84a3d] Fix a bug in rtree that occurs when too many constraints are passed in on a query. (CVS 5162) (check-in: [54b84a3d] user: drh branch: trunk, size: 75879)
2008-05-26
20:49
[8b849f04] 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: 74787)
20:19
[9352fa04] part of check-in [aa8eba33] Update the amalgamation builder to incorporate the RTREE extension. (CVS 5160) (check-in: [aa8eba33] user: drh branch: trunk, size: 74769)
18:41
[f56f8a58] part of check-in [b104dcd6] Import 'rtree' extension. (CVS 5159) (check-in: [b104dcd6] user: danielk1977 branch: trunk, size: 74709) Added