/ Timeline
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.

100 most recent check-ins that include changes to files matching 'ext/*'

2019-10-11
18:55
Update the zipfile extension to use deflateBound(), instead of compressBound(), to learn the maximum possible size of a deflate()d buffer. check-in: f5ee3042 user: dan tags: trunk
15:33
Ensure fts3/4 prefix indexes are flushed to disk before an 'optimize' command. Fix for [745f1abc]. check-in: 4ed905b1 user: dan tags: trunk
14:27
Fix the fts3/4 integrity-check command so that it works with "ORDER=DESC" tables. Fix for [8a6fa2bb]. check-in: 5863546d user: dan tags: trunk
11:21
Merge the 3.30.1 changes into reuse-schema. Leaf check-in: eff7cd7f user: drh tags: reuse-schema-3.30
2019-10-10
16:41
Fix a problem in the fts3 integrity-check routine causing it to report as corrupt tables that contain values with embedded 0x00 bytes. Ticket [278ac142625e3dcd] check-in: 629e20c9 user: dan tags: trunk
16:10
Fix a problem with running ALTER TABLE ADD COLUMN statements within a transaction that writes to one or more virtual tables. Fix for [8fe768e9]. check-in: a4974a0f user: drh tags: branch-3.30
2019-10-09
18:36
Do not allow users to effectively disable fts5 crisismerge operations by setting the crisismerge threshold to higher than the maximum allowable segment b-trees on a single level. Fix for [d392017c]. check-in: 86e49720 user: dan tags: trunk
17:38
Merge recent fixes and enhancements from trunk. Leaf check-in: 553258c2 user: drh tags: 2-size-lookaside
15:26
Disallow fts5 page sizes greater than 65536 bytes - as there are 16-bit offsets used in the page header. Fix for [81a7f7b9]. check-in: 75775c5a user: dan tags: trunk
2019-10-08
13:34
Fix problems with using the fts5 'rebuild' command inside a transaction that contains other updates of the same table. Fix for [e258f008]. check-in: 238e0835 user: dan tags: trunk
2019-10-07
20:36
Disallow page-sizes smaller than 32 bytes in fts5. Also ensure the fts5 integrity-check works even when "PRAGMA reverse_unordered_selects" is true. Fix for [265e935b26]. check-in: 8ab0aebd user: dan tags: trunk
18:43
Fix a problem with running ALTER TABLE ADD COLUMN statements within a transaction that writes to one or more virtual tables. Fix for [8fe768e9]. check-in: 31e85fbb user: dan tags: trunk
2019-10-04
16:24
Bring the begin-concurrent-pnu-wal2 branch up-to-date with 3.30.0. Leaf check-in: dd09f7ce user: drh tags: begin-concurrent-pnu-wal2
16:15
Bring the wal2 branch up to date with version 3.30.0 Leaf check-in: 16e1dced user: drh tags: wal2
16:08
Bring the begin-concurrent-pnu branch up-to-date with version 3.30.0. Leaf check-in: a4d26bcf user: drh tags: begin-concurrent-pnu
15:52
Bring the begin-concurrent branch up-to-date with the 3.30.0 release. Leaf check-in: abd1b4df user: drh tags: begin-concurrent
15:41
Bring the apple-osx branch up-to-date with the 3.30.0 release. Leaf check-in: 76b26aca user: drh tags: apple-osx
15:31
Bring the reuse-schema branch up-to-date with version 3.30.0. Leaf check-in: 6e09afec user: drh tags: reuse-schema
2019-10-02
19:33
Fix a long-standing problem in fts4 incrmental merge. check-in: 67da31e2 user: dan tags: trunk
2019-09-30
19:13
The nodeReaderInit() function in FTS3 may not assume that the node is non-empty. check-in: 361eb2f6 user: drh tags: trunk
16:57
Merge in the 3.30.0 beta 1 changes. check-in: 06796124 user: drh tags: reuse-schema
16:49
Merge in the 3.30.0 beta 1 enhancements. check-in: ebf88726 user: drh tags: begin-concurrent-pnu-wal2
16:44
Merge 3.30.0 beta 1 changes from trunk. check-in: 918bd97d user: drh tags: wal2
16:43
Merge version 3.30.0 beta 1 changes from trunk. check-in: ac4b6442 user: drh tags: begin-concurrent-pnu
16:14
Merge the 3.30.0 beta 1 changes from trunk. check-in: a003818f user: drh tags: begin-concurrent
16:13
Merge the 3.30.0 beta 1 changes from trunk. check-in: 9ce4c791 user: drh tags: apple-osx
2019-09-28
11:19
In FTS3/4, the poslist end marker must be larger than any other possible poslist value, even on a corrupt poslist. check-in: 752679ae user: drh tags: trunk
2019-09-21
17:31
Fix harmless compiler warnings. check-in: 8ea1dc72 user: drh tags: trunk
2019-09-19
13:51
Fix an assert() in fts3 that could fail when accessing a corrupt database. check-in: 601ce953 user: dan tags: trunk
2019-09-18
17:22
Add extra tests for the handling of corrupt records in fts3. check-in: 40e29a47 user: dan tags: trunk
11:46
Fix a "jump depends on unititialized value" valgrind error in fts5 triggered by corrupt database records. check-in: 6b6751cd user: dan tags: trunk
2019-09-16
12:35
Merge all recent trunk enhancements into the reuse-schema branch. check-in: 27eb2236 user: drh tags: reuse-schema
12:29
Bring the begin-concurrent-pnu-wal2 branch up to date with all the latest enhancements on trunk. check-in: 15593bf3 user: drh tags: begin-concurrent-pnu-wal2
12:23
Merge recent trunk enhancements into the wal2 branch. check-in: da8bc974 user: drh tags: wal2
12:17
Merge recent trunk enhancements into the begin-concurrent-pnu branch. check-in: 54930b7e user: drh tags: begin-concurrent-pnu
12:08
Merge recent trunk enhancements into the begin-concurrent branch. check-in: 93b9ef3f user: drh tags: begin-concurrent
12:02
Merge the latest changes from trunk into the apple-osx branch. check-in: a95191de user: drh tags: apple-osx
2019-09-14
00:21
Fix the windows inverse function on the JSON aggregates. check-in: f464d847 user: drh tags: trunk
2019-09-13
18:27
Add the SQLITE_SUBTYPE flag, which may be passed to sqlite3_create_window_function() to indicate that the window function uses sqlite3_value_subtype() to check the sub-type of its arguments. check-in: ba2ebc3a user: dan tags: trunk
17:30
Fix a typo in the carray extension header comment - the comment that serves as the documentation to this extension. check-in: 658a42d3 user: drh tags: trunk
17:05
Change the meaning of the SQLITE_SUBTYPE flag so that it indicates that the user-defined function cares about the subtypes of its arguments. Closed-Leaf check-in: af1bc20f user: dan tags: window-functions-subtype-fix2
16:19
Merge latest trunk changes with this branch. check-in: 14ef7543 user: dan tags: window-functions-subtype-fix
13:23
Ensure that the idxStr for FTS5 is always zero-terminated. Fix for check-in [9d418a7a491761ee] check-in: 090cd07d user: drh tags: trunk
12:24
Fix harmless compiler warnings. check-in: a8927d14 user: drh tags: trunk
2019-09-12
19:38
Allow fts5 to filter on multiple MATCH clauses in a single scan. check-in: 9d418a7a user: dan tags: trunk
2019-09-07
18:20
Add the SQLITE_SUBTYPE flag, which can be passed to sqlite3_create_function() and similar to indicate to the core that a user function is likely to use sqlite3_result_subtype(). check-in: 6aa438ce user: dan tags: window-functions-subtype-fix
2019-09-03
19:40
Fix a buffer overread that could occur when running fts5 prefix queries inside a transaction. Leaf check-in: b54aa18b user: dan tags: branch-3.18
19:29
Fix a buffer overread that could occur when running fts5 prefix queries inside a transaction. Leaf check-in: b584fd36 user: dan tags: branch-3.9
18:43
Fix a buffer overread that could occur when running fts5 prefix queries inside a transaction. Leaf check-in: 0770363b user: drh tags: branch-3.19
18:36
Fix a buffer overread that could occur when running fts5 prefix queries inside a transaction. Leaf check-in: 68b89838 user: drh tags: branch-3.22
18:04
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 tags: branch-3.22
17:55
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 tags: branch-3.19
17:46
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 tags: branch-3.18
17:39
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 tags: branch-3.9
2019-09-02
14:46
Fix a potential crash in fts5 caused by using an auxiliary function on a "special" query like '*id' or '*reads'. check-in: 9490683a user: dan tags: trunk
2019-08-29
14:25
Fix a potential buffer overrun in fts5 caused by corrupted database records. check-in: c465d0eb user: dan tags: trunk
2019-08-27
19:59
Add support for "ORDER BY ... NULLS FIRST" and "ORDER BY ... NULLS LAST". Use this to fix ticket [f8a7060e]. check-in: 94085fb3 user: dan tags: trunk
2019-08-26
20:41
Merge in recent fixes from trunk. Closed-Leaf check-in: ad816d01 user: drh tags: nulls-last
2019-08-24
17:11
Fix a potential buffer overrun in fts5 caused by corrupt database records. check-in: 156d6128 user: dan tags: trunk
2019-08-21
17:46
Disable broken test case in expert1.test. check-in: 73e30c2e user: dan tags: nulls-last
15:41
Update this branch with latest trunk changes. check-in: 6153bcf4 user: dan tags: nulls-last
11:31
Fix a broken assert() in the fts3 snippet code that was failing for queries containging more than 64 phrases. check-in: 4c01e017 user: dan tags: trunk
2019-08-20
19:11
Fix a problem with fts5 "ORDER BY rank" queries when the fts5 table name requires quoting. check-in: 00e9a8f2 user: dan tags: trunk
17:14
Bring the hard-heap-limit branch up-to-date with trunk. Leaf check-in: 9b14eb77 user: drh tags: hard-heap-limit
2019-08-17
19:58
Add some extra tests for the lsm virtual table module. check-in: 4cb009b0 user: dan tags: trunk
19:55
Fix to the query planner for the LSM1 extension. check-in: 7496e872 user: drh tags: trunk
15:47
Merge trunk changes into this branch. check-in: db1e6080 user: dan tags: nulls-last
2019-08-13
20:34
Add some static to the 'regexp' extension. check-in: a21d1dde user: mistachkin tags: trunk
17:27
Update some corruption test cases to take [724f4df9c] into account. check-in: 927cd7b4 user: dan tags: trunk
15:22
Merge latest trunk changes with this branch. check-in: 5b4689d8 user: dan tags: reuse-schema
15:11
Fix a problem with RBU function sqlite3rbu_bp_progress() when used during an RBU vacuum. check-in: 8c44b02f user: dan tags: trunk
2019-08-12
15:37
Fix the build for compilation using separate files rather than the amalgamation. Leaf check-in: 1e0f4869 user: drh tags: sha3
15:19
Make the sha3 extension part of the amalgamation, enabled using SQLITE_ENABLE_SHA3. check-in: a48a7b78 user: drh tags: sha3
2019-08-09
01:11
Fix more compiler warnings. check-in: 1b85442b user: drh tags: trunk
2019-08-05
12:55
Prevent an fts5 table from being its own content table, or part of a view that is the content table. check-in: b6d52c93 user: dan tags: trunk
2019-07-31
12:13
Do not allow the json_set() function to overwrite the same element more than once. check-in: f237f60e user: drh tags: trunk
2019-07-29
17:18
Convert an assert() in R-Tree into a database corruption detection case. check-in: 48b518eb user: drh tags: trunk
16:53
Fix a crash in fts3 caused by corrupt database records. check-in: 11f7f94f user: dan tags: trunk
02:49
Fix harmless compiler warning seen with MSVC for x64. check-in: 857b2ba6 user: mistachkin tags: trunk
2019-07-26
20:54
Merge latest changes from trunk into this branch. check-in: 7f1e4e4b user: dan tags: reuse-schema
20:33
Update RBU so that it supports indexes on expressions. check-in: 6bfa44da user: dan tags: trunk
16:16
Fix RBU handling of partial indexes with comments embedded in their CREATE INDEX statements. check-in: e1ccf211 user: dan tags: trunk
2019-07-25
19:29
Fix a potential buffer overread in fts5 triggered by a corrupt database record. check-in: 16472112 user: dan tags: trunk
2019-07-23
13:26
Avoid redefining types u32 and u16 when fossildelta.c is compiled as part of the amalgamation. check-in: d8e88248 user: dan tags: trunk
2019-07-20
18:00
Early detection of a corrupt R-Tree in the R-Tree search algorithm. check-in: 2bf5a4c1 user: drh tags: trunk
17:43
Performance optimizations in the rtreeStepToLeaf() routine of RTree. check-in: 4e34e361 user: drh tags: trunk
2019-07-13
09:56
Merge latest trunk changes into this branch. check-in: 86ab963c user: dan tags: filter-clause
2019-07-10
18:45
Merge the version 3.29.0 release enhancements into the reuse-schema branch. check-in: 9819ead0 user: drh tags: reuse-schema
18:40
Merge the 3.29.0 updates into the begin-concurrent-pnu-wal2 branch. check-in: 627b428f user: drh tags: begin-concurrent-pnu-wal2
18:30
Merge the 3.29.0 release into the wal2 branch. check-in: 8baa4022 user: drh tags: wal2
18:21
Merge the 3.29.0 changes into the begin-concurrent-pnu branch. check-in: c89949cc user: drh tags: begin-concurrent-pnu
18:11
Merge the 3.29.0 release into the begin-concurrent branch. check-in: 983733ae user: drh tags: begin-concurrent
17:58
Merge the 3.29.0 release into the apple-osx branch. check-in: 87aa1d70 user: drh tags: apple-osx
2019-07-09
17:36
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 tags: trunk
2019-07-08
21:32
Merge recent trunk enhancements into the reuse-schema branch. check-in: fae92fee user: drh tags: reuse-schema
21:25
Merge enhancments from wal2, which also merges trunk enhancements. check-in: 08dcb459 user: drh tags: begin-concurrent-pnu-wal2
21:19
Merge all enhancements from trunk into the wal2 branch. check-in: dcbcbc2a user: drh tags: wal2
21:12
Merge enhancements from trunk into the begin-concurrent-pnu branch. check-in: 05aa93af user: drh tags: begin-concurrent-pnu
21:06
Merge recent trunk enhancements into the begin-concurrent branch. check-in: 7fff0803 user: drh tags: begin-concurrent
20:59
Merge recent enhancements from trunk into apple-osx. check-in: de88ed86 user: drh tags: apple-osx