Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 ancestors of 211411d02c0729c9
|
2015-04-13
| ||
| 23:05 | Add #ifdef magic for HAVE_GETHOSTUUID so that the build will hopefully now work on more verions of MacOS with SQLITE_ENABLE_LOCKING_STYLE turned on. (check-in: 211411d0 user: drh tags: trunk) | |
| 22:26 | On a DETACH statement, keep all schemas intact except fo the one that is being detached, and thus avoid unnecessary schema reparsing. (check-in: 661db19b user: drh tags: trunk) | |
| 21:39 | Omit the "pc" or "program counter" variable from the VDBE loop for 0.6% performance increase. (check-in: d2f10c41 user: drh tags: trunk) | |
| 19:14 | Remove the out2-prerelease VDBE opcode property and its associated code, for a 0.5% performance improvement. (check-in: e29c7f2c user: drh tags: trunk) | |
| 17:43 | Add a comment to wal.c to explain why a race condition is safe. (check-in: bc33af86 user: dan tags: trunk) | |
| 14:44 | Remove a faulty assert() from the btree balancing logic. (check-in: d06669d9 user: drh tags: trunk) | |
| 14:08 | Test that if the definition of a collation sequence is changed and VACUUM run, the new database contains records sorted in the (new) correct order. (check-in: ce6eaac1 user: dan tags: trunk) | |
| 14:03 | Remove an unreachable branch from the VACUUM logic. (check-in: 65ace4b0 user: drh tags: trunk) | |
| 12:45 | Remove an unreachable branch from the vdbeSorterCompareInt() routine. (check-in: f666ef06 user: drh tags: trunk) | |
|
2015-04-12
| ||
| 21:28 | Update the version number to 3.8.10 because of the new sort optimizations from check-in [79326d6eec]. (check-in: bd2cfa1d user: drh tags: trunk) | |
| 17:35 | Fix a problem with a stale Select.pWith pointer when a CTE is used together with a compound query and an ORDER BY clause. (check-in: 9a453f52 user: drh tags: trunk) | |
| 01:22 | Avoid problems when a query has a GROUP BY and an ORDER BY but no FROM clause. (check-in: e527d96a user: drh tags: trunk) | |
|
2015-04-11
| ||
| 20:44 | Optimizations for VACUUM, CREATE INDEX and some cases of ORDER BY. (check-in: 79326d6e user: dan tags: trunk) | |
| 20:20 | Fix a problem with sorting large amounts of partially ordered data. (check-in: acca97ef user: dan tags: trunk) | |
| 18:45 | Merge latest trunk changes with this branch. (Closed-Leaf check-in: cf7590f6 user: dan tags: sorter-opt) | |
| 13:49 | Add the --changeset option to the sqldiff utility program, for generating a sessions changeset file instead of an SQL diff. (check-in: f9a3a839 user: drh tags: trunk) | |
| 13:48 | The --changeset option now appears to be working. (Closed-Leaf check-in: 1a2e2803 user: drh tags: sqldiff-changeset) | |
| 12:07 | First complete attempt to generate a working changeset. Still contains bugs. (check-in: 5611fa9b user: drh tags: sqldiff-changeset) | |
| 11:53 | Update tests in whereD.test to account for the change in the previous commit. (check-in: da49700c user: dan tags: trunk) | |
| 11:44 | Do not assume an index contains unique entries unless it is declared UNIQUE and NOT NULL is specified for all columns. Fix for [7b4fee9f6c]. (check-in: e3b1f625 user: dan tags: trunk) | |
| 02:08 | Detect and report oversized records constructed from multiple zeroblobs. (check-in: 9e139afd user: drh tags: trunk) | |
|
2015-04-10
| ||
| 21:16 | Minor build enhancements for MSVC. (check-in: 40c417a7 user: mistachkin tags: trunk) | |
| 19:41 | Work toward adding the --changeset option to the sqldiff utility program. Changes are incomplete. This is an incremental check-in. (check-in: 463e38d7 user: drh tags: sqldiff-changeset) | |
| 16:05 | In sqlite3_declare_vtab(), avoid accessing the database structure until after the "api-armour" safety-check has completed and the db mutex has been obtained. (check-in: 860e4f8a user: dan tags: trunk) | |
| 12:04 | Fix foreign key CASCADE for cases where the parent key is an INTEGER PRIMARY KEY and the parent table contains other columns named "rowid", "_rowid_", and "oid". (check-in: ed3cbaab user: drh tags: trunk) | |
| 08:20 | Update this branch with latest trunk changes. (check-in: 60be9c1c user: dan tags: sorter-opt) | |
| 07:55 | Do not allow virtual table constructors to be called recursively. (check-in: 0a72726d user: dan tags: trunk) | |
|
2015-04-09
| ||
| 19:39 | Fix incorrect column names in UPDATE statements generated by the sqldiff utility. (check-in: ee53b460 user: drh tags: trunk) | |
| 18:14 | Add the --primarykey option to the sqldiff tool, which causes it to use the schema-defined PRIMARY KEY. (check-in: 5063f907 user: drh tags: trunk) | |
| 16:30 | Remove two pointless assert() statements. This should silence harmless compiler warnings reported at https://bugzilla.mozilla.org/show_bug.cgi?id=1152845 (check-in: 83b342a4 user: drh tags: trunk) | |
| 13:40 | Fix comment typos in the sqldiff.c utility program. (check-in: 32ab2bb9 user: drh tags: trunk) | |
| 13:34 | Add the "sqldiff" utility program. (check-in: 88da5bf5 user: drh tags: trunk) | |
| 11:24 | Remove a variable initializion to silence a harmless compiler warning. (check-in: 79861adb user: drh tags: trunk) | |
|
2015-04-08
| ||
| 12:16 | Version 3.8.9 (check-in: 8a8ffc86 user: drh tags: trunk, release, version-3.8.9) | |
|
2015-04-07
| ||
| 15:39 | Avoid signed integer overflow when converting oversized in-line integer widths and precisions in printf(). (check-in: 8e4ac2ce user: drh tags: trunk) | |
| 14:38 | Another change to avoid a problem caused by integer overflow in the printf() code. (check-in: 95625ef3 user: dan tags: trunk) | |
| 13:28 | Further changes to guard against integer overflow in the width and precision of printf() arguments. (check-in: 5ce4e7d7 user: drh tags: trunk) | |
| 12:41 | Guard against excessive width and precision in floating-point conversions in the printf routines. (check-in: c494171f user: drh tags: trunk) | |
|
2015-04-06
| ||
| 11:04 | Fix a problem with fts3 prefix terms within phrase queries on "order=DESC" tables with a mix of negative and positive rowids. (check-in: 3ad829e5 user: dan tags: trunk) | |
| 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) | |
|
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
| ||
| 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: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) | |
| 13:21 | Improved detection and suppression of endless loops in clearDatabasePage(). (check-in: 30011ad2 user: drh tags: trunk) | |
|
2015-03-31
| ||
| 19:40 | On windows, flush the mapping view when syncing content to disk. (check-in: a828e73d user: drh tags: trunk) | |
| 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: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) | |
|
2015-03-30
| ||
| 23:43 | Prevent a possible infinite loop when trying to DROP a table from a corrupt database. (check-in: 395bb3e6 user: drh tags: trunk) | |
| 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) | |
| 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) | |
| 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) | |
|
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) | |
| 18:19 | Suppress a compiler warning that was appearing with SQLITE_THREADSAFE=0. (check-in: 436314b5 user: drh tags: trunk) | |
| 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) | |
|
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) | |