/ 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 [b5897bc0]

2015-11-11
18:08
Add a hack to debug out a description of the WHERE clause of a SELECT (or other) statement. Use this in script tool/schemalint.tcl to automatically recommend indexes that might speed up specific queries. check-in: c6fa01c2 user: dan tags: schemalint
15:28
Improvements to the SQLITE_CONFIG_PAGECACHE documentation. Enhance the command-line shell to be able to take advantage of the full range of SQLITE_CONFIG_PAGECACHE capabilities, such as setting pMem==NULL and N<0. check-in: 2518d5c9 user: drh tags: trunk
2015-11-10
14:51
Improved output formatting for "PRAGMA parser_trace=ON;". check-in: e43e1171 user: drh tags: trunk
14:27
Make the output of "PRAGMA parser_trace" go to stdout instead of stderr. check-in: 1e484991 user: drh tags: trunk
13:45
Save a few bytes in the parser by using "int" instead of "u8" or "u16" for all small integer types. check-in: 5dcd212b user: drh tags: trunk
12:41
Change all parsers to use the standard "lempar.c" template in the tool/ folder and remove the customized lempar.c from src/, plus other compiler performance and space enhancements. check-in: 0e7fb24a user: drh tags: trunk
12:31
Fix harmless compiler warnings in FTS5. Closed-Leaf check-in: 09752e51 user: drh tags: parser-enhancements
03:30
Performance enhancement to the tokenizer. check-in: 6ea2df86 user: drh tags: parser-enhancements
00:02
Remove an unused non-terminal from the grammar. check-in: 3c37c522 user: drh tags: parser-enhancements
2015-11-09
19:35
Fix a comment typo in the lempar.c template that was missed by the prior check-in. check-in: c4a7e93f user: drh tags: parser-enhancements
19:33
Change the parser to use the standard "lempar.c" template over in the tool/ folder rather than the customized "lempar.c" found in src/. check-in: 0a72991f user: drh tags: parser-enhancements
15:06
Avoid recursion in the yy_find_shift_action() routine of the Lemon-generated parser, so that routine can be inlined, for a size reduction and performance increase. check-in: 0557a179 user: drh tags: trunk
14:11
Size reduction and performance improvement in the stack-popping logic of the Lemon-generated parser. check-in: 9748c48a user: drh tags: trunk
12:47
Fix incorrect WHERE clause in sqldiff, as reported on the mailing list by Youcef Hilem. check-in: e0ed4c3e user: drh tags: trunk
12:44
Check in the cg_anno.tcl and run-speed-test.sh scripts, as an historical record. check-in: 836418d3 user: drh tags: trunk
12:33
Avoid unnecessary function prologues in the sqlite3VdbeAddOp3() routine. check-in: 7c6a19ba user: drh tags: trunk
02:08
Small size reduction and performance increase in the parser. check-in: d62cd757 user: drh tags: trunk
2015-11-07
18:32
Enhance the sqldiff utility to deal gracefully with ALTER TABLE ADD COLUMN. check-in: 7ea036ac user: drh tags: trunk
18:07
Fix a bug in CTE handling discovered by LibFuzzer that can cause an infinite loop in the query planner. check-in: 088009ef user: dan tags: trunk
17:51
Add test cases for WITH clauses. Closed-Leaf check-in: e7e65c75 user: dan tags: infinite-with-loop-bug
17:48
Proposed fix for an infinite loop bug in the WITH clause semantic analysis logic. check-in: 028475cb user: drh tags: infinite-with-loop-bug
15:19
Enhance TreeView to show WITH clauses. Add an assert to detect the infinite loop behavior when certain kinds of errors occur on a nested WITH clause. check-in: 2040d88e user: drh tags: infinite-with-loop-bug
01:57
Merge recent enhancements and fixes from trunk. check-in: 5429f99b user: drh tags: apple-osx
01:33
Merge recent enhancements and bug fixes from trunk. check-in: 78bc42e6 user: drh tags: sessions
01:19
The OPFLAG_SEEKEQ optimization is only applicable to equality comparisons against an index, not against a rowid table. check-in: 0f5b147d user: drh tags: trunk
00:51
Fix a harmless sanitizer warning in the ieee754 extension. check-in: dd9a26ec user: drh tags: trunk
2015-11-06
20:22
Avoid an unnecessary key comparison when doing an indexed lookup against an equality constraint. check-in: d741e1cc user: drh tags: trunk
20:13
Work around a sign-extension bug in the optimizer on the HP C compiler that comes with HP/UX. check-in: 46c36b15 user: drh tags: trunk
20:04
Test changes: Omit numindex1.test from valgrind, since valgrind uses a none-standard floating-point processor which gives inconsistent answers. Run one releasetest.tcl module using LONGDOUBLE_TYPE=double. check-in: d421efbf user: drh tags: trunk
19:53
Enforce consistent comparison results between integer and floating point values. Fix for ticket [38a97a87a6e4e83]. check-in: 849e686d user: drh tags: trunk
17:59
Merge the fixes and tests for the ieee754 extension. Closed-Leaf check-in: 7a9988d3 user: drh tags: int-float-precision
17:28
A proposed patch for working around a bug in the optimizer for the HP compiler found on HP/UX Itanium. Closed-Leaf check-in: 8a171548 user: drh tags: hp-optimizer-fix
17:01
Test cases for the ieee754 extension. check-in: 840cbda8 user: drh tags: trunk
14:59
A different approach to handling integer/float comparisons. This seems to work better on systems where "long double" and "double" are the same type, but still needs refinement and testing. check-in: a3f7614b user: drh tags: int-float-precision
12:50
Have fts5 load its configuration from the xConnect() method is invoked. This ensures that the very first query run uses the correct value of the 'rank' option. check-in: 33e6606f user: dan tags: trunk
04:14
More test cases for indexes on large numeric values. check-in: c220741a user: drh tags: int-float-precision
03:37
Some simple test cases from the mailing list. check-in: 1d642b73 user: drh tags: int-float-precision
01:04
Increase the precision of integer vs. floating-point comparisons. Candidate fix for ticket [38a97a87a6e4e8]. check-in: cfcaa0ff user: drh tags: int-float-precision
2015-11-05
22:30
Improvements and simplifications to the equality seek logic. Tests are adjusted so that they all pass now. Closed-Leaf check-in: 997ce6c9 user: drh tags: seekeq-experiment
21:49
Fix typo in help information for an FTS5 script. check-in: 777ae800 user: mistachkin tags: trunk
20:25
The top of an index equality loop normally starts with OP_SeekGE and OP_IdxGT. This check-in adds a flag to OP_SeekGE such that it fails immediately if the key is not equal, then jumps over the OP_IdxGT, saving a call to the key comparison functions. Consider this check-in a proof-of-concept. It needs improvement before going on trunk. Some tests fail, but only because they new use fewer key comparisons than expected (which is a good thing!). check-in: 32e31b9b user: drh tags: seekeq-experiment
18:09
Add the 'hashsize' configuration option to fts5, for configuring the amount of memory allocated to the in-memory hash table while writing. check-in: 44548009 user: dan tags: trunk
11:47
Remove a #pragma used to work around an issues with MSVC 2012 that has been overcome but subsequent changes. check-in: 8303e4cf user: drh tags: trunk
03:26
Remove #pragma that was used to work around an obsolete issue with MSVC 2012. Closed-Leaf check-in: b9b22fae user: mistachkin tags: reoptimizeArm
2015-11-04
22:31
Performance improvements in the getAndInitPage() routine of btree.c. check-in: 2aa50f6f user: drh tags: trunk
20:22
Rename the sqlite3PagerAcquire() function to sqlite3PagerGet(). The former macro called sqlite3PagerGet() has been removed. check-in: 708253be user: drh tags: trunk
16:34
In releasetest.tcl, run larger test first if --jobs is greater than 1. Run smaller tests cases first if --jobs is 1. check-in: 3fece5d0 user: drh tags: trunk
13:03
Exclude cffault.test and symlink.test from the (incompatible) inmemory_journal permutation. check-in: 4f16e968 user: drh tags: trunk
2015-11-03
23:39
Increase the fuzzcheck timeout when running valgrind. check-in: a5816877 user: drh tags: trunk
19:13
In 'e_uri.test', make sure all created test database files get deleted. check-in: 40c4f4a6 user: mistachkin tags: trunk
15:39
In the releasetest.tcl script, add the --progress option to cause the start of each subprocess to be shown. Otherwise, revert to the old-style display. Improvements to the handling of the --buildonly option. check-in: d969792f user: drh tags: trunk
15:16
In the releasetest.tcl script, show the --jobs object on the command-line summary. Report the time of each "starting:" event. Do not show errors on a --dryrun. check-in: b7510777 user: drh tags: trunk
14:49
Update the releasetest.tcl script so that it can run multiple tests in parallel in separate processes. check-in: e3de8291 user: drh tags: trunk
06:23
Further enhancement and a bit of cleanup. Closed-Leaf check-in: 0d8b5978 user: mistachkin tags: mp-releasetest
02:47
Use the native name for the MSVC makefile as well. check-in: e457c615 user: mistachkin tags: mp-releasetest
2015-11-02
23:29
Attempt to centralize and simplify the MSVC handling. check-in: 4ae96d6d user: mistachkin tags: mp-releasetest
23:21
Fix the backcompat.test module so that it does not try to compare against itself on windows. check-in: f625bce8 user: drh tags: mp-releasetest
21:05
Get things working better on Windows with MSVC. check-in: 22cc3e6c user: mistachkin tags: mp-releasetest
20:52
Fix the --dryrun option on the releasetest.tcl script. check-in: e565e026 user: dan tags: mp-releasetest
20:28
Fix releasetest.tcl so that it does not choke if a test fails so badly that there is no log file. Add the --jobs switch to the usage message. check-in: 20e96f52 user: dan tags: mp-releasetest
20:24
Fix releasetest.tcl so that output lines are less than 80 characters wide. check-in: aef177fe user: dan tags: mp-releasetest
18:57
Merge all recent enhancements and fixes from trunk. check-in: 0546d1cd user: drh tags: sessions
18:32
Add the "--jobs N" option to the releasetest.tcl script to allow tests to be run in parallel by N processes. N defaults to 1. check-in: 3d29f912 user: dan tags: mp-releasetest
15:10
Merge latest trunk changes, including the follow-symlinks functionality and 3.9.2 bugfixes, into this branch. check-in: 447521d7 user: dan tags: apple-osx
15:08
On unix, if a file is opened via a symlink, create, read and write journal and wal files based on the name of the actual db file, not the symlink. check-in: 6d5ce3ed user: dan tags: trunk
2015-11-01
21:19
If a table-constraint PRIMARY KEY lists a single column in single-quotes and that column has type INTEGER, then make that column an integer primary key, for historical compatibility. Fix for ticket [ac661962a2aeab3c331]. check-in: db319a03 user: drh tags: trunk
2015-10-31
17:58
On unix, if a file is opened via a symlink, create, read and write journal and wal files based on the name of the actual db file, not the symlink. Closed-Leaf check-in: c7c81050 user: dan tags: follow-symlinks
2015-10-30
20:54
Add mutex operations to test code in test3.c to avoid triggering assert() failures in certain configurations. check-in: 9f19420b user: dan tags: trunk
17:17
Merge the sqlite3_db_cacheflush() enhancements and other changes from trunk. check-in: f2cde4cf user: drh tags: begin-concurrent
16:50
Merge all the latest enhancements from trunk. check-in: 395a153f user: drh tags: sessions
16:37
Merge the 3.10.0 version number update from trunk. check-in: 980d6207 user: drh tags: apple-osx
16:36
Increase the version number to 3.10.0, due to the addition of the sqlite3_db_cacheflush() interface. check-in: 7565b046 user: drh tags: trunk
16:23
Merge latest trunk changes, including sqlite3_db_cacheflush(), with this branch. check-in: 6e4306ef user: dan tags: apple-osx
16:14
Add new API function sqlite3_db_cacheflush(). check-in: ad80d307 user: dan tags: trunk
14:28
Return immediately if sqlite3PagerWrite() is called when the pager is in PAGER_ERROR state. Closed-Leaf check-in: a6695b00 user: dan tags: cacheflush
14:25
Add the --enable-editline option to various autoconf scripts. check-in: 866f0277 user: drh tags: trunk
09:13
Test that calling sqlite3_db_cacheflush() does not interfere with savepoints. check-in: 0e09e4a2 user: dan tags: cacheflush
2015-10-29
21:11
Do not attempt to flush the pages of an in-memory database to disk if sqlite3_db_cacheflush() is called. check-in: 9b79a390 user: dan tags: cacheflush
20:57
Add a test case that calls sqlite3_db_cacheflush() on an in-memory database. check-in: f0cdfb54 user: dan tags: cacheflush
18:16
Avoid automatically rolling back the transaction if an SQLITE_IOERR or SQLITE_FULL error occurs within sqlite3_db_cacheflush(). check-in: 370b5d52 user: dan tags: cacheflush
14:29
The optimization on this branch is logically incorrect. It changes the return value of "SELECT 0 OR 'xyzzy'" FROM 0 to 'xyzzy'. Closed-Leaf check-in: a0c08d26 user: drh tags: simplify-or-clause
13:48
Fix uses of ctype functions (ex: isspace()) on signed characters in test programs and in some obscure extensions. No changes to the core. check-in: 34eb6911 user: drh tags: trunk
12:27
Apply optimizations to simplify OR clauses that contain constant terms. check-in: d533e23f user: drh tags: simplify-or-clause
01:11
Enhance comments in the MSVC batch build tool. check-in: 2964ce25 user: mistachkin tags: trunk
2015-10-28
20:01
Make the internal sqlite3PExpr() interface responsive to the TKFLG_DONTFOLD flag on the operator parameter. check-in: b10ab59f user: drh tags: trunk
19:46
Add experimental API sqlite3_db_cacheflush(). check-in: 65b86dc1 user: dan tags: cacheflush
16:05
Factor out adding NOT expression nodes in the parser into a subroutine. check-in: 00185418 user: drh tags: trunk
2015-10-27
20:04
Have contentless and external content fts5 tables ignore "OR REPLACE" conflict handling. check-in: a85c2a47 user: dan tags: trunk
17:48
Fix problems with prefix queries in fts5. check-in: 3b5758c6 user: dan tags: trunk
13:35
Provide hints to the storage engine using the sqlite3BtreeCursorHint() interface when compiling with SQLITE_ENABLE_CURSOR_HINTS. check-in: 45d3539e user: drh tags: trunk
13:24
Split out sqlite3BtreeCursorHintFlags() from sqlite3BtreeCursorHint() the interface for improved performance. Closed-Leaf check-in: b3ec9a0d user: drh tags: cursor-hints
2015-10-26
20:11
Merge the BTREE_FORDELETE enhancement with this branch. check-in: 20da0849 user: dan tags: cursor-hints
18:51
Merge in all trunk changes prior to the BTREE_FORDELETE enhancement. check-in: 53d5a4ad user: drh tags: cursor-hints
2015-10-16
20:53
Merge recent enhancements from trunk. Version now 3.9.1. check-in: 26fa091d user: drh tags: cursor-hints
2015-10-14
20:09
Merge in all the 3.9.0 updates from trunk. check-in: 29444149 user: drh tags: cursor-hints
2015-09-24
15:06
Merge trunk changes into the cursor-hints branch. check-in: fbe63762 user: drh tags: cursor-hints
2015-09-15
17:31
Merge enhancements from trunk. check-in: 66fe0683 user: drh tags: cursor-hints
2015-09-03
14:39
Merge enhancements from trunk. check-in: 25ee3000 user: drh tags: cursor-hints
2015-09-01
18:31
Merge enhancements from trunk. check-in: 29570a60 user: drh tags: cursor-hints
2015-08-20
23:45
Merge recent enhancements from trunk, including table-valued expressions. check-in: b9927c87 user: drh tags: cursor-hints
2015-08-18
15:58
Provide hints for all terms in a range constraint if there are any equality terms anywhere in the constraint. Range constraint terms are only omitted for a pure range constraint with no equality prefix. check-in: b5897bc0 user: drh tags: cursor-hints
2015-08-17
17:19
Avoid generating hints using constraints that are also used to initialize the cursor, since presumably the cursor already knows about those constraints. check-in: 142b048a user: drh tags: cursor-hints
2015-08-15
00:51
Change the display of the P4 operand of CursorHint in EXPLAIN output to function notation. check-in: bee73d42 user: drh tags: cursor-hints
2015-08-14
23:57
Always provide the BTREE_BULKLOAD hint, even when SQLITE_ENABLE_CURSOR_HINTS is not defined, as that hint gives a 4% performance increase. check-in: 83a84435 user: drh tags: cursor-hints
20:08
Updated testing of cursor-hints. Remove the test_cursorhint.c file and associated logic in the core and do tests based purely on the newly enhanced EXPLAIN output. check-in: bf383e66 user: drh tags: cursor-hints
18:50
Fix the cursor hint mechanism so that it does the right thing for indexed lookups. check-in: 581e3d49 user: drh tags: cursor-hints
15:05
Refactor the sqlite3BtreeCursorHint() interface for improved maintainability. check-in: fc3fb5cd user: drh tags: cursor-hints
01:03
Fix the CursorHint so that it includes the scan boundary constraints. On the expression text for the CursorHint opcode, show rowid correctly. check-in: f0d428d1 user: drh tags: cursor-hints
2015-08-13
21:38
Fix a harmless compiler warning. check-in: 608ab4ac user: drh tags: cursor-hints
21:32
Convert the hint expression of the CursorHint opcode into a string for display by EXPLAIN. check-in: 20688471 user: drh tags: cursor-hints
20:34
Fix a bug in sqlite3ExprContainsSubquery(). check-in: be254715 user: drh tags: cursor-hints
20:07
Merge in all the trunk changes from the previous year. This breaks the cursor-hint mechanism, but provides a baseline for trouble-shooting. check-in: 82a7a61b user: drh tags: cursor-hints
18:26
Add the sqlite3rbu_savestate() function to the rbu extension. To force rbu to save its state to disk without closing the sqlite3rbu* handle. check-in: 851a875a user: dan tags: trunk
11:46
Avoid invoking system call unlink() directly from RBU code. Use the xDelete method of the default VFS instead. check-in: ee966af8 user: dan tags: trunk
2015-08-12
15:36
Minor optimization for fts5 API xInst(). check-in: efb7c9c5 user: dan tags: trunk
12:11
Add the xPhraseFirst() and xPhraseNext() fts5 APIs, for faster iteration through a single phrases position list. Also optimize xInst() and xInstCount() a bit. check-in: f7682435 user: dan tags: trunk
2015-08-11
14:25
Merge fixes from the fts5NoWarn branch. check-in: 61cb2fc6 user: dan tags: trunk
2015-08-08
23:30
Fix compiler warnings and remove unreachable code. check-in: fd5608fb user: drh tags: trunk
23:23
Fix an assert() that was in the wrong spot. Closed-Leaf check-in: 962b6cd6 user: drh tags: warnings
22:47
Fix compiler warnings and remove unreachable code. check-in: be190fe7 user: drh tags: warnings
15:13
Update RBU to avoid repreparing a statement immediately after it is prepared. check-in: 1d75a41b user: dan tags: trunk
2015-08-07
20:57
Enhance the query planner so that it is able to use partial indexes that use AND-connected terms in the WHERE clause. check-in: 06576590 user: drh tags: trunk
20:06
Add a specially formatted comment to shell.c to make it easier for scripts to edit. No code changes. check-in: 6d47b35a user: dan tags: trunk
2015-08-06
12:54
increase the version number to 3.8.12 check-in: e596a6b6 user: drh tags: trunk
03:19
Fix harmless compiler warnings in FTS5 code. Closed-Leaf check-in: 0ddb2532 user: mistachkin tags: fts5NoWarn
03:09
Fix duplicate test numbering in the FTS5 matchinfo tests. check-in: 483ebe89 user: mistachkin tags: trunk
2015-08-05
19:35
Add tests for the matchinfo-like test function. Fix problems found in test and fts5 code by doing so. check-in: 9e3aafe4 user: dan tags: trunk
15:29
Update the spellfix virtual table extension so that an explicit "top = ?" constraint works even if there is also a "distance < ?" or "distance <= ?" constraint. check-in: 08888383 user: dan tags: trunk
08:01
Fix some problems in test code detected by cppcheck. check-in: c9ff4ca4 user: dan tags: trunk
07:43
Remove all references to "docid" within fts5 source code and comments. Replace with "rowid". check-in: dffd358f user: dan tags: trunk
2015-08-04
20:29
Add new test file fts5_test_mi.c, containing an implementation of a function similar to FTS4 matchinfo() for FTS5. check-in: 4f9520a9 user: dan tags: trunk
19:06
Improve the usage comment on sqlite3_analyzer: show the available switches. check-in: 783f78e3 user: drh tags: trunk
15:29
Update the [showdb] program so that the database file is read directly (bypassing the SQLite VFS) only if the --raw option is specified. Otherwise, it is read using the default VFS. Also, the URI syntax may be used on the command line to specify the name of the database file to examine, so an alternative VFS may be requested using a URI parameter. check-in: e3c6d4b6 user: dan tags: trunk
15:23
Update the [showdb] program so that the database file is read directly (bypassing the SQLite VFS) only if the --raw option is specified. Otherwise, it is read using the default VFS. An alternative VFS may be specified by specifying the database file to open using the URI syntax. Closed-Leaf check-in: 9699e9bd user: dan tags: showdb-uri-option
14:18
In the sqlite3_analyzer.exe utility, show the depth of each btree and report the average fanout of indexes and WITHOUT ROWID tables. check-in: cd997770 user: drh tags: trunk
2015-08-03
17:03
Add the "--uri" option to utility program "showdb". This option causes showdb to use sqlite with the SQLITE_OPEN_URI option to open the database file, instead of opening it directly using the OS open() function. check-in: 90e34d51 user: dan tags: showdb-uri-option
13:44
Allow a VIEW to reference undefined tables and functions when initially created. The error report is deferred until the VIEW is used. This allows views to be created before subviews and tables that the view references. check-in: 70b57daf user: drh tags: trunk
2015-08-01
18:18
Add extra tests for RBU and FTS3/4. check-in: 34190449 user: dan tags: trunk
2015-07-31
19:52
Add support for "fossil deltas" to RBU and "sqldiff --rbu". check-in: e26ef165 user: dan tags: trunk
18:59
Fix the sqlite3_stmt_busy() interface so that it always returns FALSE after the statement has returned SQLITE_DONE, even for ROLLBACK statements. Clarify the documentation. check-in: 047d3475 user: drh tags: trunk
17:48
Remove a duplicate "typedef struct Fts5Global Fts5Global;" from fts5_main.c (duplicate is in fts5Int.h). check-in: 54a771fe user: dan tags: trunk
15:14
When building the VSIX package for UAP, omit the AppLocal suffix for the MSVC runtime library because it is no longer needed. check-in: fee7ad73 user: mistachkin tags: trunk
15:13
Fix a problem causing [sqldiff --rbu] to fail on tables for which all columns are part of the PRIMARY KEY. check-in: 93449e70 user: dan tags: trunk
14:43
Fix a bug in the fts5 porter tokenizer preventing it from passing xCreate() arguments through to its parent tokenizer. check-in: c3c672af user: dan tags: trunk
2015-07-30
20:26
Add the --rbu switch to the "sqldiff" utility. check-in: 098bea26 user: dan tags: trunk
11:38
Allow RBU tables to be named "data[0-9]*_<target>" instead of strictly "data_<target>". Also update RBU so that it always processes data tables in order sorted by name. check-in: 287aa306 user: dan tags: trunk
11:26
Return an error message (instead of segfaulting) if test function fts5_expr() is invoked with no arguments. check-in: 8e818b89 user: dan tags: trunk
2015-07-29
22:38
Support building VSIX packages for UAP using Visual Studio 2015 and the Windows 10 SDK. check-in: 96559adb user: mistachkin tags: trunk
22:37
Update Windows 10 SDK version for RTM. Closed-Leaf check-in: 80ab338c user: mistachkin tags: msvc2015
21:47
Add SQLITE_DISABLE_INTRINSIC define to disable use of intrinsic functions (e.g. for certain older compilers and/or platforms). check-in: f0075d73 user: mistachkin tags: trunk
20:24
Fix the releasetest.tcl script so that it ignore cast overflow errors that recent versions of clang generate but which are unavoidable given the test input. check-in: a0020c57 user: drh tags: trunk
20:00
Version 3.8.11.1 check-in: cf538e27 user: drh tags: trunk, release, version-3.8.11.1
15:22
Restore an undocumented side-effect of PRAGMA cache_size: it forces the database schema to be parsed. Also increase the version number to 3.8.11.1. check-in: e4628de3 user: drh tags: trunk
14:58
Update comments in fts5.h describing the xColumnCount() API function. check-in: a623eb55 user: dan tags: trunk
14:46
Increase the version number to 3.8.11.1 Closed-Leaf check-in: 326d746d user: drh tags: branch-3.8.11
14:10
The "PRAGMA cache_size" reads the database schema, as it has done in all prior versions of SQLite. This side-effect of cache_size is undocumented, but apparently it does get used and its absence from 3.8.11 was causing problems. check-in: 4489722a user: drh tags: branch-3.8.11
2015-07-28
19:35
Update batch build tool library paths for MSVC 2015. check-in: d431d4e1 user: mistachkin tags: msvc2015
18:53
Fix the xfer optimization for WITHOUT ROWID tables so that it correctly updates the change count returned by sqlite3_changes(). check-in: eff43715 user: drh tags: trunk
2015-07-27
19:57
Clarification to the documentation for sqlite3_result_zeroblob64(). No changes to code. check-in: c98175e9 user: drh tags: trunk
13:49
Version 3.8.11 check-in: b8e92227 user: drh tags: trunk, release, version-3.8.11
12:19
Merge the fts5-btree-index branch with this one. FTS5 changes only. check-in: 9f1dcdc3 user: dan tags: trunk
11:49
Bump the "version" field in the fts5 config table. Closed-Leaf check-in: 92c91789 user: dan tags: fts5-btree-index
11:43
Minor tweak to the SQL schema used by fts5. check-in: 427bf09b user: dan tags: fts5-btree-index
11:01
Remove a potentially undefined behaviour involving signed integers and bitshift operations from fts5_hash.c. check-in: ad6286ab user: dan tags: fts5-btree-index
10:46
Merge latest trunk changes with this branch. check-in: 5ec933c2 user: dan tags: fts5-btree-index
2015-07-25
19:26
Remove a duplicated "if" condition from fts3.c. check-in: ee348b12 user: dan tags: trunk
14:26
Fix the rowallock.test script so that it works with builds that do not support mmap mode. check-in: 7efed578 user: dan tags: trunk
14:12
Fix the wal3.test module so that it works with the memsubsys1 permutation. check-in: af85b01d user: drh tags: trunk
12:03
Fix a test script problem in memsubsys2.test. check-in: 70885729 user: dan tags: trunk
03:10
Disable the page cache bulk allocation for the shrink.test and wal.test modules. check-in: 3418f1f1 user: drh tags: trunk
2015-07-24
23:28
Fix the zeroblob.test script so that it works even on builds where the SQLITE_MAX_LENGTH has been raised to 2147483645. check-in: db129149 user: drh tags: trunk
21:19
Enable the RBU extension to compile cleanly on Windows using MSVC. check-in: cca79fdc user: mistachkin tags: trunk
20:43
For Windows CE, a different header is required for the byteswap intrinsics. check-in: 2d572b8c user: mistachkin tags: trunk
20:34
Fix warnings in fts5 code. check-in: bd4f156d user: dan tags: trunk
19:56
Fix the pragma2.test module so that it works with SQLITE_ENABLE_MEMORY_MANAGEMENT. check-in: de281a4f user: drh tags: trunk
18:58
Allow the RBU module to read data from appropriately named SQL views created within the RBU database. check-in: 45c6a760 user: dan tags: trunk
18:22
Fix a test script bug introduced by [562687d9]. check-in: a343745d user: dan tags: trunk
17:36
Add the sqlite3_bind_zeroblob64() API. check-in: 1997ee54 user: dan tags: trunk
17:26
New makefile target "fastfuzztest" runs the same tests as "fuzztest" but with a 100M memory size limit. This more than doubles the speed. The original unlimited "fuzztest" is still run on a "fulltest". check-in: cfeb1b1c user: drh tags: trunk
17:14
Fix compiler warnings. Get the new sqlite3_result_zeroblob64() working on loadable extensions. check-in: f8991e6f user: drh tags: trunk
16:24
Add the sqlite3_result_zeroblob64() API. Use it in the SQL zeroblob() function. check-in: c6445b9f user: dan tags: trunk
15:49
More robust handling of zeroblob() with oversized arguments. Fix fuzzcheck so that it can be run with limited heap memory. check-in: 4e3e516a user: drh tags: trunk
14:17
Modify a few test scripts to avoid leaving the sqlite3Config structure in a non-default state. check-in: 562687d9 user: dan tags: trunk
00:02
Update RBU description comment in the header file. No changes to code. check-in: 119883a2 user: mistachkin tags: trunk
2015-07-23
20:44
Change the name of the OTA extension to RBU: Resumable Bulk Update. check-in: 017c5019 user: drh tags: trunk
17:16
When SQLITE_OMIT_LOOKASIDE is set, do not allocate any lookaside memory since it will never be used. check-in: 0ffd499f user: drh tags: trunk
16:39
The sqlite3ExprCodeGetColumn() is not guaranteed to put the result in the register requested. Fix the skip-scan code generator for WITHOUT ROWID tables so that it always checks the register and copies the result if it lands in the wrong register. Fix for ticket [8fd39115d8f46ece70e7d4b3]. check-in: 793e206f user: drh tags: trunk
2015-07-21
19:22
Fix harmless compiler warning in MSVC 2015. check-in: 01c8b9cc user: mistachkin tags: trunk
2015-07-19
19:53
Cleanup the 'config.h' file in the appropriate distclean targets. check-in: e0a99780 user: mistachkin tags: trunk
2015-07-17
12:42
More adjustments to the malloc5.test module so that it works correctly with the new pcache1 bulk allocation. check-in: 2a7b3a44 user: drh tags: trunk
01:16
Avoid a harmless compiler warning. check-in: 2288842b user: drh tags: trunk
2015-07-16
20:24
Merge trunk changes, including fixes for compiler warnings in fts5 code, with this branch. check-in: 7190d79b user: dan tags: fts5-btree-index
20:17
Fix compiler warnings in fts5 code. check-in: e9bf275c user: dan tags: trunk
18:37
Fix harmless compiler warnings. check-in: 9a592cf9 user: drh tags: trunk
18:18
Defer the bulk pcache1 memory allocation until the first page allocation request. Limit the size of the pcache1 bulk allocation to the cache_size setting. Deallocate the bulk allocation on a sqlite3_db_release_memory() request, if the bulk allocation is completely unused. check-in: b79a4aff user: drh tags: trunk
17:29
Fix compilation issues with SQLITE_OMIT_COMPOUND_SELECT defined. check-in: 9c39d464 user: mistachkin tags: trunk
2015-07-15
23:15
Enable memory-mapped I/O on FreeBSD and DragonFly. check-in: 2cdd6479 user: drh tags: trunk
21:00
Make the debugging line numbers in the amalgamation more accurate. check-in: 3b34e95c user: mistachkin tags: trunk
19:46
Use a WITHOUT ROWID table to index fts5 btree leaves. This is faster to query and only slightly larger than storing btree nodes within an intkey table. check-in: 862418e3 user: dan tags: fts5-btree-index
18:35
Fix some harmless compiler warnings. check-in: 110cd84f user: drh tags: trunk
18:04
Attempt to fix harmless warnings generated by GCC and Clang runtime analyzers. check-in: b522c95d user: drh tags: trunk