/ 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 ancestors of [e22ca3cd]

2016-08-04
12:33
Add the experimental SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION compile-time option. When enabled, the "unknown function" error is suppressed for EXPLAIN and a no-op function named "unknown()" is substituted. This facilitiates using the command-line shell to analyze queries from applications that contain many application-defined functions that are not normally available to the shell. check-in: e22ca3cd user: drh tags: apple-osx
09:13
Merge the ORDER BY LIMIT fix, and other enhancements, from trunk. check-in: bf5a9542 user: drh tags: apple-osx
09:09
Make sure the ORDER BY LIMIT optimization is not applied if the inner-most loop can only have a single iteration and is hence not really a loop. check-in: 13e3bd3d user: drh tags: trunk
2016-08-03
14:51
Fix a typo in a comment in btree.c. No changes to code. check-in: 722c1281 user: drh tags: trunk
13:40
Fix the --help output on fuzzcheck so that it fix in an 80-character window. check-in: b91444b5 user: drh tags: trunk
2016-08-02
20:42
Fix a unused variable that comes up with -DSQLITE_OMIT_DATETIME_FUNCS. check-in: e2f9919e user: drh tags: trunk
19:29
The 'replace.tcl' tool should use Unix line-endings. check-in: 50de9631 user: mistachkin tags: trunk
13:26
Updates to requirements marks. No changes to code. check-in: b23c10ac user: drh tags: trunk
11:29
Fix a problem introduced by [77948b5eceab92a7] causing duplicate calls to be made to the xSavepoint() method of virtual tables under some circumstances. check-in: e64a4173 user: dan tags: trunk
08:45
Fix harmless compiler warnings in sqlite3_status(). check-in: 7c38a79c user: drh tags: trunk
2016-08-01
21:17
Update the wordcount.c test program and add a new script "time-wordcount.sh" for additional performance testing. check-in: d8ef9f58 user: drh tags: trunk
17:06
Fix other harmless compiler warnings. check-in: 90d2c490 user: drh tags: trunk
16:57
Remove a duplicate typedef from loadext.c (remaining copy is in sqlite3ext.h). check-in: fd184e5a user: dan tags: trunk
16:50
Add an extra compiler switch to loadext.test to ensure that it picks up the correct version of sqlite3.h when building a test extension. check-in: e57fa6af user: dan tags: trunk
15:00
Update releasetest.tcl to automatically do one round of tests with USE_STDCALL=1 when running on Windows with MSVC. check-in: a6a112de user: drh tags: trunk
14:35
Avoid making unnecessary changes to the signatures of the sqlite3_auto_extension() and sqlite3_cancel_auto_extension() interfaces. check-in: b6ea2f21 user: drh tags: trunk
2016-07-30
18:54
Fix harmless compiler warning seen with MSVC. check-in: 390a38a1 user: mistachkin tags: trunk
2016-07-29
17:36
Using the header file 'intrin.h' requires MSVC 2005 or later. check-in: 9fae75c0 user: mistachkin tags: trunk
04:12
For test 'shell1-5.0', disable round-trip testing for characters in the range 0xE0 to 0xEF on Linux, due to intermittent shell portability issues. check-in: 544c990a user: mistachkin tags: trunk
02:04
Fix typo in a test file interactive output string. check-in: 4fedd790 user: mistachkin tags: trunk
01:55
Merge additional linkage macro changes from the branch. check-in: 8b0eb22e user: drh tags: trunk
01:49
Further refinement to the calling convention macros. check-in: 45588de3 user: drh tags: trunk
01:47
Merge updates from trunk. check-in: 71ffa195 user: mistachkin tags: callbackConv
01:46
Update the autoconf makefile for MSVC. check-in: 2daf2098 user: mistachkin tags: callbackConv
01:32
Undo some unhelpful changes to skip-scan scoring that were added by the check-in [9e2b2681] that improved scoring of index scan. check-in: c7d51934 user: drh tags: trunk
01:31
Add macro necessary for building several extensions when the __stdcall calling convention is not in use. check-in: bc8c9b55 user: mistachkin tags: callbackConv
2016-07-28
23:58
Missed a couple Tcl command deletion callbacks. check-in: fc5c1876 user: mistachkin tags: callbackConv
23:54
Use the SQLITE_TCLAPI macro in several extensions that were missed in the previous check-in. check-in: df254365 user: mistachkin tags: callbackConv
22:53
More compiler warning fixes for GCC related to the auto-extension mechanism. check-in: b8218129 user: mistachkin tags: callbackConv
22:46
The return type used by the auto-extension entry points is 'int', not 'void'. check-in: bf9c86c7 user: mistachkin tags: callbackConv
22:38
Make sure all the auto-extension mechanism function signatures match up precisely. check-in: 87ba69b5 user: mistachkin tags: callbackConv
22:23
Make the extension auto-loading mechanism work with the __stdcall calling convention. Also, fix a couple Tcl command calling conventions missed in the previous check-in. check-in: 3ea567c4 user: mistachkin tags: callbackConv
19:28
The 'sqlite3ext.h' content should be processed before being included in the amalgamation. check-in: cbe1de47 user: mistachkin tags: trunk
18:55
Decorate all interfaces with calling convention macros. check-in: fd784887 user: drh tags: trunk
18:49
All SQLite API functions and callbacks in the 'sqlite3ext.h' header file must be decorated with the calling convention. Closed-Leaf check-in: 97fc6e43 user: mistachkin tags: callbackConv
18:42
Merge recent trunk fixes. check-in: 97657445 user: drh tags: apple-osx
18:38
Disable the authorizer callback when reparsing the schema. This avoids undesirable authorization failures following an ALTER TABLE. check-in: 805d01cd user: drh tags: trunk
18:18
Fixup reserved function pointers in the Tcl stubs table and several macros containing Tcl function pointers. check-in: 959cd013 user: mistachkin tags: callbackConv
18:06
Adjustments to get 'testfixture.exe' compiling with Tcl 8.6 when __stdcall is enabled. check-in: 90e89ec9 user: mistachkin tags: callbackConv
17:24
Improvements to the way the COMPILER compile-time option is set when compiling with Clang. check-in: 81f9cf86 user: drh tags: trunk
17:11
Make sure the SQLITE_TCLAPI macro is always defined and use it for all callback functions that must interface with the Tcl C API. check-in: f2f1323c user: mistachkin tags: callbackConv
16:09
More work on getting the 'testfixture.exe' target to work correctly. check-in: 36b72fd6 user: mistachkin tags: callbackConv
15:38
Modify the mksqlite3h.tcl tool to handle the syscall typedef specially. check-in: 478a84ef user: mistachkin tags: callbackConv
15:09
Change mksqlite3h.tcl to automatically insert the SQLITE_CALLBACK calling convention macros. check-in: 11ab9c9a user: drh tags: callbackConv
14:37
Allow the 'testfixture.exe' target to be compiled with the __stdcall calling convention. check-in: e8be3dfe user: mistachkin tags: callbackConv
12:52
New test case to insure legacy CREATE TABLE syntax is supported. check-in: 6feff15c user: drh tags: trunk
04:14
Work in progress on setting a calling convention for all callback functions. check-in: 02b8040e user: mistachkin tags: callbackConv
2016-07-27
19:30
Enhance the query planner cost estimation for index scans to take into account WHERE clause terms that can be computed using only the index and that do not require looking up rows in the original table. This fixes an obscure performance regression that arose when the ORDER BY LIMIT optimization was added by check-in [bf46179d44843]. check-in: 9e2b2681 user: drh tags: trunk
19:20
Add test cases and fix a comment. Closed-Leaf check-in: 50f8ea37 user: drh tags: improved-index-scan
18:27
When estimating the cost of an index scan, factor in the cost savings of being able to use the index to evaluate some WHERE clause terms without having to do a table lookup. check-in: a59b5622 user: drh tags: improved-index-scan
16:03
Initialize a variable in where.c to avoid a valgrind warning. check-in: 4d59df02 user: dan tags: trunk
2016-07-26
15:17
Merge fixes to sqlite3_scrub_backup() from trunk. check-in: 91e811f5 user: drh tags: apple-osx
10:46
Ensure that the sqlite3_scrub_backup() extension creates a backup database at least as large as indicated by the database header, even if the last page of the input database is a free-list leaf. check-in: 483994a5 user: dan tags: trunk
04:54
Merge the cache_spill VACUUM fix from trunk. check-in: cc6bfdf8 user: drh tags: apple-osx
04:49
Copy the cache_spill setting from the main database over to the vacuum_db transient database when running a VACUUM. check-in: c0e7d98e user: drh tags: trunk
04:31
Make sure affinity is applied correctly on lower-bound range constraints in the min() optimization. Fix for ticket [a0bac8b3c3d1bb]. check-in: b819bace user: drh tags: trunk
04:23
Make sure affinity is applied correctly on lower-bound range constraints in the min() optimization. Fix for ticket [a0bac8b3c3d1bb]. check-in: 0e9f534f user: drh tags: apple-osx
2016-07-25
22:46
Merge the VACCUM cache_size adjustment from trunk. check-in: cdb7efd0 user: drh tags: apple-osx
22:40
In the VACUUM command, set the cache_size of the transient vacuum_db database to be the same as the database being vacuumed. check-in: b78d9954 user: drh tags: trunk
21:11
Fix a test case in FTS5 to make it compatible with Tcl 8.5. check-in: a495f8e7 user: drh tags: trunk
18:50
Add the experimental SQLITE_VACUUM_CACHE_SIZE macro. check-in: 68ecd8e0 user: drh tags: apple-osx
17:31
Merge 3.14 alpha changes from trunk. check-in: e98cefb1 user: drh tags: apple-osx
16:10
Minor test infrastructure changes to better support SEE testing. check-in: 8dcb9d50 user: drh tags: trunk
14:40
Add a new %ifdef to parse.y so that the build works with SQLITE_OMIT_SUBQUERY. check-in: 38a48cfb user: drh tags: trunk
14:20
Changes to test scripts to get them all running on OpenBSD. check-in: 9e7bedee user: drh tags: trunk
12:10
Disable the DBSTATUS_CACHE_USED_SHARED tests on mac when memsys3/5 is disabled due to differences in the allocation sizes for the Darwin memory allocator. check-in: d6f6c87c user: drh tags: trunk
12:01
Update the vacuummem.test script so that it works on mac as well as on linux. check-in: ea7fb98b user: drh tags: trunk
11:57
If both MEMSYS3 and MEMSYS5 are enabled, than automatically disable MEMSYS3. check-in: ccc22e14 user: drh tags: trunk
11:39
Another attempt at getting --enable-memsysN working. check-in: 5f40e6ad user: drh tags: trunk
11:32
Fix the --enable-memsysN options in configure so that they actually work. check-in: 67955255 user: drh tags: trunk
11:27
Add --enable-memsys3 and --enable-memsys5 options to the configure script. check-in: 67e1dc98 user: drh tags: trunk
02:42
Evidence marks and code reformatting for SQLITE_TRACE_STMT operation. check-in: e1e02238 user: drh tags: trunk
02:31
Change SQLITE_TRACE_STMT to return unexpanded SQL text in the X argument. Add documentation on how and when to use sqlite3_expanded_sql(P) to compute the expanded text for legacy sqlite3_trace() compatibility. check-in: 163e1522 user: drh tags: trunk
00:05
Fix code so that the deprecated sqlite3_trace() and sqlite3_profile() interfaces are not called when SQLITE_OMIT_DEPRECATED is used. check-in: 1c5baae3 user: drh tags: trunk
2016-07-23
20:27
Use sqlite3_trace_v2() instead of sqlite3_trace() in the shell. check-in: c8e0539b user: drh tags: trunk
19:34
Add the json_quote() function to the JSON1 extension. check-in: 269892ab user: drh tags: trunk
19:18
Small tweak to the btree balancer for improved tree balance. check-in: 8817dedb user: drh tags: trunk
14:50
Fix recently added tests so that they work in all configurations. check-in: d0bcaf0c user: drh tags: trunk
05:22
Add the sqlite3_expanded_sql() and sqlite3_trace_v2() interfaces. check-in: 99a6c518 user: drh tags: trunk
04:58
Improvements to sqlite3_trace_v2() documentation. Fix the sqlite3VdbeExpandSql() routine to respond better to OOM conditions. Closed-Leaf check-in: 0400f642 user: drh tags: sqlite3_trace_v2
02:07
Add requirements marks to the sqlite3_trace_v2() interface documentation. check-in: ebd388e9 user: drh tags: sqlite3_trace_v2
00:43
Fix sqlite3VdbeExpandSql() so that it handles OOMs by always returning NULL. check-in: 5a027fe4 user: drh tags: sqlite3_trace_v2
2016-07-22
21:35
Revise a warning fix from the previous check-in to improve clarity. Also, fix an incorrect test prefix (typo). check-in: f50a3fd6 user: mistachkin tags: trunk
21:26
Fix harmless compiler warnings seen with MSVC. check-in: 8bb6e6fc user: mistachkin tags: trunk
20:45
Be sure to hold the database connection mutex while calling sqlite3VdbeExpand() from within sqlite3_expanded_sql(). check-in: 527b5ba6 user: drh tags: sqlite3_trace_v2
20:20
Add requirements marks to the sqlite3_expanded_sql() documentation. check-in: 409535e6 user: drh tags: sqlite3_trace_v2
10:09
Fix a problem with upper case module names in the "sqldiff --vtab" command. check-in: 87e25fc4 user: dan tags: trunk
2016-07-21
18:02
Add extra test cases to verify the fix in [64ca1a835]. check-in: bf98a2de user: dan tags: trunk
16:43
Add new test file vacuummem.test. To test that any temporary memory used by VACUUM is freed as soon as the VACUUM has finished (not, for example, when sqlite3_close() is finally called). check-in: 1b1ad0b2 user: dan tags: trunk
2016-07-15
19:17
Add the largely untested SQLITE_FTS5_NO_WITHOUT_ROWID compile time option to fts5. For building a dynamically loadable extension that does not use WITHOUT ROWID. check-in: d0a1cf1c user: dan tags: trunk
10:01
The sqlite3_expanded_sql() function compiles, but always returns NULL, when the SQLITE_OMIT_TRACE compile-time option is used. check-in: 53c25ebe user: drh tags: sqlite3_trace_v2
02:55
Merge fixes from trunk. Fix the tclsqlite.test script. check-in: d2b1fa55 user: drh tags: sqlite3_trace_v2
02:50
Disable the CSV extension when virtual tables are disabled. check-in: ec718089 user: drh tags: trunk
01:49
Modify the Tcl test command 'sqlite3_bind_blob' to make use of the Tcl_GetByteArrayFromObj() API. check-in: e03c8189 user: mistachkin tags: sqlite3_trace_v2
00:39
Fix typo in sqlite3_trace_v2(). check-in: 97ccf15f user: mistachkin tags: sqlite3_trace_v2
00:23
Corrections and enhancements for the new tests. check-in: 20e74c63 user: mistachkin tags: sqlite3_trace_v2
00:09
Modify one test result to be case-insensitive. check-in: 5ccbeeea user: mistachkin tags: sqlite3_trace_v2
00:07
Add tests, including some for the sqlite3_expanded_sql() API. check-in: 8b8c0b74 user: mistachkin tags: sqlite3_trace_v2
2016-07-14
23:17
More work on the Tcl interface and tests for the sqlite3_trace_v2() API. check-in: f3c4aa97 user: mistachkin tags: sqlite3_trace_v2
21:26
Initial work on the Tcl API interface to the new sqlite3_trace_v2() function. check-in: 7b59fa40 user: mistachkin tags: sqlite3_trace_v2
19:48
Minor tweak the the b-tree balancer. Closed-Leaf check-in: d2a0af7a user: drh tags: btree-tuning