SQLite
Timeline
Not logged in

56 timeline items tagged with "trunk" occurring on or after release.

2017-11-21
23:38
[2dcef5a9] Leaf: 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] (user: drh, tags: trunk)
21:15
[17dd2f73] Fix typo in the Makefiles for MSVC. (user: mistachkin, tags: trunk)
21:14
[9cb47430] Fix compilation issue (C99-ism) in the shell seen with MSVC. (user: mistachkin, tags: trunk)
20:53
[0cd82ee9] 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. (user: dan, tags: trunk)
2017-11-20
15:46
[7fdb1e2a] 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. (user: dan, tags: trunk)
2017-11-18
18:07
[ee840a76] Enhance the log messages produced in some cases if database corruption is encountered by an SQLITE_DEBUG build. (user: dan, tags: trunk)
2017-11-17
21:01
[723f1be3] 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. (user: drh, tags: trunk)
20:07
[c21406ab] Add some missing "finish_test" lines to the end of test scripts. (user: dan, tags: trunk)
17:32
[00c32831] New assert() statements in the rowvalue IN expression processing. (user: drh, tags: trunk)
15:02
[071cabd2] Clarification of comments on sqlite3FindInIndex(). No changes to code. (user: drh, tags: trunk)
13:21
[93e012a3] Do not count temporary databases that have been attached using ATTACH when figuring out if a master-journal file is required by a transaction. (user: dan, tags: trunk)
2017-11-16
20:48
[5ffec5db] 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(). (user: dan, tags: trunk)
19:04
[e0b5c058] Add a missing "finish_test" to the end of the stmtvtab1.test script. (user: drh, tags: trunk)
2017-11-15
19:14
[1ca3b8cc] Futher improvements to the .testctrl interface in the shell. (user: drh, tags: trunk)
17:07
[5d66219c] UI improvements on the .testctrl dot-command in the shell. (user: drh, tags: trunk)
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)
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)
2017-11-10
12:41
[3711ef23] Fix harmless compiler warning seen with MSVC. (user: mistachkin, tags: trunk)
2017-11-09
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
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
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)
2017-11-06
09:34
[66d98310] Fix a harmless compiler warning from Xcode 9.1. (user: drh, tags: trunk)
2017-11-04
08:53
[51ee5188] Fix an LSM problem with read-only connections and compression (not compression-factory) callbacks. (user: dan, tags: trunk)
2017-11-03
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-01
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)
2017-10-31
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)
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)
18:49
[37284d4e] Improve the performance of the LIKE operator by using strcspn() to aid wildcard matching. (user: drh, tags: trunk)
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)
12:20
[689743d8] Add test cases from OSSFuzz to prevent a regression in co-routine processing. (user: drh, tags: trunk)
2017-10-27
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)
12:27
[8d3cc928] Additional test case demonstrating the ability to access structure elements using quoted names in the JSON1 extension. (user: drh, tags: trunk)
2017-10-26
20:04
[6caec908] Enhance the min/max optimization so that it works with indexes on expressions. (user: drh, tags: trunk)
18:43
[6fbf74ab] Extra ".selecttrace" output following aggregate analysis. No changes to production builds. (user: drh, tags: trunk)
15:21
[e1faa785] 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. (user: dan, tags: trunk)
2017-10-25
19:18
[d4f893e1] Fix the sqlite3_dbpage virtual table so that it can read and write from any attached database. (user: drh, tags: trunk)
18:17
[d6130cd2] Add tests cases and fix minor issues in the rtreecheck() function. (user: dan, tags: trunk)
18:01
[7d264980] 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. (user: mistachkin, tags: trunk)
16:14
[adfa7ed2] 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. (user: drh, tags: trunk)
01:34
[1e30f477] Add the sqlite_btreeinfo eponymous-only table for introspecting the schema and estimating the sizes of various btrees. (user: drh, tags: trunk)
2017-10-24
21:17
[b76bffd3] Force the autoconf makefile for MSVC to always use the 'find.exe' included with Windows. (user: mistachkin, tags: trunk)
19:05
[5ab662b4] Merge all of the fixes from the 3.21.0 release. (user: drh, tags: trunk)