Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
200 most recent check-ins using file src/util.c version 5168013c
|
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 | |
|
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 | |
|
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 | |
|
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 | |
| 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 | |
| 10:04 | Allow "BEGIN CONCURRENT" transactions to modify the temp schema. check-in: 0fb6d91c user: dan tags: begin-concurrent | |
|
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 | |