/ Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

100 descendants and 100 ancestors of [a2a0cd4a]

2011-07-26
15:50
Fix a problem causing sqlite3changeset_invert() to effectively drop UPDATE changes. check-in: bb3e65d9 user: dan tags: sessions
2011-07-25
23:25
Enable the SQLITE_FCNTL_SIZE_HINT on unix even if SQLITE_FCNTL_CHUNK_SIZE has not been set. check-in: 05c9832e user: drh tags: trunk
2011-07-23
13:54
Merge the winAccess retry logic from the anti-antivirus branch into the trunk. check-in: 08d0e879 user: drh tags: trunk
13:11
In the multiplexor, close auxiliary files before deleting them when doing a truncate. check-in: 6fb7cfc2 user: drh tags: trunk
2011-07-22
21:25
Add retry logic for AV defense to winAccess(). Also allow OS tracing to be enabled by a compile-time option. Closed-Leaf check-in: a6b85c73 user: drh tags: av-defense
12:49
Merge the latest trunk changes into the sessions branch. check-in: 110cfd69 user: drh tags: sessions
11:23
Also add the sqlite3-all.c target to the MSVC makefile. check-in: 8ce2b74a user: drh tags: trunk
11:16
Add makefile targets sqlite3-all.c. check-in: 71f7be58 user: drh tags: trunk
10:53
Adjust the maximum number of open database connections in wal3.test down for OpenBSD. check-in: b38e52f6 user: drh tags: trunk
10:33
Use $(TCLSH_CMD) instead of tclsh in the autoconf makefile. check-in: fd36d806 user: drh tags: trunk
2011-07-21
21:29
Compile with the SQLITE_ENABLE_8_3_NAME macro set to 2 to force 8+3 filenames to be on all the time. check-in: ae83dac7 user: drh tags: trunk
20:59
All multiplexor chunk sizes up to 4GiB. Disable the multiplexor if the chunk size is set to 0. check-in: 83191ad6 user: drh tags: trunk
2011-07-20
17:59
For an existing multiplexed database, try to set the chunk size automatically based on the sizes of the preexisting pieces. check-in: 427a9a51 user: drh tags: trunk
17:13
All the SQLITE_OPEN_URI flag to propagate down into the VFS. check-in: 29866f95 user: drh tags: trunk
16:35
When the multiplexor opens an auxiliary file, it now persists the name of that file until it is closed, as it should. Remove the limit on the number of auxiliary files used by the multiplexor. check-in: 1ffa542b user: drh tags: trunk
2011-07-19
18:29
Formatting changes on the multiplexor code - make sure no lines exceed 80 characters. No logical changes. check-in: ed5f0aad user: drh tags: trunk
15:27
Increase the version number to 3.7.8. check-in: 4355bf29 user: drh tags: trunk
2011-07-18
15:22
Fix the sqlite3session_isempty() method so that it returns, as documented, non-zero when no changes have been recorded by the session object. check-in: d04e0fd8 user: dan tags: sessions
2011-07-16
18:35
Fix error in a comment in sqlite3session.h. No changes to code. check-in: 70c84e50 user: dan tags: sessions
18:05
Note in the documentation that when iterating through a changeset, all changes to a single table are grouped together. Also add the sqlite3session_isempty() function. check-in: 364f3b82 user: dan tags: sessions
2011-07-15
19:11
Add a few casts required by 64-bit VS2010 to the sessions code. check-in: 5ac4a061 user: dan tags: sessions
13:43
In os_unix.c, check if the ESTALE macro is defined before using it. check-in: 87017410 user: dan tags: trunk
2011-07-13
18:31
Do not try to use STAT2 to refine the row estimate of a query that uses a unique or nearly-unique index. check-in: efffc49b user: drh tags: trunk
16:03
Added the SQLITE_FCNTL_WIN32_AV_RETRY file control for configuring the retry counts and delays in the windows VFS. check-in: 7aaf0a6a user: drh tags: trunk
15:21
Add the xFilter callback to the sqlite3changeset_apply() function. This callback allows the application to accept or reject changes on a per-table basis when applying a changeset. check-in: 282474c4 user: dan tags: sessions
2011-07-12
14:38
Merge the improved anti-virus defenses into the trunk. check-in: 0207fd9b user: drh tags: trunk
14:28
Experimental support for speeding up CREATE INDEX commands using an offline merge sort. check-in: 30dbf0fe user: dan tags: experimental
14:02
Revise logic in winDelete to check the file prior to attempting to delete it. Closed-Leaf check-in: 36f11acc user: mistachkin tags: av-defense
13:51
Improvements to the logging that occurs on an antivirus I/O retry. check-in: ff0ff75c user: drh tags: av-defense
11:04
Update the anti-virus retry logic for DeleteFile(). Invoke sqlite3_log() for each anti-virus retry. Make the retry delay configurable at compile-time. check-in: 89f1848d user: drh tags: av-defense
2011-07-11
23:45
Update the TCL commands for setting windows manditory locks. Add test cases for manditory lock delays under windows. check-in: 03af4c17 user: drh tags: trunk
19:45
Modifications so that the sessions extension works with blob handles. check-in: 82ac16c4 user: dan tags: sessions
18:17
Change the windows backend to retry read and write requests if the encounter ERROR_LOCK_VIOLATION and ERROR_SHARING_VIOLATION errors - which we think sometimes happens due to aggressive anti-virus software. check-in: c20aca06 user: drh tags: trunk
15:52
Here is an attempted enhancement to the query planner that didn't work out. But it seems good to save this change for historical reference, even if it does not belong on the trunk. Closed-Leaf check-in: 8daf6e1b user: drh tags: query-planner-deadend
2011-07-09
16:17
Fix harmless compiler warnings on unix. check-in: 90b1aea1 user: drh tags: trunk
13:00
In where.c::findIndexCol - make sure that the Expr.op is TK_COLUMN before accessing the Expr.iColumn and Expr.iTable fields. Also fix a couple of unreachable branches. check-in: 418a4da2 user: drh tags: trunk
2011-07-08
17:02
Change the default chunk size on test_multiplex.c to 2147418112 bytes (formerly 1073741824 bytes) and make the default configurable at compile-time using SQLITE_MULTIPLEX_CHUNK_SIZE and at run-time using the "chunksize" URI query parameter. Add support fo test_multiplex to the shell. check-in: e305b5a9 user: drh tags: trunk
16:10
Fix for [54844eea3f]: Do not create automatic indexes on correlated sub-queries. check-in: 9f14fa56 user: dan tags: trunk
13:07
Extend the SQLITE_TESTCTRL_OPTIMIZATIONS option to disable DISTINCT optimizations. check-in: 18501dd1 user: drh tags: trunk
2011-07-07
08:52
Update the tool/symbols.sh script to check for accidentally exported global variables. check-in: 71b749a9 user: drh tags: trunk
08:19
Add a target to main.mk that will fail if the amalgamation contains any exported symbols that do not begin with "sqlite3_". Run this target from within releasetest.tcl. Add "static" to a couple of private functions in mem3.c. check-in: a68b6580 user: dan tags: trunk
07:37
Remove accidental global variable "doclist" from fts3Int.h. check-in: f244b2f3 user: dan tags: trunk
2011-07-06
09:36
Expose the value of compile time symbol SQLITE_MAX_DEFAULT_PAGE_SIZE to test scripts. check-in: 33573663 user: dan tags: trunk
2011-07-04
06:52
Adjust a couple of test scripts so that they work with OMIT_UTF16 builds. check-in: 6c51bad0 user: dan tags: trunk
2011-07-02
19:12
Add a testcase macro to ensure testing a boundary case in DISTINCT processing. check-in: ff9fc722 user: drh tags: trunk
15:32
Ensure that automatic indexes are only created in scenarios where they may be used more than once. check-in: 27c65d4d user: dan tags: trunk
09:46
Merge experimental changes improving optimization of DISTINCT queries with the trunk. check-in: 45e581bf user: dan tags: trunk
06:44
Fix a broken assert() in where.c. Closed-Leaf check-in: 090b2917 user: dan tags: experimental
2011-07-01
18:43
Merge latest trunk changes with experimental branch. check-in: e56be74e user: dan tags: experimental
18:26
Improve use of indexes to optimize DISTINCT queries. check-in: 6c202ea0 user: dan tags: experimental
14:22
Test case for ticket [d6ddba6706353915ceed] check-in: 953e169e user: drh tags: trunk
14:21
Improvements and tests for detection of redundant DISTINCT qualifiers. check-in: 7337293c user: dan tags: experimental
13:50
Ignore the database name on the target table when parsing a CREATE TABLE statement out of the sqlite_master table. This is a fix for ticket [d6ddba6706353] that preserves backwards compatibility. check-in: 009c96ea user: drh tags: trunk
2011-06-30
20:17
Experimental changes to improve optimization of DISTINCT queries. check-in: f7ba0219 user: dan tags: experimental
2011-06-29
17:11
Pass the BTREE_UNORDERED hint into both sqlite3BtreeOpen() and into sqlite3BtreeCreateTable(). check-in: 591de898 user: drh tags: trunk
2011-06-28
17:39
Version 3.7.7.1. Leaf check-in: af0d91ad user: dan tags: release, version-3.7.7.1, branch-3.7.7
14:16
Merge the fts3-changes branch back into the trunk. check-in: b9477eb0 user: dan tags: trunk
11:58
Add a fix and tests for the FTS deferred token logic. Closed-Leaf check-in: 91daea7d user: dan tags: fts3-changes
09:51
Merge latest trunk changes with fts3-changes branch. check-in: 22668647 user: dan tags: fts3-changes
07:15
Changes to allow FTS to be compiled as a loadable module again. check-in: 29e69f38 user: dan tags: trunk
2011-06-27
23:39
Update the version number to 3.7.7.1 check-in: de8ad5f8 user: drh tags: branch-3.7.7
23:32
Create a branch that contains just the fix for the case_sensitive_like pragma bug, ticket [25ee81271091ec]. check-in: ec8f23fc user: drh tags: branch-3.7.7
19:37
Remove an unnecessary assignment from vdbeapi.c. check-in: 6c871ac1 user: dan tags: trunk
19:25
Merge latest trunk changes. check-in: 11ea98e4 user: dan tags: fts3-changes
19:12
Remove an unnecessary assignment from vdbeapi.c. check-in: 25e5b768 user: dan tags: fts3-changes
16:55
Add a case to permutations.test to run the veryquick test suite using sqlite3_prepare() instead of sqlite3_prepare_v2(). This helps to test the fix for bug [25ee812710]. check-in: d9f7993b user: dan tags: trunk
11:15
Changes to improve the selection of deferred tokens within phrases. check-in: 2c4bbd90 user: dan tags: fts3-changes
00:01
Make sure all new statements begin life unexpired, even if they registered functions or did other actions during preparation that would have expired all statements. Fix for ticket [25ee81271091] check-in: faa38c87 user: drh tags: trunk
2011-06-26
23:44
Modifications to the "like.test" script in order to expose the problem reported by ticket [25ee81271091ec27a8c5]. check-in: c4db5b64 user: drh tags: trunk
2011-06-25
21:43
Changes to make pragma synchronous sticky when SQLITE_DEFAULT_WAL_SAFETYLEVEL is used check-in: c6158b25 user: adam tags: apple-osx
16:35
Fix test cases so that they work with SQLITE_DEFAULT_WAL_SAFETYLEVEL defined. check-in: 8f8b373e user: dan tags: apple-osx
01:14
Support using nmake via cmd.exe, allow Tcl related variables to be overridden via the environment, and add 'dll' to the 'all' target. check-in: 0cb0f306 user: mistachkin tags: trunk
2011-06-24
21:47
Fix the build. check-in: 97729542 user: drh tags: apple-osx
20:47
Merging local changes to apple-osx check-in: 34f0efa2 user: adam tags: apple-osx
18:43
Explicitly cast an argument to printf() to (int), in case the result of the pointer arithmetic expression is a 64-bit integer on some platforms. check-in: 90cfeaf7 user: dan tags: trunk
13:50
Fix a Windows line ending issue in a test case that was causing an incrblob test to fail. check-in: afbe9023 user: shaneh tags: trunk
11:29
Fix some harmless compiler warnings that were occurring with THREADSAFE=0. check-in: 9b191bb4 user: drh tags: trunk
2011-06-23
19:49
Version 3.7.7. check-in: 4374b7e8 user: drh tags: trunk, release, version-3.7.7
17:42
Pull the last-minute fixes for 3.7.7 into the apple-osx branch. check-in: 2d4458af user: drh tags: apple-osx
17:40
Pull the latest version 3.7.7 release-candidate changes into the sessions branch. check-in: 840bf9c2 user: drh tags: sessions
17:29
Add a bit to the SQLITE_TESTCTRL_OPTIMIZATIONS setting that will disable affinity when writing to any index, regardless of whether or not the index is on a manifestation of a view. This allows better testing of the fix for ticket [91e2e8ba6ff2e2]. check-in: b61a76a5 user: drh tags: trunk
17:09
Fix some of the code issues (missing comments etc.) in the new FTS code. check-in: 8230d831 user: dan tags: fts3-changes
16:40
Add a test for ticket [91e2e8ba6f]. No changes to code. check-in: c271f7e8 user: dan tags: trunk
16:18
Do not do affinity transformations on inserts into an index for the manifestation of a view or subquery. Fix for ticket [91e2e8ba6ff2e2]. check-in: 0b3174e0 user: drh tags: trunk
02:30
Pull the latest changes from trunk into the apple-osx branch. check-in: b5acda04 user: drh tags: apple-osx
02:11
Pull the latest trunk changes into the sessions branch. check-in: 5d95b429 user: drh tags: sessions
01:42
Provide the SQLITE_MAX_SCHEMA_RETRY compile-time parameter for adjusting the number of reparse attempts after a schema change. check-in: 8dca748b user: drh tags: trunk
01:07
Remove unused variables from test_vfs.c check-in: 07884cc2 user: drh tags: trunk
00:59
If "PRAGMA page_size" commands are not authorized, the FTS module will assume a page size of 1024. check-in: ba39382e user: drh tags: trunk
2011-06-22
20:14
Added limited support to omittest.tcl for nmake makefile. check-in: f5f46dc7 user: shaneh tags: trunk
15:40
Update a test case for Windows that failed because of size_hint implementation differences. check-in: f853fa63 user: shaneh tags: trunk
15:21
Print a warning in oserror-1.1.1 that a valgrind warning might occur but that it is benign. check-in: 13e96376 user: drh tags: trunk
14:43
Adjust a test case in triggerC.test to handle non-default SQLITE_MAX_TRIGGER_DEPTH settings. check-in: f14339c5 user: shaneh tags: trunk
14:21
Add a flush of stdout so some test code reading from a command pipe works correctly on Windows. check-in: 6705f21e user: shaneh tags: trunk
12:01
Update sessions branch with latest trunk changes. check-in: 48d5cab3 user: dan tags: sessions
11:24
Update apple-osx branch with the latest trunk changes. check-in: fb7ad09d user: dan tags: apple-osx
10:56
Change a test case in types3.test slightly so that it works with the latest versions of Tcl. check-in: 6e1f4df5 user: dan tags: trunk
10:37
Modify the implementation of the test code in test_vfs.c so that test VFS objects may be invoked recursively. check-in: 065e5a5e user: dan tags: trunk
2011-06-21
19:39
Fix typo in previous tester.tcl commit. check-in: c2e5faca user: shaneh tags: trunk
19:38
Update filepath_normalize for unix. check-in: 30dd4f88 user: shaneh tags: trunk
19:30
Update a few of the uri tests to work on Windows. check-in: a2a0cd4a user: shaneh tags: trunk
18:12
Updates to nmake makefile to allow options to be passed to lib.exe. check-in: 9eac4a6b user: shaneh tags: trunk
15:54
Give the osLocaltime() function file scope in date.c. check-in: 15774845 user: drh tags: trunk
15:38
Initialize a variable introduced as part of the fix for [bd484a090c8077] in order to silence a compiler warning. check-in: 6b9877fa user: dan tags: trunk
15:27
Add a missing initializer for sqlite3GlobalConfig.bLocaltimeFault. check-in: 7fe8ba2e user: dan tags: trunk
15:24
Fix main.mk so that the "amalgamation-testfixture" target works again. check-in: 22265323 user: dan tags: trunk
15:01
Rework the localtime logic yet again in order to make all branches reachable and to follow GNU standards for HAVE_LOCALTIME_R-type macros. Ticket [bd484a090c8077]. check-in: 17624809 user: drh tags: trunk
14:35
Simplifications to the localtime() interface. Fix the case where localtime_r() is available so that it works. Ticket [bd484a090c8077]. check-in: 5b68dae3 user: drh tags: trunk
13:46
Change the error message returned when localtime_r() fails to "local time unavailable". Ticket [bd484a090c8077] check-in: 0e82175f user: dan tags: trunk
12:53
Fix an error made in the previous commit. The parameters to localtime_s() were accidentally reversed. Ticket [bd484a090c807]. check-in: 97e86ec6 user: dan tags: trunk
12:47
Return an error if localtime_r() fails within one of the date/time functions. Fix for [bd484a090c]. check-in: 76ae8257 user: dan tags: trunk
03:36
Add a new AWK script in the tool/ folder for converting text files into C string literals. Use it for building sqlite3_analyzer. check-in: dcb46d3f user: drh tags: trunk
2011-06-20
23:51
More typo fixes in evidence marks. No code changes. check-in: e60eefc7 user: drh tags: trunk
22:34
Fix typos in evidence marks on tests. check-in: bd980be4 user: drh tags: trunk
21:47
Fix more documentation typos. check-in: b9cbab73 user: drh tags: trunk
20:52
Add ability to pass linker specific options to nmake makefile. check-in: b4f09c93 user: shaneh tags: trunk
20:50
Fix a couple of compiler issues on Windows due to warning clean up. check-in: 81e6f151 user: shaneh tags: trunk
20:48
Add additional error check for disk full on Windows. check-in: 3ee5d1a5 user: shaneh tags: trunk
20:39
Fix documentation typos. No changes to code. check-in: 3276f3f7 user: drh tags: trunk
20:15
Remove the SQLITE_OMIT_CONFLICT_CLAUSE preprocessor define which was no longer in use. check-in: 90249559 user: drh tags: trunk
19:00
More compiler warning fixes. check-in: ed2dda93 user: drh tags: trunk
18:27
Fix compiler warnings in lemon by removing some of the code added by Ryan Gordon in [1e8b842039cc0]. check-in: 76b18b2b user: drh tags: trunk
18:00
Rework the autoconf script to better deal with utime() and dlopen(). check-in: f69ed286 user: drh tags: trunk
17:41
Update a couple test scripts to account for more floating point display variation in Windows-based versions of TCL. check-in: a4a8402b user: shaneh tags: trunk
17:24
Fix various harmless compiler warnings in FTS3 and RTREE. check-in: fe62179e user: drh tags: trunk
15:24
Enable crnl to nl translation for the mksqlite3c.tcl script. check-in: 161379d2 user: drh tags: trunk
12:24
Update some test cases in fts4aa.test. check-in: 65e5f770 user: dan tags: trunk
11:15
Fix a problem where FTS test code was not being included in the testfixture build when SQLITE_ENABLE_FTS4 was defined. check-in: e539d08a user: dan tags: trunk
10:46
Add tests for the "column:term" query syntax to fts3auto.test. check-in: d138b0e6 user: dan tags: trunk
2011-06-19
21:17
Do not run test tkt-2d1a5c67d.test in the inmemory_journal permutation since that test requires WAL mode which does not work with inmemory_journal. check-in: 228c43c7 user: drh tags: trunk
2011-06-17
18:52
Fix a header dependency in nmake Makefile. check-in: 54492212 user: shaneh tags: trunk
17:37
Avoid loading doclists for infrequent terms that are part of phrases twice. check-in: 8f939723 user: dan tags: trunk
16:04
Add a missing declaration to fts3Int.h. check-in: 3bfd4466 user: dan tags: trunk
15:57
Fix a few more issues with the nmake makefile. check-in: a117005f user: shaneh tags: trunk
15:55
Update walro.test script for Windows. check-in: d6443f8e user: shaneh tags: trunk
15:54
Force almagamation gen scripts to use unix line endings for consistency across platforms. check-in: a4adc7f7 user: shaneh tags: trunk
07:22
More updates to the nmake makefile. check-in: 55bb56d3 user: shaneh tags: trunk
07:07
Add Microsoft nmake compatible makefile; update a few test cases for Windows. check-in: a7590af6 user: shaneh tags: trunk
2011-06-16
16:06
Fix a problem with NEAR queries executed inside a transaction that writes the FTS table. check-in: 051c756c user: dan tags: trunk
00:54
Changes to #ifdefs so that the build goes correctly if the only FTS macro defined is SQLITE_ENABLE_FTS4. check-in: a0b43a32 user: drh tags: trunk
2011-06-15
23:34
Fix the multiplex.test module so that it works with the inmemory_journal permutation. check-in: 03d9480f user: drh tags: trunk
19:18
Further tweaks to the wal7.test test case. check-in: 177e2d72 user: drh tags: trunk
17:04
Add a couple of pointer type casts to test file test_quota.c. check-in: 0df061b0 user: dan tags: trunk
16:07
Fix the wal7.test script so that it works even if secure_delete is engaged. check-in: 68fb7a54 user: drh tags: trunk
13:11
Merge the improved incremental doclist loading test from the broken-build branch (which is now fixed) into trunk. check-in: f9750870 user: drh tags: trunk
13:02
Fix so that the TCL test harness works even if SQLITE_ENABLE_FTS is omitted. Closed-Leaf check-in: 63ebcb52 user: drh tags: broken-build
12:43
Fix a couple of compiler warnings. check-in: 3899f3b9 user: drh tags: broken-build
08:30
Add an interface to better test incremental loading of doclists by FTS4. Also some tests for this and term prefix queries. check-in: 7a381313 user: dan tags: broken-build
2011-06-14
14:18
Fix a memory leak that can follow an OOM error in a user-function that uses sqlite3_set_auxdata(). check-in: 0185c4b6 user: dan tags: trunk
11:50
Merge fts3-prefix-search branch with trunk. check-in: b1f9c1e0 user: dan tags: trunk
11:32
Add a couple of extra tests. Closed-Leaf check-in: aefd46df user: dan tags: fts3-prefix-search
09:00
Fix another bug caused by NEAR/matchinfo/order=DESC interaction. check-in: 04907fba user: dan tags: fts3-prefix-search
07:22
Merge recent trunk changes into fts3-prefix-search branch. check-in: 135ce30f user: dan tags: fts3-prefix-search
07:14
Remove unused parameters from internal fts3 function. check-in: 06de3f2c user: dan tags: fts3-prefix-search
2011-06-13
18:21
Update trace2.test to account for new FTS queries. check-in: 2c201292 user: dan tags: fts3-prefix-search
17:00
Add tests for deferred tokens to fts3auto.test. Fix a problem with OR queries and deferred tokens. check-in: b9fb69e5 user: dan tags: fts3-prefix-search
13:48
Changes to fts3auto.test to test OR, AND and NOT operations. check-in: e4ab6cdb user: dan tags: fts3-prefix-search
12:19
Use only unsigned values in the implementatin of LIKE and GLOB so that values won't overflow to negative when dealing with malformed UTF8. check-in: 77f01578 user: drh tags: trunk
09:11
Fix a bug exposed by combining matchinfo(), NEAR and "ORDER BY rowid DESC". check-in: 5f6b87f4 user: dan tags: fts3-prefix-search
2011-06-10
18:33
When updating a field that requires foreign key constraints be checked, ensure that the indexes and tables are consistent when the FK logic is run. Otherwise, it may detect the inconsistency and report database corruption. check-in: 2b3d9996 user: dan tags: trunk
16:33
Fix minor problems with foreign key constraints where the parent table is the same as the child table. check-in: 442d8d8b user: dan tags: trunk
2011-06-09
17:53
Fix a line in pcache1.c where a global data structure is accessed without using the GLOBAL() macro. This causes a subtle malfunction on test systems that use SQLITE_OMIT_WSD. check-in: b11b2e1f user: dan tags: trunk
10:48
Fix problems to do with using both OR and NEAR operators in a single expression. check-in: 4e8dd19e user: dan tags: fts3-prefix-search
2011-06-08
18:39
Fix various issues to do with deferred tokens, NEAR expressions and matchinfo(). check-in: 3972a787 user: dan tags: fts3-prefix-search
2011-06-07
18:35
Have NEAR queries use incremental merging. Fix issues surrounding the deferred token optimization. check-in: 9d10a684 user: dan tags: fts3-prefix-search
18:31
Fix a comment type on the description of the Schema object. check-in: 095cd9a6 user: drh tags: trunk
2011-06-06
18:14
Merge the latest trunk changes into the fts3-prefix-search branch. check-in: 567dd843 user: drh tags: fts3-prefix-search
14:51
Modify fts3rnd.test to run tests for both "ORDER BY docid ASC" and "ORDER BY docid DESC" with both order=ASC and order=DESC FTS tables. Fixes for some bugs found. check-in: 89f2f482 user: dan tags: fts3-prefix-search
13:38
Add assert() statements to verify that u16 pointers associated with the enhancement in [897f56a158] are always 2-byte aligned. check-in: 98ccfa93 user: drh tags: trunk
06:55
Clean up the code for processing FTS4 options a bit. check-in: 0425138a user: dan tags: fts3-prefix-search
2011-06-04
20:13
Remove some unreachable code. check-in: 650e1a79 user: dan tags: fts3-prefix-search
20:04
Allow the "order=DESC" and "order=ASC" parameters in FTS4 "CREATE VIRTUAL TABLE" statements. Tables created with "order=DESC" store all doclists in descending order, which allows optimizations normally applied to "ORDER BY docid ASC" queries to be used with "ORDER BY docid DESC" queries instead. check-in: f6a0193f user: dan tags: fts3-prefix-search
01:43
Performance improvement to the btree search routine. check-in: 65db822f user: drh tags: trunk
2011-06-03
23:28
Performance improvements on memory copies inside of btree by moving 2 bytes at a time instead of just 1 byte at a time. check-in: 897f56a1 user: drh tags: trunk
21:34
Performance enhancement to the blob-literal tokenizer. check-in: 61aa2031 user: drh tags: trunk
20:11
Create and use a function especially for adding the ParseSchema opcode. This gives a small reduction in code and a small performance increase. check-in: 957b2ab6 user: drh tags: trunk
18:00
FTS changes: Remove unreachable code. Fix bugs. When processing a large doclist incrementally, read from disk incrementally too. check-in: a4c7e282 user: dan tags: fts3-prefix-search
17:50
Factor an "if" out of a loop in balance_nonroot() for about a 1% performance increase. check-in: 1bd72d0c user: drh tags: trunk
14:19
Hush some harmless compiler warnings in the URI parsing logic. check-in: 0206bc6f user: drh tags: trunk
13:28
Include more detailed version information in the command-line shell output. check-in: 049c3c42 user: drh tags: trunk
13:06
Add shell scripts used for testing compiler warnings (tool/warnings.sh), for verifying that the library exports the correct symbols (tool/symbols.sh), and to demonstrate building a full-featured command-line shell (tool/build-shell.sh). check-in: 3aca9a92 user: drh tags: trunk
13:02
Fix the build when using SQLITE_OMIT_PRAGMA. check-in: 051f4635 user: drh tags: trunk
12:15
Fix an #ifdef of SQLITE_OMIT_VIRTUALTABLE that had an extra "_" character. check-in: 93e0be2b user: drh tags: trunk
2011-06-02
19:57
Changes to improve performance and support LIMIT clauses on fts3 tables. This branch is unstable for now. check-in: 28149a78 user: dan tags: fts3-prefix-search
17:24
Fix a faulty assert() in the WAL-mode logic for read-only shared memory. check-in: a13cfe61 user: drh tags: trunk
15:48
Add a missing check for out-of-memory in the lemon code generator. check-in: efb20b9d user: drh tags: trunk
13:04
Merge the read-only shared memory branch into trunk. After this merge, an unprivileged process can open WAL-mode databases owned by another user as long as a database connection with write permission exists on the database file and if the readonly_shm=1 URI query parameter is supplied. check-in: 19084a66 user: drh tags: trunk
2011-06-01
20:13
Make use of the sqlite3GetBoolean() interface for more robust processing of the readonly_shm query parameter inside of unixShmMap(). Closed-Leaf check-in: 1f930d7e user: drh tags: wal-readonly
20:01
Simplify the wal-readonly branch so that it does not require changes to anything other than os_unix.c and wal.c and a couple of new error codes. check-in: d6b4709d user: drh tags: wal-readonly
19:44
Pull the latest trunk changes into the wal-readonly branch. check-in: 0b63b713 user: drh tags: wal-readonly
19:16
Avoid unnecessary duplication of SQL parameter names. check-in: e704e869 user: drh tags: trunk
18:15
Refactor the SQL parameter processing so that parameter names for values that are optimized out of the prepare statement are not forgotten. check-in: b3aaf715 user: drh tags: trunk
2011-05-31
17:08
Merge the latest trunk changes into the wal-readonly branch. check-in: 2c6b5a28 user: drh tags: wal-readonly
16:50
Fix a problem in the sqlite3TestErrorName() function (used only for testing) that appears to have originated from a bad merge. check-in: a0ae314c user: drh tags: trunk
11:56
Update the documentation to state that any parameter that is optimized out of a prepared statement becomes an anonymous parameter for which sqlite3_bind_parameter_name() returns NULL. check-in: 701b8a23 user: drh tags: trunk
2011-05-30
23:42
Minor performance improvements. check-in: f9950c6a user: drh tags: trunk
15:06
Update evidence marks on the URI filename tests to conform to the latest documentation. check-in: 1bab03c4 user: drh tags: trunk
14:35
Make sure the P5 argument to the OP_VUpdate opcode is always set to a valid conflict resolution code. check-in: e3350dbd user: drh tags: trunk
2011-05-28
19:24
Fix a "#ifdef" from check-in [03f7d36a8a] that should have been "#ifndef". check-in: edb865c3 user: drh tags: trunk
15:57
Minor changes made while planning a larger change. check-in: 84097a4c user: dan tags: fts3-prefix-search
15:53
Print a log message on each cache spill if compiled with SQLITE_LOG_CACHE_SPILL. check-in: 5f15579f user: drh tags: trunk