Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
200 most recent check-ins using file test/fts3fault2.test version 3198eef2
|
2017-07-21
| ||
| 03:23 | Add new interfaces sqlite3_result_pointer(), and sqlite3_value_pointer() and use them to transfer the eponymous FTS3 column pointer to the snippet() and offsets() routines. This is a cherry-pick of [f0f492245e95], which is in turn inspired by check-in [72de49f2]. Leaf check-in: a66a5b39 user: drh tags: branch-3.8.6 | |
|
2016-08-10
| ||
| 03:35 | Try to make pcache1TruncateUnsafe() run faster for the case where iLimit is very close to iMaxKey. Leaf check-in: 9ab53605 user: drh tags: debug | |
| 02:54 | Remove all timers and other debugging logs except for the one timer on pcache1TruncateUnsafe(). check-in: 5980e625 user: drh tags: debug | |
|
2016-08-09
| ||
| 11:44 | Add another timer on pcache1TruncateUnsafe(). check-in: 42ce53f6 user: drh tags: debug | |
| 11:23 | Add a debug timer to pcache1Truncate(). Change the formatting of some other messages to make them easier to read. check-in: 7d0af4b5 user: dan tags: debug | |
| 01:21 | Refocus the timer on the pager_end_transaction() routine. check-in: 9d4eb6e4 user: drh tags: debug | |
|
2016-08-04
| ||
| 14:08 | Add extra logging calls to this branch. check-in: 491f1ef3 user: dan tags: debug | |
|
2016-07-30
| ||
| 03:33 | A new version of the slow mutex log that uses gettimeofday() instead of trying to access the hardware timer. check-in: 92b9fead user: drh tags: debug | |
|
2016-07-29
| ||
| 16:32 | Turn memory status off by default. check-in: ea3c7162 user: drh tags: debug | |
| 14:31 | Enhance a debugging log message to better identify a mutex. check-in: e60cb6d8 user: dan tags: debug | |
| 14:23 | Use __sync_synchronous(), when available, instead of a mutex when a memory barrier is needed. check-in: 7d4562e9 user: drh tags: debug | |
| 14:10 | Add calls to sqlite3_log() when sqlite3_mutex_enter() takes more than 100,000 CPU cycles. check-in: 33c7ef7a user: drh tags: debug | |
|
2016-07-16
| ||
| 11:47 | Temporarily add extra sqlite3_log() calls to this version to help with debugging a performance problem. check-in: 613c1cea user: dan tags: debug | |
|
2016-07-14
| ||
| 20:19 | Experimental patch restore the slight bias in btree-balancing immediately after the change to reduces the amount of memcpy() work done by balancing. Leaf check-in: 46bd9533 user: drh tags: btree-balance-bias | |
|
2015-08-13
| ||
| 21:43 | Convert the hint expression of the CursorHint opcode into a string for display by EXPLAIN. Leaf check-in: 12640cb2 user: drh tags: cursor-hints-displayP4 | |
|
2015-05-21
| ||
| 17:24 | Prevent a virtual table from being destroyed while it is in use. Also: replace Vdbe.inVtabMethod with sqlite3.nVDestroy. Simplify the EXPLAIN output for P4.pVtab to only show the sqlite3_vtab pointer. Cherrypick of [cbeb9a1aed8c]. check-in: b3bb660a user: dan tags: branch-3.8.6 | |
| 17:21 | Avoid ever writing before the start of an allocated buffer in the DIRECT_OVERFLOW_READ code. Fix for [e3a290961a6]. Cherrypick of [c3c15d20c691]. check-in: 31b13eb5 user: dan tags: branch-3.8.6 | |
|
2015-05-20
| ||
| 20:50 | Fix a problem in test file e_reindex.test. Cherrypick of [5b3de9390f2f]. check-in: 80633682 user: dan tags: branch-3.8.6 | |
| 20:34 | Fix a problem causing the fts3 integrity-check to fail if run inside a transaction. Cherrypick of [3b925189a75e]. check-in: 7d7d633c user: dan tags: branch-3.8.6 | |
| 20:30 | Ensure that tables names are dequoted exactly once by the trigger and FK logic. Cherrypick of [59e92bd9521f] and [9d887b92f808]. check-in: bd357739 user: dan tags: branch-3.8.6 | |
| 20:27 | Fix an obscure problem with "INSERT INTO tbl(cols) SELECT" statements where the SELECT is a compound with an ORDER BY and "cols" is a strict subset of tbl's columns. Cherrypick of [718d5d0eab04]. check-in: 3cd2b772 user: dan tags: branch-3.8.6 | |
| 20:24 | Fix a potential NULL pointer deference on a corrupt database schema. Cherrypick of [dc61b292d8ea]. check-in: 7f3943fb user: dan tags: branch-3.8.6 | |
| 20:21 | Fix a bug caused by cherrypicking from a branch that assumes sqlite3_stricmp() can handle NULL arguments. check-in: 2c649cdf user: dan tags: branch-3.8.6 | |
| 19:57 | When parsing the schema, ignore any SQL that does not begin with "CREATE". Cherrypick of [d3c00d61581c]. check-in: 0da229b8 user: dan tags: branch-3.8.6 | |
| 19:53 | Detect and report oversized records constructed from multiple zeroblobs. Cherrypick of [9e139afd9211]. check-in: 4a08f6b8 user: dan tags: branch-3.8.6 | |
| 19:50 | Do not allow virtual table constructors to be called recursively. Cherrypick of [0a72726da215] check-in: 023a29ba user: dan tags: branch-3.8.6 | |
| 19:48 | Avoid signed integer overflow when converting oversized in-line integer widths and precisions in printf(). Cherrypick of [c494171f77dc], [5ce4e7d7651e], [95625ef3adc3] and [8e4ac2ce2441]. check-in: b330c7ff user: dan tags: branch-3.8.6 | |
| 19:44 | Ensure that comparison operators do not mess up the MEM_Dyn flag on registers when reverting affinity changes. Cherrypick of [02e3c88fbf6a]. check-in: 4125477e user: dan tags: branch-3.8.6 | |
| 19:34 | Fix a problem causing collation sequence names to be dequoted multiple times under some circumstances. Cherrypick of [eddc05e7bb31]. check-in: fc1a4f29 user: dan tags: branch-3.8.6 | |
| 19:32 | Silently ignore any attempt to add a prefix index for prefixes zero bytes in size to an fts3/4 table. Or any prefix index size so large that it overflows a 32-bit signed integer. Cherrypick of [ad4b19d2ac0889a2]. check-in: ff7be4db user: dan tags: branch-3.8.6 | |
|
2015-04-21
| ||
| 20:13 | Fix a problem in fts5fault1.test. check-in: a21d60cb user: dan tags: fts5 | |
| 19:07 | Fix an fts5 problem with large deletes. check-in: e50e8031 user: dan tags: fts5 | |
|
2015-04-20
| ||
| 18:48 | Fix some fts5 problems with very large position lists. check-in: 2ea8f9cb user: dan tags: fts5 | |
|
2015-04-15
| ||
| 18:49 | Logically store updates as (insert+delete) within the FTS tree. This allows keys to be annihilated more quickly under some circumstances. check-in: 50fae1f0 user: dan tags: fts5 | |
| 16:01 | Fix a problem preventing doclist indexes from being loaded. check-in: b29109a0 user: dan tags: fts5 | |
|
2015-04-14
| ||
| 20:15 | Begin changing fts5 to use a delete flag so that delete markers may be annihilated more quickly. check-in: 9341c070 user: dan tags: fts5 | |
|
2015-04-11
| ||
| 18:25 | Have fts5 integrity check verify that prefix indexes contain the same values as returned by prefix queries on the main terms index. check-in: bdb8e82a user: dan tags: fts5 | |
| 16:23 | Improve fts5 integrity-check so that it checks that DESC queries return the same as ASC. Change the poslist format slightly to make room for a delete-flag. check-in: 49c1e745 user: dan tags: fts5 | |
|
2015-04-07
| ||
| 21:17 | Correct typo in new test numbering. check-in: d176c9fa user: mistachkin tags: expShell | |
| 21:16 | Enhance the shell export to support emitting column names in 'insert' mode when headers are enabled. check-in: 6e504cd0 user: mistachkin tags: expShell | |
|
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 | |
| 09:05 | Fix a problem with fts3 prefix terms within phrase queries on "order=DESC" tables with a mix of negative and positive rowids. Closed-Leaf check-in: 0cdf5028 user: dan tags: fts3-prefix-query-fix | |
|
2015-04-04
| ||
| 16:49 | Fix a problem with resolving ORDER BY clauses that feature COLLATE clauses attached to compound SELECT statements. check-in: edc1de2a user: dan tags: trunk | |
| 16:43 | Fix a problem with resolving ORDER BY clauses that feature COLLATE clauses attached to compound SELECT statements. Closed-Leaf check-in: 427b50fb user: dan tags: compound-order-by-fix | |
| 00:02 | Enhance the 'releasetest.tcl' tool to support MSVC. check-in: f664bfdc user: mistachkin tags: winTest | |
|
2015-04-03
| ||
| 20:33 | Disable the SQLITE_FCNTL_WAL_BLOCK feature for now. It needs more work and is not yet ready for release. check-in: 4ae9a3ac user: drh tags: trunk | |
| 18:33 | Add source code to the "showlocks" utility program in the tool/ subdirectory. check-in: 6868cc66 user: drh tags: trunk | |
|
2015-04-02
| ||
| 17:46 | Fix build with OSTRACE enabled on Windows when building using separate source files. check-in: 5f6e3580 user: mistachkin tags: winTest | |
| 15:24 | Disable e_walauto.test on OpenBSD, as it requires a coherent cache. check-in: 90701227 user: dan tags: trunk | |
| 09:06 | Fix a problem in vdbesort.c to do with caching unpacked records. check-in: 80a00539 user: dan tags: sorter-opt | |
|
2015-04-01
| ||
| 18:22 | Merge latest trunk changes with this branch. check-in: 4621b2ee user: dan tags: sorter-opt | |
| 18:20 | When vacuuming an index that uses no collations other than BINARY, assume that the order of index entries will not be changed by the VACUUM. check-in: e403460b user: dan tags: sorter-opt | |
| 16:39 | Merge recent enhancements from trunk. check-in: aea439bd user: drh tags: sessions | |
| 16:18 | Reduce the CPU used by CREATE INDEX statements by taking better advantage of the fact that keys are inserted in sorted order. check-in: 592cdc5d user: dan tags: sorter-opt | |
| 16:13 | Merge all recent trunk fixes and enhancements into the apple-osx branch. check-in: 71b6f507 user: drh tags: apple-osx | |
| 13:21 | Improved detection and suppression of endless loops in clearDatabasePage(). check-in: 30011ad2 user: drh tags: trunk | |
| 01:26 | The build is still broken. Multiple definitions of sqlite3OSTrace when compiled using separate source files. check-in: 5c965a71 user: drh tags: winTest | |
|
2015-03-31
| ||
| 19:40 | On windows, flush the mapping view when syncing content to disk. check-in: a828e73d user: drh tags: trunk | |
| 19:17 | Set the winShm.id member when it is going to be traced. check-in: fa7916b6 user: mistachkin tags: winTest | |
| 19:06 | Build fixes for OSTRACE enhancements. check-in: f79c236f user: mistachkin tags: winTest | |
| 18:18 | Path portability enhancements for mptester.exe. check-in: c8694657 user: drh tags: winTest | |
| 18:05 | Add the "mptest" target to main.mk. Change TRUNCATE and PERSIST to DELETE for mptest.c on Windows because of problems trying to delete the journal. check-in: ea697e6d user: drh tags: trunk | |
| 17:58 | Path handling portability enhancements for mptester. check-in: da49634b user: mistachkin tags: winTest | |
| 17:45 | Testing enhancements on Windows. check-in: 9cc70eee user: mistachkin tags: winTest | |
| 17:32 | Change the sqlite3_log() message generated on a retry after delay in os_win to be an SQLITE_NOTICE instead of SQLITE_IOERR. check-in: 5d533eee user: drh tags: trunk | |
| 17:01 | Fix configure.ac and Makefile.in so that they generate pkgIndex.tcl correctly. check-in: 3deff252 user: drh tags: trunk | |
| 16:42 | Minor tweaks to the MSVC Makefile. check-in: 7244ea59 user: mistachkin tags: trunk | |
| 16:33 | Handle very large URI pathnames for in-memory shared-cache databases. check-in: 586a94e8 user: drh tags: trunk | |
| 15:15 | Fix harmless compiler warnings in lemon.c check-in: bbe7dcda user: drh tags: trunk | |
| 14:31 | Fix the corruptJ.test case so that it works with and without SQLITE_SECURE_DELETE. check-in: 0c0ecfd6 user: drh tags: trunk | |
| 14:18 | Additional logging information output by mptester. check-in: 0cbbf6e4 user: drh tags: trunk | |
| 13:46 | Add the "mptest" target to Makefile.msc check-in: 1e814e0b user: drh tags: trunk | |
| 11:42 | Ensure that comparison operators do not mess up the MEM_Dyn flag on registers when reverting affinity changes. check-in: 02e3c88f user: drh tags: trunk | |
| 00:10 | Merge all recent trunk enhancements and fixes into the sessions branch. check-in: df94e61f user: drh tags: sessions | |
|
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 | |
| 23:43 | Prevent a possible infinite loop when trying to DROP a table from a corrupt database. check-in: 395bb3e6 user: drh tags: trunk | |
| 15:45 | Merge sorter optimizations with this branch. check-in: 9bf1cfb4 user: dan tags: insert-select-opt | |
| 12:06 | Improve performance of multi-field sorts where the first field has a low cardinality. check-in: 601e7b6b user: dan tags: sorter-opt | |
| 09:58 | Remove some unnecessary code from vdbesort.c. check-in: b58191e9 user: dan tags: sorter-opt | |
|
2015-03-28
| ||
| 19:56 | Further optimizations for sorting records that begin with integer or text values. check-in: 24fe9f25 user: dan tags: sorter-opt | |
|
2015-03-27
| ||
| 18:22 | Merge updates from trunk. Closed-Leaf check-in: 45acf6a8 user: mistachkin tags: winViewFlush | |
| 18:20 | Enhancements to OSTRACE usage in the Win32 VFS. check-in: ab580029 user: mistachkin tags: trunk | |
| 02:27 | Fix the ".testctrl imposter" command in the command-line shell to be consistent in error reporting and results with the other .testctrl commands. check-in: 0ec08ba8 user: drh tags: trunk | |
| 00:21 | Using MSVC, get the sqlite3IoTrace variable working with the USE_STDCALL and/or DYNAMIC_SHELL options. check-in: fe976c91 user: mistachkin tags: trunk | |
| 00:19 | In the MSVC Makefile, make the DYNAMIC_SHELL option work without USE_STDCALL. check-in: 25b46a9c user: mistachkin tags: trunk | |
|
2015-03-26
| ||
| 23:36 | When syncing a memory mapped file on Windows, flush the mapped view as well. check-in: df204049 user: mistachkin tags: winViewFlush | |
| 18:24 | Revise Win32 locking test to account for recent log message changes. check-in: 1bc76339 user: mistachkin tags: trunk | |
| 17:04 | Avoid leaving the malloc subsystem in a partially initialized state if the low-level initialization callback fails. check-in: 3e872011 user: drh tags: trunk | |
| 15:27 | Provide source code line numbers for errors in the Windows VFS generated by the winLogIoerr() routine. check-in: b5da0d93 user: drh tags: trunk | |
| 14:29 | Fix a harmless compiler warning in FTS3. check-in: 1688f60c user: drh tags: trunk | |
| 12:38 | Merge sorter optimization into this branch. check-in: aeb8e9a9 user: dan tags: insert-select-opt | |
| 11:55 | Optimize cases where all the sorter is sorting a set of records that all begin with integer values, or that all begin with text values to be compared using BINARY. check-in: ce5ad17c user: dan tags: sorter-opt | |
|
2015-03-25
| ||
| 18:29 | Change an unreachable branch into an assert(). check-in: fb076b28 user: drh tags: trunk | |
| 17:35 | Fix the saveCursorPosition() routine in btree.c so that it works correctly for a eState=CURSOR_SKIPNEXT cursor. check-in: 37866b4d user: drh tags: trunk | |
| 15:23 | Extend [52e73eec] so that the IS optimization may be used on primary keys with more than 3 columns. check-in: 4e8796af user: dan tags: ota-update | |
| 13:06 | Reactivate an older assert() (adding an "|| CORRUPT_DB" term) and add a new assert() in btree.c. check-in: 1e96520a user: drh tags: trunk | |
| 12:05 | Add two new assert()s to the sqlite3BtreeDataSize() method. check-in: 42d1793d user: drh tags: trunk | |
| 00:09 | Backport the 'stdcall' related enhancements from trunk. Leaf check-in: cbb93d1a user: mistachkin tags: stdcall-3.8.8 | |
|
2015-03-24
| ||
| 22:00 | Add SQLITE_STDCALL and SQLITE_CDECL macros on public function definitions. check-in: cae3239a user: mistachkin tags: trunk | |
| 21:54 | Further simplifications to the amalgamation builder. Closed-Leaf check-in: e826cd7d user: drh tags: stdcall | |
| 21:52 | Update the 'mksqlite3c-noext' tool as well. check-in: a5322566 user: mistachkin tags: stdcall | |
| 21:34 | Fix a couple comment typos in a tool script. No changes to code. check-in: 83421af6 user: mistachkin tags: trunk | |
| 21:27 | Add SQLITE_STDCALL and SQLITE_CDECL macros on public function definitions. check-in: 242f09d4 user: mistachkin tags: stdcall | |
| 19:43 | Update this branch with latest trunk changes. check-in: 3ccd64ef user: dan tags: insert-select-opt | |
| 19:02 | Merge all recent trunk enhancements into the sessions branch. check-in: 54aaa6f2 user: drh tags: sessions | |
| 18:49 | Merge the latest trunk enhancements into the apple-osx branch. check-in: a2bd81e5 user: drh tags: apple-osx | |
| 18:21 | Merge the latest trunk changes into this branch. check-in: 9d9b6c88 user: dan tags: ota-update | |
| 18:19 | Suppress a compiler warning that was appearing with SQLITE_THREADSAFE=0. check-in: 436314b5 user: drh tags: trunk | |
| 18:03 | When the OTA module updates or deletes a row, save only those fields that are part of an index or primary key to the ota update database. check-in: 6326fd32 user: dan tags: ota-update | |
| 16:43 | Prevent a virtual table from being destroyed while it is in use. Also: replace Vdbe.inVtabMethod with sqlite3.nVDestroy. Simplify the EXPLAIN output for P4.pVtab to only show the sqlite3_vtab pointer. check-in: cbeb9a1a user: drh tags: trunk | |
| 14:57 | Add tests to check that attempting to DROP a virtual table while it is use does not cause problems. Closed-Leaf check-in: 5ee625b1 user: dan tags: nVDestroy | |
| 14:57 | Simplify the EXPLAIN output of virtual table P4 parameters to only show the pointer to the sqlite3_vtab object and omit the sqlite3_module object. Closed-Leaf check-in: 85610bbb user: drh tags: nVDestroy | |
| 14:05 | More defenses against virtual table being deleted out from under a running statement. check-in: 116c9982 user: drh tags: nVDestroy | |
| 13:32 | Prevent a virtual table from being destroyed while it is in use. check-in: fba674c0 user: drh tags: nVDestroy | |
| 12:51 | Replace the Vdbe.inVtabMethod field with the sqlite3.nVDestroy counter. check-in: 9faefb96 user: drh tags: nVDestroy | |
|
2015-03-23
| ||
| 21:32 | Disable loadable extensions in the command-line shell on VxWorks user-space. check-in: 0ee2d38d user: drh tags: trunk | |
| 19:55 | Track total memory usage using a 64-bit integer on 64-bit systems. Add the sqlite3_status64() interface. Make the sqlite3_status() and sqlite3_status64() interfaces atomic using mutexes and verify correct mutex operation using assert() statements. check-in: 6fc4e79a user: drh tags: trunk | |
| 19:16 | Fix a non-C89 variable declaration that causes problems for MSVC. Closed-Leaf check-in: 3de085ea user: drh tags: status64 | |
| 19:03 | Fix datetype size asserts in btree.c. check-in: ff4812d0 user: drh tags: trunk | |
| 18:52 | Add the SQLITE_PTRSIZE macro. Use it to help sqlite3_status() run faster on 32-bit systems. check-in: c742bd60 user: drh tags: status64 | |
| 17:25 | Add the sqlite3_status64() interface. Make the new interface and the legacy sqlite3_status() both atomic and threadsafe. Check threadsafety using assert()s. check-in: 1ce8e8fa user: drh tags: status64 | |
| 17:10 | Fix a broken assert() in the ota module. check-in: 858de8a5 user: dan tags: ota-update | |
| 14:39 | Set the OPFLAG_SEEKRESULT correctly in "INSERT INTO ... SELECT" statements. check-in: 6f7d9995 user: dan tags: insert-select-opt | |
|
2015-03-22
| ||
| 10:23 | Fix a potential NULL pointer dereference following a syntax error. check-in: 8d27e3e1 user: drh tags: trunk | |
|
2015-03-21
| ||
| 23:38 | Fix harmless compiler warnings with MSVC when assert() and SQLITE_MEMDEBUG are both enabled. check-in: 9513dbd4 user: mistachkin tags: trunk | |
| 22:23 | Add more comments to the MSVC batch build tool. check-in: 03522da3 user: mistachkin tags: trunk | |
| 22:13 | Increase the debugging level for the debug configuration in the MSVC batch build tool. check-in: 041484ff user: mistachkin tags: trunk | |
| 20:59 | Do not invoke a C preprocessor macro with an empty argument, as (reportedly) some versions of GCC are unable to deal with that. check-in: de9da317 user: drh tags: trunk | |
| 20:50 | Add a missing "int" on a constant declaration. check-in: 235157de user: drh tags: trunk | |
| 19:35 | Avoid a segfault if NULL is passed as the first argument to SQL scalar function fts3_tokenizer(). check-in: 6d098969 user: dan tags: trunk | |
| 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 | |
| 16:40 | Change walblock.test to block an external process for 10 seconds, not 5. 5 seconds is not long enough to tell the difference between a blocking lock and a series of retries. check-in: 717335fc user: dan tags: trunk | |
| 16:36 | Fix the blocking WAL lock so that it works and so that it compiles on a Mac. check-in: 67d69d21 user: drh tags: trunk | |
| 15:45 | Merge trunk changes with this branch. check-in: 14274391 user: dan tags: fts5 | |
| 15:37 | When scanning the full-text index as part of the fts5 integrity-check, also run a point query for every term and verify that these results are consistent with those found by the linear scan. check-in: ce972f6a user: dan tags: fts5 | |
| 15:26 | Do not use sorters for INSERT statements that insert multiple rows using the VALUES clause. check-in: 93e28ea1 user: dan tags: insert-select-opt | |
| 15:04 | Merge latest trunk changes with this branch. check-in: 9affe7f3 user: dan tags: insert-select-opt | |
| 12:25 | Remove an unreachable branch from the OP_VCreate opcode (merge accidental fork in trunk). check-in: 2fbfec62 user: dan tags: trunk | |
| 12:22 | Avoid an integer overflow in fts3 causing gcc 4.7.1 with -O2 to behave counter-intuitively (perhaps because the behaviour is undefined). Add an "ifcapable trace" to a test in shell4.test. check-in: e3e23464 user: dan tags: trunk | |
| 12:22 | Remove an unreachable branch from the OP_VCreate opcode. check-in: 5fca41a3 user: drh tags: trunk | |
| 10:53 | Add a missing "ifcapable fts3" to a test case in vtab2.test. check-in: d845b0f6 user: dan tags: trunk | |
| 07:16 | Merge recent trunk changes with this branch. check-in: 35eef4dd user: dan tags: insert-select-opt | |
| 07:03 | Disable the sorter optimization used by INSERT INTO SELECT statements if the statement explicitly specifies REPLACE, IGNORE or FAIL conflict handling. check-in: d4215942 user: dan tags: insert-select-opt | |
| 03:18 | Correctly detect the error of having a "*" wildcard on a SELECT without a FROM clause on the left-hand side of a recursive CTE. check-in: b11d1793 user: drh tags: trunk | |
| 02:58 | If a column is both UNIQUE and a PRIMARY KEY, make sure the PRIMARY KEY designation takes precedence. check-in: d871a792 user: drh tags: trunk | |
| 02:34 | Merge updates from trunk. check-in: 441a00e7 user: mistachkin tags: expShell | |
| 02:25 | Remove superfluous define from the MSVC makefile. check-in: 880d2513 user: mistachkin tags: trunk | |
| 02:22 | Improvements to the MSVC build. Fix harmless compiler warnings. Enable use of 'stdcall'. check-in: 737630b8 user: mistachkin tags: trunk | |
|
2015-03-20
| ||
| 20:30 | Where possible insert the set of new keys for each index in sorted order within "INSERT INTO ... SELECT" statements. check-in: 0a7f2051 user: dan tags: insert-select-opt | |
| 16:54 | Provide the BTREE_SEEK_EQ hint to the b-tree layer. check-in: 3c367004 user: drh tags: trunk | |
| 16:34 | Fix to get SQLITE_SMALL_STACK working correctly again after the previous change. Closed-Leaf check-in: 78df0ce1 user: drh tags: seek-eq | |
| 14:57 | Provide the BTREE_SEEK_EQ hint to the b-tree layer. check-in: e750830f user: drh tags: seek-eq | |
| 08:43 | Fix a problem causing collation sequence names to be dequoted multiple times under some circumstances. check-in: eddc05e7 user: dan tags: trunk | |
|
2015-03-19
| ||
| 20:09 | If a virtual table is created with a malformed UTF8 name in a UTF16 database, make sure that does not cause problems. check-in: b74cb0a9 user: drh tags: trunk | |
| 19:59 | Fix a crash that can occur following an OOM condition within a CREATE VIRTUAL TABLE statement on a utf-16 database. Closed-Leaf check-in: 9453e7da user: dan tags: malformed-vtab-name | |
| 18:56 | Fix a problem with creating virtual table with names specified using malformed utf-8 within utf-16 databases. check-in: 9969cff2 user: dan tags: malformed-vtab-name | |
| 16:25 | Fix an FTS3/4 problem with handling empty tokenizer declarations (e.g. "CREATE VIRTUAL TABLE t(tokenize=);"). check-in: 26d2def8 user: dan tags: trunk | |
| 15:52 | Silently ignore any attempt to add a prefix index for prefixes zero bytes in size to an fts3/4 table. Or any prefix index size so large that it overflows a 32-bit signed integer. check-in: ad4b19d2 user: dan tags: trunk | |
| 15:04 | Add an assert() to check that the database mutex is held in sqlite3BtreeLeave(). check-in: 31f54d7b user: dan tags: trunk | |
| 14:48 | Fix typo in shell error message. check-in: 775a02d5 user: mistachkin tags: trunk | |
| 14:46 | Merge updates from trunk. check-in: 3e363f40 user: mistachkin tags: expShell | |
| 13:30 | Fix a bug in error handling in the ".trace" command of the command-line shell. check-in: 6a48b5d7 user: drh tags: trunk | |
|
2015-03-18
| ||
| 20:03 | Allow whereShortCut() to use the PRIMARY KEY index of a WITHOUT ROWID table to optimize a vector of "IS" operators in a WHERE clause. check-in: 52e73eec user: dan tags: ota-update | |
| 19:04 | Clarify that OTA is unable to update or delete rows with NULL values in primary key fields. check-in: 2e7c1e0a user: dan tags: ota-update | |
| 16:00 | Add another sqlite3FaultSim() to the multi-threaded sorter logic to improve testability. check-in: 49ea2cde user: drh tags: trunk | |
|
2015-03-17
| ||
| 20:39 | Clarify the documentation on sqlite3_errcode(). No changes to code. check-in: 2c0e0d87 user: drh tags: trunk | |
| 18:54 | Merge all recent trunk enhancements into the sessions branch. check-in: 1d1c57c3 user: drh tags: sessions | |
| 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 | |
| 17:08 | Also merge the WAL blocking lock tests that were somehow missed on the previous check-in. check-in: 7214dab7 user: drh tags: trunk | |
| 16:59 | Transient locks in WAL mode can now block in order to resolve priority inversions. check-in: ec2f46de user: drh tags: trunk | |
| 16:01 | Add a test for the change on this branch. Closed-Leaf check-in: e22dde18 user: dan tags: wal-blocking-lock | |
|
2015-03-16
| ||
| 20:40 | Make SQLite slightly more likely to use an auto-index within a sub-query. check-in: ab832336 user: dan tags: trunk | |
| 18:08 | Fix typo of test prefix in the new WHERE test file. check-in: 34779c52 user: mistachkin tags: trunk | |
| 17:48 | When the WHERE clause contains two OR-connected terms with identical operands but different operators, try to combine them into a single term. Example: (X=A OR X>A) becomes (X>=A). check-in: 8bdda827 user: drh tags: trunk | |
| 17:07 | Modify the fts3query.test script so that it works even when testfixture is built using a version of TCL that is unable to sort the integer -9223372036854775808 check-in: f61fd24b user: drh tags: trunk | |
| 16:44 | When deleting the master journal to commit a multi-database transaction, do not sync the directory if PRAGMA synchronous=OFF for all participating database files. check-in: 018d7671 user: drh tags: trunk | |
| 16:28 | When estimating the number of rows visited by a range scan for which the keys consist of more than one field, consider prefixes of stat4 samples as well as the full samples. This generates more accurate estimates. check-in: 3e0590de user: dan tags: trunk | |
| 13:48 | Use #ifdef to omit code that is only used for STAT3 and STAT4. check-in: f2c9c5b5 user: drh tags: trunk | |
| 13:12 | Improved comments. No code changes. Closed-Leaf check-in: 23f71a26 user: drh tags: combine-disjuncts | |
| 12:13 | When a WHERE clause contains disjuncts with the same operands, try to combine them into a single operator. Example: (x=A OR x>A) becomes (x>=A). check-in: 7a309768 user: drh tags: combine-disjuncts | |
| 09:21 | Another test case for the planner change on this branch. Closed-Leaf check-in: f2207a06 user: dan tags: stat4-change | |
|
2015-03-14
| ||
| 18:59 | When estimating the number of rows visited by a range scan for which the keys consist of more than one field, consider prefixes of stat4 samples as well as the full samples. check-in: e1caf93c user: dan tags: stat4-change | |
|
2015-03-13
| ||
| 15:44 | Add tests to ensure "PRAGMA incremental_vacuum" and "PRAGMA auto_vacuum = incremental" handle corrupt databases correctly. check-in: 1c2166cb user: dan tags: trunk | |
| 08:31 | Extra tests for commit [0f250957]. check-in: 5aa522dc user: dan tags: trunk | |
| 00:11 | Remove debugging logic accidently included in the previous check-in. check-in: 2887fb38 user: drh tags: trunk | |
|
2015-03-12
| ||
| 23:48 | Fix the "now" option for date-time functions for cases when STAT4 is disabled. check-in: 3ac1f6a3 user: drh tags: trunk | |
| 21:22 | When STAT4 is enabled, allow probes of the STAT4 table using the value of constant functions computed at compile-time. check-in: 0f250957 user: drh tags: trunk | |
| 21:02 | Always disallow functions as the DEFAULT of a column. Add assert()s and Closed-Leaf check-in: a991bb1a user: drh tags: stat4-function | |
| 19:12 | Disable multiplexing of master-journal files in the test_multiplex.c module. check-in: b8684df3 user: dan tags: trunk | |
| 18:38 | If an error occurs in the compile-time evaluation of an application-defined function, then propagate back out the exact error code, not just the generic SQLITE_ERROR. check-in: 93f42586 user: drh tags: stat4-function | |
| 06:46 | The valueFromFunction() routine is better able to handle OOM errors. Omit unreachable branches. check-in: 8fb6bd9b user: drh tags: stat4-function | |
| 05:08 | Improve the text on one of the opcode documentation comments in vdbe.c. check-in: 08958f57 user: drh tags: trunk | |
|
2015-03-11
| ||
| 20:59 | Allow the default value for columns added using ALTER TABLE ADD COLUMN to be a function in existing schemas loaded from disk. But prevent this version of SQLite from being used to create such a column. check-in: ff868e22 user: dan tags: stat4-function | |
| 20:06 | Allow the query planner to evaluate deterministic scalar SQL functions used in WHERE constraints if all arguments are SQL literals in order to compare the results with sqlite_stat4 sample data. check-in: b7f1fc26 user: dan tags: stat4-function | |
| 14:51 | Add an optimization to the fts5 unicode tokenizer code. check-in: f5db4892 user: dan tags: fts5 | |
| 14:34 | Expand the multi-process test cases to repeat each case 20 times and to repeat tests using different journal modes. check-in: a2715b04 user: drh tags: trunk | |
|
2015-03-10
| ||
| 20:22 | Arrange for some of the transient locks in WAL mode to block, as a single to the OS to fix priority inversions. check-in: c6e6d5f4 user: drh tags: wal-blocking-lock | |
| 19:24 | Avoid redundant string comparisons while merging fts5 segment b-trees. check-in: 5c46820d user: dan tags: fts5 | |
| 15:34 | Fix an incrblob2 test case so that it works on 32-bit systems. check-in: 8d0b11c9 user: drh tags: trunk | |
| 13:50 | Revise test cases in malloc5.test to accommodate varying allocation sizes returned by some system malloc() implementations. check-in: fbae6baf user: drh tags: trunk | |