/ Timeline
Login

100 check-ins occurring around 00bb9c9ce4.

2012-03-28
18:08
Do the accounting for incr-merge work in pages instead of blocks. Closed-Leaf check-in: 83037d58 user: dan tags: fts4-incr-merge-exp
16:44
Merge in the latest changes from trunk. Closed-Leaf check-in: 66c4aaad user: drh tags: fts4-incr-merge
16:22
Avoid loading overflow pages just to satisfy typeof() or length() functions if the correct result can be computed without the extra page fetches. check-in: 0733c98c user: drh tags: trunk
16:14
Minor changes to the core of OP_Column for performance and to clarify the critical path. Closed-Leaf check-in: 86839476 user: drh tags: faster-typeof-and-length
15:44
This change turned out to the code slower. Side track it. Was: Tweaks to the OP_Column opcode for clarity of presentation. Closed-Leaf check-in: 4d516240 user: drh tags: mistake
13:55
Fix a problem in fts4merge3.test. check-in: 64fc8b30 user: dan tags: fts4-incr-merge
13:41
Improvements to comments. Minor changes to code in the hot path of OP_Column - with the hope of get a few cycles of performance improvement. check-in: ca093103 user: drh tags: faster-typeof-and-length
02:51
Test cases for length() of a large blob in an aggregate query. check-in: d095fa4b user: drh tags: faster-typeof-and-length
02:43
Fix the typeof() and length() optimization so that it works for aggregates as well as scalar queries. check-in: bc18215a user: drh tags: faster-typeof-and-length
01:34
Evaluate typeof(X) and length(Y) where X is any column and Y is a blob column without actually loading X and Y from disk. check-in: b899dbeb user: drh tags: faster-typeof-and-length
2012-03-27
18:00
Add output of PRAGMAs auto_vacuum and encoding to the "schema" command of the fts3view utility program. check-in: e3107631 user: drh tags: fts4-incr-merge
15:10
Really delete the fts3merge.test script (should have been deleted by the previous commit). check-in: 83838149 user: dan tags: fts4-incr-merge
15:00
Remove the fts3merge.test script in favour of changing the fts4merge.test script so that it runs tests using both fts4 and fts3. Fix some problems with incr-merge and FTS3 tables. check-in: 5c447e22 user: dan tags: fts4-incr-merge
14:54
In the fts3view utility, label the blank segments used to mark the end of a segment sequence for a level/idx as "null". Improve the alignment of root segment names. check-in: 04aea024 user: drh tags: fts4-incr-merge
13:51
Enhance the fts3view tool with the big-segment command and fix a bug in the display of doclists. check-in: e9436d80 user: drh tags: fts4-incr-merge
13:44
Merge the fts4-incr-merge-exp branch with fts4-incr-merge. check-in: eb00b958 user: dan tags: fts4-incr-merge
11:48
Allow multiple incremental merges to proceed concurrently. This is required to prevent a large crisis-merge from occuring while an even larger incremental-merge is underway. Closed-Leaf check-in: 7ed9d2f2 user: dan tags: fts4-incr-merge-exp
00:38
Minor correct errors in the file format description for FTS3/4 contained in the fts3.c header comment. check-in: fb8aacdd user: drh tags: fts4-incr-merge
00:34
Enhance fts3view to show decodes of segments and doclists. check-in: 6d09de23 user: drh tags: fts4-incr-merge
2012-03-26
21:57
Add the fts3view utility program. check-in: f936c8ea user: drh tags: fts4-incr-merge
14:36
Fix FTS3 so that it works even without SQLITE_DEBUG. check-in: a18c1031 user: drh tags: fts4-incr-merge
10:57
Modify the FTS integrity-check so that the checksums do not depend on the results of signed integer overflow, which is undefined in C. check-in: f907fc3f user: dan tags: fts4-incr-merge
10:47
Add a comment to explain how the FTS integrity-check works. check-in: 64e8a116 user: dan tags: fts4-incr-merge
10:36
Add an experimental integrity-check function to FTS. check-in: 40fc8804 user: dan tags: fts4-incr-merge
2012-03-25
17:25
Increase the version number to 3.7.12 check-in: d95f9fb7 user: drh tags: trunk
2012-03-24
20:09
Add SQLITE_DBSTATUS_CACHE_WRITE to the command-line shell. check-in: 30b8dd32 user: drh tags: trunk
20:06
Add SQLITE_DBSTATUS_CACHE_WRITE. Used to query a database connection for the cumulative number of database pages written. check-in: 05f98d4e user: drh tags: trunk
19:44
Add SQLITE_DBSTATUS_CACHE_WRITE. Used to query a database connection for the cumulative number of database pages written. check-in: 3cb6a879 user: dan tags: fts4-incr-merge
17:29
Enable fts3 tables to use incremental merge by automatically creating the %_stat table when it is needed. check-in: cc051fc0 user: drh tags: fts4-incr-merge
17:09
Fix a failing assert() in the FTS3_LOG_MERGES related code. check-in: 4220d52c user: dan tags: fts4-incr-merge
16:43
Add a comment to fts3SyncMethod() to justify the nMinMerge=64 constant. check-in: af55ca5f user: dan tags: fts4-incr-merge
16:18
Fix a bug in debugging code enabled when FTS3_LOG_MERGES is defined. check-in: 2e06babf user: drh tags: fts4-incr-merge
16:11
Remove the Fts3Table.mxLevel variable. check-in: 67a0cffc user: dan tags: fts4-incr-merge
14:45
Merge auto-incr-merge with incr-merge branch. check-in: 1c68687a user: dan tags: fts4-incr-merge
14:45
Modify the way the number of leaves written and the maximum relative level are calculated in the auto-incr-merge code. Closed-Leaf check-in: 0d841c95 user: dan tags: fts4-auto-incr-merge
02:20
An attempt at automatic incremental merging for FTS4. check-in: ed69434c user: drh tags: fts4-auto-incr-merge
2012-03-23
18:26
Fix a spurious SQLITE_CONSTRAINT error that may be returned by an incr-merge operation. check-in: ed7c17ea user: dan tags: fts4-incr-merge
15:38
Add a test to verify that sqlite3_total_changes() works with incr-merge operations. check-in: 1c72cecc user: dan tags: fts4-incr-merge
14:38
Remove an incorrect assert() statement. Fix a const-related warning. check-in: 96ed4749 user: dan tags: fts4-incr-merge
14:23
When an incremental blob cursor is invalidated (occurs when an SQL statement modifies or deletes the row the blob cursor points to) release all page references held by the cursor. Otherwise, the presence of these references may cause other code in btree.c to incorrectly infer that the database is corrupt. check-in: 341b703c user: drh tags: trunk
13:40
Fix another test case issue in trace2.test. check-in: 02a8e423 user: dan tags: fts4-incr-merge
12:28
Update MSVC makefile to support compiling for WinRT using one setting. check-in: c10794bf user: mistachkin tags: winrt
11:09
When an incremental blob cursor is invalidated (occurs when an SQL statement modifies or deletes the row the blob cursor points to) release all page references held by the cursor. Otherwise, the presence of these references may cause other code in btree.c to incorrectly infer that the database is corrupt. check-in: 82c3f2ba user: dan tags: fts4-incr-merge
11:07
Update a couple of existing test cases. check-in: dcb8fa0f user: dan tags: fts4-incr-merge
2012-03-22
17:48
Add test cases to fts4merge.test. check-in: ecab2083 user: dan tags: fts4-incr-merge
16:48
Following an incr-merge operation that does not completely consume its input segments, store context in the rowid==1 row of the %_stat table that allows the next incr-merge to pick up where the previous left off. check-in: ab0a4f44 user: dan tags: fts4-incr-merge
12:50
Always quote the names of tables in the output of the shell's ".dump" command, even if the name is pure alphabetic text, in case the name is a keyword. check-in: 638b7115 user: drh tags: trunk
2012-03-21
14:34
Add fts4merge3.test, for testing that older versions of FTS4 may interoperate with incr-merge capable versions. check-in: 903ec512 user: dan tags: fts4-incr-merge
2012-03-20
17:04
Merge trunk changes into the fts4-incr-merge branch. check-in: f61d5fb0 user: drh tags: fts4-incr-merge
15:10
Remove the _SafeInit() entry points from the TCL interface. They have long been no-ops. Removing them completely avoids confusion as to why they don't work. check-in: 0fb26c7b user: drh tags: trunk
11:35
Version 3.7.11 check-in: 00bb9c9c user: drh tags: trunk, release, version-3.7.11
03:10
Fix out-of-bounds array references in the "echo" virtual table module used for testing. No changes to the SQLite core. check-in: 7b449b30 user: drh tags: trunk
02:18
Add WinRT comments to MSVC makefile. check-in: ddea657b user: mistachkin tags: winrt
02:10
Remove version information from the MSVC makefile as it is no longer necessary. check-in: 6f0c1f97 user: mistachkin tags: winrt
2012-03-19
23:32
Merge updates from trunk. check-in: 4ab1ffd4 user: mistachkin tags: winrt
23:28
Fix typo, use the syscall table for osOutputDebugStringA. check-in: 9598c2a3 user: mistachkin tags: winrt
17:42
Add additional test cases to e_insert.test. Update evidence marks. no changes to core code. check-in: 036395c0 user: drh tags: trunk
16:21
Merge latest trunk changes into apple-osx branch. check-in: f999197b user: dan tags: apple-osx
14:57
Fix one more compiler warning missed by the previous check-in. check-in: bc03d99a user: drh tags: trunk
14:51
Suppress harmless compiler warnings on windows in FTS4 and RTREE. check-in: 4fd68647 user: drh tags: trunk
14:28
Avoid a compiler warning (an incorrect compiler warning, at that) in vs2010. check-in: 7dd97f12 user: drh tags: trunk
11:17
Merge the latest trunk changes into the sessions branch. check-in: 2277c70b user: dan tags: sessions
10:21
Ensure that compatible malloc and free functions are used with stat3 data if SQLITE_ENABLE_STAT3 is defined. check-in: 32bb1ece user: dan tags: trunk
2012-03-18
03:22
On Windows, when no temporary path is available, skip prepending the directory separator. check-in: 32b5c20e user: mistachkin tags: winrt
01:32
Add SQLITE_OMIT_SHUTDOWN_DIRECTORIES compile-time option to disable clearing the sqlite3_data_directory and sqlite3_temp_directory variables during sqlite3_shutdown. Also, only clear the variables if the heap was actually shutdown. check-in: 1ae9f9e4 user: mistachkin tags: winrt
2012-03-17
16:56
Fix various incorrect and missing comments and other style issues in and around the FTS incremental merge code. check-in: 7aabb62c user: dan tags: fts4-incr-merge
15:12
In pager1.test, use "file attr test.db -readonly 0" before "file attr test.db -perm rw-rw-rw-", not after. check-in: 4f5283f1 user: dan tags: trunk
09:43
Modify a test in ioerr2.test to account for the new SQLITE_ABORT_ROLLBACK extended error code. check-in: affaebde user: dan tags: trunk
2012-03-16
17:00
Update the trace2.test script for languageid. check-in: a11528ac user: drh tags: trunk
16:52
Cherrypick the [3475092cff] fix for 32-bit overflow with large language-ids into trunk. check-in: 2755edc7 user: drh tags: trunk
15:54
Fix some integer overflow problems that can occur when using large langauge id values. check-in: 3475092c user: dan tags: fts4-incr-merge
14:54
Add a comment to the FTS getAbsoluteLevel() function. No actual code changes. check-in: 7e0f861b user: dan tags: fts4-incr-merge
10:28
Reset the sqlite3_data_directory and sqlite3_temp_directory variables when the sqlite3_shutdown function is called since they may refer to memory allocated by the heap subsystem that was just shutdown. check-in: cd70bc4b user: mistachkin tags: winrt
00:28
Fix harmless compiler warnings. check-in: 74eadeec user: drh tags: trunk
2012-03-15
22:54
Add the sqlite3_db_readonly() API to trunk. check-in: fed134a5 user: drh tags: trunk
21:28
Add the sqlite3_db_readonly() interface. This is still tentative, pending a closer look at other ideas to accomplish the same thing. Closed-Leaf check-in: 254f99ea user: drh tags: db-readonly-api
17:45
Modify incremental merge code to merge nMin segments at a time. check-in: cd34bc1a user: dan tags: fts4-incr-merge
03:40
Add SQLITE_WIN32_HEAP_CREATE compiler define to control whether or not the Win32 native allocator will create an isolated heap for all allocated data. check-in: 8693fb65 user: mistachkin tags: winrt
2012-03-14
23:08
Fix macro issues for osGetProcessHeap and sqlite3_win32_write_debug. check-in: d3d07159 user: mistachkin tags: winrt
20:20
Fix typos, use #if instead of #ifdef when checking for the Win32 native heap validation define. check-in: 845aa46f user: mistachkin tags: winrt
20:17
Avoid redefining macros. Enable use of the Win32 native heap on WinRT. Use the syscall table to call OutputDebugStringW and fix type casting warnings. check-in: 46c412a8 user: mistachkin tags: winrt
20:01
Add tests for incremental merge code. check-in: 57047372 user: dan tags: fts4-incr-merge
12:17
Avoid allocating a large object on the stack in the incremental merge code. Use sqlite3_malloc() instead. check-in: 36ae510d user: dan tags: fts4-incr-merge
11:51
Fix another bug in the incremental merge code. check-in: f97b12e0 user: dan tags: fts4-incr-merge
03:41
Remove SQLITE_OS_WINRT setting from MSVC makefile. check-in: df4caf13 user: mistachkin tags: winrt
01:28
Add warning to the docs about changing the data directory when a database connection is open. check-in: c07cd85c user: mistachkin tags: winrt
00:44
Add experimental support for resolving relative database file paths using a fixed user-defined directory. check-in: 7354ae8f user: mistachkin tags: winrt
2012-03-13
19:56
Fix some bugs in the incremental merge code. Some remain. check-in: bff21683 user: dan tags: fts4-incr-merge
03:38
Add assert to verify the number of characters to write in sqlite3_win32_write_debug. check-in: 8083f616 user: mistachkin tags: winrt
03:35
Defer creation of the sleep event object until it is needed. Added sqlite3_win32_write_debug and sqlite3_win32_sleep APIs to assist in portability to WinRT. check-in: 7af88ad3 user: mistachkin tags: winrt
01:30
Cleanup the Windows syscall table, removing the unused CreateFileMapping entry. check-in: fb7d8bf6 user: mistachkin tags: winrt
01:16
More changes required to compile for WinRT using VS 11 beta. Also, replace more APIs with their WinRT alternatives. check-in: 6b997d9c user: mistachkin tags: winrt
2012-03-09
22:02
Candidate fix for the optimizer problem described in ticket [b7c8682cc17f3] which can causes a LEFT JOIN to be changed into a INNER JOIN if there are OR terms in the WHERE clause. check-in: 0dc4cb93 user: drh tags: trunk
12:52
Minor commenting and stylistic changes only. check-in: a1747086 user: drh tags: fts4-incr-merge
2012-03-08
20:39
Merge test current directory value fix from trunk and fix uri tests. check-in: 88963c33 user: mistachkin tags: winrt
20:28
On Windows, make sure the returned test current directory value does not contain any backslashes. check-in: efee39e6 user: mistachkin tags: trunk
20:22
Merge and manually resolve testing updates from trunk. check-in: 5eecdb44 user: mistachkin tags: winrt
20:00
On Windows, make sure the current directory value used by the test suite is 'normalized' to what the parent command shell sees. Also, clean the test directories used by the quota2.test file. check-in: 82bcd7ec user: mistachkin tags: trunk
18:39
Add the 'merge=?,?' command to fts4. This still needs some work. check-in: 741b8f89 user: dan tags: fts4-incr-merge
2012-03-07
20:11
When compiled for WinRT, use the CreateFile2 and LoadPackagedLibrary functions instead of CreateFile and LoadLibrary. check-in: 27d6942c user: mistachkin tags: winrt