/ 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 descendants and 100 ancestors of [417e7777]

2016-03-01
18:24
Allow test_bestindex.c to set the omit flag for a constraint. check-in: 759b9d5b user: dan tags: test-bestindex
18:07
Add test code useful for testing the planners use of teh virtual table xBestIndex() method. check-in: de034c0d user: dan tags: test-bestindex
14:31
Change the estimated row counts in stat1 to be one-third worst-case and two-threads average case. check-in: 21bfd47c user: drh tags: analyze-worst-case
12:45
Fix test cases to align with the improved stats computation. check-in: 810967bf user: drh tags: analyze-worst-case
02:11
Better estimatedCost in the xBestIndex method of the generate_series vtab. check-in: f2c16094 user: drh tags: trunk
2016-02-29
23:02
Improvements to the logic for adding the "noskipscan" flag to stat1 entries. check-in: 421b5b54 user: drh tags: analyze-worst-case
21:27
The ANALYZE command automatically appends "noskipscan" to sqlite_stat1 entries that have large worst-case repeat estimates but small average repeat estimates. check-in: 6326ba58 user: drh tags: analyze-worst-case
20:18
When using a temporary file for a statement journal, store the first 64KiB in memory. If the file grows larger than that, flush it to disk and free the memory. Hardcoding to 64KiB is just an experiment to check that the memjournal.c code works. check-in: 44b2dc18 user: dan tags: memjournal-exp
20:00
Fix minor problems with new code in memjournal.c. check-in: 9fd3f7b9 user: dan tags: memjournal-exp
18:30
Modify the ANALYZE command to store worst-case statistics in sqlite_stat1, rather thn average case. check-in: 5a0143c9 user: drh tags: analyze-worst-case
17:34
Fix a problem in fts5 where a corrupt db could lead to a (huge) buffer overread. check-in: c9a30e11 user: dan tags: trunk
17:16
Fix an fts5 problem causing 'optimize' to corrupt the fts index under some circumstances. check-in: 251d6473 user: dan tags: trunk
15:53
Reduce the amount of heap required to store many schemas by storing each column datatype appended to the column name, rather than as a separate allocation. Closed-Leaf check-in: 842b2116 user: drh tags: schema-storage
13:44
Very minor improvement to the performance and reduction in size to the parser by capturing the name and datatype of table columns in a single grammar rule reduction. check-in: 4b55c520 user: drh tags: trunk
13:37
Further simplifications to the grammar. Closed-Leaf check-in: 519fd03b user: drh tags: schema-storage
2016-02-27
23:25
Update the parser so that it pulls out the column name and type all in one go, rather than using separate reductions. check-in: ad3ffe2e user: drh tags: schema-storage
21:16
Eliminate the need for the Column.zDflt (using Column.pDflt instead) to reduce the amount of memory needed to hold the schema. check-in: d8c94a46 user: drh tags: trunk
20:14
Extend the code in memjournal.c so that it subsumes the role of journal.c. And (untested) can flush journal or statement journal files to disk after they grow to a specified size. check-in: e0b0b431 user: dan tags: memjournal-exp
19:19
Tighter description of I/O stats in the shell. Show I/O stats on speedtest1.c. check-in: f681d800 user: drh tags: trunk
19:03
More compact implementation of PRAGMA onconflict, and some test cases. Leaf check-in: 3e5d38f5 user: drh tags: pragma-onconflict
17:16
Experimental "PRAGMA onconflict=FAIL" statement to change the default ON CONFLICT algorithm to something other than ABORT. check-in: 3a0c347c user: drh tags: pragma-onconflict
17:12
Enhance the ".stats" command in sqlite3.exe to show one-time stats information if invoked with one argument. Also show /proc/PID/io information if run on Linux. check-in: 3c36948f user: drh tags: trunk
14:04
Fix a requirement mark to conform to a typo fix in the documentation. check-in: d1392c62 user: drh tags: trunk
14:00
Enhance documentation of sqlite3_snapshot_open() to explain that the database connection must have participated in at least one read operation prior to the beginning of the transaction for which the snapshot is to be opened. Add test cases for this fact. check-in: 33dd671c user: drh tags: trunk
00:21
Add 'Replace.exe' to the MSVC clean target. check-in: c2277fab user: mistachkin tags: trunk
00:21
Fix typo in ICU error message. check-in: 00c8fffd user: mistachkin tags: trunk
00:07
Make sure the Replace.cs file is included in the autoconf tarball. check-in: b850df48 user: drh tags: trunk
2016-02-26
23:13
Support generating the '.def' file using the autoconf Makefile for MSVC. check-in: 3617564c user: mistachkin tags: trunk
21:20
Fix a potential buffer overflow in the ICU upper() function. check-in: b8dc1b9f user: drh tags: trunk
21:03
Further refinements to the MSVC batch build process. check-in: cf4e4fbd user: mistachkin tags: trunk
16:14
Merge all recent enhancements from trunk, and in particular the SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER change. check-in: 4fb4aee8 user: drh tags: apple-osx
16:03
Fix the ICU extension LIKE function so that it does not read past the end of a buffer if it it passed malformed utf-8. check-in: 424b7aee user: dan tags: trunk
15:38
Provide the new SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER option to sqlite3_db_config() that can be used to activate the two-argument version of fts3_tokenizer() for a specific database connection at run-time. check-in: 374b5108 user: drh tags: trunk
13:22
Fix a typo in a comment (though an important comment in that it is used to generate documentation). check-in: ff3d7f84 user: drh tags: trunk
04:13
Ephemeral tables used to hold manifested views may not be unordered since they might be subject to an ordered comparison if they are part of a join. check-in: 3ef6a315 user: drh tags: trunk
04:04
Remove a debugging "exit" command mistakenly left in the "where.test" module. check-in: beda0b8c user: drh tags: trunk
2016-02-25
23:27
Add some comments in the VSIX test tool. check-in: c871473f user: mistachkin tags: trunk
23:25
Add tool for smoke-testing the UWP VSIX package. check-in: d27f32c6 user: mistachkin tags: trunk
23:22
Enhance checking of prerequisites in the vsixtest tool. Closed-Leaf check-in: 799d5f09 user: mistachkin tags: vsixTest
23:21
Fix an incorrect cost computation for sorting (introduced just a few check-ins ago). Should be NlogN, not NloglogN. check-in: 2459d323 user: drh tags: trunk
21:38
Small optimization in FK handling. check-in: e0d25913 user: mistachkin tags: trunk
21:27
Change the srcck1.c utility program to use only unsigned characters. check-in: d64d005e user: drh tags: trunk
21:19
Change the "PRAGMA stats" command to report size values in LogEst units. The eliminates the need for sqlite3LogEstToInt() unless non-standard compile-time options are used, so leave it out except in those cases. check-in: 832c237f user: drh tags: trunk
20:17
Disable the RESTRICT foreign key action if "PRAGMA defer_foreign_keys" is set. check-in: 9ffff484 user: dan tags: trunk
19:52
Disable the RESTRICT foreign key action if "PRAGMA defer_foreign_keys" is set. check-in: 8fea1166 user: dan tags: sessions
18:54
Merge all the latest changes from trunk. check-in: b8659004 user: drh tags: sessions
18:40
Query planner improvements: Take the LIMIT into account when estimated the cost of an ORDER BY. Avoid automatic indexes on query loops that are expected to run less than twice. See [9e2b2681] for a later enhancement. check-in: bf46179d user: drh tags: trunk
18:22
Improvement on the previous check-in: disallow automatic indexes for any loop that is expected to run less than twice. Closed-Leaf check-in: aab53a21 user: drh tags: planner-improvements
18:03
Do not use an automatic index on an outer loop that only runs once. check-in: 5957e793 user: drh tags: planner-improvements
16:04
Take the LIMIT clause into account when estimating the cost of sorting. check-in: d491745c user: drh tags: planner-improvements
13:33
In the command-line shell: When the ".import" command is creating a new table using column names from the first row of CSV input, make sure double-quotes in the name are properly escaped. check-in: 2e67a1c8 user: drh tags: trunk
08:02
Improve readability and logging of the vsixtest script. check-in: 4fe7c4e9 user: mistachkin tags: vsixTest
02:56
Enable all steps and add/update comments. check-in: 788f99f4 user: mistachkin tags: vsixTest
02:49
More work. Install and build steps are now tested. check-in: 0ab74373 user: mistachkin tags: vsixTest
2016-02-24
23:31
Fix typo. Improve interim debugging. check-in: e0029bdf user: mistachkin tags: vsixTest
23:25
Test build all supported configurations and platforms during VSIX testing. check-in: cce40a0b user: mistachkin tags: vsixTest
21:42
Initial work on an automated VSIX testing tool. Not working or tested yet. check-in: 496e4ac9 user: mistachkin tags: vsixTest
20:16
Extend [3e9ed1ae] so that covering indexes on WITHOUT ROWID tables are also identified. check-in: e721975f user: dan tags: trunk
19:57
Change a char* to const char* in order to suppress some harmless compiler warnings. check-in: 56f62e34 user: drh tags: trunk
17:18
When an index completely covers a table, it can be used as a covering index even if columns past the 63rd column are indexed and accessed. check-in: 3e9ed1ae user: drh tags: trunk
16:14
Fix a problem with handling identifiers that start with "x" if SQLITE_OMIT_BLOB_LITERAL is defined. check-in: b65217c6 user: dan tags: trunk
15:43
Identify indexes that completely cover their table. Closed-Leaf check-in: 71d488b5 user: drh tags: covering-index
13:35
LSM1: Fix the integer key encoding so that negative keys are in numeric order. check-in: f92dc418 user: drh tags: lsm-vtab
2016-02-23
16:28
Add the SQLITE_BITMASK_TYPE compile-time option. check-in: 0064a8c7 user: drh tags: trunk
01:41
Merge trunk enhancements. check-in: fac4f4ec user: drh tags: lsm-vtab
01:37
Add support for (variable length) integer keys in LSM1. check-in: 32f3daec user: drh tags: lsm-vtab
2016-02-22
23:44
Remove code not needed now that synchronous=OFF database files no longer trigger the use of a master journal. check-in: aa9f4c62 user: drh tags: trunk
23:14
Avoid an unnecessary seek operation some corner-case skip-scan operations. check-in: 2a6003a9 user: drh tags: trunk
21:19
Clearer presentation of the logic. No functional changes. Closed-Leaf check-in: a3dcf6db user: drh tags: skip-scan-improvement
20:52
Avoid an unnecessary seek operation on some corner-case skip-scans. check-in: 38e837e6 user: drh tags: skip-scan-improvement
16:32
Merge the master-journal optimization and other recent changes from trunk. check-in: 18c3ab47 user: drh tags: apple-osx
16:04
Always use the sqlite3VdbeDeleteAuxdata() routine for clearing auxdata on function parameter, rather than having a separate deleteAuxdataFromFrame() for doing the job for trigger frames. check-in: 64386fa3 user: drh tags: trunk
14:57
Avoid creating a master journal unless two or more databases in the transaction can actually benefit from that master journal. check-in: 3ed18906 user: drh tags: trunk
13:23
Change magic numbers associated with synchronous settings to named constants. check-in: 9230ba6c user: drh tags: trunk
13:01
Merge up to trunk. check-in: f9e5fb88 user: drh tags: lsm-vtab
09:45
Add an extra test case for the change in commit [c4295725]. check-in: a48ac4c3 user: dan tags: trunk
2016-02-19
19:46
Further enhancements to the MSVC batch build tool. check-in: 06f1495f user: mistachkin tags: trunk
18:54
Use a separate list of aux-data structures for each trigger program at the VDBE level. Fix for [dc9b1c91]. check-in: c4295725 user: dan tags: trunk
16:19
Enhance speedtest1 to display the particular version of SQLite under test. check-in: 0cb728c1 user: drh tags: trunk
15:17
Fix a couple of harmless warnings generated by clang. check-in: a1a3ff1f user: drh tags: trunk
14:20
Fix a harmless uninitialized variable access. check-in: 398522e6 user: drh tags: trunk
14:10
Make sure WhereClause objects are fully initialized before use when planning OR queries. check-in: 16205302 user: drh tags: trunk
13:29
Fix (harmless) compiler warnings in some of the TCL-based test code. check-in: 7c26d2b4 user: drh tags: trunk
13:20
Add an SQLITE_DISABLE_INTRINSIC #ifdef to the sqlite3Put4Byte() function. check-in: ba9c6827 user: drh tags: trunk
13:19
Omit the unused yyzerominor constant. check-in: 60ad68a9 user: drh tags: trunk
10:18
Add an "#ifndef SQLITE_AMALGAMATION" guard around a typedef in fts5_test_mi.c to avoid redefining "u32" if it is compiled as part of the amalgamation. check-in: f9c49ba1 user: dan tags: trunk
00:48
Further improvements to the MSVC batch build tool. check-in: b9626b59 user: mistachkin tags: trunk
2016-02-18
21:15
Correct the install location for the UWP VSIX package. check-in: f74de325 user: mistachkin tags: trunk
14:53
Merge the tokenizer buffer overrun bug-fix from trunk. check-in: 82e7e31b user: drh tags: apple-osx
14:49
Avoid a potential buffer overrun if an SQL statement being parsed ends with an illegal "!" token. (This problem was detected by fuzzcheck running under valgrind. The problem was introduced by check-in [9570b6b43df3], two days ago and has not appeared in a release.) check-in: 2a8d97e7 user: drh tags: trunk
14:03
Improved handling of the -v option on the fuzzcheck test program. check-in: c8cd7804 user: drh tags: trunk
13:32
Remove an unnecessary "include <tcl.h>" line from fts5_test_mi.c. check-in: 31d8b69e user: dan tags: trunk
01:36
Merge recent performance enhancements and the enhanced API_ARMOR from trunk. check-in: b7fa0fb3 user: drh tags: apple-osx
01:29
Add extra API armor on the sqlite3_bind_blob() interface. check-in: 80de1ad5 user: drh tags: trunk
2016-02-17
20:47
When VDBE opcodes fail, they cause an immediate exit from the loop, rather than depending on the rc==SQLITE_OK test at the top of the loop. This is faster and smaller. check-in: 24c7151c user: drh tags: trunk
18:44
Fix up all VDBE opcodes so that they cause an immediate exit on any kind of error, and thereby eliminate the need to test "rc" at the top of the loop. Resulting code is a little smaller and faster. Closed-Leaf check-in: a444633a user: drh tags: vdbe-performance
15:01
Bump the version number to 3.12.0. check-in: c17d7276 user: drh tags: trunk
14:48
Remove the "#ifdef SQLITE_TEST" condition from fts5_test_mi.c. Update fts5_main.c so that if SQLITE_FTS5_TEST_MI is defined when it is built the fts5_test_mi.c entry point is automatically called. This makes it easier to build versions of fts5 that include the matchinfo() demo by default. check-in: 87e6e225 user: dan tags: trunk
14:11
Improve test coverage of demo code in fts5_test_mi.c. check-in: 8a78050d user: dan tags: trunk
13:24
Enhance Lemon to generate more compact and efficient code for yy_reduce(). Update the main SQL grammar to take advantage of the new capabilities. check-in: 53fd040c user: drh tags: trunk
12:34
More agressive use of /*A-overwrites-X*/ in the parser. Fix an off-by-one error in parser stack overflow detection. Closed-Leaf check-in: 417e7777 user: drh tags: parser-performance
04:33
Enhance Lemon so that if reduce code contains a comment of the form "/*A-overwrites-X*/" then a LHS label A is allowed to overwrite the RHS label X. check-in: 5cfe9545 user: drh tags: parser-performance
01:46
Further improvements to the Lemon-generated code for yy_reduce(). check-in: ef95a7d6 user: drh tags: parser-performance
01:18
In Lemon, add the ability for the left-most RHS label to be the same as the LHS label, causing the LHS values to be written directly into the stack. check-in: 4bb94c7c user: drh tags: parser-performance
2016-02-16
21:19
Experimental changes to Lemon for improved parser performance. check-in: a65d583c user: drh tags: parser-performance
13:04
Minor simplification to the tokenizer. Slightly smaller and faster. check-in: 9570b6b4 user: drh tags: trunk
01:01
Improve the Lemon parser template (lempar.c) so that it avoids unnecessary work when the grammer defines YYNOERRORRECOVERY (as SQLite does). Slightly smaller and faster code results. check-in: 9235b0cf user: drh tags: trunk
2016-02-15
23:46
Fix a harmless compiler warning in FTS5. check-in: e52c9075 user: drh tags: trunk
22:37
Readability improvements for winRandomness. check-in: 1640f814 user: mistachkin tags: trunk
22:28
Fix comment. No changes to code. check-in: 2e1f2eff user: mistachkin tags: trunk
22:01
Revise compiler checks for the rand_s() function. check-in: 287f508d user: mistachkin tags: trunk
21:31
On windows systems when rand_s() is available, use it to obtain additional seed material in winRandomness(). check-in: 139081be user: drh tags: trunk
20:41
Improved entropy gathering for the implementation of winRandomness(). check-in: fea3705e user: drh tags: trunk
19:38
Add working -q and --help options to testfixture. check-in: 404494e5 user: drh tags: trunk
18:58
In the tool/warning.sh script, disable Android-specific compiler warning tests when not running on Linux. check-in: 153f01a8 user: drh tags: trunk
18:47
Fix harmless compiler warnings previously seen in 64-bit MSVC builds. check-in: 70262463 user: drh tags: trunk
18:15
Add the SQLITE_NOMEM_BKPT macro to enhance the ability to debug OOM errors. Only effective with compiling with SQLITE_DEBUG. check-in: 9b345476 user: drh tags: trunk
18:02
Minor code simplifications. check-in: c3b38efd user: drh tags: trunk
17:56
Make the application-defined SQL function logic more compact and faster, especially faster for the case where an application defines thousands of new SQL functions. check-in: 7d49ed32 user: drh tags: trunk
17:29
Version 3.11.0 check-in: 3d862f20 user: drh tags: trunk, release, version-3.11.0
15:06
Make sure the codec is invoked when overwriting existing frames of the WAL file. Yikes! check-in: f694e60a user: drh tags: trunk
00:34
Improvements to the application-defined function mechanism so that it is more compact and runs faster, especially when the application defines thousands of new SQL functions. Closed-Leaf check-in: 3201fbcc user: drh tags: many-app-functions
2016-02-14
00:14
Update a comment. Closed-Leaf check-in: e9753d9a user: mistachkin tags: noMemBkpt
2016-02-13
23:43
Enhance ability to debug out-of-memory errors. check-in: 6a9c4a3e user: mistachkin tags: noMemBkpt
18:54
Provide Sqlite3_SafeInit() and Sqlite3_SafeUnload() entry points on the TCL interface, but have the always return TCL_ERROR, because the non-standard TCL builds on Macs require this. check-in: 37ec3015 user: drh tags: trunk
2016-02-12
18:48
Fix a potential buffer overread provoked by invalid utf-8 in fts5. check-in: a049fbbd user: dan tags: trunk
17:56
Fix a fairly obscure buffer overread in fts5. check-in: 13058020 user: dan tags: trunk
17:30
Fix a documentation typo. No changes to code. check-in: d9c98587 user: drh tags: trunk
17:27
Enhance mptester so that it takes great care to delete its test database prior to start-up, including checking the return code from unlink() and retrying after a delay if unlink() fails. Hopefully this will clear intermittant startup problems on Windows. check-in: 6ea84ec1 user: drh tags: trunk
05:19
Naming updates for Universal Windows Platform. check-in: 717c1fc4 user: mistachkin tags: trunk
00:13
Remove an unused parameter from whereSortingCost(). check-in: b5d77199 user: drh tags: trunk
2016-02-11
22:41
Automatically disable FTS3 and FTS4 when building with SQLITE_OMIT_VIRTUALTABLE. check-in: 0beb32d2 user: drh tags: trunk
21:59
Enhance the MSVC makefile to enable building 'testfixture' fully from source code. check-in: f183e059 user: mistachkin tags: trunk
21:55
Remove the unexplained extra 3.0 cost factor for the B-tree sorting that is done to implement DISTINCT in the absence of an index to help. check-in: 52571991 user: drh tags: trunk
21:53
Remove the unused fts5BlobCompare() routine. check-in: defc762d user: drh tags: trunk
21:38
Prevent 'expanded command line X too long' errors during the batch 'for' loops used for copying files. Closed-Leaf check-in: 67ee9b5a user: mistachkin tags: testFixtureSrc
21:28
Enhance the MSVC makefile to enable building 'testfixture' fully from source code. check-in: 54ff3a26 user: mistachkin tags: testFixtureSrc
18:18
Fix another unused variable warning in fts5 code. check-in: 61b4c120 user: dan tags: trunk
18:08
Avoid a buffer overread when reading a corrupt fts5 structure record. check-in: facbc424 user: dan tags: trunk
17:01
Handle parser stack overflow when parsing fts5 query expressions. Fix some compiler warnings in fts5 code. check-in: bc3f7900 user: dan tags: trunk
15:37
Add JSON1 and FTS5 to the set of extensions subject to close compiler warning analysis. Fix some warnings in each. More (harmless) warnings still exist in FTS5. check-in: cfe2eb88 user: drh tags: trunk
13:30
Minor simplifications deferred to the next release. Closed-Leaf check-in: a863729c user: drh tags: simplify
2016-02-10
21:45
In the MSVC makefile, include the working directory so that it can pickup build generated files (e.g. sqlite3.h, etc). check-in: e9e6000b user: mistachkin tags: trunk
19:10
Add testcase() macros to the CHECK constraint avoidance logic. Avoid creating an unused VDBE label during CHECK constraint code generation. check-in: 970881be user: drh tags: trunk
18:24
Fix to previous check-in: Make sure CHECK constraints involving the ROWID are not ignored when the ROWID changes. check-in: 7782cb1d user: drh tags: trunk
16:52
Omit unnecessary CHECK constraints in UPDATE statements, when none of the columns referenced in the CHECK constraint are modified. check-in: 02fbdbc7 user: drh tags: trunk
16:03
Omit NOT NULL checks on unchanging columns in an UPDATE. check-in: 6a3aaedf user: drh tags: trunk
13:36
When generating the snapshot-tarball, truncate the date/time in the name to 12 significant digits (YYYYMMDDhhmm) omitting the seconds and fractional seconds. check-in: 604f7775 user: drh tags: trunk
13:17
Updates to the autoconf tarball README.txt file. check-in: a3e911e3 user: drh tags: trunk
2016-02-09
22:54
Update the snapshot tarball name to use the date (ISO8601 format) instead of the SHA1 hash in its name. check-in: 070ec66f user: drh tags: trunk
22:39
Add the new "snapshot-tarball" target to the unix makefiles, for building a tarball similar to "amalgamation-tarball" but named by the SHA1 hash of the current check-out rather than by the version number. check-in: 4f360b2a user: drh tags: trunk
22:00
Update the MSVC autoconf makefile with the recent changes from the primary one. check-in: c7242aa3 user: mistachkin tags: trunk
20:37
Fix the makefiles in the autoconf-tarball so that they build the command-line shell with SQLITE_ENABLE_EXPLAIN_COMMENTS. check-in: 1135ad01 user: drh tags: trunk
20:31
In the shell, use the appropriate string constant instead of a literal new-line. check-in: 61951b15 user: mistachkin tags: trunk
20:11
Enhance the command-line shell to be in auto-explain mode by default. It is no longer necessary to use the ".explain" command to put the shell into a mode where the EXPLAIN output is formatted nicely. That now happens automatically. check-in: 751915cb user: drh tags: trunk
20:04
Improved auto-detection of EXPLAIN output in the shell. Closed-Leaf check-in: 6c6d7a6e user: drh tags: auto-explain
18:39
Add auto-explain mode to the command-line shell. Default on. Auto-explain tries to automatically detect EXPLAIN queries and format them appropriately. check-in: 1d62aa6b user: drh tags: auto-explain
18:28
Fix MSVC makefile options that enable control-flow guard. check-in: 51b6823f user: mistachkin tags: trunk
17:12
Fix the top-level makefiles to always include SQLITE_ENABLE_EXPLAIN_COMMENTS when building the shell. Still need to fix main.mk and the amalgamation tarball. check-in: 99228239 user: drh tags: trunk
16:09
Code simplification: ALTER TABLE ADD COLUMN always upgrades the file_format to 4 if is not there already. No need to upgrade to only 2 or 3 since format 4 has now been supported for over 10 years. check-in: e1d8ec85 user: drh tags: trunk
02:12
Make sure every co-routines has its own set of temporary registers and does not share temporaries, since a co-routine might expect the content of a temporary register to be preserved across an OP_Yield. Proposed fix for ticket [d06a25c84454a]. check-in: ca72be86 user: drh tags: trunk
2016-02-08
20:45
Fix spelling error in MSVC makefile comments. check-in: 6eab74c9 user: mistachkin tags: trunk
20:40
More work on Windows 10 SDK integration. check-in: 1e563c6e user: mistachkin tags: trunk
20:14
Fix a signed/unsigned comparison warning in fts5. check-in: 85eb05dd user: dan tags: trunk
20:06
Fix a compiler warning when compiling without SQLITE_ENABLE_FTS3_TOKENIZER. check-in: 6926f28c user: drh tags: trunk
19:40
Disable the two-argument form of the fts3_tokenizer() SQL function unless the library is built with -DSQLITE_ENABLE_FTS3_TOKENIZER. check-in: e0eb217a user: dan tags: trunk
19:36
Changes to help the tokenizer run about 33% faster. check-in: a050e6f0 user: drh tags: trunk
19:15
Add code to get the tokenizer character-class logic working for EBCDIC. Closed-Leaf check-in: 04f7da77 user: drh tags: tokenizer-char-class
03:23
Faster keywordCode() implementation by taking advantage of the fact that the input is always pure ASCII alphabetic and underscore and that the keyword table is always upper-case. check-in: ff406b97 user: drh tags: tokenizer-char-class
02:30
Demonstrate a much faster sqlite3GetToken() routine by using a lookup table to map initial token characters into a character class. This check-in does not work for EBCDIC. More optimization needed. check-in: 9115baa1 user: drh tags: tokenizer-char-class
2016-02-07
20:39
Fix harmless compiler warning in 'srcck1' tool and add it to the clean targets. check-in: 852a529a user: mistachkin tags: trunk
00:08
Add the sourcetest target to Makefile.msc. check-in: ab269e72 user: drh tags: trunk
2016-02-06
22:32
Add a utility program that looks for assert(), NEVER(), ALWAYS(), and testcase() macros that have side-effects, and reports errors when they are found. Also fix a bug that this utility detected as it was being tested. check-in: b0b4624f user: drh tags: trunk
19:48
Make sure variable declarations occur at the beginning of blocks, even with SQLITE_DEBUG enabled. check-in: 2f7778e6 user: drh tags: trunk
14:14
Fix an assert() to have a test instead of a side effect check-in: a2952231 user: pdr tags: trunk
2016-02-05
21:09
Add tests for and remove unreachable branches from fts5 in order to restore test coverage. check-in: 22589018 user: dan tags: trunk
19:40
More work on Windows 10 SDK integration. Closed-Leaf check-in: ebace2c9 user: mistachkin tags: win10sdk
19:18
Further streamlining of fts5 prefix query code. check-in: ca91bd8a user: dan tags: trunk
17:49
Make sure the "bak.db" database file does not actually exist before starting the "quota.test" testing. check-in: 1cac6c45 user: drh tags: trunk
16:46
From test scripts, remove stray "breakpoint" commands and blank lines at the ends of files. check-in: a6b35273 user: drh tags: trunk
14:11
Improvements to the way out-of-memory conditions are handled, resulting in an almost 1% performance gain in the commmon case where OOM errors do not occur. check-in: b082538d user: drh tags: trunk
13:38
Add the slightly faster sqlite3DbMallocRawNN(db,n) routine for the majority cases where db is guaranteed to be not NULL. Closed-Leaf check-in: 0a802e96 user: drh tags: oom-handling
04:55
Improve ERRORLEVEL handling in the MSVC batch build tool sub-routine 'fn_UnsetVariable'. check-in: fe123ab4 user: mistachkin tags: trunk
04:50
OOM failures on sqlite3_errmsg16() in an app-defined function are no longer benign. check-in: 9efb223f user: drh tags: oom-handling
04:39
Another small tweak to the MSVC batch build tool. check-in: 76718bbc user: mistachkin tags: trunk
02:50
Minor simplification of schema error reporting. check-in: a8846aee user: drh tags: oom-handling
02:42
Further performance improvements that fall out of the mallocFailed changes. check-in: d94416dd user: drh tags: oom-handling
01:55
Improvements to the way that OOM errors are processed. check-in: c3ef0347 user: drh tags: oom-handling
2016-02-04
19:50
Temporarily back out the 0.5% performance improvement from check-in [632071bac5ff32]. Need a more elaborate solution that works with reentrant virtual tables and SQL functions. check-in: 42736fb0 user: drh tags: trunk
19:45
Further improve performance of unindexed fts5 prefix queries. check-in: c9c6457d user: dan tags: trunk
17:31
Avoid running some particularly time-consuming tests as part of veryquick.test. check-in: f465944b user: dan tags: trunk
11:48
Remove unnecessary sets of db->mallocFailed. check-in: b787165b user: drh tags: trunk
11:15
Use sqlite3_malloc64() instead of sqlite3_malloc() in the spellfix extension. check-in: 634d008c user: drh tags: trunk
10:28
Escape control characters in JSON. Fix for ticket [ad2559db380abf8]. check-in: 4f1b5229 user: drh tags: trunk
09:48
Refinements to synchronous logic: (1) Use PAGER_SYNCHRONOUS_FULL rather than the corresponding magic number. (2) Honor SQLITE_NO_SYNC on xDelete calls with sync (3) Count xDelete syncs during testing (4) Fix #ifs on SQLITE_EXTRA_DURABLE so that directory syncs on journal unlink are off by default. check-in: e3157cb5 user: drh tags: trunk
2016-02-03
22:14
In the VDBE loop, only check for OOM errors at jumps rather than after every opcode, for about a 0.5% performance increase. check-in: 632071ba user: drh tags: trunk
20:04
Improve performance of fts5 prefix queries on detail=col tables. check-in: ca11f46d user: dan tags: trunk
19:52
Fix markup errors in comments used to generate the documentation - specifically in the documentation on the OP_Seek opcode. check-in: ef252bc4 user: drh tags: trunk
19:20
Add "PRAGMA synchronous=EXTRA" which syncs the directory containing the rollback journal when the rollback journal is deleted in order to commit a transaction in DELETE mode. check-in: af924018 user: drh tags: trunk
01:55
Enhance the internal sqlite3VdbeAddOpList() interface to automatically update jump destinations. Use this feature to simplify the AUTOINCREMENT code generator. check-in: ae8b9d2e user: drh tags: trunk
2016-02-02
21:19
Add tests to restore full coverage of fts5 code. check-in: 063755c8 user: dan tags: trunk