SQLite

Timeline
Login

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

44 events for the month beginning 2019-10-01 by user dan

Following month ↑
2019-10-28
13:54
Fix a problem in fts3 causing it to report corruption if a doclist contains consectutive rowid entries that differ by more than 2^63. (check-in: 0b0a3048 user: dan tags: trunk)
2019-10-24
20:36 Closed ticket [dd1f67bf]: FTS integrity-check malfunctions nondeterministically with tokenize="ascii" plus 6 other changes (artifact: 85d26dd0 user: dan)
20:35
In fts5, fix a case of overreading a buffer by 1 byte when counting characters in malformed utf-8. Fix for [dd1f67bf]. (check-in: 8d964e1c user: dan tags: trunk)
2019-10-21
13:35 Closed ticket [7fc8e5ff]: INSERT into table with two triggers does not terminate plus 6 other changes (artifact: a6cbd20a user: dan)
2019-10-20
08:26
Fix a resource leak in fts5 that could occur if an auxiliary function is called from within a query that does not use the full-text index. (check-in: b528bdcd user: dan tags: trunk)
2019-10-17
15:41
Avoid an infinite loop in fts3/4 incremental-merge in the case where the lowest level in the database contains segments but no data (because there is a delete-marker for each valid entry). Fix for [bf1aab89]. (check-in: 35beaee0 user: dan tags: trunk)
2019-10-14
15:15
Fix a problem with row-value IN(...) operators and virtual tables. (check-in: aa57d7ab user: dan tags: trunk)
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 Closed ticket [745f1abc]: FTS integrity-check malfunctions for transaction and the prefix option plus 5 other changes (artifact: 2e2548be user: dan)
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:28 Closed ticket [8a6fa2bb]: FTS order=DESC results into integrity-check failing plus 5 other changes (artifact: 9a6bda80 user: dan)
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)
2019-10-10
17:10 Closed ticket [c3103404]: LEFT JOIN in view malfunctions with NOTNULL plus 5 other changes (artifact: 2f2ef2bb user: dan)
17:09
Prevent SQLite from assuming that if ((? IS NOT NULL) IS NOT NULL) is true, ? may not be NULL. Fix for [c31034044bb72c89]. (check-in: 7833feec user: dan tags: trunk)
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)
15:17 Closed ticket [1079ad19]: Crash in query with FILTER clause on normal aggregate that refers to a column of a subquery plus 3 other changes (artifact: c408da84 user: dan)
15:17
Be sure to rewrite column references inside FILTER clauses and window frame definitions when flattening queries. Fix for [1079ad19]. (check-in: ccba7202 user: dan tags: trunk)
14:51 Ticket [1079ad19] Crash in query with FILTER clause on normal aggregate that refers to a column of a subquery status still Open with 6 other changes (artifact: 322e6e80 user: dan) ... 1 similar event omitted.
13:56 Closed ticket [a976c487]: LEFT JOIN in view malfunctions plus 5 other changes (artifact: 48167f98 user: dan)
2019-10-09
21:14
Avoid assuming that an expression that contains the sub-expression (? IS FALSE) or (? IS TRUE) may only be true if ? is non-null. Fix for [a976c487]. (check-in: eb7ed90b user: dan tags: trunk)
18:36 Closed ticket [d392017c]: FTS rebuild in combination with crisismerge results in error "database or disk is full" plus 5 other changes (artifact: 6b56f867 user: dan)
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)
15:27 Closed ticket [81a7f7b9]: FTS integrity-check indicates that the database disk image is malformed plus 5 other changes (artifact: 3a0ead54 user: dan)
15:27 Edit [75775c5ab44e497c|75775c5a]: Edit check-in comment. (artifact: db5c09fe user: dan)
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
19:45
Store 64-bit offset values in osinst log files. (Leaf check-in: 74d975c6 user: dan tags: osinst)
13:35 Closed ticket [e258f008]: FTS rebuild in transaction causes integrity-check to fail plus 5 other changes (artifact: 947d92df user: dan)
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 Closed ticket [265e935b]: FTS pgsz option results in "database disk image is malformed" error plus 3 other changes (artifact: c7fc254e user: dan)
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:44 Closed ticket [8fe768e9]: FTS integrity-check malfunctions plus 5 other changes (artifact: c4fa0e06 user: dan)
18:44 Edit [31e85fbbc4cfd09a|31e85fbb]: Edit check-in comment. (artifact: d9ea9a7d user: dan)
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)
13:46
Add a test case for the assert() fix in the previous commit. (check-in: 32fba11a user: dan tags: trunk)
10:29
Avoid attempting to read 0 bytes from a file in the osinst vtab code. (check-in: 1fb76c3e user: dan tags: osinst)
2019-10-05
19:37
Fix a problem in Makefile.msc on this branch. (check-in: ed3499a1 user: dan tags: osinst)
19:17
Add a timestamp to each osinst log entry, to facilitate merging multiple log files. (check-in: c9519c0c user: dan tags: osinst)
17:29
Have sqlite3.c automatically turn on osinst logging for all connections. (check-in: eea231f8 user: dan tags: osinst)
2019-10-03
16:02
Avoid running a couple of tests in affinity2.test as part of the valgrind permutations, as the way floating point computations are simulated by valgrind causes them to fail. (check-in: 7f9a4b60 user: dan tags: trunk)
14:36
Fix some test script issues that come up with SQLITE_OMIT_VIRTUALTABLE builds. (check-in: 3934d2d0 user: dan tags: trunk)
13:44
Fix issues with command line invocation of wapptest.tcl. (check-in: 9e0d5d26 user: dan tags: trunk)
2019-10-02
19:43
Update corruptM.test to account for the fact that the database schema may be loaded from within the "sqlite3" command for some test permutations. (check-in: cb9470fc user: dan tags: trunk)
19:33
Fix a long-standing problem in fts4 incrmental merge. (check-in: 67da31e2 user: dan tags: trunk)
Previous month ↓