Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
|
2018-01-16
| ||
| 20:05 | Move the ZLIB version announcement in the CLI out of the default banner and put it in the ".version" command. (check-in: 231679d6 user: drh tags: trunk) | |
| 19:03 | Show version of zlib in use when running the shell tool in interactive mode. (check-in: a8906b52 user: mistachkin tags: trunk) | |
| 17:33 | Change a cat in zipfile.c from (z_const Bytef*) to just (Bytef*). This allows the module to build with older versions of zlib. (check-in: ac9af91d user: dan tags: trunk) | |
| 13:37 | Fix a problem causing an infinite loop or other malfunction in some UPDATE statements with an OR term in the WHERE clause. Ticket [47b2581aa9bfecec] (check-in: feb2c2b6 user: dan tags: trunk) | |
| 02:38 | Disable the ".archive" command tests in shell8.test if the CLI is compiled without ZLIB support. (check-in: ce8bfe6c user: drh tags: trunk) | |
|
2018-01-15
| ||
| 21:59 | Merge the enhancements associated with the first 3.22.0 beta. (check-in: c9d2ec51 user: drh tags: apple-osx) | |
| 19:00 | Fix a problem in the zipfile module causing it to generate incorrect checksums. Remove the ability to insert compressed data into a zip archive. (check-in: b0b7d036 user: dan tags: trunk) | |
| 15:49 | Fix a zipfile problem with extracting zero length files compressed using deflate. (check-in: cf640872 user: dan tags: trunk) | |
| 14:32 | Fix an error in the setDeviceCharacteristics() procedure for the (unsupported) QNX code in os_unix.c. (check-in: 8151913a user: drh tags: trunk) | |
|
2018-01-14
| ||
| 20:12 | Avoid excess stack usage when a VALUES clause with lots of rows occurs within a scalar expression. This fixes a problem discovered by OSSFuzz. (check-in: a4fa0581 user: drh tags: trunk) | |
|
2018-01-13
| ||
| 23:28 | Fix harmless compiler warnings in zipfile.c. (check-in: 8f7a592f user: drh tags: trunk) | |
| 19:08 | Support UPDATE statements against zipfile virtual tables. (check-in: f2d2a5df user: dan tags: trunk) | |
| 14:28 | Fully initialize the Mem object for serial-type 10, in case such a serial-type is found in a corrupt database file. (check-in: bd70a07d user: drh tags: trunk) | |
| 14:02 | Fix various problems in test scripts preventing "make test" from passing on F2FS file-systems with the "atomic-write" feature. (check-in: 6bedc743 user: dan tags: trunk) | |
| 14:01 | Fix a typo in crash8.test. (Closed-Leaf check-in: c3dc7b8d user: dan tags: f2fs-test-fixes) | |
| 13:07 | Fix various problems in test scripts preventing "make test" from passing on F2FS file-systems with the "atomic-write" feature. (check-in: 56d93d07 user: dan tags: f2fs-test-fixes) | |
| 02:07 | Updates and minor typo fix for the README. (check-in: bb196fcb user: mistachkin tags: trunk) | |
| 01:53 | Add the new "nochange" APIs to the extension loading mechanism. (check-in: cd7c4269 user: drh tags: trunk) | |
|
2018-01-12
| ||
| 23:38 | Add the sqlite3_value_nochange() API, usable from within the xUpdate method of a virtual table to discover whether or not a column was unchanged at the SQL level. (check-in: dec3ea4e user: drh tags: trunk) | |
| 23:18 | Improved comments. Slightly tighter implementation, but no big changes. (Closed-Leaf check-in: a1b3f285 user: drh tags: sqlite3_value_nochange) | |
| 21:00 | Add the experimental sqlite3_value_nochange() interface usable by xUpdate methods of virtual tables to see if a column has actually changed values. (check-in: 8b7be15e user: drh tags: sqlite3_value_nochange) | |
| 19:33 | Simplification to the implementation of OP_Insert. (check-in: 6acbdba5 user: drh tags: trunk) | |
| 19:20 | Fix error handling in sqlite3session_diff() when it is invoked for table "sqlite_stat1". (check-in: 874285e4 user: dan tags: trunk) | |
| 18:46 | Avoid an unnecessary branch when not using pre-update hooks. (check-in: ec96707e user: drh tags: trunk) | |
| 18:03 | Fix obsolete comments. No changes to code. (check-in: ec39c99b user: drh tags: trunk) | |
| 17:25 | Include changes made to the sqlite_stat1 table in changesets generated by the sessions module. sqlite_stat1 entries in such changesets are ignored by legacy clients. (check-in: 20642335 user: dan tags: trunk) | |
| 16:44 | Experimental change to include changes made to the sqlite_stat1 table in changesets generated by the sessions module. sqlite_stat1 entries in such changesets are ignored by legacy clients. (Closed-Leaf check-in: bd46c442 user: dan tags: sessions-stat1) | |
| 14:34 | Always use utimes() instead of utimensat() since the latter is not available even on some recent unix systems. (check-in: 30ed7a4b user: drh tags: trunk) | |
| 12:02 | Add a test to ensure that the sqlite3changeset_apply() function ignores tables that do not have the expected primary keys. (check-in: bf2daf06 user: dan tags: trunk) | |
| 00:30 | Enable the one-pass optimization for DELETE and UPDATE on RTree. This is parked in a branch because is seems to make no measureable performance difference. (Leaf check-in: 8b8314cb user: drh tags: rtree-one-pass) | |
|
2018-01-11
| ||
| 18:15 | Add the sqlite3_vtab_nochange() interface. Test cases are in TH3. (check-in: a5d09dfa user: drh tags: trunk) | |
| 17:33 | Change zipfile to be a WITHOUT ROWID virtual table and table-valued function. (check-in: 931201f6 user: dan tags: trunk) | |
| 17:04 | Add the sqlite3_vtab_nochange() method which virtual table implementations can use to optimize UPDATEs. (Closed-Leaf check-in: d444b1ff user: drh tags: sqlite3_vtab_nochange) | |
| 16:16 | Add test cases for running multiple RBU operations within the same process concurrently. (check-in: 407b5ed3 user: dan tags: trunk) | |
| 14:50 | Minor formatting changes in zipfile.c. No logical code differences. (check-in: 4f68bed3 user: drh tags: trunk) | |
| 13:43 | Fix typo in comment. No code changes. (check-in: 2c55571b user: drh tags: trunk) | |
| 00:38 | Update the .help screen in the CLI. Make sure the temporary files for ".open" are not deleted too soon. (check-in: b8d92d8d user: drh tags: trunk) | |
| 00:04 | Add the built-in edit(VALUE) and edit(VALUE,EDITOR) function to the CLI. (check-in: ef823c47 user: drh tags: trunk) | |
|
2018-01-10
| ||
| 23:29 | Add the ".once -e" and ".once -x" commands to the CLI, and the ".excel" command that is an alias for ".once -x". (check-in: a6ed5ab9 user: drh tags: trunk) | |
| 23:27 | Update test cases for the new "usage" for .output. (Closed-Leaf check-in: fbf5e43c user: drh tags: excel-shell-cmd) | |
| 22:27 | Save and restore the output mode when doing ".once -x" or ".excel". (check-in: f697c164 user: drh tags: excel-shell-cmd) | |
| 22:15 | An attempt to get ".once -e" working reliably on Windows. (check-in: 9b97f9d2 user: drh tags: excel-shell-cmd) | |
| 21:50 | Fix a potential SQLITE_MISUSE in the .excel command when no database is open. (check-in: 9b95ff1a user: drh tags: excel-shell-cmd) | |
| 21:41 | Add support for the ".excel" command (and ".once -e" and ".once -x") in the CLI. (check-in: 23fa7c57 user: drh tags: excel-shell-cmd) | |
| 19:50 | Fix a harmless compiler warning in zipfile.c (check-in: 60c694c1 user: drh tags: trunk) | |
| 19:15 | Include RTREE in the default CLI build. (check-in: 6a6a3d49 user: drh tags: trunk) | |
| 18:09 | Modify the new "--append" option to the .archive so that it takes a filename argument, the same as "--file". (check-in: 58e3b07c user: drh tags: trunk) | |
| 17:44 | Add the lsmode(MODE) function in the fileio.c extension and use that function in the .archive implementation. Add the --append and --dryrun options to the .archive command and remove the --zip option, making it automatic. (check-in: 38f28029 user: drh tags: trunk) | |
| 17:39 | Fix minor problems with the new ".archive" command changes. (Closed-Leaf check-in: 612b30c9 user: drh tags: archive-improvements) | |
| 17:37 | Return an SQLITE_CONSTRAINT error if an attempt is made to insert duplicate entries into a zip archive. (check-in: 1f099b2b user: dan tags: trunk) | |
| 17:19 | In the fileio.c extension, change the filetype(MODE) function into lsmode(MODE). Use the new lsmode(MODE) function in shell.c. (check-in: 52d12ba9 user: drh tags: archive-improvements) | |
| 16:50 | Implement the ".ar --create" command using a single "REPLACE INTO sqlar SELECT ... FROM fsdir();" statement. Add the shell_putsnl() SQL function for providing --verbose output. (check-in: 28ab9304 user: drh tags: archive-improvements) | |
| 16:30 | Have the zipfile module automatically append "/" to directory names that do not already end with such a character. This is required for info-zip compatibility. (check-in: 94bc3c60 user: dan tags: trunk) | |
| 15:53 | Add the "filetype()" SQL function for interpreting file modes to the fileio.c extension. (check-in: 58c0c74c user: drh tags: archive-improvements) | |
| 15:17 | The ".ar" command deduces whether or not the target file is a ZIP or SQLAR and does the appropropriate thing. The "-z" option is omitted. The "--append" option is added to open auxiliary databases using apndvfs. (check-in: 430d1a7d user: drh tags: archive-improvements) | |
| 14:00 | Allow the use of ".ar -t" without specifying an archive file or the "-z" option when the command-line shell is opened on a ZIP archive. (check-in: 9340a2c1 user: drh tags: archive-improvements) | |
| 13:58 | Tag an unreachable branch using ALWAYS(). (check-in: c42c734f user: drh tags: trunk) | |
| 13:44 | Checked into the wrong branch. (Closed-Leaf check-in: 55116dc3 user: drh tags: mistake) | |
| 13:11 | Work on the ".archive" command. (1) Add the --dryrun option. (2) Do not require --file when open on a ZIP archive. (3) Miscellaneous code simplifications. This is an incremental check-in of work in progress. (check-in: a2baada4 user: drh tags: archive-improvements) | |
| 11:56 | Fix a problem in os_unix.c causing it to return SQLITE_CANTOPEN instead of SQLITE_READONLY_RECOVERY. (check-in: 6a16f554 user: dan tags: trunk) | |
| 00:53 | Rearrange some routines in shell.c to avoid the need to forward reference a static function. (check-in: fd7f51a1 user: drh tags: trunk) | |
| 00:40 | Compute the correct column name even if the column identifier is the very last token in the SQL statement. This fixes a problem introduced by check-in [0fdf97efe5df745510c6b] and reported by the community during beta-testing. (check-in: 36b89d72 user: drh tags: trunk) | |
|
2018-01-09
| ||
| 22:23 | When disconnecting from the 'swarmvtab' extension, close each database prior to invoking the 'openclose' function on it. (check-in: 3e5647cb user: mistachkin tags: trunk) | |
| 20:49 | Fix harmless compiler warnings. (check-in: 0fb42090 user: mistachkin tags: trunk) | |
| 20:44 | Return SQLITE_CONSTRAINT if a user attempts to update a zipfile table. (check-in: 64c9ccf6 user: dan tags: trunk) | |
| 20:34 | In the os_unix.c implementation of xOpen(), do not return SQLITE_READONLY_DIRECTORY in cases where the file cannot be opened for reasons other than a readonly directory, such as the process running out of file descriptors. (check-in: fa8b80bb user: dan tags: trunk) | |
| 18:31 | Fix a potential crash in sqlite3expert.c caused by a missing sqlite3_reset() call. (check-in: f6355970 user: dan tags: trunk) | |
| 15:57 | Fix another -fsanitize issue in new shell code. (check-in: 6ee7b54c user: dan tags: trunk) | |
| 15:28 | Updates to the README.md file for the ext/misc directory. No code changes. (check-in: 6b3f4349 user: drh tags: trunk) | |
| 15:25 | Fix the shell so that it can be built with SQLITE_OMIT_VIRTUALTABLE. (check-in: 931421a2 user: dan tags: trunk) | |
| 14:30 | Do not attempt to build the code in ext/expert/sqlite3expert.c if SQLITE_OMIT_VIRTUALTABLE is defined. (check-in: ba967ad2 user: dan tags: trunk) | |
| 14:27 | Attempt to fix the fileio.c extension so that it builds on MinGW-64. (check-in: a7446d32 user: drh tags: trunk) | |
| 10:29 | Fix a zipfile problem with adding new directories to an archive. (check-in: 5fed6703 user: dan tags: trunk) | |
| 07:16 | Fix a problem in zipfile.c found by -fsanitize. (check-in: 4fe697fa user: dan tags: trunk) | |
| 02:27 | Avoid a compiler warning when building with newer versions of MinGW (check-in: cba0206a user: drh tags: trunk) | |
| 00:28 | Improve portability of compile-time MinGW detection for the command line shell. (check-in: 4a723614 user: mistachkin tags: trunk) | |
| 00:26 | Fix harmless compiler warnings. (check-in: 1adf4e60 user: mistachkin tags: trunk) | |
|
2018-01-08
| ||
| 20:04 | Test cases for sqlite3_normalize(). (Closed-Leaf check-in: 658f4225 user: drh tags: normalize) | |
| 19:59 | Update the zipfile module so that it matches the documentation. (check-in: 7e7e472f user: dan tags: trunk) | |
| 19:29 | Special handling of the NULL keyword. Sometimes it is a literal, and sometimes it is a keyword. (check-in: db5d138e user: drh tags: normalize) | |
| 19:18 | Add IN-operator normalizating and the SQLITE_NORMALIZE_CLI compile-time option for generating a stand-alone program. (check-in: d77dbb39 user: drh tags: normalize) | |
| 17:34 | Fix problems in the sqlite3expert.c code revealed by -fsanitize. (check-in: 7a93dd78 user: dan tags: trunk) | |
| 17:12 | Add an "ifcapable trace {}" block to a test in fkey1.test that uses SQL tracing. (check-in: 7182591d user: dan tags: trunk) | |
| 17:09 | Remove a superfluous define from the 'fileio' extension when compiled for Win32. (check-in: 6dcba669 user: mistachkin tags: trunk) | |
| 17:05 | Fix a malloc/sqlite3_free mismatch in the shell tool code. (check-in: fe053b2e user: dan tags: trunk) | |
| 16:54 | First code for an auxiliary function that will normalize an SQL statement. (check-in: 84814aac user: drh tags: normalize) | |
| 14:24 | Fix compilation of 'sqltclsh.exe' for MSVC. (check-in: abb112d9 user: mistachkin tags: trunk) | |
|
2018-01-07
| ||
| 23:28 | Avoid the use of utimensat() on older unix platforms. (check-in: 90cb01d8 user: drh tags: trunk) | |
| 21:58 | Remove the dependency on test_windirent.h from the generated shell.c file. (check-in: 0a50c9e3 user: drh tags: trunk) | |
| 20:38 | Modify the sqltclsh startup script to look for a properly formatted SQLAR at the end of the executable. Fix the CLI so that it automatically links against appendvfs and so that the --append command-line option works. (check-in: 67c4a8c6 user: drh tags: trunk) | |
| 19:52 | Improved comments on the sqlar.c and compress.c extensions that describe the differences between the "zlib format" used by SQLAR, the raw deflate format used by ZIP, and the custom format used by compress.c. No changes to code. (check-in: c13415c5 user: drh tags: trunk) | |
|
2018-01-06
| ||
| 21:46 | The shell detects and opens ZIP archives using the zipfile extension. (check-in: 05c99eb8 user: drh tags: trunk) | |
| 19:19 | In the shell, include the ".archive" command only if compiling with SQLITE_HAVE_ZLIB. Add ".archive" to the ".help" output. (check-in: 366469f5 user: drh tags: trunk) | |
| 15:49 | Better whitespace in the "CREATE TABLE sqlar()" statement for the ".ar" command. (check-in: 252ee55a user: drh tags: trunk) | |
| 15:46 | Improved output from ".schema --indent" when a column definition is followed by a comment. (check-in: 87da7eff user: drh tags: trunk) | |
| 14:44 | Remove a trailing tab from the Makefile for MSVC. (check-in: 00cc26e3 user: mistachkin tags: trunk) | |
| 14:43 | Minor tweaks to the Makefile for MSVC. (check-in: 2f6cc5d8 user: mistachkin tags: trunk) | |
| 13:42 | Add the appendvfs extension and code for the sqltclsh.exe executable. (check-in: b0a43e32 user: drh tags: trunk) | |
| 13:33 | Fix the appendvfs so that it leaves sqlite3_file->pMethods as NULL if it fails to open. (Closed-Leaf check-in: 46b341e3 user: drh tags: appendvfs) | |
| 04:34 | Add sqltclsh.exe to the windows makefile. (check-in: a6d5c7c2 user: drh tags: appendvfs) | |
|
2017-12-23
| ||
| 18:40 | Merge recent enhancements from trunk. (check-in: edceaccd user: drh tags: appendvfs) | |
| 14:39 | Simplification to the error handling logic in the extension loader. (check-in: 07c77314 user: drh tags: trunk) | |
| 13:55 | Improve the error message that comes back when sqlite3_load_extension() fails because the named file exists but is not a valid shared library. (check-in: 05fee1a2 user: drh tags: trunk) | |
| 12:33 | Move the generation of output column names earlier in the case of a CREATE TABLE AS. This is a fix for ticket [3b4450072511e62] and a continuation of check-in [ade7ddf1998190b2b63] that fixes cases of ticket [de3403bf5ae5f72ed6] that were missed previously. (check-in: 6b2ff26c user: drh tags: trunk) | |
| 11:51 | Add a SELECTTRACE() macro to indicate when column names are assigned to a SELECT statement. This helps with debugging for tickets like [de3403bf5ae5f72e] and [3b4450072511e621]. (check-in: 8f194008 user: drh tags: trunk) | |
|
2017-12-22
| ||
| 19:53 | In the sqlite3TreeViewExprList() routine, show the "AS" alias name for each expression in the list, if it exists. (check-in: 5efd854f user: drh tags: trunk) | |
| 00:52 | Modify the new sqlite3_vtab_collation() interface so that it takes a pointer to the sqlite3_index_info object passed into xBestIndex rather than an sqlite3 connection pointer, which the xBestIndex method might not have access to. (check-in: 5c1fe666 user: drh tags: trunk) | |
|
2017-12-21
| ||
| 21:41 | Fix SQLITE_DBCONFIG_TRIGGER_EQP so that it works even if SQLITE_DEBUG is not defined. (check-in: afbbfff7 user: drh tags: trunk) | |
| 21:02 | Add the ".eqp trigger" option to the ".eqp" command in the command-line shell. Implemented using the new SQLITE_DBCONFIG_TRIGGER_EQP control. (check-in: 2c51644a user: drh tags: trunk) | |
| 18:55 | Add the ".expert" command to the shell tool's ".help" output. (check-in: fc6193af user: dan tags: trunk) | |
| 18:23 | Change the name of SQLITE_DBCONFIG_FULL_EQP to be SQLITE_DBCONFIG_TRIGGER_EQP (which we can do without breaking compatibility because the former name has not yet appeared in an official release) and streamline its implementation. (check-in: fffc7685 user: drh tags: trunk) | |
| 14:46 | Add the SQLITE_DBCONFIG_MAX preprocessor macro which will always be equal to the largest SQLITE_DECONFIG value. (check-in: 95d41033 user: drh tags: trunk) | |
| 02:17 | Add the experimental ".expert" command to the sqlite3.exe shell. (check-in: 0821bae7 user: drh tags: trunk) | |
|
2017-12-20
| ||
| 23:46 | Lowercase local variable names in the SHA3 extension in order to avoid collisions with macros in termios.h. (check-in: 3ec73711 user: drh tags: trunk) | |
|
2017-12-19
| ||
| 18:56 | Fix crash in sqlite3_vtab_collation() when called for an IS NOT NULL constraint. (check-in: ad38d2c4 user: dan tags: trunk) | |
| 17:42 | Experimentally add the SQLite expert functionality to the shell tool. (Closed-Leaf check-in: 51068dba user: dan tags: expert-in-shell) | |
|
2017-12-16
| ||
| 19:36 | Add the sqlite3_vtab_collation() function, which allows an xBestIndex callback to determine the collation sequence that SQLite will use for a comparison. And the SQLITE_DBCONFIG_FULL_EQP configuration option, which enhances the output of "EXPLAIN QUERY PLAN" so that it includes statements run by triggers. And the code for the sqlite3_expert extension and command line application. (check-in: 4c782c95 user: dan tags: trunk) | |
| 19:16 | Merge latest trunk changes into this branch. (Closed-Leaf check-in: d5b597b5 user: dan tags: schemalint) | |
| 04:37 | Add unnecessary initializations to some local variables in the rtree module to suppress false-positive compiler warnings coming out of MSVC. (check-in: 64487d65 user: drh tags: trunk) | |
|
2017-12-15
| ||
| 20:21 | Enhance the "swarmvtab" extension. See header comments in ext/misc/unionvtab.c for details. (check-in: 01c17365 user: dan tags: trunk) | |
| 12:22 | In the LEMON parser generator, provide reduce actions with access to the lookahead token. (check-in: 42af190f user: drh tags: trunk) | |
|
2017-12-14
| ||
| 19:24 | Fixes to the appendvfs.c extension. Add the "sqltclsh" application that uses appendvfs.c to find its scripts. (check-in: ee248b52 user: drh tags: appendvfs) | |
| 16:57 | The "apndvfs" VFS shim now appears to be working for both reads and writes. (check-in: 7f7b72d8 user: drh tags: appendvfs) | |
| 16:28 | Add the ability to write to an appended database. This check-in compiles but is otherwise untested. (check-in: e343c63c user: drh tags: appendvfs) | |
| 14:50 | Bring in the latest trunk changes. (check-in: 75d85177 user: drh tags: appendvfs) | |
|
2017-12-13
| ||
| 23:47 | In valueFromExpr() only generate a OOM fault if there have been no prior faults. (check-in: 3765aaf7 user: drh tags: trunk) | |
| 22:42 | Add support for the 'lsm1.c' target in the MSVC makefile. (check-in: 6de21dea user: mistachkin tags: trunk) | |
| 20:35 | An improved way of generating the SQLITE_READONLY_DIRECTORY error. The error message submitted to sqlite3_log() is still correct this way. (check-in: 1c0aa919 user: drh tags: trunk) | |
| 20:02 | New result code SQLITE_READONLY_DIRECTORY is returned when an attempt is made to write on a database file that is in a read-only directory and hence the journal file could not be created. This situation formerly returned SQLITE_CANTOPEN, which less helpful. (check-in: 3ec73c38 user: drh tags: trunk) | |
| 18:01 | Correctly invalidate a column cache line when it is overwritten with NULL. Fix for ticket [123c9ba32130a6c9d432]. (check-in: 65754dc3 user: drh tags: trunk) | |
| 15:32 | Change some LSM code internal typenames from "Blob" and "Pgno" to "LsmBlob" and "LsmPgno". This allows the LSM code to be compiled as a single unit with sqlite3.c. (check-in: 30bf38d5 user: dan tags: trunk) | |
| 14:22 | Add script to amalgamate all LSM files into "lsm1.c". (check-in: e32b69d7 user: dan tags: trunk) | |
| 10:11 | Minor enhancement to two assert() statements in the default VFSes. (check-in: 9cede8a8 user: drh tags: trunk) | |
|
2017-12-11
| ||
| 17:20 | Fix a buffer overwrite in fts5 that could occur when processing a prefix query. (check-in: 92fc146b user: dan tags: trunk) | |
|
2017-12-09
| ||
| 01:02 | Fix a harmless API signature mismatch in the unix VFS. (check-in: bab9de7f user: drh tags: trunk) | |
|
2017-12-08
| ||
| 19:37 | The query planner tries to avoids using indexes that use unknown collating functions. (check-in: 02013fc1 user: drh tags: trunk) | |
| 16:23 | Add compile time switch SQLITE_ENABLE_ICU_COLLATIONS. For enabling ICU collations without also enabling the tokenizer, the LIKE operator, the REGEXP operator, or the unicode aware upper()/lower() scalar functions. (check-in: a079f914 user: dan tags: trunk) | |
| 14:07 | Make sure the bComplex variable in sqlite3DeleteFrom() is initialized when compiling with -DSQLITE_OMIT_TRIGGER. (check-in: e526d0c4 user: drh tags: trunk) | |
|
2017-12-07
| ||
| 22:10 | When doing a table scan using an index, do not error out if collating functions used by that index are unavailable, since they will not be used. (check-in: bbd69fa6 user: drh tags: trunk) | |
| 22:04 | Fix typo in comment. No changes to code. (check-in: 95958b60 user: mistachkin tags: trunk) | |
| 16:51 | Fix harmless compiler warnings in the rot13 extension. (check-in: 11347077 user: drh tags: trunk) | |
| 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
| ||
| 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: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: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) | |
| 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) | |
| 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: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: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: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: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) | |
| 19:34 | Add the ability to read from read-only WAL-mode database files as long as the -wal and -shm files are present on disk. (check-in: 00ec95fc user: drh tags: trunk) | |
| 17:06 | Fix the SQLITE_ENABLE_UPDATE_DELETE_LIMIT functionality so that it works with views and WITHOUT ROWID tables. (check-in: dae4a97a user: dan tags: trunk) | |
| 03:42 | Improvement to a comment. No changes to code. (Closed-Leaf check-in: 486949fc user: drh tags: readonly-wal-recovery) | |
|
2017-11-13
| ||
| 05:51 | Remove some branches in walTryBeginRead() that were added by check-in [ce5d13c2de] but became unreachable with the addition of logic in check-in [18b26843] that enabled read-only clients to parse the WAL file into a heap-memory WAL-index, thus guaranteeing that the WAL-index header is always available. (check-in: 9c6b38b9 user: drh tags: readonly-wal-recovery) | |
|
2017-11-11
| ||
| 20:11 | In wal.c: improved comments, new assert() and testcase() macros, and replace some magic numbers with appropriate symbolic constants. (check-in: 13ec8a77 user: drh tags: readonly-wal-recovery) | |
| 13:30 | Further comment improvements in wal.c. No code changes. (check-in: 34638800 user: drh tags: readonly-wal-recovery) | |
|
2017-11-10
| ||
| 20:13 | Omit some extra code from non-SQLITE_ENABLE_UPDATE_DELETE_LIMIT builds. (Closed-Leaf check-in: 72be33f9 user: dan tags: update-delete-limit-fix) | |
| 20:00 | Improved comments and variable names in the read-only WAL logic. (check-in: d3c25740 user: drh tags: readonly-wal-recovery) | |
| 17:47 | Add further tests for the code on this branch. (check-in: f8c4e33f user: dan tags: update-delete-limit-fix) | |
| 16:14 | Fix a problem involving "DELETE/UPDATE...LIMIT" statements that use an INDEXED BY clause. (check-in: 09f94c2c user: dan tags: update-delete-limit-fix) | |
| 15:42 | Fix a problem with (DELETE...LIMIT) statements against WITHOUT ROWID tables with a single column PK. (check-in: 35477a3d user: dan tags: update-delete-limit-fix) | |
| 12:41 | Fix harmless compiler warning seen with MSVC. (check-in: 3711ef23 user: mistachkin tags: trunk) | |
|
2017-11-09
| ||
| 23:24 | Avoid superfluous SHM unlock call in the Win32 VFS. (check-in: 5a384be6 user: mistachkin tags: readonly-wal-recovery) | |
| 22:25 | Cleanup superfluous whitespace changes. (check-in: a2908e2c user: mistachkin tags: readonly-wal-recovery) | |
| 22:23 | Revise and vastly simplify the Win32 SHM file locking semantics, allowing all new tests to pass. (check-in: d0997b0f user: mistachkin tags: readonly-wal-recovery) | |
| 20:37 | Add an assert() in the Win32 VFS. (check-in: 22e58330 user: mistachkin tags: readonly-wal-recovery) | |
| 20:34 | Enhance walro2.test to better ensure that readonly_shm clients are not using invalid *-shm files. (check-in: ff630b66 user: dan tags: readonly-wal-recovery) | |
| 20:02 | Get read-only SHM file tests passing on Win32. (check-in: abef0535 user: mistachkin tags: readonly-wal-recovery) | |