/ Timeline
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

100 check-ins occurring around 1cc97711fa86a393.

2017-07-15
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
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