SQLite

Timeline
Login

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

50 most recent check-ins

2025-08-25
16:41
Fix a typo in a comment. (Leaf check-in: d2a74d5c36 user: dan tags: trunk)
14:27
Check that certain ON clauses do not refer to tables to their right as a separate step after parsing a SELECT statement, instead of as part of the planner stage. Fix for [forum:ccfb3b5052 | forum post ccfb3b5052]. (check-in: e0beda7ffe user: dan tags: trunk)
13:04
For the --pagecache option of the CLI, if the SIZE parameter is a power-of-two, automatically round it up to using the PCACHE_HDRSZ. (check-in: e7a2ba842c user: drh tags: trunk)
11:47
Add test case to this branch to show that it handles cases where ON clauses use select-list aliases to refer to columns to their right. (Closed-Leaf check-in: 4d34ab4acf user: dan tags: on-clause-fix-3rd-try)
2025-08-23
18:18
Small simplification to the query flattener logic. (check-in: cbfe3f0c84 user: drh tags: trunk)
16:26
Fix the cases in joinI.test on this branch. (check-in: 23ac237731 user: dan tags: on-clause-fix-3rd-try)
11:09
Fix cksumvfs test case added by [e3bd1feccaee8ff2] so that it works with varying page sizes. Test case change only - no changes to code. (check-in: b6f8f086da user: drh tags: trunk)
2025-08-22
23:06
Minor tweaks to this option, to make it ready to land on trunk, if we decide to do so. (Closed-Leaf check-in: f01ed7316d user: drh tags: on-clause-option-4)
22:02
Disable the query flattener if the subquery is a join and the subquery is anywhere to the right of a RIGHT JOIN and if there is an ON clause on the subquery. (check-in: 7776ab3f5a user: drh tags: on-clause-option-4)
21:46
Fix the sqlite3SetJoinExpr() routine so that it correctly sets the join flags on CASE expressions. (check-in: a4107c947c user: drh tags: trunk)
19:30
Steal the test/joinI.test from the on-clause-error-fix branch that demonstrates that this branch does not work. (check-in: d163535ec8 user: drh tags: on-clause-fix-3rd-try)
19:17
Remember if a SELECT statement contains an ON clause. If it does, then after name resolution, scan the WHERE clause to verify that the ON clause does not reference tables to its right. (check-in: 0ec8a8f644 user: drh tags: on-clause-fix-3rd-try)
19:14
Improve performance of this patch. (Closed-Leaf check-in: 3060b2c447 user: dan tags: on-clause-error-fix)
18:19
Enhance treeview so that it shows the contents of ON clauses while they are still attached to the SrcItem object and before they are moved into the WHERE clause. (check-in: 3e285bc117 user: drh tags: trunk)
16:34
Experimental minor simplification of the query flattener. (Closed-Leaf check-in: 953ea637d5 user: drh tags: simplify-flattener)
16:25
Attempt to detect errors cause by ON clauses that refer to tables to the right of themselves while resolving names, instead of later on after query-flattening and other operations have complicated things. (check-in: 4bb527d337 user: dan tags: on-clause-error-fix)
2025-08-21
18:47
Fix a minor typo in a comment. (check-in: 9ada44eb6d user: drh tags: trunk)
17:59
Add config as an alias for the reconfigure makefile target. Minor makefile doc tweaks. Random typo fixes in shell.c.in and tclsqlite.h pointed out by the misspell makefile target. No code changes. (check-in: 9f15182776 user: stephan tags: trunk)
17:39
Remove some resolved TODOs from the makefile. Ensure that testfixture links against TCL_LIBS. (check-in: b7751d1443 user: stephan tags: trunk)
2025-08-20
23:29
The sqlite3_prepare() and similar interfaces should not return SQLITE_ERROR_RETRY. [forum:/forumpost/aa61ab56adb56159|Forum post aa61ab56]. (check-in: 4e473cf0c2 user: drh tags: trunk)
23:13
Add an assert() to prove that sqlite3_prepare() does not return SQLITE_ERROR_RETRY. (Closed-Leaf check-in: 6c6a8a596f user: drh tags: create-index-error-retry-fix)
21:12
Change a newly unreachable branch into an ALWAYS(). (check-in: 99556be3fd user: drh tags: create-index-error-retry-fix)
15:42
Avoid returning SQLITE_ERROR_RETRY if collation sequences associated with the table's PK cannot be found when creating an index. Possible fix for [forum:aa61ab56ad | forum post aa61ab56ad]. (check-in: ac649e5b9c user: dan tags: create-index-error-retry-fix)
11:21
Fix a problem with SQLITE_CHANGESET_CONFLICT conflicts caused by DELETE triggers within a call to sqlite3changset_apply_v2() with SQLITE_CHANGESETAPPLY_IGNORENOOP specified. (check-in: 138e2aab43 user: dan tags: trunk)
09:43
In builds without HAVE_FCHMOD (e.g. WASI), make the chmod() of temp files a no-op, analog to how lack of HAVE_FCHOWN is handled, as discussed in [forum:98d5158d3fdd7a41 | forum post 98d5158d3f]. (check-in: 7d13e8e403 user: stephan tags: trunk)
2025-08-19
21:35
Fix a problem causing an SQLITE_CHANGESET_DATA conflict of a DELETE operation to be incorrectly ignored if the SQLITE_CHANGESETAPPLY_IGNORENOOP is specified. (check-in: 78b543f85a user: dan tags: trunk)
2025-08-16
10:17
Add a doc sentence about sqlite3_set_clientdata()'s result value, per request in [forum:bda6c22b6a | forum post bda6c22b6a]. No code changes. (check-in: c664cee321 user: stephan tags: trunk)
2025-08-14
19:36
Avoid depending on HAVE_STDINT_H and SQLITE_PTRSIZE and other things in non-amalgamation builds of fts5. (check-in: 309fdd4966 user: dan tags: trunk)
2025-08-13
19:59
Minor internal cleanups in the configure script. No behavioral changes. (check-in: c42269e5ce user: stephan tags: trunk)
19:13
Have cksumvfs write checksums to the database file only, not the wal file. Writing them to the wal file breaks wal file recovery. (check-in: e3bd1fecca user: dan tags: trunk)
18:37
In cksumvfs, do not write checksums to the wal file, as this prevents recovery from working. (Closed-Leaf check-in: 5bf48c7e31 user: dan tags: cksumvfs-wal-fix)
18:30
Minor autosetup/README.md tweaks. (check-in: bd7530bf6a user: stephan tags: trunk)
17:58
Move the forced NDEBUG in fts3Int.h up above the #include of assert.h, as reported in [forum:8f16dd9480aad85f | forum post 8f16dd9480aad85f]. (check-in: 3b06d1c9b6 user: stephan tags: trunk)
16:49
Doc updates in the configure script. No functional changes. (check-in: 47c4a2ddd1 user: stephan tags: trunk)
14:40
Fix a problem with the checksum-vfs and direct-overflow-reads. Forum post [forum:350e147cd1 | 350e147cd1]. (check-in: 7b7ce5f17f user: dan tags: trunk)
14:35
Fix a problem with the checksum-vfs and direct-overflow-reads. (Closed-Leaf check-in: 8288edb9f9 user: dan tags: cksum-direct-ovfl-fix)
11:46
Doc cleanups in main.mk. No functional changes. (check-in: 839c998443 user: stephan tags: trunk)
2025-08-12
19:02
Fix a problem with reading wal mode databases from UNC shares on windows introduced by [e88212b10a7829ff]. (check-in: f341e78129 user: dan tags: trunk)
18:57
Fix a problem building testfixture on non SQLITE_OS_WIN platforms. (Leaf check-in: 9e6fa73467 user: dan tags: win-unc-fix)
17:55
On windows, when opening a UNC path, fall back to using a single file handle shared between all connections for locking. (check-in: 5c0202d96c user: dan tags: win-unc-fix)
2025-08-11
13:17
The off-by-one fix at [3e627d66ebdef8df] is insufficient. An index can hold twice as many columns as a table, if the table is a WITHOUT ROWID table. The limit should be twice the maximum, not just one more than the maximum. Problem discovered by OSSFuzz. (check-in: a836126bbe user: drh tags: trunk)
10:54
Replace some 32-bit arithmetic in fts3_write.c with 64-bit to avoid the possibility of integer overflow. (check-in: 6711110b1c user: dan tags: trunk)
2025-08-07
20:20
Add an explicit call to sqlite3_initialize() to sqlite3_rsync so that it works when built with SQLITE_OMIT_AUTOINIT, as suggested in [forum:c4ec6b33097b8536 | forum post c4ec6b33097b8536]. (check-in: 8c9db62371 user: stephan tags: trunk)
2025-08-06
19:20
Increase the patch level from 4 to 5. (Leaf check-in: 46c7ca9570 user: drh tags: branch-3.50)
19:19
Do not allow the number of terms in an ORDER BY or GROUP BY clause to exceed the maximum number of columns in a table. (check-in: cb41512386 user: drh tags: branch-3.50)
19:16
Skip checking for dlopen() on mingw builds and those which include "windows" in their host tuple, as suggested in [forum:2436c8ffed | forum post 2436c8ffed]. Those environments identify as Windows for SQLite's purposes so use LoadLibrary(). (check-in: 69b87d4fa8 user: stephan tags: trunk)
19:12
Do not allow the number of terms in an ORDER BY or GROUP BY clause to exceed the maximum number of columns in a table. (check-in: 139e587c7b user: drh tags: trunk)
19:05
Fix Windows makefile breakage caused by [ae9d7c9c922bb241]. (check-in: c41324139d user: drh tags: trunk)
16:51
Add *.obj to the make clean target for the sake of the Unix-on-Windows environments. (check-in: da07e0c02f user: stephan tags: trunk)
15:57
Extend the sqlite3_rsync PATH to include /opt/local/bin, per request in [forum:ca3c1bb7ca8e03 | forum post ca3c1bb7ca8e03]. (check-in: 79a14a5ebd user: stephan tags: trunk)