Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
383 check-ins using file src/update.c version 5404be9e
|
2017-11-14
| ||
| 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:00 | Improved comments and variable names in the read-only WAL logic. (check-in: d3c25740 user: drh tags: readonly-wal-recovery) | |
| 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) | |
| 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
| ||
| 20:02 | Merge latest trunk changes into this branch. (check-in: 7f217eda user: dan tags: begin-concurrent) | |
| 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) | |
| 10:04 | Allow "BEGIN CONCURRENT" transactions to modify the temp schema. (check-in: 0fb6d91c user: dan tags: begin-concurrent) | |
| 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
| ||
| 19:34 | Fix some comments in new code on this branch. No changes to code. (Closed-Leaf check-in: cbec1bfe user: dan tags: fcntl_shm_read) | |
| 17:51 | Merge latest trunk changes with this branch. (check-in: 585e0a09 user: dan tags: fcntl_shm_read) | |
| 17:17 | Allow readonly_shm connections to access the *-shm file using read() even if it is unable to take a DMS lock. (check-in: 9b0d5c4f user: dan tags: fcntl_shm_read) | |
| 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) | |
| 18:26 | Speed up wildcard searches in LIKE using strchr() (Closed-Leaf check-in: 4d336d74 user: drh tags: like-compare-opt) | |
| 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
| ||
| 23:28 | I was a little concerned about this check-in. Though I could not generate a failure myself, I thought it was risky. I checked it in for further testing. Then, overnight, OSSFuzz found a failure case for me. So the change is now moved out into a deadend branch. Was: Use OP_SCopy rather than OP_Copy to transfer results from a co-routine to its consumer. This undoes an earlier fix for ticket [98825a79ce] by check-in [ec6a06246e] because that problem no longer occurs due to WHERE clause push-down. (Closed-Leaf check-in: 0926df09 user: drh tags: mistake) | |
| 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) | |
| 16:38 | 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: dde0bb3e user: dan tags: rtree-integrity-check) | |
| 16:14 | Do not reference the ioctl() system call in the unix backend unless it is actually needed by the Batch Atomic Write extension. This should allow the build to work on VxWorks. (check-in: adfa7ed2 user: drh tags: trunk) | |
| 01:34 | Add the sqlite_btreeinfo eponymous-only table for introspecting the schema and estimating the sizes of various btrees. (check-in: 1e30f477 user: drh tags: trunk) | |
|
2017-10-24
| ||
| 21:17 | Force the autoconf makefile for MSVC to always use the 'find.exe' included with Windows. (check-in: b76bffd3 user: mistachkin tags: trunk) | |
| 19:12 | Merge all enhancements and fixes from the 3.21.0 release. (check-in: 13be3a44 user: drh tags: apple-osx) | |
| 19:05 | Merge all of the fixes from the 3.21.0 release. (check-in: 5ab662b4 user: drh tags: trunk) | |
| 18:55 | Version 3.21.0 (Leaf check-in: 1a584e49 user: drh tags: release, branch-3.21, version-3.21.0) | |
| 17:28 | Fix a problem in the incr-blob code causing a new cursor to be opened for every sqlite3_blob_reopen() call. (check-in: 41ef34a1 user: dan tags: branch-3.21) | |
|
2017-10-23
| ||
| 21:24 | On the amalgamation package, enable the sqlite_dbpage virtual table so that the .dbinfo command works in the CLI. (check-in: 54b90b4f user: drh tags: branch-3.21) | |
| 20:20 | Merge trunk fixes to swarmvtabfault.test and the lsm extension into this branch. No changes to core SQLite code. (check-in: f632b870 user: dan tags: branch-3.21) | |
| 20:17 | In the 'swarmvtabfault' test module, make sure to close the database handle prior to raising an error from the 'not found' callback script. (check-in: f317037b user: mistachkin tags: trunk) | |
| 17:36 | Cleanup a test database file prior to using it. (check-in: e1bf5e1d user: mistachkin tags: trunk) | |
| 16:34 | Updates to test procedures so that they all work with encryption. No changes to the core SQLite code. (check-in: 04813307 user: drh tags: branch-3.21) | |
| 16:03 | Avoid passing a NULL value as the second argument to memcpy(). (check-in: 58e5bb49 user: dan tags: branch-3.21) | |
| 11:48 | In lsm (not SQLite), avoid opening the *-shm file before the database file is locked. Otherwise, there is a race condition whereby a connection in another process process may unlink() it while it is still in use. (check-in: c8b8b9b5 user: dan tags: trunk) | |
| 07:53 | Fix minor test script problems revealed by releasetest.tcl. (check-in: c333ee7e user: dan tags: branch-3.21) | |
| 07:52 | Fix minor test script problems revealed by releasetest.tcl. (check-in: 15e87d9b user: dan tags: trunk) | |
|
2017-10-22
| ||
| 08:03 | Fix test cases in dbpage.test so that they work with SQLITE_DEFAULT_AUTOVACUUM=1 builds. (check-in: 9474f061 user: dan tags: branch-3.21) | |
| 08:02 | Fix test cases in dbpage.test so that they work with SQLITE_DEFAULT_AUTOVACUUM=1 builds. (check-in: 0fcf1e61 user: dan tags: trunk) | |
| 07:58 | Avoid running tests that use sqlite_dbpage with SQLITE_OMIT_VIRTUAL_TABLE builds. (check-in: 6dde8d61 user: dan tags: branch-3.21) | |
| 07:57 | Avoid running tests that use sqlite_dbpage with SQLITE_OMIT_VIRTUAL_TABLE builds. (check-in: 7bd20a20 user: dan tags: trunk) | |
|
2017-10-21
| ||
| 17:17 | Merge all the enhancements and bug fixes from trunk, since none are destablizing. Call this the second beta. (check-in: fb3ee1b7 user: drh tags: branch-3.21) | |
| 14:17 | Catch and avoid a 16-bit integer overflow on the number of columns in a common table expression. This fixes a problem found by OSS-Fuzz. The test case is in TH3. (check-in: 6ee8cb6a user: drh tags: trunk) | |
| 13:29 | Remove unnecessary "#if SQLITE_MAX_COLUMN". SQLITE_MAX_COLUMN is always defined. (check-in: 6ec82acd user: drh tags: trunk) | |
| 12:59 | Initial implementation of the appendvfs extension. Untested. (check-in: 063a03a3 user: drh tags: appendvfs) | |
|
2017-10-19
| ||
| 15:17 | Take extra care to avoid an OOB read caused by a corrupt b-tree page. This fixes a problem detected by Natalie Silvanovich of Google Project Zero. (check-in: 04925dee user: dan tags: trunk) | |
|
2017-10-18
| ||
| 15:02 | Avoid using snprintf as a member variable of a struct in sqlite3ext.h. This causes problems on OSX. Similar to fix [a1fd3aa8]. (check-in: cd0471ca user: dan tags: trunk) | |
| 14:29 | Avoid using snprintf as a member variable of a struct in sqlite3ext.h. This causes problems on OSX. (Closed-Leaf check-in: b066d5a6 user: dan tags: sqlite3ext-fix) | |
|
2017-10-17
| ||
| 18:33 | The source code files generated for the 'sqlite3-all.c' target should not have Windows line-endings. (check-in: 6a08c434 user: mistachkin tags: trunk) | |
| 13:44 | Fix the ".check" command of the command-line shell to return 1 (error) rather than 2 (exit) on a test failure. (check-in: e2af0cc6 user: drh tags: trunk) | |
|
2017-10-16
| ||
| 11:50 | Improved comments, including a typo fix, on the whereLoopCheaperProperSubset() function. (check-in: 700a3c69 user: drh tags: trunk) | |
|
2017-10-15
| ||
| 22:16 | In the query planner, do not consider index X to be a proper subset of index Y if X is a covering index but Y is not. (check-in: ee31c043 user: drh tags: trunk) | |
|
2017-10-14
| ||
| 19:58 | Updates to the Makefiles for MSVC. Cherrypick of [ac8786f3f9f35cb6]. (check-in: 92eb721f user: mistachkin tags: branch-3.21) | |
| 19:54 | Updates to the Makefiles for MSVC. (check-in: ac8786f3 user: mistachkin tags: trunk) | |
|
2017-10-13
| ||
| 20:14 | Improved ability to generate stand-alone program using TCL and SQLite by compiling with -DTCLSH_INIT_PROC=name to cause the TCL interpreter to be initialized using procedure name(). Both sqlite3_analyzer and testfixture are now built this way. (check-in: d65d1f29 user: drh tags: trunk) | |
| 18:58 | Add the tcl/mkccode.tcl script used to construct a single C-language source fiel for programs that combine C-code, SQLite, and TCL. Use this script to construct the sqlite3_analyzer program. (check-in: 298a3fdd user: drh tags: trunk) | |
| 16:24 | Fix main.mk to name the win32 executable "sqlite3_expert.exe", not "sqlite3_expert". (check-in: e38571d5 user: dan tags: schemalint) | |
| 16:19 | Move a bunch of unrelated test code out of tclsqlite.c and into test_*.c files. There is still some test code in tclsqlite.c, but the amount is greatly reduced. (check-in: a9c4bc88 user: drh tags: trunk) | |
| 16:01 | The db_use_legacy_prepare command no longer exists. Use the undocumented -use-legacy-prepare option to DB version instead. (Closed-Leaf check-in: ea2fa9ab user: drh tags: tclsqlite-cleanup) | |
| 15:56 | When compiling with SQLITE_TEST, extra options are available on the "DB version" command for controlling the internal state of the SqliteDb object, for testing purposes. (check-in: bf86478d user: drh tags: tclsqlite-cleanup) | |
| 15:06 | Move some test logic out of tclsqlite.c and into auxiliary test_*.c files. This is a work in progress. (check-in: 95b7687f user: drh tags: tclsqlite-cleanup) | |
| 14:20 | Update main.mk to build the sqlite3_expert program with -DSQLITE_THREADSAFE=0 and -DSQLITE_OMIT_LOAD_EXTENSION. To minimize dependencies. (check-in: 4c68ad7d user: dan tags: schemalint) | |
|
2017-10-12
| ||
| 20:37 | Add the sqlite_dbpage virtual table (enabled using SQLITE_ENABLE_DBPAGE_VTAB). Make that virtual table and dbstat available to the command-line shell. (check-in: eaeeb09d user: drh tags: trunk) | |
| 20:24 | Fix the EXPLAIN processing so that it returns SQLITE_ERROR on an OOM, as it should. (check-in: 4ec63ef2 user: drh tags: schemalint) | |
| 19:50 | Create the new ext/repair folder and move checkfreelist.c there. Remove checkfreelist.c from the command-line shell (undoing check-in [48418f2e]). (Closed-Leaf check-in: dfdebd12 user: drh tags: dbpage) | |
| 15:28 | Add the experimental "sqlite_expert" extension. Used to find index definitions that might help with specified SQL queries. (Later:) Parked on a dead-end branch due to an assertion fault in TH3. We will merge again after the bug is fixed. (Closed-Leaf check-in: d1ef9eab user: dan tags: withdrawn) | |
| 14:18 | Fix a harmless compiler warning about an unused parameter. (check-in: de20133d user: drh tags: branch-3.21) | |
| 14:13 | Update this branch to match latest trunk. (check-in: d325da6c user: dan tags: schemalint) | |
| 14:13 | Fix the "snapshot-tarball" makefile target, which was broken by the shell.c change of check-in [36acc0a9]. (check-in: c643ace2 user: drh tags: branch-3.21) | |
| 14:03 | Merge fixes from trunk. All changes are on makefiles and test scripts. There are no core code changes. (check-in: 1fb87a0c user: drh tags: branch-3.21) | |
| 13:47 | The src/shell.c file is now generated from src/shell.c.in, so remove shell.c from version control and update the makefiles to build it automatically. (check-in: 36acc0a9 user: drh tags: trunk) | |
| 13:21 | Merge fixes from the 3.21 branch. (check-in: 29292169 user: drh tags: trunk) | |
| 11:33 | Fix a potential crash that may follow an OOM or other system error in the shell tool. (check-in: c36761e1 user: dan tags: trunk) | |
| 11:13 | Update some test cases to work with SQLITE_OMIT_VIRTUALTABLE and DEFAULT_AUTOVACUUM builds. (check-in: 4b68f424 user: dan tags: trunk) | |
| 10:28 | Make sure the tableColumnList() routine of the command-line shell does not cause a null-pointer dereference in an error condition. (check-in: 5d0ceb8d user: drh tags: branch-3.21) | |
| 01:24 | Merge fixes from the 3.21 branch. (check-in: 18d4654f user: drh tags: dbpage) | |
| 01:19 | Fix a typo in a numeric constant in an assert() - a bug that has been present in the code since check-in [79e22b95038] on 2010-03-30. (check-in: f0a2724f user: drh tags: branch-3.21) | |
|
2017-10-11
| ||
| 20:27 | Add test file mmapwarm.test. With tests for the sqlite3_mmap_warm() extension. (check-in: 5c4980ef user: dan tags: trunk) | |
| 20:26 | Merge latest trunk changes with this branch. (check-in: 2719cf5c user: dan tags: schemalint) | |
| 18:26 | Add the checkfreelist extension to the command-line shell. (check-in: 48418f2e user: drh tags: dbpage) | |
| 18:21 | Check that the leaf count on each freelist trunk page is in range as part of checkfreelist processing. (check-in: 4e894062 user: dan tags: dbpage) | |
| 18:00 | Add new extension "checkfreelist", which uses sqlite_dbpage to check that there are no invalid entries on the database free-list. (check-in: 21930ef5 user: dan tags: dbpage) | |
| 17:51 | Convert the implementation of the ".dbstat" dot-command of the command-line shell to use the sqlite_dbpage table. (check-in: 497409e1 user: drh tags: dbpage) | |
| 17:50 | Make JSON1 defines consistent in the makefiles for MSVC. (check-in: 31eee0e4 user: mistachkin tags: branch-3.21) | |
| 17:25 | Enable JSON by default in the Windows command-line shell sqlite3.exe. (check-in: 79c96121 user: drh tags: branch-3.21) | |
| 17:13 | Enable sqlite_dbpage and dbstat virtual tables in the shell, by default. (check-in: 01bf856c user: drh tags: dbpage) | |
| 15:02 | Get writes working on the sqlite_dbpage virtual table. Add a few test cases. (check-in: a8b264d8 user: drh tags: dbpage) | |
| 13:48 | Initial implementation of the "sqlite_dbpage" virtual table. Currently it is read-only and has a place-holder xBestIndex. (check-in: c2c1d656 user: drh tags: dbpage) | |
| 12:20 | In the speed-check.sh test script, allow an additional test-name argument which becomes the comparison baseline, in place of "trunk". (check-in: 0245adff user: drh tags: trunk) | |
| 11:12 | Create a branch for the 3.21.0 release. Development continues on trunk. (check-in: 0f160a8a user: drh tags: branch-3.21) | |
|
2017-10-10
| ||
| 20:11 | Add new extension "bgckpt" in ext/misc/bgckpt.c. For experimenting with running wal2 mode checkpoints in a background thread. (check-in: 63955442 user: dan tags: wal2) | |
| 13:37 | DROP TABLE now works for WITHOUT ROWID tables and the SQLITE_OMIT_AUTOVACUUM compile-time option. Fix for ticket [e651b1341861d6] (check-in: b8c1b5a5 user: drh tags: trunk) | |
|
2017-10-09
| ||
| 19:50 | Merge latest trunk changes with this branch. (check-in: d218d815 user: dan tags: wal2) | |
| 19:49 | Add a header comment to wal.c describing the differences between wal and wal2 mode. (check-in: 9c80cd20 user: dan tags: wal2) | |
|
2017-10-08
| ||
| 02:22 | Fix harmless compiler warnings in FTS5 seen with MSVC. (check-in: 5594a121 user: mistachkin tags: trunk) | |
|
2017-10-07
| ||
| 23:58 | Fix harmless compiler warning seen with MSVC. (check-in: 39d920d1 user: mistachkin tags: trunk) | |
| 23:35 | Revise variable declaration moved in the previous check-in so sqlite3VdbeReset() is consistent with sqlite3VdbeRewind(). (check-in: 63d1b425 user: mistachkin tags: trunk) | |
| 23:31 | Fix C99-style variable declaration issue seen with older versions of MSVC. (check-in: 14b181e8 user: mistachkin tags: trunk) | |
| 19:55 | Ignore the *-wal2 file if the *-wal file is zero bytes in size. (check-in: f7360fad user: dan tags: wal2) | |
| 13:37 | Check in test file wal2simple.test. (check-in: 8932b2f1 user: dan tags: wal2) | |
|
2017-10-06
| ||
| 18:00 | Add tests for the example fts3 "rank" function that appears in the documentation. (check-in: 702b137a user: dan tags: trunk) | |
| 14:25 | Merge latest trunk changes into this branch. (check-in: 7e435178 user: dan tags: wal2) | |
| 14:08 | Fix a bug in recovering wal2 mode databases introduced by the previous commit. (check-in: 9e1502e1 user: dan tags: wal2) | |
| 13:43 | Fix frame overwriting in wal2 mode. (check-in: a4b02bc9 user: dan tags: wal2) | |
|
2017-10-05
| ||
| 20:57 | Fix compiler warnings that come up with SQLITE_OMIT_WAL. (check-in: 8ca0fa8d user: drh tags: trunk) | |
| 20:02 | Fix a problem building with SQLITE_OMIT_WAL defined. (check-in: 373b0ace user: dan tags: trunk) | |
| 19:12 | Fix the command-line shell so that the ".schema --indent" command does a better job of dealing with \r\n in the middle of a CREATE statement in the schema. (check-in: 4258fb57 user: drh tags: trunk) | |
| 18:14 | Fix test case failures on this branch. (check-in: 16decc13 user: dan tags: wal2) | |
| 11:29 | Disable the delta checksum verification in RBU by default. Reenable it using -DRBU_ENABLE_DELTA_CKSUM, if desired. (check-in: d22c99b6 user: drh tags: trunk) | |
|
2017-10-04
| ||
| 20:57 | Add experimental mode that uses two wal files. Activated using "PRAGMA journal_mode = wal2". (check-in: e2fc5c81 user: dan tags: wal2) | |
| 18:26 | Updates to requirements marks. (check-in: 40964a4e user: drh tags: trunk) | |
| 17:05 | Update the speedtest1 program so that it prints the output of "PRAGMA compile_options" if the -stats option is specified. (check-in: 7c69f8f1 user: dan tags: trunk) | |
| 16:35 | Fix typos in session extension header comments. No changes to code. (check-in: 182ec9d6 user: mistachkin tags: trunk) | |
| 14:13 | New test cases for ticket [b899b6042f97f5] derived from a bug report on the mailing list from Wout Mertens. (check-in: ef94ea06 user: drh tags: trunk) | |
| 12:08 | Amend recent changes to busy.test to avoid failing with SQLITE_ENABLE_STAT4 builds. (check-in: 9ff49441 user: dan tags: trunk) | |
| 12:06 | Turn restriction 20 on the query flattener into an assert since the situation restricted can no longer occur because of the more aggressive use of co-routines. (check-in: 4464f40c user: drh tags: trunk) | |
| 10:39 | Add tests to verify that the busy-handler is invoked correctly when processing "PRAGMA optimize" and ANALYZE commands. (check-in: fb83c3d8 user: dan tags: trunk) | |
| 05:59 | Remove a redundant restriction from the query flattener. (check-in: 66629b2a user: drh tags: trunk) | |
| 02:30 | Fix a minor typo in the query flattener header comment. No code changes. (check-in: d050dc60 user: drh tags: trunk) | |
|
2017-10-03
| ||
| 19:53 | Simplify the computation of types on columns of a view. (check-in: 772b0db1 user: drh tags: trunk) | |
| 18:35 | Do not enable SELECT tracing with -DSQLITE_DEBUG. Require the -DSQLITE_ENABLE_SELECTTRACE compile-time option to enable SELECT tracing. (check-in: f5c39583 user: drh tags: trunk) | |
| 17:29 | Add some OK_IF_ALWAYS_TRUE() marks on optimization branches in select.c. (check-in: 1dd82808 user: drh tags: trunk) | |
| 17:17 | Remove an unused variable from sqlite3Insert() and fix harmless compiler warnings associated with -DSQLITE_MUTATION_TEST. (check-in: 7be760e9 user: drh tags: trunk) | |
| 16:57 | Fix the sqlite3_column_decltype() interface to return the correct datatype when the value comes through a CTE. (check-in: 966438bd user: drh tags: trunk) | |
| 14:24 | The simplification to sqlite3SelectExpand() in last night's [3a4ffb21] check-in was not completely correct. This adjustment is needed for correct OOM handling in some configurations. (check-in: c5ad5e16 user: drh tags: trunk) | |
| 03:24 | Simplification to the logic that computes column type names. Update: Does not work in all configurations. (Closed-Leaf check-in: f10ece96 user: drh tags: does-not-work) | |
| 03:01 | Do not compute column and row size estimates for the transient Table objects associated with the result set of a SELECT statement, since those estimates are never used for anything constructive. (check-in: e4342fd4 user: drh tags: trunk) | |
|
2017-10-02
| ||
| 23:50 | Mark a single branch within sqlite3SelectExpand() as an optimization. (check-in: 3a4ffb21 user: drh tags: trunk) | |
| 23:30 | Simplification to sqlite3SelectPrep() for improved testability. (check-in: 5bf2ccb9 user: drh tags: trunk) | |
| 21:29 | Add the OK_IF_ALWAYS_TRUE() and OK_IF_ALWAYS_FALSE() macros for marking conditionals that improve performance but do not change the outcome. (check-in: 6035c9b2 user: drh tags: trunk) | |
| 13:20 | Avoid using lookaside memory for persistent virtual table structures. (check-in: d815f255 user: drh tags: trunk) | |
| 02:52 | The query planner now always prefers to implement a FROM-clause subquery using a co-routine rather than flattening the subquery into the outer query. (check-in: c9104b59 user: drh tags: trunk) | |
| 02:32 | Improvements to a comment in lempar.c. No code changes. (check-in: 8000d230 user: drh tags: trunk) | |
|
2017-09-30
| ||
| 11:47 | More details in the header comment of pushDownWhereTerms(). No changes to code. (Closed-Leaf check-in: 92848623 user: drh tags: prefer-coroutine-sort-subquery) | |
| 10:50 | Make sure the SQLITE_Stat34 optimization switch is always 0x800, a value which is hard-coded in the TH3 test suite. (check-in: 6aed4ea3 user: drh tags: prefer-coroutine-sort-subquery) | |
| 01:25 | Fix unreachable conditionals and revise a testcase that was made obsolete by the changes on this branch. (check-in: 71f0adf7 user: drh tags: prefer-coroutine-sort-subquery) | |
|
2017-09-29
| ||
| 22:13 | Always render a subquery that is not part of a join as a co-routine. (check-in: 6b1651d7 user: drh tags: prefer-coroutine-sort-subquery) | |
| 16:08 | Merge the query flattener comment improvements from trunk. (check-in: f62cd4d9 user: drh tags: prefer-coroutine-sort-subquery) | |
| 16:07 | Clean up the comments on the query flattener to more clearly and accurately express the conditions under which the flattener is able to run. (check-in: 0840f9f8 user: drh tags: trunk) | |
| 14:31 | Merge changes from trunk. (check-in: 06f432fb user: drh tags: prefer-coroutine-sort-subquery) | |
| 12:44 | Make sure the 6th parameter to the authorizer callback for view subqueries has the correct view name. (check-in: 2a45bbc9 user: drh tags: trunk) | |
| 12:12 | Better names for subqueries in EXPLAIN comments. (check-in: 04ef40a8 user: drh tags: trunk) | |
|
2017-09-28
| ||
| 20:06 | Do not flatten subqueries that contain an ORDER BY or GROUP BY clause and can be implemented using a co-routine. (check-in: 042d655d user: drh tags: prefer-coroutine-sort-subquery) | |
| 17:29 | Remove the (undocumented) query-planner control that prevents a "SELECT ALL" subquery in FROM clause from being implemented as a co-routine. This control was added by [a29e117d7ec], where it was called a "stop-gap". (check-in: ff2f5a31 user: drh tags: trunk) | |
| 16:56 | Fix over-length source code lines in select.c. No logic changes. (check-in: fd3267ef user: drh tags: trunk) | |
| 13:47 | Fix an issue introduced by check-in [4cd2a9672c59] (2017-03-03) that could allow a negative value in the 3rd parameter to memmove() when defragmentPage() is called on a btree page with a corrupted freeblock list. The corruption is now detected early and results in an SQLITE_CORRUPT return before the memmove() is reached. (check-in: 5b9ae693 user: drh tags: trunk) | |
| 01:58 | Add new routines to simplify dealing with collating sequences in expressions: sqlite3ExprNNCollSeq() and sqlite3ExprCollSeqMatch(). (check-in: 490e488e user: drh tags: trunk) | |
| 01:09 | Indexes on expressions with a COLLATE clause are able to satisfy an ORDER BY with the same COLLATE clause. (check-in: 04130018 user: drh tags: trunk) | |
| 00:01 | In two places, change the magic number -1 to its proper symbol XN_ROWID. (check-in: 80277d2f user: drh tags: trunk) | |
|
2017-09-27
| ||
| 16:51 | Disable tests for the LIKE optimization when ICU is enabled, since the LIKE optimization only works for the built-in LIKE operator and ICU overrides the built-in. (check-in: f5ef2e1b user: drh tags: trunk) | |
|
2017-09-25
| ||
| 09:37 | Add an extra snapshot related test case. (check-in: 24a95e14 user: dan tags: trunk) | |
|
2017-09-23
| ||
| 07:46 | Experimental change so that snapshot transactions always lock the wal file - preventing writers or truncate-checkpointers from wrapping it. (Closed-Leaf check-in: d71eeaab user: dan tags: snapshots-lock-wal) | |
|
2017-09-22
| ||
| 20:18 | Merge in all the trunk enhancements of the previous 7 months. The LIKE optimization has stopped working when there is an ESCAPE - that problem will be addressed in a subsequent check-in. (Leaf check-in: 8d2a1cca user: drh tags: est_count_pragma) | |
| 16:23 | Use the updated Win32 VFS semantics for winOpen from check-in [5d03c738e9] for WinRT, et al, as well. (check-in: 2c03d8b8 user: mistachkin tags: trunk) | |
| 12:52 | Partial backout of check-in [e0af9a904076]. It turns out we do need some extra space at the end of the record blob as an overrun area to use when decoding a maliciously malformed record. (check-in: 403b88a8 user: drh tags: trunk) | |
| 11:09 | Cherrypick [ec37ad6d08] into this branch. With this patch, if SQLITE_SHARED_MAPPING is defined at build-time SQLite will use a single memory mapping for multiple connections to the same database file within a single process. (check-in: c7a5880d user: dan tags: begin-concurrent) | |
| 10:49 | Merge latest trunk changes into this branch. (check-in: 307b802e user: dan tags: begin-concurrent) | |
| 00:24 | Update the configure script so that it looks for tclsh8.7 ahead of tclsh8.6. (check-in: 0a12915b user: drh tags: trunk) | |
|
2017-09-21
| ||
| 20:43 | In the Windows VFS, when trying to open a database file read/write, if it fails check to see if the file exists and is read-only and immediately fall back to a read-only open attempt, rather than running the AV retry loop. (check-in: 5d03c738 user: drh tags: trunk) | |
| 20:03 | In the Windows VFS, do not emit an SQLITE_CANTOPEN error log message when falling back from SQLITE_OPEN_READWRITE to SQLITE_OPEN_READONLY. Wait until the open fails completely. (check-in: fa3f5bcc user: drh tags: trunk) | |
| 19:08 | Fix harmless UB in the ICU extension. (check-in: 68e9a840 user: drh tags: trunk) | |
| 14:03 | The sqlite3_snapshot_describe() interface useful for debugging snapshot logic. (Leaf check-in: 3fbfa9a8 user: drh tags: sqlite3_snapshot_describe) | |
| 13:11 | Fix a potential use of an uninitialized pointer in RTree following an OOM error. (check-in: fd4ec0cd user: drh tags: trunk) | |
| 10:24 | Fix a bug in tool/mksourceid.c: The mksourceid.c program was incorrectly including the "# Remove this line" line of the Fossil-generated "manifest" file in the SHA3 hash. That means that all SQLITE_SOURCE_IDs for trunk versions going back to check-in [30966d56] (2017-08-22) are incorrect. (check-in: 65765222 user: drh tags: trunk) | |
| 01:04 | Revert one performance improvement changes from check-in [3b3e32d4cd07] as it was causing a reference to an uninitialized value. (check-in: f8b1c64d user: drh tags: trunk) | |
| 00:49 | Fix the rendering of the P4_INTARRAY argument to the OP_IntegrityCk opcode in the output of EXPLAIN. (check-in: adc12c83 user: drh tags: trunk) | |
|
2017-09-20
| ||
| 18:47 | Size and performance optimization on sqlite3VdbeMemGrow(). (check-in: 4b3f7eac user: drh tags: trunk) | |
| 18:07 | The BLOB returned by sqlite3VdbeMemFromBtree() does not need to be zero-terminated. (check-in: e0af9a90 user: drh tags: trunk) | |
| 17:49 | Small size and performance optimization in the bytecode engine. (check-in: 3b3e32d4 user: drh tags: trunk) | |
| 10:47 | Improved resolution of large integer values in "CAST(x AS NUMERIC)". (check-in: 7f2bd4ff user: drh tags: trunk) | |
| 09:09 | Updates to the "lemon.html" document received from Andy Goth. (check-in: 5b2002f3 user: drh tags: trunk) | |
|
2017-09-18
| ||
| 18:17 | Add the sqlite3_mmap_warm() function as an extension in the ext/misc/mmapwarm.c source file. (check-in: 1b2de414 user: drh tags: trunk) | |
| 18:08 | Fix a typo in the MSVC makefile. (Closed-Leaf check-in: 3235835b user: drh tags: mmap-warm) | |
| 16:28 | Add extension "mmapwarm.c". Provides function sqlite3_mmap_warm(), used to "warm up" the memory mapping used by SQLite in mmap mode to access db file content. (check-in: d4a30b91 user: dan tags: mmap-warm) | |
| 13:16 | Minor simplification of error message generation during compound query code generation. (check-in: a9447193 user: drh tags: trunk) | |
| 09:40 | The out-of-bounds read on recovery fix of check-in [378afa16381a222a] caused problems for some corner-case error conditions. This alternative fix appears to work better. (check-in: 74f399d8 user: drh tags: trunk) | |
| 08:51 | Merge latest trunk changes with this branch. (Leaf check-in: 2e573350 user: dan tags: shared-mapping-hack) | |
| 00:18 | Fix the CSV virtual table extension so that it works when the default character is unsigned. (check-in: 42f07775 user: drh tags: trunk) | |
|
2017-09-17
| ||
| 19:45 | Do not make the assumption (as check-in [4da49a95c0f07] incorrectly did) that the ExprList returned by sqlite3ExprListDup() would never be passed into sqlite3ExprListAppend(). Include a new test case that shows this sometimes does happen. (check-in: 29227d00 user: drh tags: trunk) | |
|
2017-09-16
| ||
| 20:58 | Simplify the sqlite3VdbeGet() routine. Smaller, faster, and easier to maintain. (check-in: 5dbb255a user: drh tags: trunk) | |
|
2017-09-15
| ||
| 17:40 | Remove an unnecessary parameter from selectInnerLoop(). (check-in: dd95887f user: drh tags: trunk) | |
| 15:38 | Improved the header-comment documentation on sqlite3ExprCodeExprList(). No changes to code. (check-in: 5dc3ecb5 user: drh tags: trunk) | |
| 15:17 | Optimization to the ExprList object to make it slightly smaller and faster. (check-in: 4da49a95 user: drh tags: trunk) | |
| 14:36 | Fix a harmless comment typo. No changes to code. (check-in: f7f0bf1d user: drh tags: trunk) | |
|
2017-09-14
| ||
| 21:12 | Add another test case for the problem fixed by the previous commit. (check-in: 1a7e0b61 user: dan tags: trunk) | |
| 20:41 | Avoid an out-of-bounds read that can be caused by a specially constructed journal file. (check-in: cf5bf42c user: dan tags: trunk) | |
| 02:36 | Avoid an out-of-bounds read on a recovery attempt using a carefully crafted database and rollback journal with mismatched page sizes. The test case for this is in TH3. (check-in: 378afa16 user: drh tags: trunk) | |
|
2017-09-13
| ||
| 20:20 | Test case update due to PRAGMA integrity_check enhancements in [8525c30c]. No changes to code. (check-in: 43c6023b user: drh tags: trunk) | |
| 18:38 | Experimental sqlite3_stmt_retryable() interface. (Leaf check-in: ebada072 user: drh tags: sqlite3_stmt_retryable) | |
| 12:55 | Disable FTS3 matchinfo() tests that assume a littleEndian platform when running on bigEndian. (check-in: 87ccdf9c user: drh tags: trunk) | |
| 00:33 | Improvements to PRAGMA integrity_check for better detection of malformed records. Integrity_check now avoids returning SQLITE_CORRUPT on a corrupt record. Also includes microoptimizations that I stumbled over while working on integrity_check. (check-in: 8525c30c user: drh tags: trunk) | |
| 00:13 | PRAGMA integrity_check returns SQLITE_OK even if it encounters corruption while scanning indexes. (Closed-Leaf check-in: 81f62e99 user: drh tags: improved-integrity-check) | |
| 00:01 | Fix test script comment. No changes to code. (check-in: a5a19492 user: mistachkin tags: trunk) | |
|
2017-09-12
| ||
| 23:58 | Remove use of the rand_s() function (added by [139081bef9f63c3e]) as it appears to cause issues with some third-party DLLs. (check-in: 3a2793aa user: mistachkin tags: trunk) | |
| 18:11 | Merge the mutex-free PRNG change into this branch. (check-in: 8b1fc4b9 user: dan tags: shared-mapping-hack) | |
| 18:03 | Hack to have multiple connections to a single file share a single memory mapping of the databse file. (check-in: ec37ad6d user: dan tags: shared-mapping-hack) | |
| 15:05 | Fix an error in [b22cdd67] that can cause a negative infinity to be (rarely) reported as a positive infinity. (check-in: 9780b23c user: drh tags: trunk) | |
| 13:27 | Changes to (hopefully) get the build working with recent Intel compilers. (check-in: b22cdd67 user: drh tags: trunk) | |
| 00:24 | Make sure all connections are closed in the pragma.test script. Test change only - no changes to code. (check-in: d7b7f038 user: drh tags: trunk) | |
|
2017-09-11
| ||
| 23:46 | New test case for ticket [b899b6042f97f52d]. (check-in: 9d91ee5e user: drh tags: trunk) | |
| 20:54 | Add support for new operators in virtual tables: !=, IS, IS NOT, IS NULL, and NOTNULL. (check-in: 3b7dbe9d user: drh tags: trunk) | |
| 19:47 | Refactor names of constants and functions associated with the auxiliary operators for xBestIndex. (Closed-Leaf check-in: 0fb992af user: drh tags: vtab-extra-ops) | |
| 18:37 | Minor adjustments to indentation and spacing for clarity. No changes to code. (check-in: d3153abd user: drh tags: vtab-extra-ops) | |
| 08:53 | Add tests to check that affinities work with != operators on virtual table column values. No changes to code. (check-in: 8d24e080 user: dan tags: vtab-extra-ops) | |
|
2017-09-10
| ||
| 01:06 | Simplifications to the PRAGMA integrity_check code generator. (check-in: 99b9140c user: drh tags: improved-integrity-check) | |
|
2017-09-09
| ||
| 22:46 | Simplification and performance improvement to sqlite3_reset(). (check-in: b6425d01 user: drh tags: improved-integrity-check) | |
| 20:38 | Improved detection of malformed records by PRAGMA integrity_check. (check-in: 8fa923ca user: drh tags: improved-integrity-check) | |
| 19:41 | Enhance the vtab interface to handle IS, !=, IS NOT, IS NULL and IS NOT NULL constraints. (check-in: 34c8e952 user: dan tags: vtab-extra-ops) | |
| 08:03 | Use a mutex-free PRNG for the random() and randomblob() SQL functions and for the randomness used during checkpoint operations. (Leaf check-in: e63d1a7c user: drh tags: mutex-free-randomness) | |
| 06:10 | Merge trunk enhancements (check-in: 6a0b9d9d user: drh tags: apple-osx) | |
| 00:51 | Fix harmless compiler warnings seen with MSVC. (check-in: faa22e29 user: mistachkin tags: trunk) | |
|
2017-09-08
| ||
| 17:48 | Have the header comment for sqlite3Checkpoint() mention TRUNCATE along with the other three checkpoint types. No changes to code. (check-in: e1e3ca7e user: dan tags: trunk) | |
|
2017-09-07
| ||
| 09:56 | Prevent a possible crash when trying to recover using a carefully corrupted \ and truncated rollback journal. (Test case in TH3) (check-in: 02828d71 user: drh tags: trunk) | |
|
2017-09-05
| ||
| 20:16 | Update "PRAGMA integrity_check" to detect inconsistencies between a single record's header and body. (check-in: 9e393a0e user: dan tags: trunk) | |
| 17:23 | Fix a comment describing the xRowid method of the "series" virtual table. No code changes. (check-in: 868cd196 user: dan tags: trunk) | |
| 16:24 | Add experimental API sqlite3rbu_temp_size_limit(). For limiting the amount of temporary disk space RBU uses. (check-in: 7fdd6298 user: dan tags: trunk) | |
|
2017-09-04
| ||
| 19:31 | Use the SQLITE_CORRUPT_BKPT return code in a couple more places. (check-in: 72d22c22 user: mistachkin tags: trunk) | |
| 18:44 | Add the 'mksourceid' executable to the clean target for MSVC. (check-in: 77854694 user: mistachkin tags: trunk) | |
| 00:33 | Proposed fix for ticket [b899b6042f97f5] (check-in: c7f9f47b user: drh tags: trunk) | |
| 00:19 | Fix recent test cases in test/indexepxr2.test so that they work even without SQLITE_ENABLE_STAT4 and SQLITE_ENABLE_JSON1. (check-in: 03f3cc03 user: drh tags: trunk) | |
|
2017-09-01
| ||
| 14:50 | Add the new sqlite3PagerUnrefPageOne() pager method to deal with the special case of unreferencing page1. (check-in: b2e2100c user: drh tags: trunk) | |
| 12:57 | Remove an obsolete optimization in pcache that due to more recent changes was recently making the code a little slower. (check-in: c4e7e175 user: drh tags: trunk) | |
| 12:18 | Small size and performance improvement in pcacheManageDirtyList() by not zeroing the PgHdr.pDirtyNext and PgHdr.pDirtyPrev pointers for PgHdr objects that are not on the dirty list. (check-in: 919863b1 user: drh tags: trunk) | |
|
2017-08-31
| ||
| 21:11 | Clarify the documentation about "protected" versus "unprotected" sqlite3_value objects. No changes to code. (check-in: 4094a341 user: drh tags: trunk) | |
|
2017-08-30
| ||
| 13:21 | Remove unnecessary "__declspec(dllexport)" qualifiers from generated file shell.c. (check-in: bcc20be5 user: dan tags: trunk) | |
| 04:44 | Small performance optimization in pcache1. (check-in: ffd437da user: drh tags: trunk) | |
|
2017-08-29
| ||
| 20:21 | Faster memory allocation from lookaside by not trying to keep track of the number of outstanding allocations, and rather computing that value only when requested. (check-in: a06263f1 user: drh tags: trunk) | |
| 17:52 | Add a Tcl script to run the performance tests described in README-server-edition.html. (check-in: 1b3df8ff user: dan tags: server-process-edition) | |
|
2017-08-28
| ||
| 17:19 | Merge recent enhancements from trunk. (check-in: d53108e7 user: drh tags: begin-concurrent) | |
| 17:00 | Add the --enable-update-limit option to the ./configure script. (check-in: 64a8ae68 user: drh tags: trunk) | |
| 16:11 | Avoid unnecessary mutexes in the pcache1 implementation in the common case where no auxiliary page cache memory is configured. (check-in: 1ba051e3 user: drh tags: trunk) | |
| 15:51 | Remove the rarely-used scratch memory allocator. This makes the code smaller, faster, and easier to maintain. In place of the scratch allocator, add the SQLITE_CONFIG_SMALL_MALLOC configuration option that provides a hint to SQLite that large memory allocations should be avoided. (check-in: 54b00024 user: drh tags: trunk) | |
| 14:33 | Backport changes to shell.c into shell.c.in. (check-in: 2348045f user: drh tags: trunk) | |
| 11:12 | Fix the ".dump", ".schema", and ".fullschema" commands of the command-line shell so that they work even if PRAGMA empty_result_callbacks is enabled. Fix for ticket [02f0f4c54f281]. (check-in: cf0d3715 user: drh tags: trunk) | |
|
2017-08-27
| ||
| 10:55 | Instrumentation and changes in an effort to reduce thread contention. (Leaf check-in: c93298d5 user: drh tags: reduced-thread-contention) | |
|
2017-08-25
| ||
| 19:51 | Fix a few over-length source code lines. No functional changes. (check-in: 1783c54c user: drh tags: trunk) | |
| 15:43 | Size and performance optimization for sqlite3Init(). (check-in: 776d9128 user: drh tags: trunk) | |
| 13:34 | Small performance optimization in sqlite3WhereBegin(). (check-in: 39f708d1 user: drh tags: trunk) | |
| 13:02 | Convert a branch made unreachable by [59560d07] into an assert(). (check-in: 2738b8db user: drh tags: trunk) | |
| 11:44 | Improve the internal mechanism used to keep track of what kind of syncing to do for WAL transaction commits and checkpoint operations. Use the checkpoint-style of syncing to sync the header of a new or restarted WAL file. (check-in: e8d23afe user: drh tags: trunk) | |
| 09:17 | Avoid returning duplicate rows in experimental pragmas "pragma_list", "module_list" and "function_list". (check-in: b79cc8dc user: dan tags: trunk) | |
| 01:14 | Update the mechanism used to keep track of what kind of syncing to do for WAL transaction commits and checkpoint operations. Use the checkpoint-style of syncing to sync the header of a new or restarted WAL file. (Closed-Leaf check-in: bf65dae8 user: drh tags: wal-sync-refactor) | |
|
2017-08-24
| ||
| 20:54 | Fix an incorrect hyperlink in a comment. (check-in: 25292b9a user: drh tags: trunk) | |
| 15:43 | Fixes to documentation about SQLITE_OPEN_URI. (check-in: 7ec72314 user: drh tags: trunk) | |
| 13:55 | Make sure the sqlite3_result_pointer() interface does not leave a VM register in an inconsistent state. Fix for ticket [7486aa54b968e9b5]. Test cases are in TH3. (check-in: d2f9230c user: drh tags: trunk) | |
| 10:10 | Test BEGIN CONCURRENT transactions that consist entirely of read-only statements. (check-in: c3fe1f4b user: dan tags: begin-concurrent) | |
|
2017-08-23
| ||
| 23:09 | Performance optimization to pageFindSlot() in the b-tree layer. (check-in: 59560d07 user: drh tags: trunk) | |
| 20:36 | Size and performance optimization to dropCell() and freeSpace(). (check-in: bc1ec123 user: drh tags: trunk) | |
| 14:45 | Smaller and faster implementation of the fillInCell() routine. (check-in: 77074990 user: drh tags: trunk) | |
|
2017-08-22
| ||
| 21:23 | Update documentation to make it clear that SQLITE_SOURCE_ID and sqlite3_sourceid() might changes if the source code is edited. (check-in: e69c0c87 user: drh tags: trunk) | |
| 21:07 | Less dramatic changes to the source-id following an edit. Modify the way that the amalgamation is constructed to give it the opportunity to detect changes and modify the source-id. (check-in: 564c7340 user: drh tags: trunk) | |
| 19:54 | Modify the SQLITE_SOURCE_ID if the source code has changed in any way since the previous check-in. (check-in: 515d6a83 user: drh tags: trunk) | |
| 19:49 | Trying again to get out-of-tree builds to work correctly. (Closed-Leaf check-in: a1b3337e user: drh tags: mksourceid) | |
| 19:44 | mksourceid still does not work right. (Leaf check-in: ca5dcb4a user: drh tags: mistake) | |
| 19:43 | Attempting to fix the source-id generator so that it works for out-of-tree builds. (check-in: 5a037ac2 user: drh tags: mksourceid) | |
| 19:19 | Add the "mksourceid" program to the build process. That program changes the SQLITE_SOURCE_ID if the source tree has been modified in any way. (check-in: d4c05e04 user: drh tags: mksourceid) | |
| 15:21 | Fix error tests in seldom-used compile-time branches of the unix backend. (check-in: 885c2b44 user: drh tags: trunk) | |
|
2017-08-21
| ||
| 02:20 | Remove an unnecessary conditional. (check-in: 56d19f9f user: drh tags: trunk) | |
| 02:05 | Minor optimization to sqlite3VdbeMemSetStr(). (check-in: 6538ef7b user: drh tags: trunk) | |
|
2017-08-19
| ||
| 20:38 | Space and size optimization to the printf implementation. (check-in: d01d2cff user: drh tags: trunk) | |
| 15:50 | Ensure that write-locks on pages are dropped at the end of each write transaction, even if there is still a read transaction open. (check-in: 2dd36ade user: dan tags: server-process-edition) | |
|
2017-08-18
| ||
| 22:30 | Another size and performance optimization to readDbPage(). This time we eliminate some unnecessary local variables. (check-in: 745bc8de user: drh tags: trunk) | |
| 21:14 | Size and performance optimization the readDbPage() routine in the pager. (check-in: ca9e1875 user: drh tags: trunk) | |
| 18:55 | Add tests to this branch. (check-in: abb6e076 user: dan tags: server-process-edition) | |
| 16:09 | For the unix VFS, avoid an unnecessary stat() system call prior to opening any file in the common case where there are no unused file descriptors. (check-in: 3075cfa0 user: drh tags: trunk) | |
| 16:04 | Do not search for locks to clear when connecting to a db in multi-process mode unless it looks like the previous user of the client-id crashed. (check-in: 66fb9e1c user: dan tags: server-process-edition) | |
| 14:34 | Combine the OP_CreateTable and OP_CreateIndex opcodes of the bytecode engine into a single OP_CreateBtree opcode. This simplifies the implementation and makes the bytecode programs clearer. (check-in: eb1202b5 user: drh tags: trunk) | |
| 08:29 | Only use indexes on expressions to optimize ORDER BY and GROUP BY if the collation sequence matches. Possible fix for [e20dd54a]. (check-in: 37e19008 user: dan tags: trunk) | |
|
2017-08-17
| ||
| 20:53 | Use the __builtin_clzll() function of gcc to improve the performance and reduce the size of the sqlite3LogEst() routine. (check-in: a42a438c user: drh tags: trunk) | |
| 19:32 | Add support for crash recovery in multi-process mode. And add test cases for the same. (check-in: a8115f95 user: dan tags: server-process-edition) | |
| 19:23 | Small optimization in the Expr tree walker. (check-in: 264a5e1b user: drh tags: trunk) | |
| 18:54 | Size optimization in the authorizer error message generation logic. (check-in: 0367a4d5 user: drh tags: trunk) | |
| 18:23 | In sqlite3ViewGetColumnNames(), return the number of errors, not an error code. (check-in: f13682ea user: drh tags: trunk) | |
| 18:17 | The RTREE extension should return SQLITE_CORRUPT_VTAB, not just SQLITE_CORRUPT when it encounters incorrectly formatted shadow tables. (check-in: 0712f057 user: drh tags: trunk) | |
| 14:47 | Remove an unnecessary branch from the [be436a7f4587ce517ddc] fix. (check-in: fb6ca99b user: drh tags: trunk) | |
| 14:12 | Add test cases for ticket [be436a7f4587ce517] using virtual table modules fts5 and rtree. (check-in: 2101b420 user: dan tags: trunk) | |
| 02:26 | Defer schema resets when the query planner is running. Proposed fix for ticket [be436a7f4587ce517]. (check-in: a7bc7752 user: drh tags: trunk) | |
|
2017-08-16
| ||
| 19:20 | Avoid a test for CURTYPE_BTREE in sqlite3VdbeCursorMoveto() in order to reduce the size and improve the performance of OP_Column. (check-in: f078deb2 user: drh tags: trunk) | |
| 17:06 | Update this branch with the latest changes from trunk. (check-in: 380a7b7a user: dan tags: server-process-edition) | |
| 16:52 | Enhance this branch to support page-level-locking (without MVCC) for multi-process deployments. (check-in: 04e0cb57 user: dan tags: server-process-edition) | |
| 14:16 | Remove an unnecessary local variable from OP_Column, for a small size reduction and performance increase. (check-in: 39543903 user: drh tags: trunk) | |
| 11:04 | Performance improvement in the OP_Column opcode. (check-in: dc98a92f user: drh tags: trunk) | |
|
2017-08-15
| ||
| 14:14 | Small size and performance improvement in the OP_Column opcode. (check-in: 2cf3f3de user: drh tags: trunk) | |
| 03:46 | Btree optimization: New field BtCursor.pPage that points to the current page, saving a single pointer dereference on each access. (check-in: 373b71d1 user: drh tags: trunk) | |
|
2017-08-14
| ||
| 23:53 | Minor size and performance optimization to sqlite3BtreeCloseCursor(). (check-in: 16969338 user: drh tags: trunk) | |
| 18:13 | Change the internal btree routine moveToRoot() to return SQLITE_EMPTY if the table is empty or if it has pgnoRoot==0. This simplifies the callers, making them smaller and faster. The SQLITE_EMPTY result code is intercepted and changed into SQLITE_OK before surfacing in an API. (check-in: 240d5714 user: drh tags: trunk) | |
| 17:03 | Fix harmless indentation error. (check-in: 25e92baa user: drh tags: trunk) | |
| 14:53 | Sometimes a TK_COLUMN Expr node can have Expr.pTab==0 if it is a reference to an expression column in an index on an expression. Fix for ticket [aa98619ad08ddcab]. (check-in: d0da791b user: drh tags: trunk) | |
| 07:16 | Remove code for PLL support in wal mode from this branch. (check-in: 8e1b28ed user: dan tags: server-process-edition) | |
| 06:55 | Update this branch with latest trunk changes. (check-in: bc2498d6 user: dan tags: server-process-edition) | |
| 01:33 | Properly dequote column names in tables constructed by an aggregate SELECT. (check-in: 7e0d3e9c user: drh tags: trunk) | |
|
2017-08-12
| ||
| 18:31 | Add new test file fts5vocab2.test. (check-in: 02174842 user: dan tags: trunk) | |
| 14:06 | Add a more rigorous test case for the bug fixed by the previous commit on this branch. (check-in: 42560723 user: dan tags: begin-concurrent) | |
| 02:16 | Update the speed-check.sh test script to append log output to the end of the cout-NAME.txt file. (check-in: 14d262d6 user: drh tags: trunk) | |
| 02:01 | Remove the zBase field from the StrAccum object. Resulting code is slightly smaller and faster. (check-in: 6e52fa5f user: drh tags: trunk) | |
| 01:09 | Size and performance micro-optimization on sqlite3SrcListIndexedBy(). (check-in: 28a5aec1 user: drh tags: trunk) | |
|
2017-08-11
| ||
| 21:16 | Fix a problem allowing a conflicting transaction to be committed in the case where more than one 32KB shared-memory page has been written to since the transaction was started. (check-in: 38dd9b50 user: dan tags: begin-concurrent) | |
| 20:22 | Add another PAGERTRACE() macro to show when pages are added to Pager.pAllRead. No impact on production builds. (check-in: 11054cf5 user: drh tags: begin-concurrent) | |
| 19:31 | Add a PAGERTRACE() macro to log when frames are written into the WAL file. This is for analysis only and is a no-op for production builds. (check-in: 39f39e3d user: drh tags: begin-concurrent) | |
| 19:16 | Merge the latest enhancements from trunk. (check-in: 47e71695 user: drh tags: begin-concurrent) | |
| 18:59 | Fix compiler warnings that arise if the PAGERTRACE macro is turned on. This changes does not affect production builds. (check-in: 831156a4 user: drh tags: trunk) | |
| 18:55 | Improved comments in the header of the LSM1 vtab module. No code changes. (check-in: aa49926d user: drh tags: trunk) | |
| 13:51 | New test cases for LSM1. (check-in: cb0c49cb user: drh tags: trunk) | |
| 12:49 | Convert the LSM1 virtual table to be WITHOUT ROWID and get UPDATE and DELETE operations working on it. (check-in: 2164031b user: drh tags: trunk) | |
| 03:47 | Simplification to the like optimization logic. Remove unnecessary branches. (check-in: 9466d952 user: drh tags: trunk) | |
|
2017-08-10
| ||
| 20:43 | Allow WITHOUT ROWID virtual tables to be writable as long as they have exactly one column as their PRIMARY KEY. (check-in: c601d128 user: drh tags: trunk) | |
| 19:12 | Fix a typo in csv01.test introduced by the previous commit. (Closed-Leaf check-in: f38ff718 user: dan tags: writable-vtab-without-rowid) | |
| 19:10 | Add extra tests to this branch. (check-in: b0e3b88a user: dan tags: writable-vtab-without-rowid) | |
| 17:53 | Test case for writing to a WITHOUT ROWID virtual table. The TCLVAR virtual table is modified to add a "fullname" column which is the primary key, and to accept update operations against the primary key. (check-in: 6997e00c user: drh tags: writable-vtab-without-rowid) | |
| 15:19 | Experimental changes that allow a WITHOUT ROWID virtual table to be writable as long as it has only a single-column PRIMARY KEY. (check-in: ab9ee4c1 user: drh tags: writable-vtab-without-rowid) | |