Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
62 check-ins using file src/pragma.c version 9e778dec
2011-06-06
| ||
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) | |
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) | |
2011-06-03
| ||
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) | |
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) | |
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
| ||
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) | |
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) | |
2011-05-06
| ||
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) | |
2011-05-05
| ||
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) | |
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) | |
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-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
| ||
19:37 | Add the start of the "uri-filenames" feature. (check-in: b8a8132e user: dan tags: uri) | |