Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
200 most recent check-ins using file test/fkey3.test version 42f88d60
2012-08-25
| ||
00:49 | Backport check-in [62678be3df35cd]: When the same index is used for all OR-terms in a WHERE clause, then try to use that index as a covering index. (Leaf check-in: 865dfcba user: drh tags: branch-3.7.2) | |
2011-12-23
| ||
11:07 | Fix a problem with [f9c4a7c8f4] as applied to this branch. (Leaf check-in: e6a04bf9 user: dan tags: branch-3.7.6) | |
2011-12-22
| ||
18:44 | Backport the fixes for Coverity-discovered problems in [1c27d84216], [676acce274], and [f9c4a7c8f4] from trunk to the 3.7.6 branch. (check-in: a61786e7 user: drh tags: branch-3.7.6) | |
2011-10-25
| ||
21:18 | Cherrypick the [3513bf6ee090d9] so that the sqlite_source_id() function works correctly even with newer versions of Fossil (check-in: 89d63a0e user: drh tags: branch-3.7.2) | |
20:36 | Cherrypick changes [53f5cfe115] and [1f7ef0af8d] in order to fix an issue with DISTINCT (check-in: 14bc58ca user: drh tags: branch-3.7.2) | |
2011-08-26
| ||
18:28 | Veryquick and min.rc tests now passing. (Closed-Leaf check-in: a7e18468 user: drh tags: stat3-3.7.2) | |
18:04 | Merge the branch-3.7.2 changes into the stat3-3.7.2 subbranch. Also fix some test script issues. (check-in: a42db19d user: drh tags: stat3-3.7.2) | |
17:17 | Cherrypick the recursion fix to test_vfs.c from [065e5a5ea4f82]. Also fix the nan.test module to handle upper/lower case changes in TCL. (check-in: 41b5f869 user: drh tags: branch-3.7.2) | |
15:51 | Get stat3 working after import from trunk-based the stat3-enhancement branch. There is still a problem in the wal2 test. (check-in: 01cc4ff6 user: drh tags: stat3-3.7.2) | |
13:52 | Merge branches branch-3.7.2 and stat3-enhancement into a new branch for testing purposes. (check-in: 0df04f92 user: drh tags: stat3-3.7.2) | |
2011-07-13
| ||
18:53 | Cherrypicked from trunk: Do not try to use STAT2 for row estimates if the index is unique or nearly so. (check-in: d55b64ef user: drh tags: branch-3.7.2) | |
2011-07-12
| ||
14:48 | Cherrypick change [9f14fa56ba] (the fix for [54844eea3f]) from the trunk. (check-in: 7afb2354 user: dan tags: branch-3.7.2) | |
2011-07-02
| ||
15:42 | Cherrypick change [27c65d4d9c] into the 3.7.2 branch. (check-in: 9bbcd8c0 user: dan tags: branch-3.7.2) | |
13:34 | Cherrypick [45e581bff7] into the 3.7.2 branch. (check-in: c593792c user: dan tags: branch-3.7.2) | |
2011-06-21
| ||
15:58 | Give the osLocaltime() function file scope in date.c. (check-in: 1abce55a user: dan tags: branch-3.7.6) | |
15:15 | Backport the localtime() failure fix of ticket [bd484a090c8077] to the 3.7.6 branch. (check-in: 5d4b0c5b user: drh tags: branch-3.7.6) | |
2011-06-14
| ||
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) | |
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-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:07 | Merge the latest trunk changes, including the read-only shared memory enhancement, into the apple-osx branch. (check-in: ce5f95de user: drh tags: apple-osx) | |
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) | |
11:26 | Toward version 3.7.5.1. This check-in updates the version number and also patches the pager so that it never spills cache while in WAL mode. The latter patch fixes ticket [2d1a5c67dfc23] and also prevents excessive WAL file sizes if the pager cache starts thrashing. A few test cases fail. (Leaf check-in: 2e5a912a user: drh tags: branch-3.7.5) | |
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) | |
13:39 | Merge the latest trunk changes into the sessions branch. (check-in: 832886b1 user: drh tags: sessions) | |
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) | |
2011-05-26
| ||
14:19 | Changes to work with SQLITE_OMIT_VIRTUAL_TABLE. (check-in: 03f7d36a user: drh tags: trunk) | |
2011-05-25
| ||
23:18 | Fix some minor and harmless compiler warnings. (check-in: a4755e70 user: drh tags: trunk) | |
20:25 | Ignore malloc failures within the WAL file truncation attempt for journal_size_limit. (check-in: dd19105a user: drh tags: trunk) | |
19:17 | If a prefix index of size N is not present, use a prefix index of size N+1 along with the terms index for queries for prefixes of length N. (check-in: cc83991c user: dan tags: fts3-prefix-search) | |
18:47 | Merge trunk changes into experimental fts3-prefix-search branch. (check-in: f0f0a03d user: dan tags: fts3-prefix-search) | |
18:46 | Fix a case where a malloc() error could lead to mismatched virtual-table xBegin/xCommit/xRollback callbacks. (check-in: d807304a user: dan tags: trunk) | |
18:34 | Change fts4 so that the prefix= parameter is passes a comma-separated list of integers. For each integer N, a separate index of all prefixes of length N bytes is created. (check-in: be59bf49 user: dan tags: fts3-prefix-search) | |
15:54 | Fix a compiler warning. (check-in: 6df99e52 user: drh tags: trunk) | |
01:16 | Changes to savepoint in virtual tables for simpler and more consistent operation. (check-in: 92f26a8b user: drh tags: trunk) | |
2011-05-24
| ||
18:49 | If the fts4 option prefix=1 is specified, have the fts4 module maintain an index of prefixes as well as terms. (check-in: b5bdc639 user: dan tags: fts3-prefix-search) | |
15:36 | Do not invoke the xRollbackTo or xRelease methods of a virtual table without having first invoked an appropriate xSavepoint method. Add assert() statements to FTS3/4 to verify that this is happening in all cases. (check-in: 651ef242 user: drh tags: trunk) | |
00:35 | Make sure the savepoint index is correct one calls to sqlite3VtabSavepoint with SAVEPOINT_BEGIN. (check-in: a9d09566 user: drh tags: trunk) | |
2011-05-23
| ||
18:37 | Minor cleanups to the header comments on various test_*.c file, to make the suitable for programmer-level documentation. (check-in: a65d043a user: drh tags: trunk) | |
2011-05-20
| ||
20:42 | Adjustments to documentation hyperlinks to accommodate the new VFS documentation. (check-in: 139a8f53 user: drh tags: trunk) | |
13:26 | Add a big comment to the top of test_vfstrace.c to explain how to compile and use that module. (check-in: a6a0fefb user: drh tags: trunk) | |
01:50 | Fix the URI test script so that it works even if there is a subdirectory named "test". (check-in: 2018d4e1 user: drh tags: trunk) | |
01:49 | Mark an unreachable branch in the recent WAL problem as unreachable. (check-in: 3e8a29ff user: drh tags: trunk) | |
2011-05-19
| ||
13:26 | Version 3.7.6.3. (check-in: ed1da510 user: drh tags: release, branch-3.7.6, version-3.7.6.3) | |
07:53 | Add another test for [2d1a5c67df]. (check-in: 97fcd9e8 user: dan tags: trunk) | |
02:48 | Merge all the latest trunk changes into the sessions branch, especially the disappearing WAL transaction fix. (check-in: 5b1b536c user: drh tags: sessions) | |
02:34 | Bring the apple-wal-readonly branch up to date with the latest changes in apple-osx, and especially the fix for disappearing WAL transactions. (Leaf check-in: 57912327 user: drh tags: apple-wal-readonly) | |
01:51 | Pull all the latest trunk changes, and especially the fix for WAL cache spills causing transactions to disappear, into the apple-osx branch. (check-in: 8d1a6bb0 user: drh tags: apple-osx) | |
01:46 | Backport the [67bf1c9a88] fix for vanishing WAL transactions due to small cache spillage. Ticket [2d1a5c67dfc236]. Also bump the version number to 3.7.6.3 in preparation for patch release. (check-in: e4d0f7ac user: drh tags: branch-3.7.6) | |
01:21 | When committing a WAL transaction, make sure at least one page is written to the WAL file so that the WAL subsystem will have a page on which to set the commit flag. Ticket [2d1a5c67dfc236]. (check-in: 67bf1c9a user: drh tags: trunk) | |
2011-05-18
| ||
17:15 | Enable URI filenames in the command-line shell. Add a check to the beginning of the shell to make sure it is compiled with the same SQLite source and header. (check-in: de58cb28 user: drh tags: trunk) | |
03:02 | Make sure the multiplexor shim uses a full pathname for temp file that it creates. (check-in: 186d7ff1 user: drh tags: trunk) | |
02:41 | Remove unreachable branches from the 8.3 filename logic. (check-in: 4f7e7b44 user: drh tags: trunk) | |
02:22 | Update multiplex VFS to handle empty filenames which can occur for during vacuuming (temp file names.) (check-in: a0749860 user: shaneh tags: trunk) | |
2011-05-17
| ||
20:36 | Add the ability to limit filenames to 8+3 using the SQLITE_ENABLE_8_3_NAMES compile-time option together with a URI parameter of "8_3_names=1". (check-in: 96d60985 user: drh tags: trunk) | |
19:43 | Fix an off-by-one error in the new sqlite3_uri_parameter() function. (check-in: 9593a640 user: drh tags: trunk) | |
18:53 | Add the sqlite3_uri_parameter() interface function for use in building new VFSes. (check-in: 6b5de95f user: drh tags: trunk) | |
15:56 | Add extended return code SQLITE_CORRUPT_VTAB. Returned when the tcontents of the sqlite tables used internally by a virtual table module are invalid or inconsistent. (check-in: 8844e8bf user: dan tags: trunk) | |
15:21 | Avoid exceeding array bounds when reading a corrupt database file in autovacuum mode. Fixes a problem discovered by John Regehr and Peng Li using a customized clang compiler. (check-in: f7c525f5 user: drh tags: trunk) | |
14:41 | Avoid including fts3_term.c in the amalgamation, as it contains test code only. (check-in: f392b7ae user: dan tags: trunk) | |
2011-05-16
| ||
21:00 | Enhance WAL mode so that the WAL file honors the journal size limit set by PRAGMA journal_size_limit. (check-in: db7e500f user: drh tags: trunk) | |
2011-05-13
| ||
18:51 | Make arrangements so that virtual table inserts into shadow tables do not modify the sqlite3_last_insert_rowid() return. Document that this is how sqlite3_last_insert_rowid() works. (check-in: e569f18b user: drh tags: trunk) | |
17:11 | Rather than document goofy behavior, it seems better to make the behavior less goofy. (Was: Updates to the sqlite3_last_insert_rowid() documentation - to make it clear that the function does not work for virtual tables.) (Closed-Leaf check-in: f88dfac3 user: drh tags: mistake) | |
17:11 | Also add fts3_term.c to main.mk. (check-in: 966f2d2c user: drh tags: trunk) | |
2011-05-12
| ||
21:01 | Add fts3_term.c to amalg gen script and configure input files. (check-in: 6ee07732 user: shaneh tags: trunk) | |
15:32 | Pull in the patches to support read-only WAL databases into a new branch off of the apple-osx branch. This also pulls in all the other pending 3.7.7 changes such as URI support. (check-in: 97b98010 user: drh tags: apple-wal-readonly) | |
2011-05-11
| ||
20:54 | Improvements to documentation hyperlinks. Change the value of SQLITE_OPEN_URI to an unreserved value. (check-in: 851ab75d user: drh tags: trunk) | |
19:00 | URI filename documentation updates. (check-in: 8885c867 user: drh tags: trunk) | |
17:36 | Add missing comments associated with readonly shm changes. (check-in: 6a2ea52e user: dan tags: wal-readonly) | |
15:53 | Merge latest trunk changes. Add a couple of readonly shm tests. (check-in: cde45a03 user: dan tags: wal-readonly) | |
14:57 | Only open a read-only connection to shared-memory if the "readonly_shm=1" option is specified as part of the database file URI (and if a read-write connection fails). (check-in: 671ba5fc user: dan tags: wal-readonly) | |
2011-05-10
| ||
18:39 | Have flags passed to sqlite3_open_v2() apply to the main and any attached databases. And change things so that any "mode=xxx" or "cache=xxx" options specified as part of a URI for the main database do not also apply to attached databases. (check-in: 3e490915 user: dan tags: trunk) | |
17:43 | Update URI test cases to account for the new error message format. (check-in: 5bde5680 user: dan tags: trunk) | |
17:31 | Add experimental support for read-only connections to WAL databases. (check-in: bb59f986 user: dan tags: wal-readonly) | |
14:52 | Provide the ability to specify an alternative mutex subsystem at compile-time. - This check-in should have gone on the trunk, not on the 3.7.6 branch. (Closed-Leaf check-in: 489c453d user: drh tags: mistake) | |
10:17 | Add new documentation keywords to the sqlite3_vfs description. (check-in: ad3389a9 user: drh tags: trunk) | |
2011-05-09
| ||
19:20 | Return a suitable error message if the mode= argument to a URI specifies a higher mode than what is allowed by context. Other minor cleanups for the URI parsing logic. (check-in: d9bc1c7f user: drh tags: trunk) | |
2011-05-07
| ||
18:40 | Set the sqlite3.mallocFailed flag if sqlite3ParseUri fails with SQLITE_NOMEM. (check-in: ca3797d4 user: drh tags: trunk) | |
18:18 | Return SQLITE_MISUSE from the sqlite3_open_v2() function if the 3rd parameter is not a valid set of bit-values. (check-in: 3c926ce0 user: drh tags: trunk) | |
14:40 | Fix minor compiler warnings. (check-in: 139eecbe user: drh tags: trunk) | |
2011-05-06
| ||
18:55 | Merge the uri branch with the trunk. (check-in: 88df33c4 user: dan tags: trunk) | |
18:53 | Remove some unnecessary modifications from the uri branch. Add a test to show that ATTACH only interprets its argument as a URI if the connection was opened with SQLITE_OPEN_URI (or URI interpretation is globally enabled). (Closed-Leaf check-in: aa90b943 user: dan tags: uri) | |
18:34 | Update comments and documentation associated with new URI parsing code. Add test file e_uri.test, containing tests mapped to documentation regarding URI filenames. (check-in: 92751788 user: dan tags: uri) | |
13:58 | Merge windows test case fixes. No changes to code. (check-in: 2e5c0ed7 user: dan tags: trunk) | |
00:19 | Increase the iVersion for sqlite3_module needed for the xSavepoint, xRelease, and xRollbackTo methods from 1 to 2. This is so that it will conform to published documentation. (check-in: 0f4954e9 user: drh tags: trunk) | |
2011-05-05
| ||
23:07 | Fix an incorrect assert() in sqlite3_value_config(). Updates to the sqlite3_value_config() documentation. (check-in: 22cbc01a user: drh tags: trunk) | |
19:44 | Changes to various test scripts so that they pass on windows. (Closed-Leaf check-in: 1586244b user: dan tags: win32-test-fixes) | |
18:53 | Have the xFullpath method in os_win.c discard the initial "/" if a filename begins with "/X:", where X is any alphabetic character. Also fix some test issues in uri.test. (check-in: fe57a8f6 user: dan tags: uri) | |
17:41 | Fix sqlite3_vtab_on_conflict() to return the correct values for ABORT, FAIL, and IGNORE. (check-in: f0617d61 user: drh tags: trunk) | |
17:00 | Fix a bug in memory usage tracking that was introduced by check-in [4e33a0eaf83922]. (check-in: 8ba456ae user: drh tags: trunk) | |
15:52 | Merge the latest trunk changes into the apple-osx branch. (check-in: f9b149e5 user: drh tags: apple-osx) | |
15:46 | Merge the latest trunk changes into the sessions branch. (check-in: 6883580e user: drh tags: sessions) | |
15:39 | Bump the version number to 3.7.7 on account of the new sqlite3_vtab_config() and sqlite3_vtab_on_conflict() interfaces. Updates to the documentation on those interfaces. (check-in: 930be6a1 user: drh tags: trunk) | |
13:54 | Change sqlite3_create_module() so that it avoids resetting the schema as long as preexisting modules are unchanged. (check-in: 8485855a user: drh tags: trunk) | |
13:53 | Add a #include to test_demovfs.c in an effort to get it to compile on Solaris. (check-in: 8f06ea33 user: drh tags: trunk) | |
12:35 | Fix a problem in the URI code preventing the amalgamation from building. Add comments describing SQLITE_CONFIG_URI and SQLITE_OPEN_URI to sqlite.h.in. (check-in: ea562d6d user: dan tags: uri) | |
2011-05-04
| ||
17:35 | Merge latest trunk changes with uri branch. (check-in: af279f36 user: dan tags: uri) | |
17:23 | Merge vtab-conflict branch with trunk. (check-in: 8f9666af user: dan tags: trunk) | |
16:30 | Fix a couple of compiler warnings in the FTS code. (Closed-Leaf check-in: 1a113359 user: dan tags: vtab-conflict) | |
15:41 | Fix a performance problem in queries that use "ORDER BY rowid DESC" and one or more FTS auxiliary functions. (check-in: 95e09b20 user: dan tags: vtab-conflict) | |
12:52 | Optimize "ORDER BY rowid/docid DESC/ASC" clauses on FTS tables. (check-in: 13395121 user: dan tags: vtab-conflict) | |
2011-05-03
| ||
15:09 | Remove some unused code related to URI parsing. (check-in: 008cd0ef user: dan tags: uri) | |
11:53 | Allow only "localhost" and "" as authorities in URIs. Do not allow escapes (%HH) in the authority part of a URI. (check-in: b8a0f1b5 user: dan tags: uri) | |
10:22 | Change the supported URI options to "mode" and "cache". (check-in: 0a694a0b user: dan tags: uri) | |
2011-05-02
| ||
17:41 | Merge the latest trunk changes into uri branch. (check-in: 7fdd0786 user: dan tags: uri) | |
2011-05-01
| ||
22:57 | Backport check-ins [0900e35348f4b9bf3] and [4fead8e714c7e50] to the 3.7.2 branch. These check-ins provide hints to the btree layer for when it is possible to use a hash table rather than a btree to implement an index. The SQLite BTree layer does not use these hints, but alternative btree layers might. (check-in: 7155e6f3 user: drh tags: branch-3.7.2) | |
2011-04-28
| ||
18:46 | Have r-tree virtual tables support on-conflict clauses. (check-in: 822ab52f user: dan tags: vtab-conflict) | |
2011-04-27
| ||
19:54 | In windows, ignore ERROR_NOT_LOCKED when calling the read-lock removal routine. (check-in: f55156c5 user: drh tags: trunk) | |
18:08 | Change the name of an internal function to avoid conflicts with the math library. (check-in: 1bd1484c user: drh tags: trunk) | |
16:05 | Expose the UTF8 to MBCS conversion routine in os_win.c to external applications. (check-in: 7b479b9b user: drh tags: trunk) | |
16:02 | Add documentation for the newly introduced sqlite3_vtab_config() and on_conflict() API functions. Test that encountering an SQLITE_MISMATCH in fts3 does not corrupt the full text index. (check-in: abdd70ae user: dan tags: vtab-conflict) | |
12:08 | Fix problems related to savepoint rollback and fts3. (check-in: ff69f823 user: dan tags: vtab-conflict) | |
01:00 | Fix a comment typo. (check-in: 19c6625a user: drh tags: trunk) | |
2011-04-26
| ||
19:21 | Extra tests for fts3. And fixes for conflict-handling related problems in fts3. (check-in: fb4a3558 user: dan tags: vtab-conflict) | |
2011-04-25
| ||
18:49 | Add support for on conflict clauses to fts3/fts4. (check-in: 6d2633a6 user: dan tags: vtab-conflict) | |
18:20 | Test case for the ".log" command to the command-line shell. (check-in: 7d0ff26a user: drh tags: trunk) | |
18:03 | Add the (deliberately undocumented) sqlite_log() SQL function as a built-in. (check-in: f7806e03 user: drh tags: trunk) | |
18:01 | Invoke the unix open() system call through a wrapper to avoid problems resulting from differing declarations to that function in various systems. (check-in: 4c7ff4dd user: drh tags: trunk) | |
2011-04-24
| ||
22:56 | Disable the transfer optimization if the destination table contains any foreign key constraint and foreign key constraints are enabled. Ticket [6284df89debdf]. (check-in: ddeea5ab user: drh tags: trunk) | |
2011-04-23
| ||
19:06 | Test that it is now possible to use different VFSs for two databases attached to a single handle. (check-in: 2af51f85 user: dan tags: uri) | |
15:54 | Have the ATTACH command do URI interpretation in the same way as sqlite3_open() and sqlite3_open_v2() do. (check-in: 68240e75 user: dan tags: uri) | |
10:12 | Fix parsing of %00 in uri handling code. (check-in: 44f0874a user: dan tags: uri) | |
2011-04-22
| ||
22:55 | Add the "getlock" utility for determining if a database file (on unix) is currently locked. (check-in: 0ab24b13 user: drh tags: trunk) | |
19:37 | Add the start of the "uri-filenames" feature. (check-in: b8a8132e user: dan tags: uri) | |
2011-04-20
| ||
13:35 | Update a comment in e_createtable.test. (check-in: d8b149f5 user: dan tags: trunk) | |
2011-04-19
| ||
06:43 | Avoid passing NULL to the xOpen method of an FTS3/4 tokenizer. (check-in: 0dd09fc0 user: dan tags: trunk) | |
2011-04-18
| ||
17:30 | Merge trunk changes into sessions branch. (check-in: b91b4c31 user: dan tags: sessions) | |
15:47 | Fix further missing comments and other minor issues in the session module code. (check-in: 99f0f350 user: dan tags: sessions) | |
12:05 | Fix some missing comments and other issues with session module code. (check-in: 20d7c280 user: dan tags: sessions) | |
07:36 | Further coverage tests for the session module. (check-in: 69a01c70 user: dan tags: sessions) | |
2011-04-17
| ||
17:25 | Version 3.7.6.2 (check-in: 154ddbc1 user: drh tags: release, version-3.7.6.2, branch-3.7.6) | |
17:17 | Bump the version number to 3.7.6.2 (check-in: c429edf3 user: drh tags: branch-3.7.6) | |
17:14 | Change the prototype for the open() system call to agree with Posix. Though a faulty function prototype in a pointer cast is a seemingly innocuous error, the correct prototype is necessary for pthreads to work correctly on NetBSD. (check-in: 986f2f25 user: drh tags: branch-3.7.6) | |
17:09 | Change the prototype for the open() system call to agree with Posix. Though a faulty function prototype in a pointer cast is a seemingly innocuous error, the correct prototype is necessary for pthreads to work correctly on NetBSD. (check-in: 3e135748 user: drh tags: trunk) | |
00:55 | Adjust some test cases in triggerC.test to handle non-default SQLITE_MAX_TRIGGER_DEPTH settings. (check-in: 9d6c6129 user: shaneh tags: trunk) | |
2011-04-16
| ||
19:23 | Improve test coverage of session module. (check-in: f46d4b64 user: dan tags: sessions) | |
2011-04-15
| ||
21:37 | Adjust test case in quota.test to handle Windows dir seperators. (check-in: 75ed1bce user: shaneh tags: trunk) | |
20:18 | Updates to test code in os_win to bring winSync inline with unixSync (test code only). Updated a few test scripts to account for dirsync counting issues on Windows. (check-in: 8f99c5bf user: shaneh tags: trunk) | |
19:30 | Remove stray semi-colon that MSVC complained about. (check-in: 7a085271 user: shaneh tags: trunk) | |
19:18 | Improve coverage of session module. (check-in: 3dfd1d63 user: dan tags: sessions) | |
16:39 | Changes to memory allocator usage tracking to delay the onset of integer overflow. (check-in: 4e33a0ea user: drh tags: trunk) | |
16:03 | Add tests and fixes for OOM handling in sqlite3changeset_concat(). (check-in: df0b2d21 user: dan tags: sessions) | |
15:18 | Backport check-in [9f9f32882501ac9] to provide EXPLAIN QUERY PLAN output for the count(*) optimization. Also backport check-in [a8761a9128de945aa] to prevent unordered indices from being used on a full table scan. The first backport was necessary in order to test the second. (check-in: 8d924e16 user: drh tags: branch-3.7.2) | |
15:04 | Have sqlite3changeset_concat() return SQLITE_SCHEMA if an attempt is made to concatenate changesets based on incompatible database schemas. (check-in: 343b6451 user: dan tags: sessions) | |
14:46 | Do not do full table scans of unordered indices. (check-in: a8761a91 user: drh tags: trunk) | |
14:33 | Fix #ifs involving SQLITE_ENABLE_LOCKING_STYLE so that they check the value of that macro and not whether it is defined. (check-in: 8775f159 user: drh tags: trunk) | |
13:29 | Add retry logic to GetFileAttributesEx() on windows. (Closed-Leaf check-in: 1cca9a49 user: drh tags: experimental) | |
12:36 | Make sure the unix backend returns SQLITE_FULL if write() fails with an ENOSPC error code. (check-in: 721e3c16 user: drh tags: trunk) | |
12:04 | Add documentation for sqlite3changeset_concat() to sqlite3session.h. (check-in: ada9efa5 user: dan tags: sessions) | |
2011-04-14
| ||
18:01 | Add further tests for the sqlite3changeset_concat() function. Also fixes. (check-in: 1fc3f15d user: dan tags: sessions) | |
11:16 | Start adding the sqlite3changeset_concat() function to the session module. (check-in: 8927b226 user: dan tags: sessions) | |
2011-04-13
| ||
23:42 | Remove extra CR and NL characters from FormatMessage() generated error messages in the windows VFS. (check-in: 8332949c user: drh tags: trunk) | |
20:26 | Add new extended error codes for I/O errors on seek and shared-memory map. Add sqlite3_log() calls in the windows backend to record details of errors. (check-in: fe603217 user: drh tags: trunk) | |
16:52 | Fix a usage comment typo in the showdb utility. (check-in: 8744ced4 user: drh tags: trunk) | |
15:42 | Update the apple-osx branch to version 3.7.6.1. (check-in: 289194d6 user: drh tags: apple-osx) | |
14:40 | Version 3.7.6.1 (check-in: a35e83ea user: drh tags: trunk, release, version-3.7.6.1) | |
14:02 | Bump the version number to 3.7.6.1 in preparation for a bug-fix release. (check-in: 5f0c394a user: drh tags: trunk) | |
13:42 | Make sure the array of overloadable system calls is always correctly sized, regardless of the compile-time configuration. Ticket [bb3a86e890c8e96ab]. (check-in: c6e727ab user: drh tags: trunk) | |
2011-04-12
| ||
01:58 | Version 3.7.6. (check-in: f9d43fa3 user: drh tags: trunk, release, version-3.7.6) | |
2011-04-11
| ||
18:35 | Do not override the fchmod system call in unix unless the SQLITE_ENABLE_LOCKING_STYLE compile-time option is engaged. (check-in: 51029d84 user: drh tags: trunk) | |
15:36 | Updates to the OS/2 patches. This change also move the location of a global variable declaration in shell.c which might effect other build targets. (check-in: 73906b67 user: drh tags: trunk) | |
15:35 | Fix a signed integer overflow problem in the testcase() macro. (check-in: f18f5f58 user: drh tags: trunk) | |