Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 descendants of [8c1c701f]
|
2017-12-07
| ||
| 21:03 | Add the ".ar x" command to the shell. For extracting the contents of sqlar archives. check-in: 0cc699d1 user: dan tags: sqlar-shell-support | |
| 16:51 | Fix harmless compiler warnings in the rot13 extension. check-in: 11347077 user: drh tags: trunk | |
| 15:44 | Begin adding support for the sqlar archive format to shell.c. There is no "extract" command so far, only "create". check-in: c9827a01 user: dan tags: sqlar-shell-support | |
| 13:15 | Updates to the main README.md file. check-in: 6bfafc35 user: drh tags: trunk | |
|
2017-12-06
| ||
| 20:50 | Fix an unreachable branch in cases when SQLITE_ENABLE_STAT4 is not defined. check-in: 6a55bd67 user: drh tags: trunk | |
|
2017-12-05
| ||
| 19:07 | For MSVC, simplify default locations for Tcl and ICU by using directories inside 'compat'. check-in: 8155b5ac user: mistachkin tags: sqlar-shell-support | |
| 18:54 | Add support for including zlib in the shell when compiling with MSVC. check-in: e1838cee user: mistachkin tags: sqlar-shell-support | |
| 18:32 | If SQLITE_HAVE_ZLIB is defined at build-time, include the functions in ext/misc/compress.c in the shell. check-in: 0296286a user: dan tags: sqlar-shell-support | |
| 15:00 | Merge latest trunk changes, including the compilation fix for builds that define both SQLITE_ENABLE_MULTITHREADED_CHECKS and SQLITE_ENABLE_API_ARMOUR. check-in: 2cb5d2a9 user: dan tags: apple-osx | |
| 14:58 | Fix a compilation problem when both SQLITE_ENABLE_MULTITHREADED_CHECKS and SQLITE_ENABLE_API_ARMOUR are defined. check-in: 0342ce51 user: dan tags: trunk | |
|
2017-12-01
| ||
| 18:40 | Fix the ".lint fkey-indexes" shell command so that it works with WITHOUT ROWID tables. check-in: 5771b1d6 user: dan tags: trunk | |
|
2017-11-30
| ||
| 11:21 | Fix some minor problems in test scripts. check-in: 4c551fde user: dan tags: trunk | |
| 07:56 | Merge latest trunk changes, including the fixes for test file walprotocol.test. check-in: b425b998 user: dan tags: apple-osx | |
| 07:55 | Update test file walprotocol.test to account for the changes in the wal locking protocol. check-in: 64e56700 user: dan tags: trunk | |
|
2017-11-29
| ||
| 16:16 | Merge latest trunk changes into this branch. check-in: 373fa21b user: dan tags: schemalint | |
|
2017-11-28
| ||
| 20:43 | Fix an assertion fault found by OSSFuzz. check-in: 75d69987 user: dan tags: trunk | |
| 13:48 | Merge the snapshots-always-lock-the-wal-file change into this branch. check-in: 3ec976e0 user: dan tags: apple-osx | |
| 13:39 | Lock the wal file for all snapshot transactions, even if they would not otherwise require this, preventing checkpointers and writers from wrapping the wal file. This means that if one connection has an open snapshot transaction it is guaranteed that a second connection can open a transaction on the same snapshot. check-in: b81a3149 user: dan tags: trunk | |
| 08:08 | Merge latest trunk changes, including the SQLITE_ENABLE_MULTITHREADED_CHECKS feature, into this branch. check-in: 1fd10349 user: dan tags: apple-osx | |
| 07:52 | Add experimental feature to detect threading bugs in apps that use SQLITE_CONFIG_MULTITHREADED. Enabled at compile time using SQLITE_ENABLE_MULTITHREADED_CHECKS. check-in: 40b598c8 user: dan tags: trunk | |
| 07:47 | Use a symbolic constant instead of a literal (-1) to identify a warn-on-contention mutex. Closed-Leaf check-in: 12a23c0a user: dan tags: multithreaded-checks | |
| 02:47 | Add the "PRAGMA table_ipk(TABLE)" command for evaluation purposes. Leaf check-in: 2494132a user: drh tags: pragma-table-ipk | |
| 00:52 | Update tests to deal with SQLITE_FAST_SECURE_DELETE. check-in: e6b89304 user: drh tags: trunk | |
|
2017-11-27
| ||
| 17:56 | Fix a faulty NEVER assert() that could fail for SQLITE_ENABLE_STAT4 builds that use foreign keys. check-in: 465350e5 user: dan tags: trunk | |
|
2017-11-26
| ||
| 02:14 | Fix an CSV output quoting problem in the command-line shell on Windows. check-in: 6500cdbd user: drh tags: trunk | |
|
2017-11-25
| ||
| 21:09 | Fix builds with both SQLITE_ENABLE_MULTITHREADED_CHECKS and SQLITE_THREADSAFE=0 defined. check-in: 7d0b12fc user: dan tags: multithreaded-checks | |
| 17:51 | Add experimental feature to detect threading bugs in apps that use SQLITE_CONFIG_MULTITHREADED. Enabled at compile time using SQLITE_ENABLE_MULTITHREADED_CHECKS. check-in: a66886ac user: dan tags: multithreaded-checks | |
|
2017-11-24
| ||
| 19:24 | Add the "^" syntax from fts3/4 to fts5. check-in: 24d7058e user: dan tags: trunk | |
| 16:55 | Enhance the configure script to detect zLib. check-in: e3b6e220 user: drh tags: trunk | |
|
2017-11-23
| ||
| 04:45 | Fix a problem in the omit-table-from-left-join optimization from check-in [0cd82ee9a8413cf] that was discovered by OSSFuzz. check-in: b016c28f user: drh tags: trunk | |
| 00:45 | Completely disable the skip-ahead-distinct optimization for all but the inner-most loop of a DISTINCT join. Fix for ticket [ef9318757b152e3a26e9592] check-in: b7595cf2 user: drh tags: trunk | |
|
2017-11-21
| ||
| 23:47 | An experimental optimization to DISTINCT that causes an immediate exit of the inner loop of a join following each output row if the inner loop does not contribute any columns to the result set. Leaf check-in: a33f88ac user: drh tags: distinct-early-out | |
| 23:38 | Fix the skip-ahead-distinct optimization on joins for cases there the table in the inner loop of the join does not contribute any columns to the result set. Proposed fix for ticket [ef9318757b152e3a2] check-in: 2dcef5a9 user: drh tags: trunk | |
| 21:15 | Fix typo in the Makefiles for MSVC. check-in: 17dd2f73 user: mistachkin tags: trunk | |
| 21:14 | Fix compilation issue (C99-ism) in the shell seen with MSVC. check-in: 9cb47430 user: mistachkin tags: trunk | |
| 20:53 | Update the omit-table-from-left-join optimization so that it can omit tables from the middle of the join as well as the end. check-in: 0cd82ee9 user: dan tags: trunk | |
| 19:22 | Update the omit-table-from-left-join optimization so that it can omit tables from the middle of the join as well as the end. Closed-Leaf check-in: 618ca9fe user: dan tags: left-join-optimization | |
|
2017-11-20
| ||
| 15:46 | Fix a problem preventing the planner from identifying scans that visit at most one row in cases where that property is guaranteed by a unique, not-null, non-IPK column that is the leftmost in its table. check-in: 7fdb1e2a user: dan tags: trunk | |
| 15:45 | Fix a typo in a test script on this branch. Closed-Leaf check-in: bff5dcfd user: dan tags: left-join-omit-fix | |
| 14:40 | Fix a problem preventing the planner from identifying scans that visit at most one row in cases where that property is guaranteed by a unique, not-null, non-IPK column that is the leftmost in its table. check-in: 299d7ca5 user: dan tags: left-join-omit-fix | |
|
2017-11-18
| ||
| 18:07 | Enhance the log messages produced in some cases if database corruption is encountered by an SQLITE_DEBUG build. check-in: ee840a76 user: dan tags: trunk | |
| 17:30 | Enhance the log messages produced in some cases if database corruption is encountered by an SQLITE_DEBUG build. Closed-Leaf check-in: 23a31280 user: dan tags: sqlite-corrupt-page | |
|
2017-11-17
| ||
| 21:01 | Improved fix for ticket [da78413751863] that does not require disabling the query flattener as was done in [005d5b870625]. This also makes the code generator for vector IN operators a little easier to understand. check-in: 723f1be3 user: drh tags: trunk | |
| 20:22 | Add missing entry for SQLITE_IOERR_VNODE to the switch statement in sqlite3ErrName(). check-in: e2b3e335 user: dan tags: apple-osx | |
| 20:16 | Add an 'extern "C"' wrapper to sqlite3_private.h. check-in: 97ab1efe user: dan tags: apple-osx | |
| 20:10 | Merge test script fixes from trunk into this branch. check-in: 32f5f461 user: dan tags: apple-osx | |
| 20:07 | Add some missing "finish_test" lines to the end of test scripts. check-in: c21406ab user: dan tags: trunk | |
| 17:32 | New assert() statements in the rowvalue IN expression processing. check-in: 00c32831 user: drh tags: trunk | |
| 15:02 | Clarification of comments on sqlite3FindInIndex(). No changes to code. check-in: 071cabd2 user: drh tags: trunk | |
| 13:23 | Merge latest changes from trunk, including the temporary db/ATTACH/master-journal fix. check-in: 162c7543 user: dan tags: apple-osx | |
| 13:21 | Do not count temporary databases that have been attached using ATTACH when figuring out if a master-journal file is required by a transaction. check-in: 93e012a3 user: dan tags: trunk | |
| 08:20 | Avoid creating a master journal if all or all but one of the databases in the transaction is a temp file. Closed-Leaf check-in: 355d1232 user: dan tags: master-journal-temp-files | |
|
2017-11-16
| ||
| 20:48 | In the LSM extension, ensure that empty space on pages is zeroed before they are written to disk. This helps with compressed databases, and stops valgrind complaining about uninitialized bytes and write(). check-in: 5ffec5db user: dan tags: trunk | |
| 19:17 | Merge the latest changes, and the stmtvtab1.test fix, from trunk. check-in: 85247880 user: drh tags: apple-osx | |
| 19:04 | Add a missing "finish_test" to the end of the stmtvtab1.test script. check-in: e0b5c058 user: drh tags: trunk | |
|
2017-11-15
| ||
| 19:14 | Futher improvements to the .testctrl interface in the shell. check-in: 1ca3b8cc user: drh tags: trunk | |
| 17:07 | UI improvements on the .testctrl dot-command in the shell. check-in: 5d66219c user: drh tags: trunk | |
| 16:29 | Merge all the latest changes from trunk. check-in: 1a1a73b8 user: drh tags: appendvfs | |
|
2017-11-14
| ||
| 23:48 | In the parse tree, combine LIMIT and OFFSET into a single expression rooted on a TK_LIMIT node, for a small code size reduction and performance increase, and a reduction in code complexity. check-in: 3925facd user: drh tags: trunk | |
| 21:06 | Fix a typo that prevented successful builds on macs. check-in: adf83060 user: drh tags: apple-osx | |
| 20:36 | Merge the patch that enables reading a read-only WAL-mode database, without any special query parameters, as long as the -shm and -wal files are on disk. check-in: 8c2a769c user: drh tags: apple-osx | |
| 20:06 | Merge changes from trunk. This fixes the SQLITE_ENABLE_UPDATE_DELETE_LIMIT functionality so that it works with views and WITHOUT ROWID tables. check-in: d90e5f34 user: dan tags: begin-concurrent | |
| 20:00 | Merge all changes from trunk prior to the read-only WAL enhancement. check-in: 1754faef user: drh tags: apple-osx | |
| 19:34 | Add the ability to read from read-only WAL-mode database files as long as the -wal and -shm files are present on disk. check-in: 00ec95fc user: drh tags: trunk | |
| 17:06 | Fix the SQLITE_ENABLE_UPDATE_DELETE_LIMIT functionality so that it works with views and WITHOUT ROWID tables. check-in: dae4a97a user: dan tags: trunk | |
|
2017-11-10
| ||
| 20:13 | Omit some extra code from non-SQLITE_ENABLE_UPDATE_DELETE_LIMIT builds. Closed-Leaf check-in: 72be33f9 user: dan tags: update-delete-limit-fix | |
| 17:47 | Add further tests for the code on this branch. check-in: f8c4e33f user: dan tags: update-delete-limit-fix | |
| 16:14 | Fix a problem involving "DELETE/UPDATE...LIMIT" statements that use an INDEXED BY clause. check-in: 09f94c2c user: dan tags: update-delete-limit-fix | |
| 15:42 | Fix a problem with (DELETE...LIMIT) statements against WITHOUT ROWID tables with a single column PK. check-in: 35477a3d user: dan tags: update-delete-limit-fix | |
| 12:41 | Fix harmless compiler warning seen with MSVC. check-in: 3711ef23 user: mistachkin tags: trunk | |
|
2017-11-09
| ||
| 19:53 | Add SQLITE_ENABLE_UPDATE_DELETE_LIMIT for views and WITHOUT ROWID tables. check-in: 584b88aa user: dan tags: update-delete-limit-fix | |
| 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
| ||
| 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
| ||
| 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 | |
|
2017-11-06
| ||
| 20:02 | Merge latest trunk changes into this branch. check-in: 7f217eda 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
| ||
| 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 | |
| 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-01
| ||
| 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 | |
| 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 | |
| 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 | |
|
2017-10-30
| ||
| 19:38 | Add support for indexes on expressions to incremental_index_check. check-in: 8c1c701f user: dan tags: checkindex | |