SQLite
Timeline
Not logged in

200 most recent timeline items related to "trunk"

2017-08-16
19:20
[f078deb2] Leaf: Avoid a test for CURTYPE_BTREE in sqlite3VdbeCursorMoveto() in order to reduce the size and improve the performance of OP_Column. (user: drh, tags: trunk)
17:06
[380a7b7a] Leaf: Update this branch with the latest changes from trunk. (user: dan, tags: server-process-edition)
14:16
[39543903] Remove an unnecessary local variable from OP_Column, for a small size reduction and performance increase. (user: drh, tags: trunk)
11:04
[dc98a92f] Performance improvement in the OP_Column opcode. (user: drh, tags: trunk)
2017-08-15
14:14
[2cf3f3de] Small size and performance improvement in the OP_Column opcode. (user: drh, tags: trunk)
03:46
[373b71d1] Btree optimization: New field BtCursor.pPage that points to the current page, saving a single pointer dereference on each access. (user: drh, tags: trunk)
2017-08-14
23:53
[16969338] Minor size and performance optimization to sqlite3BtreeCloseCursor(). (user: drh, tags: trunk)
18:13
[240d5714] Change the internal btree routine moveToRoot() to return SQLITE_EMPTY if the table is empty or if it has pgnoRoot==0. This simplifies the callers, making them smaller and faster. The SQLITE_EMPTY result code is intercepted and changed into SQLITE_OK before surfacing in an API. (user: drh, tags: trunk)
17:03
[25e92baa] Fix harmless indentation error. (user: drh, tags: trunk)
14:53
[d0da791b] Sometimes a TK_COLUMN Expr node can have Expr.pTab==0 if it is a reference to an expression column in an index on and expression. Fix for ticket [aa98619ad08ddcab]. (user: drh, tags: trunk)
06:55
[bc2498d6] Update this branch with latest trunk changes. (user: dan, tags: server-process-edition)
01:33
[7e0d3e9c] Properly dequote column names in tables constructed by an aggregate SELECT. (user: drh, tags: trunk)
2017-08-12
18:31
[02174842] Add new test file fts5vocab2.test. (user: dan, tags: trunk)
02:16
[14d262d6] Update the speed-check.sh test script to append log output to the end of the cout-NAME.txt file. (user: drh, tags: trunk)
02:01
[6e52fa5f] Remove the zBase field from the StrAccum object. Resulting code is slightly smaller and faster. (user: drh, tags: trunk)
01:09
[28a5aec1] Size and performance micro-optimization on sqlite3SrcListIndexedBy(). (user: drh, tags: trunk)
2017-08-11
19:16
[47e71695] Merge the latest enhancements from trunk. (user: drh, tags: begin-concurrent)
18:59
[831156a4] Fix compiler warnings that arise if the PAGERTRACE macro is turned on. This changes does not affect production builds. (user: drh, tags: trunk)
18:55
[aa49926d] Improved comments in the header of the LSM1 vtab module. No code changes. (user: drh, tags: trunk)
13:51
[cb0c49cb] New test cases for LSM1. (user: drh, tags: trunk)
12:49
[2164031b] Convert the LSM1 virtual table to be WITHOUT ROWID and get UPDATE and DELETE operations working on it. (user: drh, tags: trunk)
03:47
[9466d952] Simplification to the like optimization logic. Remove unnecessary branches. (user: drh, tags: trunk)
2017-08-10
20:43
[c601d128] Allow WITHOUT ROWID virtual tables to be writable as long as they have exactly one column as their PRIMARY KEY. (user: drh, tags: trunk)
20:36
[34a7bd71] Add the "instance" type to the fts5vocab virtual table module. For direct access to the contents of the fts5 term index. (user: dan, tags: trunk)
19:12
[f38ff718] Closed-Leaf: Fix a typo in csv01.test introduced by the previous commit. (user: dan, tags: writable-vtab-without-rowid)
15:19
[ab9ee4c1] Experimental changes that allow a WITHOUT ROWID virtual table to be writable as long as it has only a single-column PRIMARY KEY. (user: drh, tags: writable-vtab-without-rowid)
03:27
[e49279e6] Add a first draft of the "vtablog" extensions that implements a generic virtual table useful for experimentation using the command-line shell. (user: drh, tags: trunk)
2017-08-09
22:55
[dcdf0913] Preserve the error code from xConnect or xCreate methods in virtual table implementations when they are encountered during parsing. (user: drh, tags: trunk)
20:35
[a6256980] Leaf: Add experimental sqlite3_open_v2() flag SQLITE_OPEN_REUSE_SCHEMA. For sharing identical in-memory schema objects between connections. (user: dan, tags: reuse-schema)
19:27
[94434a25] Various bug fixes for the new LSM1 virtual table design. (user: drh, tags: trunk)
18:40
[313df946] Work toward redesigning the interface to the LSM1 virtual table. (user: drh, tags: trunk)
2017-08-08
21:40
[795eede3] The identifier "vsnprintf" appears to be a reserved word in recent versions of XCode, so avoid using it as a structure field. (user: drh, tags: trunk)
21:30
[f4a4b149] Fix a faulty signed/unsigned character comparison in the LIKE optimization logic. (user: drh, tags: trunk)
20:03
[537e3be2] Enhance the CSV virtual table extension so that it accepts the last row of the CSV file even if the last row omits the closing \n, as long as the last row has a full set of columns. (user: drh, tags: trunk)
2017-08-07
19:12
[b26d7a1c] Avoid casting a value larger than 2^31 to a (size_t) or (SIZE_T) on systems where it is a 32-bit type. (user: dan, tags: trunk)
19:06
[f08d63b4] Leaf: On Windows, avoid casting a value larger than 2^31 to a (SIZE_T) on systems where it is a 32-bit type. (user: mistachkin, tags: mmap-size-limit)
18:13
[46c3085d] Avoid casting a value larger than 2^31 to a (size_t) on systems where it is a 32-bit type. (user: dan, tags: mmap-size-limit)
17:28
[38f30091] Fix an out-of-order test number. (user: mistachkin, tags: trunk)
17:14
[17447062] Add new test file "bigmmap.test". For testing builds with -DSQLITE_MAX_MMAP_SIZE > 2GB. (user: dan, tags: trunk)
14:15
[17bc7ded] Update this branch with latest trunk changes. (user: dan, tags: server-process-edition)
2017-08-05
16:15
[6ce8b7ca] Fix a segfault in swarmvtab that could occur if there was an error in the SQL statement passed to the constructor. Add other test cases. (user: dan, tags: trunk)
15:49
[422cd9f3] Microoptimization in pcache1.c makes the code slightly smaller and faster. (user: drh, tags: trunk)
15:30
[002a9c7b] Fix memory leak in swarmvtab. (user: dan, tags: trunk)
2017-08-04
20:27
[0f6f6f03] Add the swarm virtual table to the existing union virtual table module. (user: drh, tags: trunk)
20:15
[a94e2f60] Closed-Leaf: Add the optional non-found-callback to the swarm-vtab. (user: drh, tags: union-vtab)
08:24
[e11e6eb1] Add SQLITE_API qualifiers to public API functions in header file sqlite3rbu.h. (user: dan, tags: trunk)
08:23
[61ab112f] Closed-Leaf: Update script tool/mksqlite3c.tcl to avoid duplicating the SQLITE_API qualifier when copying sqlite3rbu.h into the amalgamation. (user: dan, tags: sqlite3rbu.h-fix)
2017-08-03
15:50
[d8637bad] Add SQLITE_API qualifiers to public API functions in header file sqlite3rbu.h. (user: dan, tags: sqlite3rbu.h-fix)
15:43
[7676b39b] Fix some problems in RBU test cases. Also update RBU source code to better handle the trivial case where an RBU update is applied to a database zero pages in size. (user: dan, tags: trunk)
00:29
[654935c7] Optimization to the comparison opcodes in the byte-code engine. (user: drh, tags: trunk)
2017-08-02
22:43
[aea5990e] In the KeyInfo object, refactor the nField and nXField elements into nKeyField and nAllField, which are more useful and run a little faster. (user: drh, tags: trunk)
19:59
[03d94388] Enhance the code in unionvtab.c to also provide the "swarmvtab" virtual table module. There are still several problems on this branch. (user: dan, tags: union-vtab)
19:04
[527974d4] Avoid redundant calls to sqlite3ApiExit() in sqlite3_step(). (user: drh, tags: trunk)
18:28
[bcc6dacb] Only attempt to invoke WAL callbacks when a transaction has committed. (user: drh, tags: trunk)
18:27
[f3c39c29] Minor optimization on clearCell() (user: drh, tags: trunk)
15:50
[49ba54e2] Optimizations associated with error handling in btree cursors. (user: drh, tags: trunk)
12:38
[c45078c0] Remove unused token codes. (user: drh, tags: trunk)
11:36
[cb3742f5] Rearrange some of the added token codes for a very slight size decrease and performance increase. (user: drh, tags: trunk)
11:04
[1cad2926] Rearrange integer token values in the parser and logic in the resolveP2Values() routine for a small size reduction and performance increase. (user: drh, tags: trunk)
03:21
[eef643a3] Show which opcodes are jumps in the comments when generating the opcodes.h header file. (user: drh, tags: trunk)
03:21
[a6e4c5ae] Add the "%token" control to the lemon parser. Not currently used by SQLite. (user: drh, tags: trunk)
02:46
[82e46fe0] Faster implementation of resolveP2Values(). (user: drh, tags: trunk)
2017-08-01
20:59
[436a89b9] Slightly smaller and faster by allocating Parser objects on the stack. (user: drh, tags: trunk)
19:53
[3e02474c] Split the OP_Last opcode into OP_Last and OP_SeekEnd. Use OP_SeekEnd to position a cursor prior to appending. Ticket [cb91bf4290c211d]. (user: drh, tags: trunk)
14:16
[24190b22] Take advantage of atomic-write capabilities in the F2FS filesystem when the database is stored on such a filesystem. This is a compile-time option activated using SQLITE_ENABLE_BATCH_ATOMIC_WRITE. (user: drh, tags: trunk)
13:54
[aafe1fec] Merge recent enhancements from trunk. (user: drh, tags: begin-concurrent)
00:20
[95e8f316] Allow ATTACH and DETACH inside of a transaction. (user: drh, tags: trunk)
2017-07-31
19:39
[0c77935c] Recognize 'AMD64' as 'x64' in the TclKit batch tool for MSVC. (user: mistachkin, tags: trunk)
19:26
[b3b89f4f] Sync up the MSVC autoconf makefile. (user: mistachkin, tags: trunk)
17:51
[14e6c302] Fix a windows-compatibility issue in the recently added schema6.test script. (user: drh, tags: trunk)
17:06
[cdc6494c] Prevent OSSFuzz from using debugging pragmas that are disabled in default builds and which generate lots of excess output. (user: drh, tags: trunk)
16:42
[ade7ddf1] Move the generation of output column names earlier, to right after name resolution and before query transformations such as flattening. This prevents the names from getting mangled by query transformations, and obviates hacks in the query flattener that attempt to work around the name mangling. The resulting code is smaller and faster and gives more consistent output. Fix to ticket [de3403bf5ae5f72ed]. (user: drh, tags: trunk)
2017-07-30
19:50
[ac1da06a] Add the schema6.test module for demonstrating schemas that generate identical and different content. (user: drh, tags: trunk)
18:40
[5216bfb7] Correctly handle an "INTEGER PRIMARY KEY UNIQUE" column in a WITHOUT ROWID table. This is a fix for ticket [bc115541132dad136], a problem discovered by OSSFuzz. (user: drh, tags: trunk)
2017-07-29
17:10
[b42c8779] Merge latest trunk changes with this branch. (user: dan, tags: server-process-edition)
17:02
[0c38dde4] Closed-Leaf: New test cases for column name generation interacting with the query flattener. (user: drh, tags: early-column-names)
16:01
[09834279] Move the generation of output column names earlier, to right after name resolution and before query transformations such as flattening. This prevents the names from getting mangled by query transformations, and obviates hacks in the query flattener that attempt to work around the name mangling. The resulting code is smaller and faster and gives more consistent output. This is an alternative fix to ticket [de3403bf5ae5f72ed]. (user: drh, tags: early-column-names)
03:33
[439cc5c5] In the query flattener, only add AS clauses to output columns of the outer query that are copied directly from the inner query. Formerly, all columns of the outer query received an AS clause if they did not have one already. This is a proposed fix for ticket [de3403bf5ae5f72]. (user: drh, tags: flattener-column-names)
2017-07-28
22:22
[bcec155e] Update Tcl version used by the TclKit batch tool for MSVC. (user: mistachkin, tags: trunk)
22:13
[3286e1a0] Fix harmless compiler warning. (user: mistachkin, tags: trunk)
20:49
[4c0520d4] Leaf: Disable the writecrash.test module on Windows. (user: drh, tags: batch-atomic-write)
2017-07-27
20:24
[f5d330f4] Enhance the like optimization so that it works with an ESCAPE clause. (user: drh, tags: trunk)
19:59
[0645f25c] Increase the version number to 3.21.0 in anticipation for changes to go into the next release. (user: drh, tags: trunk)
18:49
[c63903a4] Merge the pointer-passing interface changes from the 3.20 branch. (user: drh, tags: trunk)
18:43
[2dfcd9a8] Simplified documentation for the pointer passing interface. (user: drh, tags: branch-3.20)
2017-07-26
19:59
[3808a00f] Add the new sqlite3.mDbFlags field. Factor out bits of sqlite3.flags that do not interact with PRAGMA statements into sqlite3.mDbFlags. (user: drh, tags: trunk)
18:26
[ac1fd6be] Closed-Leaf: Allow ATTACH and DETACH to occur inside of a transaction. (user: drh, tags: attach-in-trans)
10:04
[622b1089] Fix a comment on the UnpackedRecord.r1 and UnpackedRecord.r2 fields. No changes to code. (user: drh, tags: trunk)
2017-07-25
15:12
[f39cb76b] Release candidate 2 for 3.20.0. (user: drh, tags: branch-3.20)
01:34
[1ca707a4] Fix a bug in the deterministic date/time function logic that can only appear with STAT3 or STAT4. (user: drh, tags: trunk)
2017-07-24
20:01
[1a632a9a] Do not attempt to run test file unionvtabfault.test with SQLITE_OMIT_VIRTUAL_TABLE builds. (user: dan, tags: trunk)
19:43
[d0719ad7] Update this branch with latest changes from trunk. (user: dan, tags: server-process-edition)
19:25
[9a5a3d60] Do not attempt to run test file unionvtab.test with SQLITE_OMIT_VIRTUAL_TABLE builds. (user: dan, tags: trunk)
17:37
[f483d06a] Handle a real OOM condition when incrblob2.test is run on a low-memory machine. (user: drh, tags: trunk)
15:29
[b1572d4e] Additional documentation on sqlite3_bind_pointer() and sqlite3_result_pointer(). No changes to code. (user: drh, tags: trunk)
14:44
[a98f07d9] Compiler warning fix associated with date/time functions. (user: drh, tags: trunk)
2017-07-21
20:31
[8de20fc7] Remove stray (and incomplete) comment from a test file. No changes to code. (user: mistachkin, tags: trunk)
2017-07-20
20:49
[e4b1dd36] Fix a harmless typo, but one that would show up in the documentation if not fixed. (user: drh, tags: trunk)
19:49
[416973ed] Add support for F2FS atomic writes. Untested at this point. (user: dan, tags: batch-atomic-write)
17:47
[213c61cb] Merge all the latest trunk enhancements. (user: drh, tags: begin-concurrent)
16:55
[10556ee4] Leaf: Experimental API sqlite3_stmt_refresh() to force a prepared statement to recompile if it needs to due to a schema change or other factor. (user: drh, tags: sqlite3_stmt_refresh)
15:08
[a90c062d] Enhance the built-in date/time functions so that they can be used in CHECK constraints, in the WHERE clause or partial indexes, and index expressions, provided that none of the non-deterministic keywords ("now", "localtime", "utc") are used as arguments. (user: drh, tags: trunk)
14:36
[b7f70c7f] Closed-Leaf: New test cases for date/time functions in indexes on expressions, in the WHERE clause of partial indexes, and in CHECK constraints. (user: drh, tags: index-on-date-func)
2017-07-19
19:48
[0a5e1c04] Allow indexes to be created on date/time functions as long as the 'now' date and the 'localtime' and 'utc' modifiers are not used. (user: drh, tags: index-on-date-func)
18:54
[be0df0a6] Merge latest trunk changes with this branch. (user: dan, tags: server-process-edition)
18:01
[d14fc621] Remove some 'breakpoint' commands in test files. (user: mistachkin, tags: trunk)
17:12
[55791928] Closed-Leaf: Create "pure" versions of the date/time functions that omit the 'now' feature and are therefore deterministic and usable in an index. (user: drh, tags: pure-date-functions)
11:52
[c93284cd] Add further tests to unionvtab.test. (user: dan, tags: trunk)
11:20
[929bc46b] Add VFS interfaces needed to make use of batch atomic write capabilities in the underlying filesystem. (user: drh, tags: batch-atomic-write)
2017-07-18
21:19
[255d6b99] Fix a crash in unionvtab caused by a misconfiguration. Add other test cases for the same. (user: dan, tags: trunk)
20:59
[505fdc8f] Fix shell.c.in so that it aligns with shell.c. (user: drh, tags: trunk)
20:49
[deadaad2] Add test cases and fix minor error-handling issues in unionvtab.c. (user: dan, tags: trunk)
20:30
[47b80ecc] Fix duplicate test name. No changes to code. (user: mistachkin, tags: trunk)
20:28
[d49639c2] Fix another harmless compiler warning. Get the MSVC makefile working with unionvtab. (user: drh, tags: trunk)
20:22
[4d147a1e] Suppress harmless compiler warnings in union-vtab. (user: drh, tags: trunk)
20:17
[a447fdf1] Remove an unused variable from unionvtab.c. (user: dan, tags: trunk)
20:03
[5bcf0f86] Improve the readability of the unionvtab code. (user: dan, tags: trunk)
19:51
[4a6c416f] Have unionvtab support constraints on the column that corresponds to the INTEGER PRIMARY KEY field of the underlying source tables in the same way as rowid. (user: dan, tags: trunk)
18:50
[6c9128e1] Add test cases to unionvtab.test. (user: dan, tags: trunk)
18:19
[948f9504] Add the union-vtab extension - still experimental and under active development. (user: drh, tags: trunk)
17:34
[9dbae1df] Do not use the flattening optimization for a sub-query on the RHS of a LEFT JOIN if that subquery reads data from a virtual table. Because it prevents the planner from creating an automatic index on the results of the sub-query, the flattening optimization sometimes slows things down in this case. (user: dan, tags: trunk)
17:13
[d2f0b2e8] Avoid creating an automatic index on the RHS of a LEFT JOIN to optimize an IS term. Fix for [ce68383b]. (user: dan, tags: trunk)
14:41
[0b69aa7e] Change the default command-line shell history depth to 2000 lines. (user: drh, tags: trunk)
2017-07-17
21:03
[f2c4a584] Closed-Leaf: Add test cases to test/unionvtab.test. (user: dan, tags: union-vtab)
20:21
[e181225d] Leaf: Merge all the latest fixes and enhancements from trunk. (user: drh, tags: apple-osx)
18:45
[e0aca7d2] Merge all changes from branch-3.20. Improvements to the fts5() extension interface. Work around a gcc/valgrind bug in the sqlite3_value_pointer() interface. (user: drh, tags: trunk)
17:46
[8a606e4a] Closed-Leaf: Interchange to branches within an "if" statement in sqlite3_value_pointer() in order to work around a bug in gcc. (user: drh, tags: branch-3.20)
13:37
[9e8e1c4a] Merge the pointer-type enhancement from the 3.20 branch. (user: drh, tags: trunk)
12:41
[e4579e50] Comment changes clarifying details of the pointer-type parameter. No changes to code. (user: drh, tags: branch-3.20)
2017-07-15
20:48
[62a86aa6] Add the "unionvtab" virtual table extension in ext/misc/unionvtab.c. (user: dan, tags: union-vtab)
20:44
[b64d64c8] Merge the fix for ticket [a4e06e75a9ab61a12] from trunk. (user: drh, tags: branch-3.20)
20:33
[253945d4] Fix a register allocation problem in PRAGMA integrity_check that caused the same register to be used for two different purposes on the first ATTACHed database if the schema for the ATTACHed database was noticable more complex than the schema for the first database. Fix for ticket [a4e06e75a9ab61a1]. (user: drh, tags: trunk)
20:25
[687bd478] Fix a missing \n at the end of a comment causing a line to be too long. No code changes. (user: drh, tags: trunk)
17:57
[5ec37c62] Enhance the showstat4 utility program to show the full precision of floating point values in sqlite_stat4 tables. (user: drh, tags: trunk)
13:35
[035a86ec] First release candidate for version 3.20.0. (user: drh, tags: branch-3.20)
08:02
[0953e746] Fix another minor problem in test file like.test. (user: dan, tags: trunk)
06:35
[b61cc5a0] Fix test problems causing the "prepare" permutation test to fail. (user: dan, tags: trunk)
2017-07-14
20:53
[ad6699d4] Fix test problems with stmtvtab1.test under some permutations. (user: dan, tags: trunk)
19:52
[65f9f29c] Fix a typo in a comment used to generate documentation. No code changes. (user: drh, tags: trunk)
19:47
[ab165dcf] Identify requirements text in the SQLITE_DBCONFIG_ENABLE_QPSG documentation. Add some implementation marks for SQLITE_DBCONFIG_MAINDBNAME requirements. No code changes. (user: drh, tags: trunk)
19:22
[26423867] Add requirements marks for some of the new features in the 3.20 release. (user: drh, tags: trunk)
19:12
[394c6f4f] Tweak Makefile.in so that testfixture can be built with the --disable-amalgamation configure switch. (user: dan, tags: trunk)
17:50
[1eb56fe0] Modify mkopcodeh.tcl so that it can handle "same as" opcodes with values larger than the total number of opcodes. (user: dan, tags: trunk)
15:57
[6ed4ef03] In the LSM1 virtual table, dequote the filename before opening the file. (user: drh, tags: trunk)
15:45
[7dc5e70e] Changes to the LSM1 Tcl tests to make things work on Win32. (user: mistachkin, tags: trunk)
15:42
[b5e3b264] Include a hint in the header comment of the LSM1 makefile about how to set the LSMOPTS variable. (user: drh, tags: trunk)
15:32
[fe319bcd] Update the Makefile for LSM1 so that the LSMOPTS can be set prior to including the Makefile, in order to add platform arguments such as -fPIC. (user: drh, tags: trunk)
15:18
[604b9664] Fix a typo in the header comment to the remember extension. No code changes. (user: drh, tags: trunk)
15:14
[1bc4e934] Change the name of the STMT virtual table to SQLITE_STMT. Also remove the first column of that virtual table, which was a pointer leak. (user: drh, tags: trunk)
13:24
[8f6dd5e2] Minor updates to requirements marks and documention. No changes to code. (user: drh, tags: trunk)
11:40
[5e0a9793] Add very simple tcl tests for the lsm1 extension. (user: dan, tags: trunk)
04:16
[d8cd0434] Minor tweaks to documentation. No code changes. (user: drh, tags: trunk)
00:28
[271ca4ac] Fix harmless compiler warnings in the readline tab-completion logic of the command-line shell. (user: drh, tags: trunk)
2017-07-13
22:39
[889968bd] Improved documentation for the new sqlite3_bind_pointer() interface and its cousins. (user: drh, tags: trunk)
22:03
[26577814] Improvements to the documentation for SQLITE_PREPARE_PERSISTENT. No code changes. (user: drh, tags: trunk)
20:11
[9319f7b7] Fix documentation typo. No changes to code. (user: drh, tags: trunk)
19:11
[55f53965] Update header comments on the carray() and remember() extensions to bring out the fact that the pointer arguments must be bound using sqlite3_bind_pointer(). (user: drh, tags: trunk)
18:09
[72de49f2] Add new interfaces sqlite3_bind_pointer(), sqlite3_result_pointer(), and sqlite3_value_pointer() used to safely move pointer values through SQL without exposing underlying memory address information. (user: drh, tags: trunk)
17:56
[0bd7875b] Closed-Leaf: Fix an incorrect type signature for the loadable extension pointer for sqlite3_result_pointer(). (user: drh, tags: bind-pointer)
17:34
[a54be6e0] Merge the latest changes from trunk. (user: drh, tags: bind-pointer)
2017-07-12
20:43
[0c805935] Smaller and faster implementation for vdbeFreeOpArray() and freeP4(). (user: drh, tags: trunk)
18:05
[604c11d1] Fix harmless compiler warnings about incomplete structure initializers. (user: drh, tags: trunk)
17:26
[f951c8b7] Remove unnecessary EP_Leaf settings on the Expr object. (user: drh, tags: trunk)
17:08
[54f55d3b] The EP_Resolved flag on the Expr object is not required for correctness nor performance, so remove it. (user: drh, tags: trunk)
14:10
[68824a43] Clarification and simplification and result column naming logic. (user: drh, tags: trunk)
14:03
[3e56a79a] Fix a problem in an lsmtest test case caused by writing data in "text" mode instead of "binary". (user: dan, tags: trunk)
12:19
[783100b8] Compile cleanly with SQLITE_OMIT_UTF16. (user: drh, tags: trunk)
2017-07-11
20:36
[39069941] In lsm, attempt to unmap the database file before truncating it when disconnecting. A mapped file may not be truncated on win32. (user: dan, tags: trunk)
19:55
[b0a49d90] Simplify the way in which the database file is truncated when the last connection disconnects. Also ignore the error code from the xTruncate call - as truncating a database file is always optional. (user: dan, tags: trunk)
18:11
[55e93f25] Fix harmless compiler warnings in the core. (user: drh, tags: trunk)
17:54
[2fe3a843] Make win32GetTimeOfDay() in the lsm1 test code more portable. (user: mistachkin, tags: trunk)
17:28
[b9debd62] Enabled the new sqlite3_prepare_v3() and sqlite3_prepare16_v3() interfaces for loadable extensions. (user: drh, tags: trunk)
17:06
[a8e651e0] Fix a whitespace alignment issue in lsm1. (user: mistachkin, tags: trunk)
16:46
[0f1307f1] Fix more harmless compiler warnings in lsm1, seen with MSVC 2015. (user: mistachkin, tags: trunk)
16:36
[cf6da4a5] Fix harmless compiler warnings seen with MSVC for lsm1. (user: mistachkin, tags: trunk)
13:59
[95cd1d9f] Add support for tab-completion (using the ext/misc/completion.c virtual table) to the command-line shell. (user: drh, tags: trunk)
13:34
[17e0bb12] Change the src/shell.c file so that it is generated from a new script at tool/mkshellc.tcl and the template file src/shell.c.in, and automatically includes the extensions it needs out of ext/misc. (user: drh, tags: trunk)
02:53
[724819b4] Fix a backup2 test case so that it works on FreeBSD. (user: drh, tags: trunk)
02:05
[0e213555] Add the "phase" output column on the COMPLETION table-valued function, for debugging. Improved comments on the implementation. (user: drh, tags: trunk)
01:38
[1cc97711] The COMPLETION virtual table now looks at the names of databases, tables, and columns in addition to SQL keywords. (user: drh, tags: trunk)
00:09
[caefbc72] Incomplete implementation of the COMPLETION table-valued function. So far it only works for SQL keywords. (user: drh, tags: trunk)
2017-07-10
21:32
[bd8a1fb9] Fix harmless compiler warnings in lsmtest. (user: mistachkin, tags: trunk)
20:39
[9a8f045d] Fix errors in comments in the STMT virtual table. No code changes. (user: drh, tags: trunk)
20:33
[bf7eda67] Minor cleanup and refactoring of the Win32 VFS for lsm1. (user: mistachkin, tags: trunk)
19:54
[05129374] Another spelling error in the README.md file. (user: drh, tags: trunk)
19:08
[12bc47c5] Spelling error in README.md (user: drh, tags: trunk)
19:07
[75c9327b] Yet another typo in README.md (user: drh, tags: trunk)
19:05
[20b1f0ef] Fix another README.md typo. (user: drh, tags: trunk)
19:03
[4f6ce7a3] Fix an obsolete statement about Lemon in the README.md file. (user: drh, tags: trunk)
18:57
[f3a6a64e] Cleanup header usage in lsmtest for files that require _O_BINARY. (user: mistachkin, tags: trunk)
18:52
[7bfd3ab7] Updates to the repository README.md file. (user: drh, tags: trunk)
18:33
[a82a9bea] In LSM, avoid calling the VFS xTestLock method to test for a lock that conflicts with one held by the same process. The results of such a call are considered undefined (since they are different under win32 and posix). (user: dan, tags: trunk)
18:04
[bde431b1] Add the "--newlines" option to the ".dump" command in the shell to disable the newline escaping mechanism. (user: drh, tags: trunk)
17:00
[c4cb9048] When multiple constraints need to be evaluated for a row, do any constraints that involve correlated subqueries last. Hence, the priority is index-covered constraints first, correlated subquery constraints last, and all others in the middle. This is a follow-on and improvement to the push-down optimization of check-in [d7bb79ed]. (user: drh, tags: trunk)
16:38
[0ca7474f] Closed-Leaf: Additional debugging Noop-comment in the constraint generator when wheretrace is enabled. (user: drh, tags: defer-where-subqueries)
14:33
[1f9c1f35] When testing non-indexed WHERE constraints, test those that involve correlated sub-queries last of all. This increases the chances of not having to run the sub-query at all. (user: dan, tags: defer-where-subqueries)
13:24
[dc857a96] For sqlite3TreeView() debugging output, show the Expr.flags field on scalar subqueries. (user: drh, tags: trunk)
12:07
[f27b6370] Update error message text for standard error codes to better describe the latest usage of those error codes. Modify sqlite3_open_v2() so that it does return a valid sqlite3 object in the event of SQLITE_MISUSE due to bad open flags, so that sqlite3_errmsg() does not report "out of memory" in that case. (user: drh, tags: trunk)
11:17
[871752f2] Remove the error message text from disused error codes such as SQLITE_EMPTY and SQLITE_FORMAT. (user: drh, tags: trunk)
2017-07-09
18:55
[70096c50] Always make "column%d" column-names 1-based, never 0-based. (user: drh, tags: trunk)