SQLite
Timeline
Not logged in

200 most recent check-ins related to "trunk"

2017-12-11
17:20
Fix a buffer overwrite in fts5 that could occur when processing a prefix query. Leaf 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
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. Leaf 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. Leaf 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
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: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. Leaf 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
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
03:42
Improvement to a comment. No changes to code. Closed-Leaf check-in: 486949fc 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
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
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
07:06
Merge latest trunk changes into this branch. check-in: 985bfc99 user: dan tags: readonly-wal-recovery
2017-10-31
18:15
Merge all recent enhancements from trunk. check-in: 24adf90f 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
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
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
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
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
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: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
2017-10-23
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
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: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: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: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
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
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:13
Update this branch to match latest trunk. check-in: d325da6c user: dan tags: schemalint
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
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
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
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
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
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
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
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
2017-09-29
16:08
Merge the query flattener comment improvements from trunk. check-in: f62cd4d9 user: drh tags: prefer-coroutine-sort-subquery
16:07
Clean up the comments on the query flattener to more clearly and accurately express the conditions under which the flattener is able to run. check-in: 0840f9f8 user: drh tags: trunk
14:31
Merge changes from trunk. check-in: 06f432fb user: drh tags: prefer-coroutine-sort-subquery
12:44
Make sure the 6th parameter to the authorizer callback for view subqueries has the correct view name. check-in: 2a45bbc9 user: drh tags: trunk