/ 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 [23722be4]

2016-04-21
15:35
Merge all recent enhancements from trunk. check-in: a15c49ae user: drh tags: apple-osx
2016-03-29
10:30
Merge 3.12.0 changes. check-in: eef55744 user: drh tags: apple-osx
2016-03-21
14:52
Merge the sqlite3_system_errno() change from trunk. check-in: 063f1b37 user: drh tags: apple-osx
2016-03-19
00:40
Fix a VDBE register allocation bug exposed by recent enhancements to PRAGMA integrity_check. check-in: c73b5b9c user: drh tags: apple-osx
2016-03-18
11:03
Test case tweaks to better support the Apple configuration options. check-in: cb0ffe84 user: drh tags: apple-osx
00:58
Merge recent enhancements from trunk. check-in: ec052b4f user: drh tags: apple-osx
2016-03-16
01:09
Merge the SQLITE_OMIT_CODEC_FROM_TCL compile-time option from trunk. check-in: 161d91e4 user: drh tags: apple-osx
2016-03-15
12:45
Merge updates from trunk - FTS5 fixes and enhancemenets to the tests scripts so that they work with SEE. check-in: f41a7361 user: drh tags: apple-osx
2016-03-08
16:35
Merge changes from trunk, especially the SQLITE_DEFAULT_SYNCHRONOUS enhancements. check-in: 29741941 user: drh tags: apple-osx
14:01
Merge coverage improvements and comment fixes from trunk. check-in: 58023bfc user: drh tags: apple-osx
2016-03-07
21:28
Fix a typo and remove an unused variable from test logic. check-in: 9f31516c user: drh tags: apple-osx
20:48
Merge recent enhancements from trunk. check-in: 84f09f00 user: drh tags: apple-osx
2016-03-04
14:57
Merge recent enhancements from trunk, and especially the changes that reduce the heap-memory footprint of schemas, and defer opening and writing to statement journals. check-in: 2f0c195c user: drh tags: apple-osx
2016-02-26
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
2016-02-22
16:32
Merge the master-journal optimization and other recent changes from trunk. check-in: 18c3ab47 user: drh tags: apple-osx
2016-02-18
14:53
Merge the tokenizer buffer overrun bug-fix from trunk. check-in: 82e7e31b user: drh tags: apple-osx
01:36
Merge recent performance enhancements and the enhanced API_ARMOR from trunk. check-in: b7fa0fb3 user: drh tags: apple-osx
01:22
Memory leak associated with SQLITE_WRITE_WALFRAME_PREBUFFERED check-in: 7bcd3ab5 user: drh tags: apple-osx
2016-02-15
17:40
Merge 3.11.0 changes. check-in: 5cecc509 user: drh tags: apple-osx
2016-02-13
17:35
Merge changes from the 3.11.0 release candidate. check-in: d198a6db user: drh tags: apple-osx
2016-02-09
15:50
Merge recent fixes and enhancements from trunk. check-in: f0734017 user: drh tags: apple-osx
2016-02-05
14:29
Merge OOM handling optimizations and PRAGMA synchronous=EXTRA as well as other enhancements from trunk. check-in: 201fcbee user: drh tags: apple-osx
2016-02-02
02:30
Merge recent enhancements from trunk. check-in: e6a4a163 user: drh tags: apple-osx
2016-01-20
11:40
Merge all recent enhancements from trunk. check-in: 3ed49691 user: drh tags: apple-osx
2016-01-14
15:03
Merge the latest enhancements and fixes from trunk. check-in: d85774e0 user: drh tags: apple-osx
2016-01-11
13:03
Import the version number change to 3.11.0. check-in: 132772d1 user: drh tags: apple-osx
12:49
Merge enhancements from trunk, and in particular the WAL overwrite feature. check-in: 79125ec9 user: drh tags: apple-osx
2016-01-06
14:35
Merge all version 3.10.0 updates. check-in: 77c28c2b user: drh tags: apple-osx
2016-01-01
13:31
Merge all recent trunk enhancements. check-in: 5b700f31 user: drh tags: apple-osx
2015-12-11
12:53
Merge recent trunk enhancements, and in particular the snapshot interface. check-in: 7e7b2406 user: drh tags: apple-osx
2015-12-02
20:22
Merge all recent trunk enhancements, especially the unix VFS changes. check-in: e1fb33c7 user: drh tags: apple-osx
2015-11-19
19:48
Merge the latest enhancements from trunk. check-in: 2c9e5436 user: drh tags: apple-osx
2015-11-13
02:13
Merge fixes from trunk. check-in: f9060b2a user: drh tags: apple-osx
2015-11-12
21:55
Import the test_sqllog.c enhancements from trunk. check-in: 178da339 user: drh tags: apple-osx
16:51
Merge the latest enhancements from trunk, and in particular the "PRAGMA cache_spill=N" change. check-in: e72331c7 user: drh tags: apple-osx
2015-11-07
01:57
Merge recent enhancements and fixes from trunk. check-in: 5429f99b user: drh tags: apple-osx
2015-11-02
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
2015-10-30
16:37
Merge the 3.10.0 version number update from trunk. check-in: 980d6207 user: drh tags: apple-osx
16:23
Merge latest trunk changes, including sqlite3_db_cacheflush(), with this branch. check-in: 6e4306ef user: dan tags: apple-osx
2015-10-26
20:50
Merge latest trunk changes, including the SQLITE_IOERR_AUTH error code, with this branch. check-in: bc195e1c user: dan tags: apple-osx
2015-10-16
20:52
Merge the 3.9.1 changes. check-in: dd07688d user: drh tags: apple-osx
2015-10-13
17:49
Merge 3.9.0 prerelease changes into the apple-osx branch. check-in: 1900ce01 user: drh tags: apple-osx
2015-10-09
17:28
Merge all changes through the first 3.9.0 beta from trunk. check-in: 1ccae39b user: drh tags: apple-osx
2015-09-24
14:43
Merge recent trunk enhancements into the apple-osx branch. check-in: 4dd06d8b user: drh tags: apple-osx
2015-09-15
17:20
Merge trunk enhancements into the apple-osx branch. check-in: f12b8a0f user: drh tags: apple-osx
2015-09-03
14:31
Merge enhancements from trunk. check-in: d01658ad user: drh tags: apple-osx
2015-09-01
18:40
Merge the latest trunk enhancements. check-in: 4af79477 user: drh tags: apple-osx
2015-08-28
15:35
Fix a potential segfault in the VFS logic that checks for fail renames out from under SQLite. check-in: 650111f6 user: drh tags: apple-osx
13:27
Disable the read-only WAL-mode database tests on the apple-osx branch because read-only WAL-mode databases are specifically disallowed by Apple-specific changes. check-in: bd911496 user: drh tags: apple-osx
02:12
Merge trunk enhancements into the apple-osx branch. Most tests works, but there are yet a few issues to be resolved. check-in: da864658 user: drh tags: apple-osx
2015-08-11
18:18
Fix the retry mechanism on file locks. check-in: 600df309 user: drh tags: apple-osx
2015-04-20
01:25
Merge all recent trunk enhancements and fixes into the apple-osx branch. check-in: 74b7bf17 user: drh tags: apple-osx
2015-04-15
13:51
Merge recent trunk fixes and enhancements into the apple-osx branch. check-in: bfc7142a user: drh tags: apple-osx
2015-04-13
23:11
Merge all recent trunk enhances into the apple-osx branch. check-in: e709d3b4 user: drh tags: apple-osx
2015-04-08
12:47
Merge in all version 3.8.9 changes from trunk. check-in: 30121870 user: drh tags: apple-osx
2015-04-06
22:05
Detect and suppress an endless loops in clearDatabasePage() that might result from a corrupt database file. This is an edited cherry-pick from [30011ad2f55c] and [395bb3e677a]. Leaf check-in: e5f5ef00 user: drh tags: apple-osx-385
2015-04-01
16:13
Merge all recent trunk fixes and enhancements into the apple-osx branch. check-in: 71b6f507 user: drh tags: apple-osx
2015-03-30
23:52
Merge the latest trunk enhancements, and especially the fix for the infinite loop on a DROP TABLE in a corrupt database, into the apple-osx branch. check-in: 4d42bf5e user: drh tags: apple-osx
2015-03-24
18:49
Merge the latest trunk enhancements into the apple-osx branch. check-in: a2bd81e5 user: drh tags: apple-osx
2015-03-21
17:00
Merge all recent trunk enhancements and especially the blocking WAL-lock fix into the apple-osx branch. check-in: 9f1f8b33 user: drh tags: apple-osx
2015-03-17
18:35
Merge all recent trunk changes, and in particular the blocking WAL lock change, into the apple-osx branch. check-in: 8abbeadb user: drh tags: apple-osx
2015-03-09
13:18
Merge recent trunk enhancements into the apple-osx branch. check-in: 5e04eec8 user: drh tags: apple-osx
2015-02-25
14:09
Merge the latest trunk fixes and enhancements into the apple-osx branch. check-in: ba8294e2 user: drh tags: apple-osx
2015-02-21
01:03
Merge trunk changes into the apple-osx branch. check-in: 3896e233 user: drh tags: apple-osx
2015-02-19
15:56
Incremental merge to prevent a huge pileup of merge conflicts resulting from editing the same code in two different branches. check-in: 82c4c4e2 user: drh tags: apple-osx
02:43
Move the os_unix.c file closer to trunk. check-in: 57d70240 user: drh tags: apple-osx
2015-02-13
16:42
Enhancements to SQLITE_ENABLE_API_ARMOR merged from trunk. check-in: 5147b94a user: drh tags: apple-osx
12:13
Merge all recent trunk fixes and enhancements into the apple-osx branch. check-in: b2449d67 user: drh tags: apple-osx
2015-02-07
15:30
Merge increment blob I/O fixes from trunk. check-in: 292cf68b user: drh tags: apple-osx
2015-02-06
16:03
Merge all recent trunk enhancements into the apple-osx branch. check-in: 44711921 user: drh tags: apple-osx
2015-01-16
12:24
Merge the 3.8.8 release changes from trunk. check-in: 518621f8 user: drh tags: apple-osx
2015-01-08
19:55
Merge the testing enhancements and the unlimited VALUES enhancement from trunk. check-in: cc780842 user: drh tags: apple-osx
2015-01-02
19:17
Merge the latest changes from trunk into the apple-osx branch. check-in: df3cdf9f user: drh tags: apple-osx
2014-12-16
00:29
Merge latest fixes and enhancements from trunk into apple-osx. check-in: 2c1d8dda user: drh tags: apple-osx
2014-12-09
15:01
Increase the default PMA size from 10 to 250 pages and provide the SQLITE_SORTER_PMASZ compile-time option to change this default. Add needed mutex call when clearing the KeyInfo cache in shared-cache mode. check-in: 6e2da589 user: drh tags: apple-osx
2014-12-05
20:16
Merge the shared-cache KeyInfo fix from trunk. check-in: 8a9b43f9 user: drh tags: apple-osx
00:49
Import compiler warning and autoconf makefile fixes from trunk. check-in: 5437e053 user: drh tags: apple-osx
2014-12-04
23:42
Import from trunk support for SQLITE_CHECKPOINT_TRUNCATE and fixes for a couple of obscure bugs. check-in: 463ad971 user: drh tags: apple-osx
2014-12-02
16:38
Merge all recent enhancements and bug fixes from trunk into the apple-osx branch. check-in: 43c4ba26 user: drh tags: apple-osx
2014-11-18
21:27
Merge recent trunk enhancements. check-in: ccb601f6 user: drh tags: apple-osx
2014-10-31
15:20
Merge all recent trunk enhancements into the apple-osx branch. check-in: fef8430f user: drh tags: apple-osx
2014-10-27
18:42
Merge latest enhancements, including the SQLITE_ENABLE_API_ARMOR patch, from trunk. check-in: 10aaf3b1 user: drh tags: apple-osx
2014-10-17
12:11
Merge the 3.8.7 changes into the apple-osx branch. check-in: aa7bbed1 user: drh tags: apple-osx
2014-10-14
14:17
Merge from trunk recent micro-optimizations and the fix for the DESC index GROUP BY ORDER BY bug. check-in: 880df756 user: drh tags: apple-osx
2014-10-09
11:40
Record the errno on fstat() failures. check-in: 2a6a0820 user: drh tags: apple-osx
11:27
Merge the latest trunk enhancements into the apple-osx branch. check-in: 6fc72077 user: drh tags: apple-osx
2014-10-01
01:46
Merge the latest enhancements from trunk. check-in: 2078454a user: drh tags: apple-osx
2014-09-21
23:08
Merge in all recent changes from trunk. check-in: 3967ebe8 user: drh tags: apple-osx
2014-09-02
15:57
Merge the latest trunk changes into the apple-osx branch. check-in: 696dc935 user: drh tags: apple-osx
2014-08-26
02:02
Merge recent performance enhancements and the CAST operator enhancements into the apple-osx branch. check-in: 5c273111 user: drh tags: apple-osx
2014-08-15
16:10
Merge the 3.8.6 changes into the apple-osx branch. check-in: b91fcb3b user: drh tags: apple-osx
2014-08-14
13:39
Merge the pre-3.8.6 changes from trunk into the apple-osx branch. check-in: 08058df3 user: drh tags: apple-osx
2014-08-06
01:51
Merge 3.8.6 beta changes in from trunk. check-in: b2e01080 user: drh tags: apple-osx
2014-07-30
14:57
Merge in the CREATE UNIQUE INDEX fix of ticket [9a6daf340df99ba93c53bcf]. check-in: fa791232 user: drh tags: apple-osx
11:49
Merge all recent trunk changes, and especially the R-Tree IN operator fix of ticket [d2889096e7bdeac]. check-in: 654c6c65 user: drh tags: apple-osx
2014-07-24
16:43
Merge recent trunk changes into the apple-osx branch. check-in: 3810dc62 user: drh tags: apple-osx
2014-06-30
19:57
Merge the latest trunk changes into the apple-osx branch. check-in: f426876f user: drh tags: apple-osx
2014-06-05
12:53
Merge in the 3.8.5 release changes and the FTS integrity-check fix. check-in: 2dbdfa51 user: drh tags: apple-osx
2014-05-29
20:36
Merge trunk changes into the apple-osx branch. check-in: b9fad449 user: drh tags: apple-osx
2014-05-26
20:08
Merge recent trunk changes into the apple-osx branch. check-in: 54b5fa77 user: drh tags: apple-osx
2014-05-20
00:27
Merge all recent trunk changes into the apple-osx branch. check-in: 23722be4 user: drh tags: apple-osx
2014-05-17
16:56
Internally, use a 64-bit integers for segment level numbers. check-in: 8180e320 user: dan tags: trunk
15:10
Fix a broken test case in fts4growth2.test. check-in: 9fde5b96 user: dan tags: trunk
2014-05-16
23:38
Fix harmless compiler warnings. Closed-Leaf check-in: 7e60347e user: mistachkin tags: ftsWarnings
23:15
Work around compilation issue with MSVC. check-in: 9623a29c user: mistachkin tags: trunk
16:16
Fixes to prevent an FTS index from growing indefinitely as the corresponding table is updated. Change the FTS 'automerge' option to allow the user to specify the number of segments that should be merged simultaneously by auto-merges. check-in: a75f1800 user: dan tags: trunk
15:48
Add extra test to backcompat.test to ensure that old and new versions of FTS may work together on the same incremental merge operation. Closed-Leaf check-in: 3997d47b user: dan tags: fts4-experimental
14:17
Repurpose the SQLITE_TESTCTRL_FAULT_INSTALL test-control to register a callback to be invoked by sqlite3FaultSim(). That test-control has been unused since 2008-06-20 and was never used in any official release. check-in: 0d43a7ad user: drh tags: trunk
10:30
Fix a bug causing an incorrect segment size value to be stored if both an old and new FTS version performed work on the same incremental merge operation. check-in: a9a2aeab user: dan tags: fts4-experimental
2014-05-15
19:05
Merge latest trunk changes with this branch. check-in: 5809986f user: dan tags: fts4-experimental
18:36
Fix a problem with the handling of delete markers by automerge on large databases. check-in: 2b09bd17 user: dan tags: fts4-experimental
2014-05-14
19:49
Do not search for promotable segments following an FTS 'optimize' operation or creation of a new segment on the oldest existing level. check-in: 34f6b4b8 user: dan tags: fts4-experimental
18:45
Fix a problem to do with loading the value of the FTS automerge setting from the database. check-in: 7268119f user: dan tags: fts4-experimental
15:58
Fix various problems to do with segment promotion. Add test file fts4growth2.test, containing tests to check that the FTS index does not grow indefinitely as the table is updated. Allow the user to configure the number of segments merged simultaneously by the automerge option. check-in: 21491a9b user: dan tags: fts4-experimental
2014-05-13
20:11
Fix a problem preventing delete markers from ever being removed from the FTS index. check-in: 7f47ae5c user: dan tags: fts4-experimental
2014-05-12
22:36
Improve a comment in the MSVC makefile. No changes to code. check-in: 0901dcce user: mistachkin tags: trunk
21:12
Add VSIX packaging support for Windows Phone 8.1 using Visual Studio 2013 Update 2. check-in: 013738f3 user: mistachkin tags: trunk
20:04
Experimental code to prevent FTS indexes from growing indefinitely as the table is updated. check-in: b3b505a4 user: dan tags: fts4-experimental
15:37
In mutex_w32.c, make inclusion of the Windows header file dependent on SQLITE_OS_WIN, not SQLITE_MUTEX_W32. check-in: 93ffbcc0 user: mistachkin tags: trunk
2014-05-10
17:33
Merge updates from trunk. Emit the AppliesTo and DependsOn SDK manifest attributes when building the VSIX for Windows Phone 8.1. Closed-Leaf check-in: f6237a5f user: mistachkin tags: vsixWinPhone81
17:28
When using Visual Studio 2013, add the appropriate MaxPlatformVersion attribute to the VSIX SDK manifest. check-in: 0a4f5967 user: mistachkin tags: trunk
2014-05-09
23:31
Further MSVC makefile changes to support Windows Phone 8.1. check-in: a9c81815 user: mistachkin tags: vsixWinPhone81
20:54
Merge updates from trunk. check-in: f4fea7bb user: mistachkin tags: vsixWinPhone81
20:51
When cross-compiling with the MSVC makefile, make sure the correct library path is used. Also, keep track of the required compilation options separately. check-in: c3dce2e7 user: mistachkin tags: trunk
14:56
Fix a misplaced #endif and a C99-ism in the unix VFS. check-in: c8d384d1 user: drh tags: apple-osx
13:27
Fix compiler warnings. When forcing the delete of a WAL file, do not fail if the WAL files does not exist. All "veryquick.tcl" tests are now passing on Linux under the standard compile-time options. check-in: eafd8aa1 user: drh tags: apple-osx
12:18
Fix an incorrect check for API misuse. check-in: 856400dc user: drh tags: apple-osx
11:45
Bring the PRAGMA logic into closer alignment with trunk, and in the process fix a couple of crashes. check-in: d66fe706 user: drh tags: apple-osx
2014-05-08
23:01
Initial attempt to merge in all trunk changes over the previous 1.5 years. This check-in compiles but there are compiler warnings and "make test" segfaults after only running a few test modules. check-in: 9411d7dc user: drh tags: apple-osx
2014-05-07
21:16
Include sqlite3rtree.h in the tsrc/ pile of source files during target_source in the main.mk makefile. check-in: 116bed5a user: drh tags: trunk
20:33
Remove a superfluous variable initialization. check-in: 68766f83 user: drh tags: trunk
20:24
A better fix for the group_concat() problem. check-in: 1c086dee user: drh tags: trunk
19:59
Fix the way parenthesis in MATCH expressions are handled by FTS if the tokenizer considers them to be token characters. check-in: e21bf7a2 user: dan tags: trunk
18:23
Make sure the group_concat() function returns an empty string, not a NULL, if it has at least one input row. Fix for ticket [55746f9e65f8587]. check-in: d01cedaa user: drh tags: trunk
18:21
Ensure that the sqlite3StrAccumAppend() routine is never called with a NULL second argument. Doing so is harmless when N==0, but it causes an assert() to fail that was placed to quiet static analyzers. Closed-Leaf check-in: f03fbf37 user: drh tags: tkt-55746f9e
17:19
Make sure the group_concat() function returns an empty string, not a NULL, if it has at least one input row. Fix for ticket [55746f9e65f8587]. check-in: 0deac873 user: drh tags: tkt-55746f9e
15:46
Add the SQLITE_IOCAP_IMMUTABLE bit as a possible return value from the xDeviceCharacteristics method in the VFS. Add the "nolock" and "immutable" query parameters to URI filenames. check-in: 1a0d7d3d user: drh tags: trunk
15:32
Fix nolock and immutable so that they work even if READONLY is requested. Closed-Leaf check-in: e193aced user: drh tags: win32-none
15:09
Add test cases and documentation for the nolock and immutable query parameters. check-in: 19d56cba user: drh tags: win32-none
2014-05-06
21:37
Merge updates from trunk. check-in: 69698ae9 user: mistachkin tags: vsixWinPhone81
21:37
Update the template VSIX package file as well. check-in: 99d96765 user: mistachkin tags: trunk
21:30
Merge updates from trunk. check-in: 7579c44a user: mistachkin tags: vsixWinPhone81
21:26
Enhance the VSIX package creation tool to better support Visual Studio 2013. check-in: c1fb04f6 user: mistachkin tags: trunk
00:09
Refactor VSIX package creation tool to better support Visual Studio 2013. check-in: 8be166af user: mistachkin tags: vsixWinPhone81
2014-05-05
22:50
Merge updates from trunk. check-in: 668ed76a user: mistachkin tags: vsixWinPhone81
22:43
When building for Windows 8.0 using Visual Studio 2013, make sure the cross-compilation native library path is set correctly. check-in: c1ab9092 user: mistachkin tags: trunk
21:08
More modularization work on the MSVC batch build tool. check-in: 9a06773a user: mistachkin tags: trunk
20:35
Merge updates from trunk. check-in: eaa8fc81 user: mistachkin tags: vsixWinPhone81
20:32
Create new header file "os_setup.h" used to detect the operating system at compile-time, and "os_win.h" that contains windows-specific header in formation. check-in: bd92e0f8 user: drh tags: trunk
20:24
Work on cleaning up the MSVC batch build tool integration with Visual Studio 2013. check-in: b5a72dfd user: mistachkin tags: trunk
20:21
Attempt to fix the build on beagleboard. Closed-Leaf check-in: 3ac75725 user: drh tags: winHdr
18:24
Centralize and reform use of the Win32 related include files. check-in: 857f2baf user: mistachkin tags: winHdr
17:49
Merge updates from trunk. check-in: 6f07f20e user: mistachkin tags: vsixWinPhone81
17:45
Merge updates from trunk. check-in: a3cfd813 user: mistachkin tags: winHdr
17:43
Fix several header file comments. No changes to code. check-in: dd6eb5d1 user: mistachkin tags: winHdr
2014-05-02
22:39
Enhance the Win32 VFS I/O retry logic. check-in: 47605043 user: mistachkin tags: trunk
21:42
Merge updates from trunk. Closed-Leaf check-in: 598a3875 user: mistachkin tags: winIoRetry
21:38
Merge updates from trunk. check-in: c4d1d8a0 user: mistachkin tags: winHdr
14:54
Fix a broken test case in fuzz.test. check-in: faa46935 user: dan tags: trunk
00:09
Add a comment explaining why WhereLoop cost adjustments are omitted for skip-scan loops. check-in: 3bc43594 user: drh tags: trunk
2014-05-01
20:26
Fix an obscure problem to do with temp register allocation that could occur if more than one simple SELECT within a compound SELECT uses a partial sort. check-in: 427409ae user: dan tags: trunk
20:24
Add #ifdefs for test coverage. Add a testcase(). check-in: be2702ce user: drh tags: trunk
10:19
Update a test case in wal2.test that explicitly corrupts a checksum in the wal file to account for the fact that the first byte of said checksum may initially be 0xFF. check-in: 2b935bde user: dan tags: trunk
01:49
Take out the special handling of nolock=true in os_win.c and add it to pager.c, so that it works for all VFSes. Add the pPager->noLock boolean for clarity. check-in: 725c1c14 user: drh tags: win32-none
01:20
Avoid unnecessary xUnlock operations on temp file. check-in: 1829c38c user: drh tags: win32-none
01:13
Add the immutable=TRUE query parameter and SQLITE_IOCAP_IMMUTABLE, either of which prevents locking of the database and omits tests for existance of journal files. check-in: 71f152c8 user: drh tags: win32-none
2014-04-30
20:32
Merge in all recent changes and enhancements from trunk. check-in: 84243f84 user: drh tags: win32-none
18:11
Fix a problem in calculating the costs of "OR" scans. check-in: 9bbca48b user: dan tags: trunk
15:22
Modify the way the costs of various query plans are estimated. If the user supplies a likelihood() value (or equivalent) on an indexed WHERE constraint, use it to estimate the number of index rows visited. check-in: 90e36676 user: dan tags: trunk
15:00
Add text to the header comment of whereLoopAddBtree() describing how the costs of various b-tree loops are estimated. Closed-Leaf check-in: 05e6e16c user: dan tags: experimental-costs
14:53
Update a couple of test cases to account for the fact that this branch prefers an index scan and partial sort over a full-table scan and full external sort. check-in: 9b975bf3 user: dan tags: experimental-costs
14:47
Fix a couple of out-of-date comments in where.c. check-in: eefeda32 user: dan tags: experimental-costs
14:22
Improved rendering of LogEst values corresponding to real values near 0.0 in the tool/logest.c utility program. check-in: 32910c8c user: drh tags: experimental-costs
13:19
Fix long-standing typos in comments. check-in: b9f91317 user: drh tags: experimental-costs
2014-04-29
19:01
Test that the default values used when sqlite_stat1 data is not available are calculated correctly. Fixes for the same. check-in: e2d42f90 user: dan tags: experimental-costs
16:46
Merge trunk changes into this branch. check-in: d74299f0 user: dan tags: experimental-costs
16:10
Ignore likelihood() values on indexed IPK lookups. check-in: 5bb7757a user: dan tags: experimental-costs
12:01
Fix a test case so that it updates sqlite_stat1 consistently. check-in: 2dc5a0b5 user: dan tags: experimental-costs
2014-04-28
20:11
Do not reduce the number of rows scanned at all for "IS NOT NULL" constraints. Fix a bug in calculating the number of rows visited by scans of partial indicies. check-in: a8ae93f0 user: dan tags: experimental-costs
19:34
The trunk assumes that an open range constraint on an indexed term (col>?) term matches 1/4 of the indexed rows, and that a closed constraint (col BETWEEN ? AND ?) matches 1/64. Change this branch to do the same. check-in: 4047ac75 user: dan tags: experimental-costs
17:56
Add the sqlite3_rtree_query_callback() API to the RTree virtual table. (Cherrypick from the sessions branch.) check-in: af2cbe64 user: drh tags: trunk
15:11
Update unordered.test to take into account for the fact that SQLite now prefers a full-table scan over a non-covering index scan that visits a large percentage of the table rows. check-in: 20f468df user: dan tags: experimental-costs
12:08
Add an extra column to a table in analyze9.test to give the planner a little more reason to select an index. check-in: 1b95544f user: dan tags: experimental-costs
10:00
Update test script analyze3.test to account for the fact that SQLite now prefers a full-table scan over a non-covering index scan that visits a large percentage of the table rows. check-in: 35f46a55 user: dan tags: experimental-costs
09:35
Modify internal function whereLoopAdjustCost() so that it does not prefer a skip-scan over a regular index scan even if the regular scan uses a subset of the WHERE terms used by the skip-scan. check-in: 88a5758d user: dan tags: experimental-costs
08:49
Fix an error in estimating of the number of rows visited by a range scan. check-in: d491de62 user: dan tags: experimental-costs
2014-04-26
20:21
Fix an sqlite3_stmt_status() problem caused by recent changs on this branch. check-in: dee20409 user: dan tags: experimental-costs
19:23
Update requirements marks to fix typos in the requirements text. No changes to code. check-in: f5a26365 user: drh tags: trunk
17:52
Allow the xfer optimization to proceed if the DEFAULT on the very first column of the two tables is different. This is a refinement of the fix for ticket [f67b41381a]. check-in: 349f4834 user: drh tags: trunk
14:07
Avoid transfering records between tables unless the default values for all columns are the same. Fix for [f67b41381a]. check-in: f8c4c495 user: dan tags: trunk
2014-04-25
20:22
If the user provides likelihood() data for a WHERE clause term used as part of an index key, have the planner use it when calculating the expected number of rows visited by the loop. check-in: c51efaa5 user: dan tags: experimental-costs
17:37
Add test cases to ensure correct operation of joins with a virtual table that include DISTINCT and ORDER BY clauses. Verification for ticket [388d01d4bb8f9]. check-in: 5ada136f user: drh tags: trunk
15:01
Store values loaded from the stat1 table as logarithmic values in memory. check-in: 1bd74c49 user: dan tags: experimental-costs
14:42
Make sure ORDER BY clauses on joins that involve virtual tables and that have a DISTINCT clause work correctly. This is a candidate fix for ticket [388d01d4bb8f9]. Test cases for that ticket will be checked in separately. check-in: 17113812 user: drh tags: trunk
12:35
When VDBE_PROFILE is enabled, ignore negative opcode times, which sometimes occur, perhaps due to context swaps. check-in: 4e88042f user: drh tags: trunk
2014-04-24
20:04
Changes to the way the planner calculates the costs of various table and index scans. Some test cases still failing. check-in: c5a6ec0a user: dan tags: experimental-costs
2014-04-22
19:42
Change from using the win32-none VFS to just a query parameter. check-in: ffceacf6 user: drh tags: win32-none
19:34
Add some OSTRACE calls for consistency. check-in: be292d55 user: mistachkin tags: win32-none
19:30
Add the win32-none VFS which omits rollback-journal locking. check-in: 03e3c5a8 user: drh tags: win32-none
2014-04-21
18:00
Preliminary changes to support building VSIX packages for Windows 8.0 and Windows Phone 8.0 using Visual Studio 2013. check-in: 3bf97c81 user: mistachkin tags: vsixWinPhone81
13:36
Comment tweaks on the test case for the [b75a9ca6b0] bug fix. check-in: 65d2544a user: drh tags: trunk