Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 descendants and 100 ancestors of [281ad505]
|
2017-07-15
| ||
| 20:25 | Fix a missing \n at the end of a comment causing a line to be too long. No code changes. (check-in: 687bd478 user: drh tags: trunk) | |
| 17:57 | Enhance the showstat4 utility program to show the full precision of floating point values in sqlite_stat4 tables. (check-in: 5ec37c62 user: drh tags: trunk) | |
| 13:49 | Minor change to one of the command-line shell test scripts to make that script compatible with Tcl 8.5. (check-in: 47cf83a0 user: drh tags: branch-3.20) | |
| 13:35 | First release candidate for version 3.20.0. (check-in: 035a86ec user: drh tags: branch-3.20) | |
| 08:02 | Fix another minor problem in test file like.test. (check-in: 0953e746 user: dan tags: trunk) | |
| 06:35 | Fix test problems causing the "prepare" permutation test to fail. (check-in: b61cc5a0 user: dan tags: trunk) | |
|
2017-07-14
| ||
| 20:53 | Fix test problems with stmtvtab1.test under some permutations. (check-in: ad6699d4 user: dan tags: trunk) | |
| 19:52 | Fix a typo in a comment used to generate documentation. No code changes. (check-in: 65f9f29c user: drh tags: trunk) | |
| 19:47 | Identify requirements text in the SQLITE_DBCONFIG_ENABLE_QPSG documentation. Add some implementation marks for SQLITE_DBCONFIG_MAINDBNAME requirements. No code changes. (check-in: ab165dcf user: drh tags: trunk) | |
| 19:22 | Add requirements marks for some of the new features in the 3.20 release. (check-in: 26423867 user: drh tags: trunk) | |
| 19:12 | Tweak Makefile.in so that testfixture can be built with the --disable-amalgamation configure switch. (check-in: 394c6f4f user: dan tags: trunk) | |
| 17:50 | Modify mkopcodeh.tcl so that it can handle "same as" opcodes with values larger than the total number of opcodes. (check-in: 1eb56fe0 user: dan tags: trunk) | |
| 15:57 | In the LSM1 virtual table, dequote the filename before opening the file. (check-in: 6ed4ef03 user: drh tags: trunk) | |
| 15:45 | Changes to the LSM1 Tcl tests to make things work on Win32. (check-in: 7dc5e70e user: mistachkin tags: trunk) | |
| 15:42 | Include a hint in the header comment of the LSM1 makefile about how to set the LSMOPTS variable. (check-in: b5e3b264 user: drh tags: trunk) | |
| 15:32 | 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. (check-in: fe319bcd user: drh tags: trunk) | |
| 15:18 | Fix a typo in the header comment to the remember extension. No code changes. (check-in: 604b9664 user: drh tags: trunk) | |
| 15:14 | 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. (check-in: 1bc4e934 user: drh tags: trunk) | |
| 13:24 | Minor updates to requirements marks and documention. No changes to code. (check-in: 8f6dd5e2 user: drh tags: trunk) | |
| 11:40 | Add very simple tcl tests for the lsm1 extension. (check-in: 5e0a9793 user: dan tags: trunk) | |
| 08:15 | Add simple tests for "PRAGMA freelist_format". (check-in: 98a36f4c user: dan tags: server-process-edition) | |
| 04:16 | Minor tweaks to documentation. No code changes. (check-in: d8cd0434 user: drh tags: trunk) | |
| 00:28 | Fix harmless compiler warnings in the readline tab-completion logic of the command-line shell. (check-in: 271ca4ac user: drh tags: trunk) | |
|
2017-07-13
| ||
| 22:39 | Improved documentation for the new sqlite3_bind_pointer() interface and its cousins. (check-in: 889968bd user: drh tags: trunk) | |
| 22:03 | Improvements to the documentation for SQLITE_PREPARE_PERSISTENT. No code changes. (check-in: 26577814 user: drh tags: trunk) | |
| 21:06 | Make the freelist format a separate feature from the page-level locking. Freelist format is now configure using "PRAGMA freelist_format". (check-in: dcc40797 user: dan tags: server-process-edition) | |
| 20:11 | Fix documentation typo. No changes to code. (check-in: 9319f7b7 user: drh tags: trunk) | |
| 19:11 | 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(). (check-in: 55f53965 user: drh tags: trunk) | |
| 18:09 | 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. (check-in: 72de49f2 user: drh tags: trunk) | |
| 17:56 | Fix an incorrect type signature for the loadable extension pointer for sqlite3_result_pointer(). (Closed-Leaf check-in: 0bd7875b user: drh tags: bind-pointer) | |
| 17:54 | Add the three new pointer interfaces to the loadable extension mechanism. Update sqlite3_value_subtype() documentation to remove the statement about it not being used internally. (check-in: e5a51803 user: drh tags: bind-pointer) | |
| 17:48 | Update the FTS3 extension to use sqlite3_result_pointer() and sqlite3_value_pointer() for passing FTS3 cursor objects from the table into functions such as snippet(). (check-in: 0fa2e170 user: drh tags: bind-pointer) | |
| 17:34 | Merge the latest changes from trunk. (check-in: a54be6e0 user: drh tags: bind-pointer) | |
|
2017-07-12
| ||
| 20:43 | Smaller and faster implementation for vdbeFreeOpArray() and freeP4(). (check-in: 0c805935 user: drh tags: trunk) | |
| 18:05 | Fix harmless compiler warnings about incomplete structure initializers. (check-in: 604c11d1 user: drh tags: trunk) | |
| 17:26 | Remove unnecessary EP_Leaf settings on the Expr object. (check-in: f951c8b7 user: drh tags: trunk) | |
| 17:08 | The EP_Resolved flag on the Expr object is not required for correctness nor performance, so remove it. (check-in: 54f55d3b user: drh tags: trunk) | |
| 14:10 | Clarification and simplification and result column naming logic. (check-in: 68824a43 user: drh tags: trunk) | |
| 14:03 | Fix a problem in an lsmtest test case caused by writing data in "text" mode instead of "binary". (check-in: 3e56a79a user: dan tags: trunk) | |
| 12:19 | Compile cleanly with SQLITE_OMIT_UTF16. (check-in: 783100b8 user: drh tags: trunk) | |
|
2017-07-11
| ||
| 20:36 | In lsm, attempt to unmap the database file before truncating it when disconnecting. A mapped file may not be truncated on win32. (check-in: 39069941 user: dan tags: trunk) | |
| 19:55 | 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. (check-in: b0a49d90 user: dan tags: trunk) | |
| 18:38 | Add SQL function usleep() to test program tserver.c. (check-in: 8cbe8f2b user: dan tags: server-process-edition) | |
| 18:11 | Fix harmless compiler warnings in the core. (check-in: 55e93f25 user: drh tags: trunk) | |
| 17:54 | Make win32GetTimeOfDay() in the lsm1 test code more portable. (check-in: 2fe3a843 user: mistachkin tags: trunk) | |
| 17:28 | Enabled the new sqlite3_prepare_v3() and sqlite3_prepare16_v3() interfaces for loadable extensions. (check-in: b9debd62 user: drh tags: trunk) | |
| 17:06 | Fix a whitespace alignment issue in lsm1. (check-in: a8e651e0 user: mistachkin tags: trunk) | |
| 16:47 | Fix a bug causing readonly mvcc connections to read the wrong cache entry in some cases. (check-in: b6157267 user: dan tags: server-process-edition) | |
| 16:46 | Fix more harmless compiler warnings in lsm1, seen with MSVC 2015. (check-in: 0f1307f1 user: mistachkin tags: trunk) | |
| 16:36 | Fix harmless compiler warnings seen with MSVC for lsm1. (check-in: cf6da4a5 user: mistachkin tags: trunk) | |
| 13:59 | Add support for tab-completion (using the ext/misc/completion.c virtual table) to the command-line shell. (check-in: 95cd1d9f user: drh tags: trunk) | |
| 13:34 | 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. (check-in: 17e0bb12 user: drh tags: trunk) | |
| 02:53 | Fix a backup2 test case so that it works on FreeBSD. (check-in: 724819b4 user: drh tags: trunk) | |
| 02:05 | Add the "phase" output column on the COMPLETION table-valued function, for debugging. Improved comments on the implementation. (check-in: 0e213555 user: drh tags: trunk) | |
| 01:38 | The COMPLETION virtual table now looks at the names of databases, tables, and columns in addition to SQL keywords. (check-in: 1cc97711 user: drh tags: trunk) | |
| 00:09 | Incomplete implementation of the COMPLETION table-valued function. So far it only works for SQL keywords. (check-in: caefbc72 user: drh tags: trunk) | |
|
2017-07-10
| ||
| 21:32 | Fix harmless compiler warnings in lsmtest. (check-in: bd8a1fb9 user: mistachkin tags: trunk) | |
| 20:39 | Fix errors in comments in the STMT virtual table. No code changes. (check-in: 9a8f045d user: drh tags: trunk) | |
| 20:33 | Minor cleanup and refactoring of the Win32 VFS for lsm1. (check-in: bf7eda67 user: mistachkin tags: trunk) | |
| 19:54 | Another spelling error in the README.md file. (check-in: 05129374 user: drh tags: trunk) | |
| 19:08 | Spelling error in README.md (check-in: 12bc47c5 user: drh tags: trunk) | |
| 19:07 | Yet another typo in README.md (check-in: 75c9327b user: drh tags: trunk) | |
| 19:05 | Fix another README.md typo. (check-in: 20b1f0ef user: drh tags: trunk) | |
| 19:03 | Fix an obsolete statement about Lemon in the README.md file. (check-in: 4f6ce7a3 user: drh tags: trunk) | |
| 18:57 | Cleanup header usage in lsmtest for files that require _O_BINARY. (check-in: f3a6a64e user: mistachkin tags: trunk) | |
| 18:52 | Updates to the repository README.md file. (check-in: 7bfd3ab7 user: drh tags: trunk) | |
| 18:33 | 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). (check-in: a82a9bea user: dan tags: trunk) | |
| 18:04 | Add the "--newlines" option to the ".dump" command in the shell to disable the newline escaping mechanism. (check-in: bde431b1 user: drh tags: trunk) | |
| 17:00 | 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]. (check-in: c4cb9048 user: drh tags: trunk) | |
| 16:38 | Additional debugging Noop-comment in the constraint generator when wheretrace is enabled. (Closed-Leaf check-in: 0ca7474f user: drh tags: defer-where-subqueries) | |
| 15:26 | Small performance optimization in sqlite3WhereExprUsage(). (check-in: 38edc677 user: drh tags: defer-where-subqueries) | |
| 15:17 | Fix another problem on this branch. (check-in: a4fc9811 user: dan tags: defer-where-subqueries) | |
| 14:39 | Fix a problem causing non-covered WHERE terms to be evaluated before covered WHERE terms. (check-in: 7d3cb39f user: dan tags: defer-where-subqueries) | |
| 14:33 | 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. (check-in: 1f9c1f35 user: dan tags: defer-where-subqueries) | |
| 13:24 | For sqlite3TreeView() debugging output, show the Expr.flags field on scalar subqueries. (check-in: dc857a96 user: drh tags: trunk) | |
| 12:07 | 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. (check-in: f27b6370 user: drh tags: trunk) | |
| 11:17 | Remove the error message text from disused error codes such as SQLITE_EMPTY and SQLITE_FORMAT. (check-in: 871752f2 user: drh tags: trunk) | |
|
2017-07-09
| ||
| 18:55 | Always make "column%d" column-names 1-based, never 0-based. (check-in: 70096c50 user: drh tags: trunk) | |
| 00:30 | Make sure the columns of a VALUES() clause are named "column%d" even if the VALUES() clause is a subquery in the FROM clause of an outer query. (check-in: acf3b9cc user: drh tags: trunk) | |
|
2017-07-08
| ||
| 22:30 | Add the --icc, --gcc7, and --orm options to the speed-check.sh test script. (check-in: 70dae08a user: drh tags: trunk) | |
| 20:46 | Support read-only MVCC transactions in server-mode. Started using "BEGIN READONLY". (check-in: 5a043aa8 user: dan tags: server-process-edition) | |
| 18:27 | Disable compiler intrinsics when using the Intel C Compiler. (Leaf check-in: dbb59f61 user: drh tags: icc-fix) | |
|
2017-07-07
| ||
| 22:58 | Merge in all the latest trunk enhancements. (check-in: 7f48f6ab user: drh tags: apple-osx) | |
| 22:47 | Basic test cases for PRAGMA secure_delete=FAST. (check-in: 0c246017 user: drh tags: trunk) | |
| 21:20 | Fix comment in the Win32 VFS for lsm1. (check-in: 12a421bc user: mistachkin tags: trunk) | |
| 21:15 | For lsmtest, use a more portable means of setting open() files to binary. (check-in: aea6e0ff user: mistachkin tags: trunk) | |
| 20:35 | Adjust copy_file() lsmtest function so it works properly for locked database files on Win32. (check-in: 54a38555 user: mistachkin tags: trunk) | |
| 20:06 | Add the "PRAGMA secure_delete=FAST" option, which overwrites most deleted content without increasing the amount of I/O. Deleted content might persist on the free page list, however. And extra CPU cycles are used for zeroing, of course. (check-in: 38978ce6 user: drh tags: trunk) | |
| 19:43 | Change the error message text for SQLITE_ERROR to omit the part about "missing database" as that meaning is now obsolete (since approx SQLite 2.0). (check-in: 732f90d6 user: drh tags: trunk) | |
| 19:22 | Fix typos in Win32 VFS for lsm1. (check-in: 0961ec87 user: mistachkin tags: trunk) | |
| 19:12 | Fix the memcpy calls in the lsmWin32OsShmMap function for lsm1. (check-in: aa4890b9 user: mistachkin tags: trunk) | |
| 19:02 | Enhance the MSVC makefile 'clean' target to handle lsm1. (check-in: 2d6faebc user: mistachkin tags: trunk) | |
| 18:31 | Add support for LSM_DEBUG to the MSVC makefile for lsm1. (check-in: 277a7fed user: mistachkin tags: trunk) | |
| 18:06 | In the command-line shell, when running ".schema" give a sensible error when the database file is locked. (check-in: cc329eb8 user: drh tags: trunk) | |
| 17:57 | Fix the usleep() macro in the Win32 test code for lsm1. (check-in: 63599fa5 user: mistachkin tags: trunk) | |
| 17:43 | Add new PRAGMAs: "function_list", "module_list", and "pragma_list". All are enclosed within #ifdef SQLITE_INTROSPECTION_PRAGMAS. The compile-time option is not on ctime.c yet, since these are still experimental and one can always test "PRAGMA pragma_list" and see whether or not it returns an empty set. (check-in: e0b6ae92 user: drh tags: trunk) | |
| 16:46 | Improve clarity in the Win32 VFS for lsm1. (check-in: 9c7a9e80 user: mistachkin tags: trunk) | |
| 16:40 | Merge latest trunk changes with this branch. (check-in: 216c757f user: dan tags: server-process-edition) | |
| 16:29 | Add support for LSM_DEBUG_MEM to the MSVC makefile for lsm1. (check-in: 3340de83 user: mistachkin tags: trunk) | |
| 16:27 | Remove a block from the Win32 VFS for lsm1 that is now superfluous. (check-in: 5f726f28 user: dan tags: trunk) | |
| 16:09 | In lsmtest, use an empty string instead of ":memory:" when requesting a temporary database from SQLite. This prevents other test code from trying to unlink() ":memory:", which fails on win32. (check-in: 281ad505 user: dan tags: trunk) | |
| 16:06 | Memory reallocation fix for the Win32 VFS for lsm1. (check-in: 5a3140e4 user: mistachkin tags: trunk) | |
| 16:00 | Enhance the sqlite3VdbeMultiLoad() interface to automatically generate the OP_ResultRow opcode on PRAGMA implementations, for a small reduction in the library footprint. (check-in: c46f0f07 user: drh tags: trunk) | |
| 13:59 | Exploit the fact that Expr.pRight and Expr.x are never used at the same time for a small performance gain. (check-in: aacbb9a4 user: drh tags: trunk) | |
| 12:58 | More efficient and compact implementation of walkExpr(). (check-in: 115d4b83 user: drh tags: trunk) | |
| 12:43 | More aggressive use of EP_Leaf on expression nodes, to help prune searches. (check-in: c1a1d68c user: drh tags: trunk) | |
| 11:49 | Very slightly smaller and faster sqlite3WalkSelect(). (check-in: 9bc65635 user: drh tags: trunk) | |
|
2017-07-06
| ||
| 22:43 | Small adjustment to main.mk that facilitates giving non-standard compile-time options to the shell. (check-in: 7c7d53a9 user: drh tags: trunk) | |
| 16:33 | Change the (machine-generated) keywordhash.h file to increase the scope of the tables used for keyword matching, so that the tables are accessible to functions other then keywordCode(). (check-in: c5ed5ebd user: drh tags: trunk) | |
| 13:51 | More compact implementation of the typeof() SQL function. (check-in: efb4aab0 user: drh tags: trunk) | |
| 13:23 | Avoid unnecessary upper-to-lower case conversion for function names when registering the built-in functions. (check-in: 06269257 user: drh tags: trunk) | |
| 03:06 | Small size reduction in findCollSeqEntry(). (check-in: 55ecd303 user: drh tags: trunk) | |
| 02:49 | Avoid unnecessary calls to sqlite3GetCollSeq() for a small performance gain. (check-in: 503ba172 user: drh tags: trunk) | |
| 01:28 | Slightly more compact implementation of the byte-code generator for the COMMIT and ROLLBACK commands. (check-in: 4da663d9 user: drh tags: trunk) | |
| 01:02 | Small performance increase in sqlite3SrcListAppend(). (check-in: 7b2623f1 user: drh tags: trunk) | |
|
2017-07-05
| ||
| 23:33 | Make the hash table implementation a little smaller and faster. (check-in: f762f1ef user: drh tags: trunk) | |
| 18:48 | Have fts3 virtual table cursors free internal resources when they reach EOF, instead of waiting until the xClose method is called. (check-in: b6b14ab6 user: dan tags: trunk) | |
| 14:29 | Fix a problem in lsmtest causing one test to fail for multi-threaded LSM connections. (check-in: 2bce64c8 user: dan tags: trunk) | |
|
2017-07-04
| ||
| 19:34 | Add the count-of-view optimization when compiled using SQLITE_COUNTOFVIEW_OPTIMIZATION. (check-in: d1ba2002 user: drh tags: trunk) | |
| 19:23 | Fix further OOM handling cases in LSM. (check-in: ca757c86 user: dan tags: trunk) | |
| 17:25 | Fix a couple of problems in handling OOM conditions within LSM. (check-in: 989a5c17 user: dan tags: trunk) | |
| 12:50 | Fix a problem in the lempar.c Lemon template for YYSTACKDEPTH<=0 introduced by check-in [36e54cd8b1fb37] (check-in: 268a40f4 user: drh tags: trunk) | |
|
2017-07-03
| ||
| 21:09 | Fix compiler warnings in LSM1, especially in the test logic. (check-in: 9bd3be92 user: drh tags: trunk) | |
| 20:19 | Fix a bug in lsm queries on levels undergoing incremental an merge that contain range-delete markers. (check-in: b2c24879 user: dan tags: trunk) | |
| 17:37 | Attempt to improve documentation on sqlite3_column_ and sqlite3_value_ interfaces. (check-in: 9111ac69 user: drh tags: trunk) | |
| 09:00 | Add more tests for LSM log file recovery. Fix a problem in recovering log files that contain range deletes. (check-in: e34eafd4 user: dan tags: trunk) | |
|
2017-07-01
| ||
| 20:59 | Fix a memory management problem in lsm log recovery code. (check-in: dd55af30 user: dan tags: trunk) | |
| 15:21 | Enhance the RTree module to detect node truncation early and report an error. (check-in: 66de6f4a user: drh tags: trunk) | |
|
2017-06-30
| ||
| 20:11 | Improved documentation for sqlite3_value_type(). (check-in: 0db20efe user: drh tags: trunk) | |
| 19:22 | Add some assert() statements in the Win32 interface for lsm1. (check-in: d076d58f user: mistachkin tags: trunk) | |
| 18:12 | Fix some minor typos in lsm1. (check-in: 0ef777d7 user: mistachkin tags: trunk) | |
| 11:44 | Avoid constantly freeing and reallocing small internal buffers associated with LSM cursors. Instead, allow them to persist for the lifetime of the cursor if they are LSM_SEGMENTPTR_FREE_THRESHOLD (default 1024) bytes or smaller. This change is based on research by Martijn Blaauw. (check-in: bacfe8cb user: dan tags: trunk) | |
|
2017-06-29
| ||
| 21:33 | In the command-line shell, add the -quote option to start up in quote mode. Enhance the ".mode" command so that it reports the current output mode if given no arguments. (check-in: 5e3f9ea5 user: drh tags: trunk) | |
| 21:11 | Remove the ".explain" command from the ".help" output of the command-line shell, though keep the implementation around for backwards compatibility. (check-in: 7782c04e user: drh tags: trunk) | |
| 20:31 | Some simple tests for the STMT virtual table. (check-in: a26e17ee user: drh tags: trunk) | |
| 20:23 | Avoid reading or writing the 32 locking bytes at the end of the first meta-page of an LSM database. (check-in: 3ed6877f user: dan tags: trunk) | |
| 20:13 | Avoid reading or writing the 32 locking bytes at the end of the first meta-page of an LSM database. (Closed-Leaf check-in: 2b5df3e8 user: dan tags: lsm-metapage-fix) | |
| 19:08 | Fix issues in the POSIX and Win32 interfaces for lsm1. (check-in: 38ec4141 user: mistachkin tags: trunk) | |
| 17:27 | Edit comments in sqlite.h.in used for generating documentation, to improve the description of the new sqlite3_prepare_v3() interfaces, and other miscellaneous cleanup. No changes to executable code. (check-in: 284707a7 user: drh tags: trunk) | |
| 16:51 | More updates to the Win32 interface for lsm1. (check-in: cae64769 user: mistachkin tags: trunk) | |
| 15:57 | Correct typo in the Win32 interface for lsm1. (check-in: 1b4facb1 user: mistachkin tags: trunk) | |
| 15:24 | Add interfaces sqlite3_prepare_v3() and sqlite3_prepare16_v3() with the extra prepFlags argument. Add the SQLITE_PREPARE_PERSISTENT option as one bit in that argument. Use the new option in FTS3, FTS5, and RTREE. (check-in: 03977248 user: drh tags: trunk) | |
| 15:13 | Further corrections to the Win32 interface for lsm1. (check-in: 4df6e247 user: mistachkin tags: trunk) | |
| 14:33 | Rename the "stmts" virtual table to just "stmt" without the final "s". (check-in: adfdb801 user: drh tags: trunk) | |
| 14:17 | A couple fixes for the Win32 interface for lsm1. (check-in: ebbd98e9 user: mistachkin tags: trunk) | |
| 13:41 | Add the stmts virtual table to testfixture builds. Add new compile-time options SQLITE_ENABLE_QPSG and SQLITE_ENABLE_STMTSVTAB to ctime.c (check-in: 60c62829 user: drh tags: trunk) | |
| 13:35 | Compilation fix for lsm1 using MSVC. (check-in: b7794cc5 user: mistachkin tags: trunk) | |
| 13:19 | Add the LSM1 extension. (check-in: 824e8327 user: drh tags: trunk) | |
| 13:13 | Add the "stmts" virtual table to the amalgamation, activated when compiled using -DSQLITE_ENABLE_STMTSVTAB. Add the SQLITE_STMTSTATUS_REPREPARE and SQLITE_STMTSTATUS_RUN statistics outputs from sqlite3_stmt_status() and add corresponding columns to the stmts virtual table. Change the numeric value of SQLITE_STMTSTATUS_MEMUSED to get it out of the way of counter values. (check-in: 88976ae3 user: drh tags: trunk) | |
| 12:59 | The query planner examines the values of bound parameters to help determine if a partial index is usable. Reprepares may happen if the bindings change. This behavior is disabled by the QPSG setting. (check-in: c322bfa2 user: drh tags: trunk) | |
| 12:54 | Implement xUnlink, xShmMap, and xShmUnmap for lsm1 on Win32. (Closed-Leaf check-in: 680cc064 user: mistachkin tags: lsm-vtab) | |
| 12:49 | Add the SQLITE_STMTSTATUS_REPREPARE and SQLITE_STMTSTATUS_RUN options to sqlite3_stmt_status(). Use this for two new columns in the stmts virtual table. (Closed-Leaf check-in: b0b0c8f8 user: drh tags: stmts-vtab) | |
| 01:23 | Fix the exprCompareVariable() routine so that it works for non-UTF8 text. (Closed-Leaf check-in: 25acd965 user: drh tags: partial-index-variables) | |
| 00:20 | Implement xRemap for lsm1 on Win32. Also, zero file handle when closing it. (check-in: 93c9aa7d user: mistachkin tags: lsm-vtab) | |
|
2017-06-28
| ||
| 21:47 | Alternative implementation of exprCompareVariable(). (check-in: b959c629 user: drh tags: partial-index-variables) | |
| 21:36 | Implement xLock and xTestLock for lsm1 on Win32. (check-in: 9112117d user: mistachkin tags: lsm-vtab) | |
| 18:25 | Make the query planners use of partial indexes based on bound variables responsive to the SQLITE_DBCONFIG_ENABLE_QPSG setting. (check-in: a934dd14 user: drh tags: partial-index-variables) | |
| 18:07 | Merge the in the latest enhancements from trunk. (check-in: 8f63c586 user: drh tags: partial-index-variables) | |
| 15:56 | Incorporate recent trunk changes. (Closed-Leaf check-in: 62b8269b user: drh tags: prepare_v3) | |
| 15:47 | Build the "stmts" virtual table into the amalgamation. It is active only when compiled using SQLITE_ENABLE_STMTSVTAB. That option is supplied to the command-line shell. (check-in: 0ff057d8 user: drh tags: stmts-vtab) | |
| 15:17 | Fix harmless compiler warnings in the CSV extension. (check-in: f02a5459 user: drh tags: trunk) | |
| 15:01 | Faster parser stack overflow detection. (check-in: 36e54cd8 user: drh tags: trunk) | |
| 14:26 | Minor tweak to the SQL grammar to make the parser tables a few bytes smaller. (check-in: cc4810b2 user: drh tags: trunk) | |
| 13:47 | In the lemon-generated parser, store the number of symbols on the RHS of each rule as a negative number and add it to the stack pointer, rather than storing the value as a positive and subtracting it. This makes the parser faster. (check-in: b362f0d8 user: drh tags: trunk) | |
| 11:56 | In the lemon-generated parser, automatically promote SHIFTREDUCE actions on nonterminal systems to pure REDUCE actions, for a performance enhancement. (check-in: c46d94a8 user: drh tags: trunk) | |
| 01:21 | Simplify error handling logic in sqlite3_exec() to save about 40 bytes. (check-in: 6480916c user: drh tags: trunk) | |
| 01:12 | Minor code simplification in the ALTER TABLE logic. (check-in: bfc4e7f3 user: drh tags: trunk) | |
| 00:55 | Avoid an unnecessary call to sqlite3XPrintf() in the code generator, for a performance improvement. (check-in: 29d6ceb3 user: drh tags: trunk) | |
|
2017-06-27
| ||
| 23:36 | Add SQLITE_DBCONFIG_ENABLE_QPSG that forces the query planner stability guarantee. This is the fix for ticket [b9f010107724c] (check-in: b82efd2a user: drh tags: trunk) | |
| 22:33 | Improve a local variable name. (check-in: d0f6973d user: mistachkin tags: lsm-vtab) | |
| 22:27 | Initial work on porting lsmtest to Win32. (check-in: 7e669d9b user: mistachkin tags: lsm-vtab) | |
| 18:15 | Implement xFullpath for lsm1 on Win32. (check-in: dbe9c8aa user: mistachkin tags: lsm-vtab) | |
| 16:39 | Fix a virtual table problem that can occur when the vtab is on the RHS of a LEFT JOIN and there is a MATCH constraint in the ON clause, or when the vtab is in a sub-query that is the RHS of a LEFT JOIN and there is a MATCH constraint in the WHERE clause of the sub-query. (check-in: 87b38166 user: dan tags: trunk) | |
| 06:28 | Minor corrections to the previous check-in. (check-in: e1cf8a78 user: mistachkin tags: lsm-vtab) | |
| 05:59 | Work in progress porting lsm1 to Win32. (check-in: 2017636e user: mistachkin tags: lsm-vtab) | |
|
2017-06-26
| ||
| 21:08 | Add the -withoutnulls option to the "db eval" method in the TCL interface. (check-in: 18f0616e user: drh tags: trunk) | |
| 18:42 | The ".import" command of the shell, and the csv virtual table extension both ignore a single UTF-8 BOM at the beginning of their input. (check-in: 7c15d762 user: drh tags: trunk) | |
| 14:46 | Make sure sqlite3VdbeSetVarmask() is never invoked when QPSG is enabled. (Closed-Leaf check-in: ebcfa73e user: drh tags: enable-QPSG) | |
| 13:57 | Add the SQLITE_DBCONFIG_ENABLE_QPSG option to activate the query planner stability guarantee. This involves refactoring the sqlite3.flags bitvector to carve out a free bit to use. (check-in: 7076e828 user: drh tags: enable-QPSG) | |
| 11:46 | Remove an invalid assert() from lsm test code. (check-in: ca8a7e99 user: dan tags: lsm-vtab) | |
| 08:24 | Fix another problem with multi-threaded mode in the LSM test code. (check-in: 461ced77 user: dan tags: lsm-vtab) | |
| 07:31 | Update a test case to reflect the fact that the lsm blocksize is configured in KiB. And defaults to 1024, not 2048. (check-in: d7015475 user: dan tags: lsm-vtab) | |
| 06:53 | Fix some compiler warnings in lsm_file.c. (check-in: 23f16382 user: dan tags: lsm-vtab) | |
|
2017-06-24
| ||
| 19:21 | Disable shell tests for the .schema command if virtual tables are not available. (check-in: c8186874 user: drh tags: trunk) | |
| 18:10 | Consider the values bound to SQL variables when determining whether or not a partial index may be used. (check-in: 7b59c353 user: dan tags: partial-index-variables) | |
| 16:35 | Make sure the config.h header is included by ctime.c, if that header exists. (check-in: c2ea6293 user: drh tags: trunk) | |
| 16:03 | Query planner tuning: When deciding between two plans with the same cost, bias the selection toward the one that does not use the sorter. (check-in: f0ec36d4 user: drh tags: trunk) | |
| 13:31 | Make sure enough memory is allocated for pathological quoting cases when computing a quoted table name in the command-line shell. (check-in: 0583b84a user: drh tags: trunk) | |
|
2017-06-23
| ||
| 15:47 | When generating individual loops for each ORed term of an OR scan, move any constant WHERE expressions outside of the loop, as is done for top-level loops. (check-in: 712267c9 user: dan tags: trunk) | |
|
2017-06-22
| ||
| 16:51 | When generating individual loops for each ORed term of an OR scan, move any constant WHERE expressions outside of the loop, as is done for top-level loops. (Closed-Leaf check-in: e4a022be user: dan tags: or-optimization) | |
|
2017-06-21
| ||
| 01:36 | Enable pragma virtual tables for the integrity_check, quick_check, and foreign_key_check pragmas. (check-in: 118f7bb3 user: drh tags: trunk) | |
|
2017-06-20
| ||
| 18:19 | Rename the azCompileOpt global constant to avoid a harmless compiler warning about a name conflict with a local variable. (check-in: 94e420ec user: drh tags: trunk) | |
| 17:43 | Ensure that the query planner knows that any column of a flattened LEFT JOIN can be NULL even if that column is labeled with "NOT NULL". Fix for ticket [892fc34f173e99d8]. (check-in: 48346268 user: dan tags: trunk) | |
|
2017-06-17
| ||
| 18:49 | Fix a missing comma in the previous check-in. (check-in: f3db02f4 user: drh tags: trunk) | |
| 17:55 | Rework the code in ctime.c a bit to report on more compile time options. And to only output configuration options passed in to SQLite, not the default values of #define symbols set automatically. Also generate the large array in ctime.c using new script tool/mkctime.tcl, instead of entering it manually. (check-in: 9a443397 user: dan tags: trunk) | |
| 17:29 | Ensure that the value of the THREADSAFE symbol is always included when reporting compile time options, even if it was not explicitly configured. (Closed-Leaf check-in: 95141c64 user: dan tags: ctime-refactor) | |
| 16:39 | Add extra test cases for sqlite3changeset_apply() and ALTER TABLE ADD COLUMN. (check-in: 603838fc user: dan tags: trunk) | |
|
2017-06-16
| ||
| 19:51 | Rework the code in ctime.c a bit to report on more compile time options. And to only output configuration options passed in to SQLite, not the default values of #define symbols set automatically. Also generate the large array in ctime.c using new script tool/mkctime.tcl, instead of entering it manually. (check-in: bc1951d6 user: dan tags: ctime-refactor) | |
| 18:31 | Minor refactoring change to clarify how ATTACH works. No functional changes. (check-in: 3944a32e user: drh tags: trunk) | |
| 13:43 | Prevent pagesize changes on VACUUM in encrypted databases even when running the VACUUM on an attached database. (check-in: 11693849 user: drh tags: trunk) | |
|
2017-06-15
| ||
| 16:56 | Move the "shell_add_schema()" SQL function used by the ".schema" command of the command-line shell to a different spot in the shell.c source file so that it is not in the middle of an unrelated module. (check-in: 254617a1 user: drh tags: trunk) | |