Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 check-ins occurring around 907fd3aab6205ac0.
|
2017-07-10
| ||
| 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 | |
| 01:01 | Fix the covering index OR optimization (check-in [fcbd6abd]) so that it works with SQLITE_MAX_ATTACHED>30. Broken by a bad cherry-pick merge. check-in: d227de8a user: drh tags: branch-3.8.9 | |
|
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 | |
| 22:39 | Fix test cases in wal2.test due to the fact that Darwin checks to see if the SHM file is writable before attempting to open in read/write. check-in: 6b618b18 user: drh tags: apple-osx | |
| 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:33 | Avoid even trying to open a SHM file read/write in WAL mode if we know that the file is read-only. This avoids scare security log messages. check-in: d9d92781 user: drh tags: apple-osx | |
| 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 | |
| 17:33 | Add the "Pragma_list" pragma. Put all three pragmas created on this branch inside of #ifdef SQLITE_INTROSPECTION_PRAGMAS. Closed-Leaf check-in: 2f3c3781 user: drh tags: list-pragmas | |
| 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:12 | Have this branch maintain an in-memory hash-table of old pages for read-only MVCC clients. There is no way to access it yet. check-in: a3a9a2e1 user: dan tags: server-process-edition | |
| 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:07 | Remove a block from the Win32 VFS for lsm1 that is now superfluous. check-in: db4a4140 user: mistachkin 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 | |
| 15:43 | Add new pragmas: "function_list" and "module_list" check-in: e5f01d7f user: drh tags: list-pragmas | |
| 14:54 | Fix an obsolete comment on the sqlite3_namelist() function implementation. Closed-Leaf check-in: f4229857 user: drh tags: experimental-namelist | |
| 14:26 | Merge recent enhancements from trunk. check-in: 73d0fc02 user: drh tags: bind-pointer | |
| 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 | |
| 22:40 | Always load the schema before starting tab-completion. check-in: 907fd3aa user: drh tags: experimental-namelist | |
| 20:08 | Tab-completion now also works using readline/editline. check-in: c906739f user: drh tags: experimental-namelist | |
| 19:26 | Use the sqlite3_namelist() interface to implement simple tab-completion using linenoise. check-in: 5cc7b0e2 user: drh tags: experimental-namelist | |
| 18:52 | Change the sqlite3_namelist() interface to return a pointer to an array of pointers to strings, and to avoid duplicates. check-in: 70291110 user: drh tags: experimental-namelist | |
| 18:25 | The sqlite3_namelist() routine now works for all name types. check-in: e41d6217 user: drh tags: experimental-namelist | |
| 17:36 | Initial implementation of a highly experimental interface for listing all keywords and symbolic names for an SQLite database connection. check-in: 04ef6783 user: drh tags: experimental-namelist | |
| 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 | |
| 16:20 | Make use of covering indexes in the OR optimization. check-in: fcbd6abd user: drh tags: branch-3.8.9 | |
| 14:54 | Add the count-of-view optimization when compiled using SQLITE_COUNTOFVIEW_OPTIMIZATION. check-in: b7ae4b87 user: drh tags: branch-3.8.9 | |
| 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
| ||
| 23:46 | Update the carray() and remember() extension functions so that they user the new sqlite3_value_pointer() interface. check-in: a99fa94d user: drh tags: bind-pointer | |
| 23:09 | Add APIs for binding pointers that can be used by app-defined functions. check-in: d9f4a831 user: drh tags: bind-pointer | |
| 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 | |