/ Timeline
Login

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

55 descendants and 100 ancestors of [85247880]

2019-09-16
12:02
Merge the latest changes from trunk into the apple-osx branch. Leaf check-in: a95191de user: drh tags: apple-osx
2019-07-10
17:58
Merge the 3.29.0 release into the apple-osx branch. check-in: 87aa1d70 user: drh tags: apple-osx
2019-07-08
20:59
Merge recent enhancements from trunk into apple-osx. check-in: de88ed86 user: drh tags: apple-osx
2019-05-14
19:39
Merge recent enhancements from trunk into apple-osx. check-in: 40362d51 user: drh tags: apple-osx
2019-05-07
02:57
Add the exprNodeCopy() routine that will safely memcpy() an Expr node that might be a size-reduced node. Leaf check-in: ab2ba8e7 user: drh tags: expr-node-copy-patch
2019-04-15
14:49
Bring in the latest enhancements from trunk. check-in: 378230ae user: drh tags: apple-osx
2019-04-04
21:40
Merge all the latest changes and enhancements from trunk. check-in: 521d5186 user: drh tags: apple-osx
2019-04-02
01:00
Merge fixes from trunk. check-in: 20372906 user: drh tags: apple-osx
00:34
Merge enhancements from trunk. check-in: 0b35aebb user: drh tags: apple-osx
2019-03-26
12:37
Merge recent enhancements from trunk. check-in: dc3c0b8b user: drh tags: apple-osx
2019-03-19
20:48
Merge recent enhancements from trunk. check-in: 000f4398 user: drh tags: apple-osx
2019-03-01
21:37
Merge recent changes from trunk. check-in: f270245a user: drh tags: apple-osx
18:27
Merge the latest enhancements from trunk. check-in: e64ded7b user: drh tags: apple-osx
2019-02-20
13:23
Merge the latest performance enhancements and fixes from trunk. check-in: be71d1e2 user: drh tags: apple-osx
2019-02-08
14:59
Merge the fix for ticket [4e8e4857d32d401f], so that this branch now contains release 3.27.1 plus the extra patch to preserve ROWID values on VACUUM. check-in: 0cdae60e user: drh tags: apple-osx
2019-02-07
19:28
Pull in the change that causes VACUUM to preserve rowid values. check-in: c9af2f71 user: drh tags: apple-osx
18:49
Merge the offical 3.27.0 release. check-in: 62829164 user: drh tags: apple-osx
2019-01-29
19:17
Merge enhancements from trunk. check-in: 31efcc37 user: drh tags: apple-osx
2019-01-17
15:47
Sync up with the latest enhancements on trunk. check-in: 475a179a user: drh tags: apple-osx
2018-12-10
02:00
Merge enhancements from trunk. check-in: b1bbc718 user: drh tags: apple-osx
2018-12-05
18:28
Merge enhancements and the ALTER TABLE bug fix from trunk. check-in: edfc2acf user: drh tags: apple-osx
2018-11-30
18:22
Merge the pre-3.26.0 fixes from trunk. check-in: 2c76ce4f user: drh tags: apple-osx
2018-11-26
23:35
Merge recent enhancements from trunk. check-in: e8c20a88 user: drh tags: apple-osx
2018-11-10
20:07
Merge the read-only shadow table and defensive mode enhancments from trunk. check-in: 977fc44e user: drh tags: apple-osx
2018-11-09
23:45
Merge fixes from trunk. check-in: e3e9b85e user: drh tags: apple-osx
2018-11-05
13:53
Merge recent trunk enhancements. check-in: 62acf7a0 user: drh tags: apple-osx
2018-10-31
01:26
Merge fixes from trunk, especially rebustness against corrupt database files. check-in: 4b370c74 user: drh tags: apple-osx
2018-10-25
16:58
Merge bug fixes from trunk. check-in: 1e973f65 user: drh tags: apple-osx
2018-10-12
22:02
Fix the SQLITE_ENABLE_APPLE_SPI compile-time option. check-in: 6cb537bd user: drh tags: apple-osx
2018-10-11
18:45
Fix issues with the new textkey pragma from the previous check-in. check-in: d1008b07 user: drh tags: apple-osx
18:28
Add the textkey and textrekey pragmas. check-in: f829099d user: drh tags: apple-osx
17:05
Merge compiler warning fixes and the codec enhancement from trunk. check-in: f9fa58e1 user: drh tags: apple-osx
16:28
Fix a merge problem in main.mk check-in: 9a549359 user: drh tags: apple-osx
14:07
Remove surplus code in geopoly.c that seems to have come from a bad merge. check-in: c486a63c user: drh tags: apple-osx
13:57
Merge enhancements from trunk. check-in: 9e10d88b user: drh tags: apple-osx
2018-10-10
01:01
Fix the build for Macs. check-in: 6a1d937d user: drh tags: apple-osx
2018-10-09
22:58
Merge enhancements from trunk. check-in: 1b60e7a9 user: drh tags: apple-osx
22:50
Merge changes for the 3.25.0 release. check-in: ddf6a54e user: drh tags: apple-osx
2018-06-04
14:10
Merge changes from trunk. check-in: 95fbac39 user: drh tags: apple-osx
2018-05-08
13:32
Merge changes from trunk, especially the activation of the cell-overwrite optimization for indexes and WITHOUT ROWID tables. check-in: a016144b user: drh tags: apple-osx
2018-05-07
13:01
Merge enhancements from trunk, and especially the cell-overwrite optimization. check-in: cb3aa778 user: drh tags: apple-osx
2018-05-04
20:00
Bring the code that changes the owner of WAL and rollback files when running as root into alignment with trunk. check-in: 180516bf user: drh tags: apple-osx
19:33
Merge recent enhancements from trunk. check-in: e17bca2c user: drh tags: apple-osx
2018-04-10
18:05
Merge all version 3.23.1 changes and enhancements from trunk. check-in: e20fcb51 user: drh tags: apple-osx
2018-03-14
17:17
Merge the latest enhancements from trunk. check-in: a658f80c user: drh tags: apple-osx
2018-01-22
19:04
Merge all version-3.22.0 changes. check-in: 27e20d69 user: drh tags: apple-osx
2018-01-15
21:59
Merge the enhancements associated with the first 3.22.0 beta. check-in: c9d2ec51 user: drh tags: apple-osx
2017-12-05
15:00
Merge latest trunk changes, including the compilation fix for builds that define both SQLITE_ENABLE_MULTITHREADED_CHECKS and SQLITE_ENABLE_API_ARMOUR. check-in: 2cb5d2a9 user: dan tags: apple-osx
2017-11-30
07:56
Merge latest trunk changes, including the fixes for test file walprotocol.test. check-in: b425b998 user: dan tags: apple-osx
2017-11-28
13:48
Merge the snapshots-always-lock-the-wal-file change into this branch. check-in: 3ec976e0 user: dan tags: apple-osx
08:08
Merge latest trunk changes, including the SQLITE_ENABLE_MULTITHREADED_CHECKS feature, into this branch. check-in: 1fd10349 user: dan tags: apple-osx
2017-11-17
20:22
Add missing entry for SQLITE_IOERR_VNODE to the switch statement in sqlite3ErrName(). check-in: e2b3e335 user: dan tags: apple-osx
20:16
Add an 'extern "C"' wrapper to sqlite3_private.h. check-in: 97ab1efe user: dan tags: apple-osx
20:10
Merge test script fixes from trunk into this branch. check-in: 32f5f461 user: dan tags: apple-osx
13:23
Merge latest changes from trunk, including the temporary db/ATTACH/master-journal fix. check-in: 162c7543 user: dan tags: apple-osx
2017-11-16
19:17
Merge the latest changes, and the stmtvtab1.test fix, from trunk. check-in: 85247880 user: drh tags: apple-osx
19:04
Add a missing "finish_test" to the end of the stmtvtab1.test script. check-in: e0b5c058 user: drh tags: trunk
2017-11-15
19:14
Futher improvements to the .testctrl interface in the shell. check-in: 1ca3b8cc user: drh tags: trunk
17:07
UI improvements on the .testctrl dot-command in the shell. check-in: 5d66219c user: drh tags: trunk
2017-11-14
23:48
In the parse tree, combine LIMIT and OFFSET into a single expression rooted on a TK_LIMIT node, for a small code size reduction and performance increase, and a reduction in code complexity. check-in: 3925facd user: drh tags: trunk
21:06
Fix a typo that prevented successful builds on macs. check-in: adf83060 user: drh tags: apple-osx
20:36
Merge the patch that enables reading a read-only WAL-mode database, without any special query parameters, as long as the -shm and -wal files are on disk. check-in: 8c2a769c user: drh tags: apple-osx
20:00
Merge all changes from trunk prior to the read-only WAL enhancement. check-in: 1754faef user: drh tags: apple-osx
19:34
Add the ability to read from read-only WAL-mode database files as long as the -wal and -shm files are present on disk. check-in: 00ec95fc user: drh tags: trunk
17:06
Fix the SQLITE_ENABLE_UPDATE_DELETE_LIMIT functionality so that it works with views and WITHOUT ROWID tables. check-in: dae4a97a user: dan tags: trunk
03:42
Improvement to a comment. No changes to code. Closed-Leaf check-in: 486949fc user: drh tags: readonly-wal-recovery
2017-11-13
05:51
Remove some branches in walTryBeginRead() that were added by check-in [ce5d13c2de] but became unreachable with the addition of logic in check-in [18b26843] that enabled read-only clients to parse the WAL file into a heap-memory WAL-index, thus guaranteeing that the WAL-index header is always available. check-in: 9c6b38b9 user: drh tags: readonly-wal-recovery
2017-11-11
20:11
In wal.c: improved comments, new assert() and testcase() macros, and replace some magic numbers with appropriate symbolic constants. check-in: 13ec8a77 user: drh tags: readonly-wal-recovery
13:30
Further comment improvements in wal.c. No code changes. check-in: 34638800 user: drh tags: readonly-wal-recovery
2017-11-10
20:13
Omit some extra code from non-SQLITE_ENABLE_UPDATE_DELETE_LIMIT builds. Closed-Leaf check-in: 72be33f9 user: dan tags: update-delete-limit-fix
20:00
Improved comments and variable names in the read-only WAL logic. check-in: d3c25740 user: drh tags: readonly-wal-recovery
17:47
Add further tests for the code on this branch. check-in: f8c4e33f user: dan tags: update-delete-limit-fix
16:14
Fix a problem involving "DELETE/UPDATE...LIMIT" statements that use an INDEXED BY clause. check-in: 09f94c2c user: dan tags: update-delete-limit-fix
15:42
Fix a problem with (DELETE...LIMIT) statements against WITHOUT ROWID tables with a single column PK. check-in: 35477a3d user: dan tags: update-delete-limit-fix
12:41
Fix harmless compiler warning seen with MSVC. check-in: 3711ef23 user: mistachkin tags: trunk
2017-11-09
23:24
Avoid superfluous SHM unlock call in the Win32 VFS. check-in: 5a384be6 user: mistachkin tags: readonly-wal-recovery
22:25
Cleanup superfluous whitespace changes. check-in: a2908e2c user: mistachkin tags: readonly-wal-recovery
22:23
Revise and vastly simplify the Win32 SHM file locking semantics, allowing all new tests to pass. check-in: d0997b0f user: mistachkin tags: readonly-wal-recovery
20:37
Add an assert() in the Win32 VFS. check-in: 22e58330 user: mistachkin tags: readonly-wal-recovery
20:34
Enhance walro2.test to better ensure that readonly_shm clients are not using invalid *-shm files. check-in: ff630b66 user: dan tags: readonly-wal-recovery
20:02
Get read-only SHM file tests passing on Win32. check-in: abef0535 user: mistachkin tags: readonly-wal-recovery
19:53
Add SQLITE_ENABLE_UPDATE_DELETE_LIMIT for views and WITHOUT ROWID tables. check-in: 584b88aa user: dan tags: update-delete-limit-fix
18:53
Further corrections to read-only SHM file handling on Win32. check-in: 43c31170 user: mistachkin tags: readonly-wal-recovery
18:21
Corrections to Win32 lock detection for SHM files. check-in: 3a91be97 user: mistachkin tags: readonly-wal-recovery
17:29
Corrections to the Win32 porting changes on this branch. check-in: 0b26a5a2 user: mistachkin tags: readonly-wal-recovery
17:29
Make it possible to use OSTRACE for multi-process testing. check-in: 0a7d416c user: mistachkin tags: readonly-wal-recovery
16:30
Initial work on porting the changes on this branch to Win32. check-in: 3738bfd0 user: mistachkin tags: readonly-wal-recovery
03:55
Disallow ORDER BY and LIMIT on UPDATE and DELETE of views and WITHOUT ROWID tables. This is a temporary fix for ticket [d4beea1633f1b88f] until a better solution can be found. check-in: 62fe56b5 user: drh tags: trunk
2017-11-08
19:26
Extra comments on the sqlite3OsShmMap() call in walBeginUnlocked(). No changes to code. check-in: 033ee92b user: drh tags: readonly-wal-recovery
17:51
Turns out that SQLITE_READONLY_CANTLOCK is an historical name that must be preserved. So make a new SQLITE_READLOCK_CANTINIT name instead. check-in: 04974a8b user: drh tags: readonly-wal-recovery
17:32
Change the name of SQLITE_READONLY_CANTLOCK to SQLITE_READONLY_CANTINIT. check-in: 6d7f94fa user: drh tags: readonly-wal-recovery
11:14
Fix a problem causing LSM to add unnecessary padding to empty segments in compressed databases. check-in: 1bc2d046 user: dan tags: trunk
02:50
Improved comments used for documentation of sqlite3_vfs. No changes to code. check-in: db8f22d0 user: drh tags: trunk
2017-11-07
21:25
Update an assert in wal.c. check-in: 94527b89 user: dan tags: readonly-wal-recovery
21:15
Handle the race condition that may occur if another process connects and then checkpoints and truncates the wal file while a readonly-shm client is building its heap-memory wal-index. check-in: 5a6703fc user: dan tags: readonly-wal-recovery
19:02
Fix handling of partial indexes in checkindex.c (sqlite3_checker). check-in: 31932a9e user: dan tags: trunk
18:20
Fix a problem causing an INDEXED BY specifying an unusable partial index to be mishandled. check-in: 292a0408 user: dan tags: trunk
16:54
Add the --trace option to the sqlite3_checker utility program. check-in: dc217b7c user: drh tags: trunk
16:23
Enhance the checkindex.c virtual table so that it will output the index_name and after_key parameters. Also add a new diagnostic output column named scanner_sql which shows the SQL statement used to implement the current index scan. check-in: 32e2520c user: drh tags: trunk
15:43
On unix, if the *-shm file cannot be opened for read/write access, open it read-only and proceed as if the readonly_shm=1 URI option were specified. check-in: ba718754 user: dan tags: readonly-wal-recovery
09:08
Add fault-injection tests for the code on this branch. check-in: a7d949fb user: dan tags: readonly-wal-recovery
2017-11-06
19:49
Add further test cases for the new code on this branch. And a couple of fixes. check-in: 71af9acb user: dan tags: readonly-wal-recovery
09:34
Fix a harmless compiler warning from Xcode 9.1. check-in: 66d98310 user: drh tags: trunk
2017-11-04
21:06
Add further tests for the code added on this branch. check-in: a6716fcd user: dan tags: readonly-wal-recovery
18:10
In cases where a readonly_shm client cannot take the DMS lock on the *-shm file, have it parse the wal file and create a wal-index to access it in heap memory. check-in: 18b26843 user: dan tags: readonly-wal-recovery
08:53
Fix an LSM problem with read-only connections and compression (not compression-factory) callbacks. check-in: 51ee5188 user: dan tags: trunk
2017-11-03
08:46
The extensions functions in spellfix are all deterministic. check-in: 29ec855e user: drh tags: trunk
06:45
Fix harmless compiler warnings. check-in: d088c5a3 user: mistachkin tags: trunk
2017-11-02
18:57
Fix test cases in wal2.test broken by the locking change in the previous commit. check-in: f569c351 user: dan tags: readonly-wal-recovery
11:12
Avoid locking shm-lock WAL_READ_LOCK(0) during recovery. Doing this allows recovery to proceed while a readonly_shm connection in unlocked mode has an ongoing read transaction. check-in: 5190d84a user: dan tags: readonly-wal-recovery
2017-11-01
20:59
If a readonly_shm connection cannot map the *-shm file because no other process is holding the DMS lock, have it read from the database file only, ignoring any content in the wal file. check-in: ce5d13c2 user: dan tags: readonly-wal-recovery
19:58
Fix harmless compiler warnings in sqlite3_checker.exe check-in: 491f867b user: drh tags: trunk
19:50
Make sure the JSON1 extension is available to sqlite3_checker.exe check-in: a946a8ed user: drh tags: trunk
19:44
Add the checkindex.c extension and the sqlite3_checker utility program used for doing live validation of large databases. check-in: 0c5d18a0 user: drh tags: trunk
19:22
Adjust page numbers in the ext/repair/test/checkfreelist01.test module due to the fact that the pending-byte page is no longer shifted down to a low-numbered page but is in its rightful place. Closed-Leaf check-in: c1641aff user: drh tags: checkindex
18:31
Add the "sqlite3_imposter DB SCHEMA ROOT SQL" command to sqlite3_checker. Use it to fix the checkindex01.test module. There are still errors reported by the checkfreelist01.test module. check-in: 0593a2ba user: drh tags: checkindex
18:05
Move the test scripts for checkfreelist and checkindex over into the ext/repair/test directory. Run them now using the sqlite3_checker utility with the --test option. Some tests are currently failing due to an incomplete port. This is an incremental check-in. check-in: 17f8d5e1 user: drh tags: checkindex
13:09
Minor cleanup in checkindex.c. Add progress displays when checking a single index in the top-level TCL script for sqlite3_checker. check-in: 3ca31cc3 user: drh tags: checkindex
07:06
Merge latest trunk changes into this branch. check-in: 985bfc99 user: dan tags: readonly-wal-recovery
06:59
Fix a race condition in os_unix.c that might allow a client to use a *-shm file corrupted by a power failure if another client fails between locking the *-shm file and truncating it to zero bytes. check-in: d655bfab user: dan tags: readonly-wal-recovery
01:05
When sqlite3_checker finds a problem, show the row key as part of the error message, not the row index number. check-in: 6ffe917d user: drh tags: checkindex
01:01
Actually perform index checks when running sqlite3_checker check-in: 54530020 user: drh tags: checkindex
00:10
Begin putting functionality into the sqlite3_checker binary. check-in: e82e883b user: drh tags: checkindex
2017-10-31
18:15
Merge all recent enhancements from trunk. check-in: 24adf90f user: drh tags: checkindex
18:09
Add the checkfreelist extension to the sqlite3_checker binary. check-in: 0c22f0d6 user: drh tags: checkindex
15:55
Fix an error in the Makefile.msc for the sqlite3_checker.exe target. check-in: 49d0c6f1 user: drh tags: checkindex
15:49
Add build infrastructure for the sqlite3_checker command-line utility. check-in: 429e3c3c user: drh tags: checkindex
14:56
Update the built procedures for the sqlite3_analyzer utility to allow it to be linked with an external sqlite3.o library. Automatically detect a missing dbstat extension and report the compile-time error. check-in: bb39744f user: drh tags: trunk
12:20
Fix redundancies in the makefiles that resulted from moving shell.c over to shell.c.in. check-in: bf09fa68 user: drh tags: trunk
12:06
Fix a minor comment typo. No changes to code. check-in: 5f79e6d9 user: drh tags: trunk
12:01
Fix a couple of issues in incremental_index_check to do with CREATE INDEX statements that contain embedded SQL comments. check-in: 2aef4181 user: dan tags: checkindex
03:40
Remove unnecessary NEVER() and ALWAYS() conditionals. check-in: 1c80c75d user: drh tags: trunk
2017-10-30
23:25
Add the showshm utility program for printing out the shm header in a human-readable format. check-in: f6304fd1 user: drh tags: trunk
20:44
Clarify some comments describing the WAL index file. No changes to code. check-in: 3be3aad9 user: drh tags: trunk
19:38
Add support for indexes on expressions to incremental_index_check. check-in: 8c1c701f user: dan tags: checkindex
18:49
Improve the performance of the LIKE operator by using strcspn() to aid wildcard matching. check-in: 37284d4e user: drh tags: trunk
17:05
In checkindex.c, use C code instead of SQL/group_concat() to compose various SQL clauses. This is to make it easier to support indexes on expressions. check-in: 940606b3 user: dan tags: checkindex
08:04
Fix an issue in incremental_index_check with indexes that use non-default collation sequences. check-in: 3ebb2351 user: dan tags: checkindex
2017-10-28
20:54
Increase the version number for the next release - which is still months away but there have been significant query planner enhancements since the previous release. check-in: 457eedfa user: drh tags: trunk
20:51
Reactivate query flattening when the result set of the outer query has no function calls or subqueries. This is a partial reversal of check-in [c9104b59]. Co-routines are still preferred if the outer query has a complex result set, but for simple results sets, query flattening is used. Check-in [4464f40ccd7] is completely backed out due to this change. check-in: d17ef7d1 user: drh tags: trunk
20:31
Fix "after" parameter handling in the incremental_index_check code. check-in: c40c3c62 user: dan tags: checkindex
12:20
Add test cases from OSSFuzz to prevent a regression in co-routine processing. check-in: 689743d8 user: drh tags: trunk
2017-10-27
20:53
Add the start of the "incremental_index_check" virtual table in ext/repair/checkindex.c. For incremental verification of index contents. check-in: d5b9dada user: dan tags: checkindex
18:24
Fix a Pager ref-count leak in the sqlite_dbpage virtual table. check-in: c063bb04 user: drh tags: trunk
17:09
Handle the Ctrl-C event for the shell on Win32. check-in: c8aaf371 user: mistachkin tags: trunk
12:27
Additional test case demonstrating the ability to access structure elements using quoted names in the JSON1 extension. check-in: 8d3cc928 user: drh tags: trunk
2017-10-26
20:04
Enhance the min/max optimization so that it works with indexes on expressions. check-in: 6caec908 user: drh tags: trunk
18:43
Extra ".selecttrace" output following aggregate analysis. No changes to production builds. check-in: 6fbf74ab user: drh tags: trunk
17:34
Fix an error in the previous commit on this branch. check-in: f71dfee0 user: dan tags: readonly-wal-recovery
17:05
Instead of extra locks, use F_GETLK to ensure that readonly_shm clients cannot connect to a wal-mode database if there are no writers. check-in: 5492f457 user: dan tags: readonly-wal-recovery
15:21
Fix a bug causing "make amalgmation-autoconf" to create an invalid package if either the current or parent directory contains a file named install.sh or install-sh. check-in: e1faa785 user: dan tags: trunk
2017-10-25
23:28
Use extra locks to prevent a readonly_shm=1 process from connecting to a WAL-mode database if there are no writers. check-in: 35d97908 user: drh tags: readonly-wal-recovery
19:18
Fix the sqlite3_dbpage virtual table so that it can read and write from any attached database. check-in: d4f893e1 user: drh tags: trunk
18:17
Add tests cases and fix minor issues in the rtreecheck() function. check-in: d6130cd2 user: dan tags: trunk
18:01
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: 7d264980 user: mistachkin tags: trunk
18:00
Fix compilation issue (C99-ism) seen with MSVC. Closed-Leaf check-in: 61870b42 user: mistachkin tags: rtree-integrity-check