SQLite
Timeline
Not logged in

93 check-ins using file src/shell.c.in version 08cbffc3

2017-11-15
16:29
[1a1a73b8] Leaf: Merge all the latest changes from trunk. (user: drh, tags: appendvfs)
2017-11-14
23:48
[3925facd] 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. (user: drh, tags: trunk)
21:06
[adf83060] Fix a typo that prevented successful builds on macs. (user: drh, tags: apple-osx)
20:36
[8c2a769c] 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. (user: drh, tags: apple-osx)
20:06
[d90e5f34] Leaf: Merge changes from trunk. This fixes the SQLITE_ENABLE_UPDATE_DELETE_LIMIT functionality so that it works with views and WITHOUT ROWID tables. (user: dan, tags: begin-concurrent)
20:00
[1754faef] Merge all changes from trunk prior to the read-only WAL enhancement. (user: drh, tags: apple-osx)
19:34
[00ec95fc] Add the ability to read from read-only WAL-mode database files as long as the -wal and -shm files are present on disk. (user: drh, tags: trunk)
17:06
[dae4a97a] Fix the SQLITE_ENABLE_UPDATE_DELETE_LIMIT functionality so that it works with views and WITHOUT ROWID tables. (user: dan, tags: trunk)
03:42
[486949fc] Closed-Leaf: Improvement to a comment. No changes to code. (user: drh, tags: readonly-wal-recovery)
2017-11-13
05:51
[9c6b38b9] 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. (user: drh, tags: readonly-wal-recovery)
2017-11-11
20:11
[13ec8a77] In wal.c: improved comments, new assert() and testcase() macros, and replace some magic numbers with appropriate symbolic constants. (user: drh, tags: readonly-wal-recovery)
13:30
[34638800] Further comment improvements in wal.c. No code changes. (user: drh, tags: readonly-wal-recovery)
2017-11-10
20:13
[72be33f9] Closed-Leaf: Omit some extra code from non-SQLITE_ENABLE_UPDATE_DELETE_LIMIT builds. (user: dan, tags: update-delete-limit-fix)
20:00
[d3c25740] Improved comments and variable names in the read-only WAL logic. (user: drh, tags: readonly-wal-recovery)
17:47
[f8c4e33f] Add further tests for the code on this branch. (user: dan, tags: update-delete-limit-fix)
16:14
[09f94c2c] Fix a problem involving "DELETE/UPDATE...LIMIT" statements that use an INDEXED BY clause. (user: dan, tags: update-delete-limit-fix)
15:42
[35477a3d] Fix a problem with (DELETE...LIMIT) statements against WITHOUT ROWID tables with a single column PK. (user: dan, tags: update-delete-limit-fix)
12:41
[3711ef23] Fix harmless compiler warning seen with MSVC. (user: mistachkin, tags: trunk)
2017-11-09
23:24
[5a384be6] Avoid superfluous SHM unlock call in the Win32 VFS. (user: mistachkin, tags: readonly-wal-recovery)
22:25
[a2908e2c] Cleanup superfluous whitespace changes. (user: mistachkin, tags: readonly-wal-recovery)
22:23
[d0997b0f] Revise and vastly simplify the Win32 SHM file locking semantics, allowing all new tests to pass. (user: mistachkin, tags: readonly-wal-recovery)
20:37
[22e58330] Add an assert() in the Win32 VFS. (user: mistachkin, tags: readonly-wal-recovery)
20:34
[ff630b66] Enhance walro2.test to better ensure that readonly_shm clients are not using invalid *-shm files. (user: dan, tags: readonly-wal-recovery)
20:02
[abef0535] Get read-only SHM file tests passing on Win32. (user: mistachkin, tags: readonly-wal-recovery)
19:53
[584b88aa] Add SQLITE_ENABLE_UPDATE_DELETE_LIMIT for views and WITHOUT ROWID tables. (user: dan, tags: update-delete-limit-fix)
18:53
[43c31170] Further corrections to read-only SHM file handling on Win32. (user: mistachkin, tags: readonly-wal-recovery)
18:21
[3a91be97] Corrections to Win32 lock detection for SHM files. (user: mistachkin, tags: readonly-wal-recovery)
17:29
[0b26a5a2] Corrections to the Win32 porting changes on this branch. (user: mistachkin, tags: readonly-wal-recovery)
17:29
[0a7d416c] Make it possible to use OSTRACE for multi-process testing. (user: mistachkin, tags: readonly-wal-recovery)
16:30
[3738bfd0] Initial work on porting the changes on this branch to Win32. (user: mistachkin, tags: readonly-wal-recovery)
03:55
[62fe56b5] 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. (user: drh, tags: trunk)
2017-11-08
19:26
[033ee92b] Extra comments on the sqlite3OsShmMap() call in walBeginUnlocked(). No changes to code. (user: drh, tags: readonly-wal-recovery)
17:51
[04974a8b] Turns out that SQLITE_READONLY_CANTLOCK is an historical name that must be preserved. So make a new SQLITE_READLOCK_CANTINIT name instead. (user: drh, tags: readonly-wal-recovery)
17:32
[6d7f94fa] Change the name of SQLITE_READONLY_CANTLOCK to SQLITE_READONLY_CANTINIT. (user: drh, tags: readonly-wal-recovery)
11:14
[1bc2d046] Fix a problem causing LSM to add unnecessary padding to empty segments in compressed databases. (user: dan, tags: trunk)
02:50
[db8f22d0] Improved comments used for documentation of sqlite3_vfs. No changes to code. (user: drh, tags: trunk)
2017-11-07
21:25
[94527b89] Update an assert in wal.c. (user: dan, tags: readonly-wal-recovery)
21:15
[5a6703fc] 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. (user: dan, tags: readonly-wal-recovery)
19:02
[31932a9e] Fix handling of partial indexes in checkindex.c (sqlite3_checker). (user: dan, tags: trunk)
18:20
[292a0408] Fix a problem causing an INDEXED BY specifying an unusable partial index to be mishandled. (user: dan, tags: trunk)
16:54
[dc217b7c] Add the --trace option to the sqlite3_checker utility program. (user: drh, tags: trunk)
16:23
[32e2520c] 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. (user: drh, tags: trunk)
15:43
[ba718754] 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. (user: dan, tags: readonly-wal-recovery)
09:08
[a7d949fb] Add fault-injection tests for the code on this branch. (user: dan, tags: readonly-wal-recovery)
2017-11-06
20:02
[7f217eda] Merge latest trunk changes into this branch. (user: dan, tags: begin-concurrent)
19:49
[71af9acb] Add further test cases for the new code on this branch. And a couple of fixes. (user: dan, tags: readonly-wal-recovery)
09:34
[66d98310] Fix a harmless compiler warning from Xcode 9.1. (user: drh, tags: trunk)
2017-11-04
21:06
[a6716fcd] Add further tests for the code added on this branch. (user: dan, tags: readonly-wal-recovery)
18:10
[18b26843] 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. (user: dan, tags: readonly-wal-recovery)
08:53
[51ee5188] Fix an LSM problem with read-only connections and compression (not compression-factory) callbacks. (user: dan, tags: trunk)
2017-11-03
19:34
[cbec1bfe] Leaf: Fix some comments in new code on this branch. No changes to code. (user: dan, tags: fcntl_shm_read)
17:51
[585e0a09] Merge latest trunk changes with this branch. (user: dan, tags: fcntl_shm_read)
17:17
[9b0d5c4f] Allow readonly_shm connections to access the *-shm file using read() even if it is unable to take a DMS lock. (user: dan, tags: fcntl_shm_read)
08:46
[29ec855e] The extensions functions in spellfix are all deterministic. (user: drh, tags: trunk)
06:45
[d088c5a3] Fix harmless compiler warnings. (user: mistachkin, tags: trunk)
2017-11-02
18:57
[f569c351] Fix test cases in wal2.test broken by the locking change in the previous commit. (user: dan, tags: readonly-wal-recovery)
11:12
[5190d84a] 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. (user: dan, tags: readonly-wal-recovery)
2017-11-01
20:59
[ce5d13c2] 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. (user: dan, tags: readonly-wal-recovery)
19:58
[491f867b] Fix harmless compiler warnings in sqlite3_checker.exe (user: drh, tags: trunk)
19:50
[a946a8ed] Make sure the JSON1 extension is available to sqlite3_checker.exe (user: drh, tags: trunk)
19:44
[0c5d18a0] Add the checkindex.c extension and the sqlite3_checker utility program used for doing live validation of large databases. (user: drh, tags: trunk)
19:22
[c1641aff] Closed-Leaf: 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. (user: drh, tags: checkindex)
18:31
[0593a2ba] 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. (user: drh, tags: checkindex)
18:05
[17f8d5e1] 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. (user: drh, tags: checkindex)
13:09
[3ca31cc3] Minor cleanup in checkindex.c. Add progress displays when checking a single index in the top-level TCL script for sqlite3_checker. (user: drh, tags: checkindex)
07:06
[985bfc99] Merge latest trunk changes into this branch. (user: dan, tags: readonly-wal-recovery)
01:05
[6ffe917d] When sqlite3_checker finds a problem, show the row key as part of the error message, not the row index number. (user: drh, tags: checkindex)
01:01
[54530020] Actually perform index checks when running sqlite3_checker (user: drh, tags: checkindex)
00:10
[e82e883b] Begin putting functionality into the sqlite3_checker binary. (user: drh, tags: checkindex)
2017-10-31
18:15
[24adf90f] Merge all recent enhancements from trunk. (user: drh, tags: checkindex)
18:09
[0c22f0d6] Add the checkfreelist extension to the sqlite3_checker binary. (user: drh, tags: checkindex)
15:55
[49d0c6f1] Fix an error in the Makefile.msc for the sqlite3_checker.exe target. (user: drh, tags: checkindex)
15:49
[429e3c3c] Add build infrastructure for the sqlite3_checker command-line utility. (user: drh, tags: checkindex)
14:56
[bb39744f] 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. (user: drh, tags: trunk)
12:20
[bf09fa68] Fix redundancies in the makefiles that resulted from moving shell.c over to shell.c.in. (user: drh, tags: trunk)
12:06
[5f79e6d9] Fix a minor comment typo. No changes to code. (user: drh, tags: trunk)
12:01
[2aef4181] Fix a couple of issues in incremental_index_check to do with CREATE INDEX statements that contain embedded SQL comments. (user: dan, tags: checkindex)
03:40
[1c80c75d] Remove unnecessary NEVER() and ALWAYS() conditionals. (user: drh, tags: trunk)
2017-10-30
23:25
[f6304fd1] Add the showshm utility program for printing out the shm header in a human-readable format. (user: drh, tags: trunk)
20:44
[3be3aad9] Clarify some comments describing the WAL index file. No changes to code. (user: drh, tags: trunk)
19:38
[8c1c701f] Add support for indexes on expressions to incremental_index_check. (user: dan, tags: checkindex)
18:49
[37284d4e] Improve the performance of the LIKE operator by using strcspn() to aid wildcard matching. (user: drh, tags: trunk)
18:26
[4d336d74] Closed-Leaf: Speed up wildcard searches in LIKE using strchr() (user: drh, tags: like-compare-opt)
17:05
[940606b3] 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. (user: dan, tags: checkindex)
08:04
[3ebb2351] Fix an issue in incremental_index_check with indexes that use non-default collation sequences. (user: dan, tags: checkindex)
2017-10-28
20:54
[457eedfa] 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. (user: drh, tags: trunk)
20:51
[d17ef7d1] 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. (user: drh, tags: trunk)
20:31
[c40c3c62] Fix "after" parameter handling in the incremental_index_check code. (user: dan, tags: checkindex)
12:20
[689743d8] Add test cases from OSSFuzz to prevent a regression in co-routine processing. (user: drh, tags: trunk)
2017-10-27
23:28
[0926df09] Closed-Leaf: 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. (user: drh, tags: mistake)
20:53
[d5b9dada] Add the start of the "incremental_index_check" virtual table in ext/repair/checkindex.c. For incremental verification of index contents. (user: dan, tags: checkindex)
18:24
[c063bb04] Fix a Pager ref-count leak in the sqlite_dbpage virtual table. (user: drh, tags: trunk)
17:09
[c8aaf371] Handle the Ctrl-C event for the shell on Win32. (user: mistachkin, tags: trunk)