Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 events by user dan occurring around 2024-01-22 14:01:07.
2024-02-20
| ||
20:18 | Have the intck extension better handle corruption at the b-tree layer. (check-in: ecd775d108 user: dan tags: incr-integrity-check) | |
18:17 | Use fewer cycles to generate the "next key" value used by sqlite3_intck_suspend() function in the intck extension. (check-in: 95f01426f9 user: dan tags: incr-integrity-check) | |
16:04 | Consider using "=" and IS operators with even low-quality indexes in cases where they are selected explicitly using an INDEXED BY clause. (check-in: 43cbbea821 user: dan tags: incr-integrity-check) | |
2024-02-19
| ||
20:15 | Use more efficient SQL to verify that indexes contain entries that match their tables. (check-in: c01e008c28 user: dan tags: incr-integrity-check) | |
18:03 | Add implementation of sqlite3_intck_suspend(). (check-in: c36ada868d user: dan tags: incr-integrity-check) | |
2024-02-17
| ||
20:55 | Add start of extension for incremental integrity-checks to ext/intck/. (check-in: 444e3c9210 user: dan tags: incr-integrity-check) | |
2024-02-16
| ||
11:41 | Handle an OOM case in fts5 code to query tokendata=1 tables. (check-in: 01222d96b9 user: dan tags: trunk) | |
11:05 | Fix a problem with the sqlite3_log() message identifying the table or index that a conflicting page belongs to. (check-in: 11a4178f0e user: dan tags: bedrock) | |
11:03 | Fix a problem with the sqlite3_log() message identifying the table or index that a conflicting page belongs to. (check-in: d6c629f165 user: dan tags: begin-concurrent) | |
2024-02-12
| ||
16:12 | Have rtree avoid keeping a blob handle open following an error. (check-in: 1cd5d4623f user: dan tags: trunk) | |
2024-02-05
| ||
17:54 | Return SQLITE_ABORT if the underlying shadow tables change in the middle of an rtree query in such a way as to invalidate an rtree internal priority queue entry. This replaces the SQLITE_ABORT_ROLLBACK mechanism added in [af5c4251]. (check-in: 32f85a5ce8 user: dan tags: trunk) | |
17:35 | Return SQLITE_ABORT if the underlying shadow tables change in the middle of an rtree query in such a way as to invalidate an rtree internal priority queue entry. (Closed-Leaf check-in: 478280ef67 user: dan tags: rtree-fix) | |
2024-02-02
| ||
16:51 | Have "PRAGMA quick_check" compare the number of entries in tables and indexes. (Closed-Leaf check-in: cc294c041b user: dan tags: quick-check-counts) | |
11:37 | Fix typo in vdbe.c comment. No changes to code. (check-in: 62010ba488 user: dan tags: trunk) | |
2024-02-01
| ||
15:42 | Ensure the fts5 xIntegrity method correctly returns error codes unrelated to corruption or missing SQL elements. (check-in: d18d9a05c2 user: dan tags: trunk) | |
15:21 | Ensure the fts3 xIntegrity method correctly returns error codes unrelated to corruption or missing SQL elements. (check-in: 1bdb8cbaf7 user: dan tags: trunk) | |
2024-01-29
| ||
19:30 | Consider an index for queries like "SELECT count(DISTINCT col) FROM ...", even if the index records are not smaller than the table records. (check-in: ad06868807 user: dan tags: trunk) | |
15:30 | Avoid a potential buffer overread when handling corrupt json blobs. (check-in: 738473dc0a user: dan tags: trunk) | |
2024-01-23
| ||
16:09 | In os_unix.c and os_win.c, do not allow xFetch() to return a pointer to a page buffer that is right at the end of the mapped region - if the database is corrupted in a specific way such a page buffer might be overread by several bytes. (check-in: 2684feac3b user: dan tags: trunk) | |
11:20 | Add extra checks for the validity of a numeric literal to sqlite3DequoteNumber(). (Closed-Leaf check-in: d57407ef59 user: dan tags: digit-separators) | |
10:47 | Ensure that the xIntegrity methods of fts3 and fts5 work on read-only databases. (check-in: e79b97369f user: dan tags: branch-3.45) | |
2024-01-22
| ||
19:42 | Fix a problem in the previous commit with hex literals that start with "0X" instead of "0x". (check-in: c063c89b11 user: dan tags: digit-separators) | |
19:38 | Allow underscores to occur in hex literals. (check-in: 81a5622946 user: dan tags: digit-separators) | |
19:00 | Add extra tests for the code on this branch. (check-in: b15bbb201a user: dan tags: digit-separators) | |
14:01 | Fix test script literal.test so that it works with SQLITE_OMIT_ALTER_TABLE builds. (check-in: 4dc00f5776 user: dan tags: trunk) | |
11:12 | Fix test script literal.test so that it works with SQLITE_OMIT_ALTER_TABLE builds. (check-in: b57327be4b user: dan tags: digit-separators) | |
2024-01-20
| ||
18:45 | Merge trunk changes into this branch. (check-in: 03ade4a810 user: dan tags: digit-separators) | |
18:41 | Ensure that values generated by DEFAULT clauses that specify real numbers that can be expressed as 64-bit integers (e.g. -1234.0) are not silently converted to integers. (check-in: 298d697728 user: dan tags: trunk) | |
16:46 | Add test cases for the new code on this branch. (check-in: 49f29a7b4f user: dan tags: digit-separators) | |
16:18 | Allow "_" characters to appear following any digit in an integer or real SQL literal. (check-in: 401650aacc user: dan tags: digit-separators) | |
2024-01-19
| ||
16:51 | Allow large hexadecimal literals to be used as DEFAULT values. (check-in: 8cccc1f27d user: dan tags: trunk) | |
2024-01-16
| ||
16:05 | Ensure that the xIntegrity methods of fts3 and fts5 work on read-only databases. (check-in: b855886c4c user: dan tags: trunk) | |
2024-01-13
| ||
20:38 | Merge latest trunk changes into this branch. (check-in: bb9a715748 user: dan tags: reuse-schema) | |
20:36 | Merge latest wal2 changes into this branch. (check-in: c39f658522 user: dan tags: bedrock) | |
20:21 | Merge latest trunk changes into this branch. (check-in: 68c2b8d0eb user: dan tags: wal2) | |
19:57 | Merge latest trunk changes into this branch. (check-in: 95bf4bc2e2 user: dan tags: begin-concurrent) | |
2024-01-12
| ||
15:38 | Fix a signed integer overflow usan complaint in fts5. This is fixed on trunk by [a76a636b23], but that is a large commit that adds new features. (check-in: 4b2d02f260 user: dan tags: branch-3.43) | |
11:44 | Have the shell tool automatically enable SQLITE_CONFIG_DQS_DDL when executing a ".dump" script against an empty db. (check-in: f47a5f4e0c user: dan tags: trunk) | |
2024-01-11
| ||
14:03 | In fts5, flush the contents of the in-memory hash table whenever the secure-delete option is toggled. This prevents spurious corruption reports under some circumstances. (check-in: ccf552319a user: dan tags: trunk) | |
2024-01-08
| ||
19:55 | Automatically turn off DEFENSIVE mode in the shell tool when executing scripts generated by the ".dump" command against an empty database. Add a warning to the top of generated ".dump" scripts that populate virtual tables. (check-in: cd016f26bb user: dan tags: trunk) | |
18:53 | Fix date on new file shell9.test. (Closed-Leaf check-in: c82da71211 user: dan tags: shell-dump-fix) | |
18:46 | Automatically turn off DEFENSIVE mode in the shell tool when executing scripts generated by the ".dump" command against an empty database. Add a warning to the top of generated ".dump" scripts that populate virtual tables. (check-in: 6e9e96b7e7 user: dan tags: shell-dump-fix) | |
13:38 | Ensure that SQLITE_PROTOCOL is not returned too early when a SQLITE_ENABLE_SETLK_TIMEOUT build fails to open a transaction on a wal mode database in cases where blocking locks are not being used. (check-in: a8e9af1356 user: dan tags: trunk) | |
2024-01-06
| ||
19:16 | Ensure that SQLITE_PROTOCOL is not returned too early when a SQLITE_ENABLE_SETLK_TIMEOUT build fails to open a transaction on a wal mode database in cases where blocking locks are not being used. (Closed-Leaf check-in: b934a33671 user: dan tags: enable-setlk-fix) | |
13:58 | Update extension ext/misc/totext.c to avoid both ubsan warnings and dubious real->integer conversions. (check-in: 541436004d user: dan tags: trunk) | |
2024-01-05
| ||
15:53 | Update extension ext/misc/totext.c to avoid both ubsan warnings and dubious real->integer conversions. (Closed-Leaf check-in: c626aa108a user: dan tags: totype-fix) | |
2024-01-04
| ||
16:15 | Testing code left in by accident. (Closed-Leaf check-in: 90e8a23354 user: dan tags: mistake) | |
2024-01-02
| ||
21:08 | Fix a problem in fts5 caused by a COMMIT involving fts5 data that immediately follows a ROLLBACK TO that does not. (check-in: 55c61f6a8d user: dan tags: trunk) | |
2023-12-28
| ||
20:54 | Update fts5origintext4.test to work with SQLITE_DIRECT_OVERFLOW_READ. (check-in: 15ed002aed user: dan tags: trunk) | |
2023-12-27
| ||
16:24 | Fix a problem in the shell tool (not library) causing an out-of-bounds write if an ".open" command failed, then the user pressed ctrl-c to interrupt a query running on the substitute in-memory database. (check-in: 026618b9e3 user: dan tags: trunk) | |