Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 check-ins occurring around fca8dc8b57.
|
2020-09-01
| ||
| 02:02 | Improvements to the IN-early-out optimization so that it works more efficiently when there are two or more indexed IN clauses on a single table. (check-in: 49b7631e86 user: drh tags: branch-3.28) | |
| 01:52 | Improvements to the IN-early-out optimization so that it works more efficiently when there are two or more indexed IN clauses on a single table. (check-in: 35505c68c1 user: drh tags: trunk) | |
| 00:26 | Fix a harmless compiler warning. (check-in: 3ca0b7d54d user: drh tags: trunk) | |
| 00:09 | Minor changes - fix a compiler warning and add an assert(). (Closed-Leaf check-in: 07222dce10 user: drh tags: in-early-out-fail) | |
|
2020-08-31
| ||
| 20:37 | Update this branch with the "PRAGMA noop_update" fix from begin-concurrent-report. (Leaf check-in: 1d98472277 user: dan tags: begin-concurrent-unixshmlock-opt) | |
| 20:29 | Update this branch with the "PRAGMA noop_update" fix from begin-concurrent-pnu. (check-in: 3c0423f0a8 user: dan tags: begin-concurrent-report) | |
| 20:27 | Restore the "PRAGMA noop_update" feature that was broken by [2b3241cf67c8eea7]. (check-in: 5fa4cbcb78 user: dan tags: begin-concurrent-pnu) | |
| 19:58 | Merge the SEEK_COUNT instrumentation enhancement from trunk. (check-in: 689ede9564 user: drh tags: in-early-out-fail) | |
| 19:19 | An attempt to improve the performance of the IN-early-out optimization (see check-in [09fffbdf9f2f6ce3]) by avoiding unnecessary calls to the b-tree search algorithm in OP_IfNoHope when the index key is at hand and the same answer can be obtained by doing a quick key comparison. Update: Experiment did not work out. (Closed-Leaf check-in: 8301da31d0 user: drh tags: branch-3.28-in-early-out-fail) | |
| 18:49 | New test-control that returns the number of calls to sqlite3BtreeMovetoUnpacked() on the main database and then resets the counter. This only works for SQLITE_DEBUG builds. (check-in: dca5b91926 user: drh tags: trunk) | |
| 16:31 | An attempt to improve the performance of the IN-early-out optimization (see check-in [09fffbdf9f2f6ce3]) by avoiding unnecessary calls to the b-tree search algorithm in OP_IfNoHope when the index key is at hand and the same answer can be obtained by doing a quick key comparison. Update 2020-08-31: This experiment did not work out. A better approach is now on trunk. (check-in: e9d983c683 user: drh tags: in-early-out-fail) | |
| 12:29 | Fix the documentation for the OP_IdxGT family of opcodes to show that the P5 operand is not used. (check-in: 62f7d2a612 user: drh tags: trunk) | |
|
2020-08-29
| ||
| 19:00 | Fix a sanitizer warning in zipfile.c. (check-in: ded1a75b3c user: dan tags: trunk) | |
| 15:36 | Improve performance of wal-mode locking on unix in cases where there are hundreds of connections to a single database within the same process. (check-in: 30214727f7 user: dan tags: begin-concurrent-unixshmlock-opt) | |
| 15:15 | Improve performance of wal-mode locking on unix in cases where there are hundreds of connections to a single database within the same process. (check-in: a1c19eea8f user: dan tags: trunk) | |
|
2020-08-28
| ||
| 20:01 | Fix handling of an xShmLock(SHARED, UNLOCK) call when the caller does not hold any lock on the specified slot, but another connection in the same process holds an EXCLUSIVE. (Closed-Leaf check-in: 3eb365027b user: dan tags: unixshmlock-opt) | |
| 19:27 | Modify the unixShmLock() function to avoid iterating through the (possibly large) set of connections to the same database file. (check-in: e0faddf0df user: dan tags: unixshmlock-opt) | |
| 18:47 | Add the miscellaneous 'series' extension to the shell. (check-in: fc0856dccf user: mistachkin tags: trunk) | |
| 13:10 | Update Lemon documentation. Patches from sgbeal. (check-in: f5dc83442b user: drh tags: trunk) | |
| 12:58 | Fix a couple of unreachable branches. (check-in: f2d26f2b11 user: drh tags: trunk) | |
| 11:19 | Add fts5 test to confirm that for a table with columns a, b, c and d, "{a b}" and "-{c d}" are handled similarly. (check-in: 1a04920998 user: dan tags: trunk) | |
|
2020-08-27
| ||
| 20:55 | Remove a (harmless) redundant variable from the CLI implementation. (check-in: 3f7bbb840d user: drh tags: trunk) | |
| 18:36 | Include the original text of the CHECK constraint in the error message for anonymous CHECK constraints. (check-in: 5ce34a955b user: drh tags: trunk) | |
| 16:28 | Apply the same fix for ticket [9eda2697f5cc1aba] to text-to-integer conversions that was done for floating point conversions by check-in [1c76f1d8ec0937a2]. (check-in: aafb7a2104 user: drh tags: trunk) | |
| 14:53 | Do not attempt to run test script analyze3.test as part of the "prepare" permutation. (check-in: f7f13cb1bc user: dan tags: trunk) | |
|
2020-08-26
| ||
| 19:07 | Enhance the ".databases" command in the CLI so that it shows the result of sqlite3_db_readonly() and sqlite3_txn_state() for each database file. (check-in: 0ffd16d23d user: drh tags: trunk) | |
| 10:50 | If the argument to the ".read" command in the CLI begins with "|" then run the remainder of the argument as a command and read input from the output of that command. (check-in: 6c716f4b55 user: drh tags: trunk) | |
|
2020-08-25
| ||
| 19:09 | Add support for the sqlite3_txn_state() interface. (check-in: ad195e3dd8 user: drh tags: trunk) | |
|
2020-08-24
| ||
| 23:44 | Reduce the N in the logN term for the sorting cost associated with computing DISTINCT by B-Tree by half, under the assumption that the DISTINCT will eliminate about half the rows of output. This is really a wild guess. But we do not have any better way of estimating what the row-count reduction due to DISTINCT will actually be. (check-in: 8787417ec1 user: drh tags: trunk) | |
| 10:52 | Correctly handle expressions like "x IS (not) true/false" within the rhs of IN() expressions. Fix for [f3ff1472]. (check-in: 493a25949b user: dan tags: trunk) | |
|
2020-08-20
| ||
| 16:25 | Fix a crash that could occur in SQLITE_MAX_EXPR_DEPTH=0 builds when processing SQL containing syntax errors. (check-in: 5f58dd3a19 user: dan tags: trunk) | |
| 11:03 | Avoid a buffer overrun in test code that could occur if certain test functions were passed a hex-string containing an odd number of digits. (check-in: 3c5e63c22f user: dan tags: trunk) | |
|
2020-08-19
| ||
| 23:51 | Try to make SQLite easier to compiler for Mac Catalyst. See forum post 803387a1c5. (check-in: e1595a20d7 user: drh tags: trunk) | |
| 23:32 | Do not skip over TK_IF_NULL_ROW operators when bypassing TK_COLLATE operators. Fix to check-in [ac31edd3eeafcef4] which was itself a fix for ticket [45f4bf4eb4ffd788]. (check-in: 871f2ddcfb user: drh tags: trunk) | |
| 15:24 | Update releasetest_data.tcl so that the "Fast-One" configuration runs bigmmap.test as part of release testing. (check-in: a0aa35aaa5 user: dan tags: trunk) | |
| 15:21 | Fix a problem in test file bigmmap.test. (check-in: d8e4738216 user: dan tags: trunk) | |
|
2020-08-17
| ||
| 21:03 | When doing an UPDATE or DELETE using a multi-column index where only a few of the earlier columns of the index are useful for the index lookup, postpone doing the main table seek until after all WHERE clause constraints have been evaluated, in case those constraints can be covered by unused later terms of the index, thus avoiding unnecessary main table seeks. (check-in: 0ecda43371 user: dan tags: branch-3.28) | |
| 09:11 | Fix the -quote option on the CLI to set the correct column separator. (check-in: c778f8295c user: drh tags: trunk) | |
|
2020-08-16
| ||
| 00:30 | Optimization to sqlite3BeginWriteOperation(). (check-in: 2173d4c6e3 user: drh tags: trunk) | |
|
2020-08-15
| ||
| 23:48 | Optimization of the sqlite3SrcListDelete() routine. (check-in: 1b4acd1ac4 user: drh tags: trunk) | |
| 22:23 | Remove more unnecessary sqlite3GetVdbe() calls, replacing them with assert()s. (check-in: b7dc932197 user: drh tags: trunk) | |
| 21:55 | Avoid unnecessary calls to the sqlite3GetVdbe() routine. Add assert() statements to prove each call is unnecessary. (check-in: 86d3790caf user: drh tags: trunk) | |
| 19:58 | Omit the unnecessary not-NULL check on the upper bound of a forward index range scan. The subsequent OP_IdxGT will always catch the NULL. Similarly, omit the not-NULL check on the lower bound of a reverse index range scan, as the SeekLE opcode will disallow the NULL. (check-in: e51ecadcbd user: drh tags: trunk) | |
|
2020-08-14
| ||
| 21:51 | When doing an UPDATE or DELETE using a multi-column index where only a few of the earlier columns of the index are useful for the index lookup, postpone doing the main table seek until after all WHERE clause constraints have been evaluated, in case those constraints can be covered by unused later terms of the index, thus avoiding unnecessary main table seeks. (check-in: 7fee0b1075 user: drh tags: trunk) | |
| 21:37 | Update the version number to 3.34.0 for the next development cycle. (check-in: 70f34f3df5 user: drh tags: trunk) | |
| 21:32 | Optimizations to the logic that converts main table accesses into equivalent index accesses. Code is now slightly smaller and faster than trunk. (Closed-Leaf check-in: 611b640442 user: drh tags: delete-bytecode-optimization) | |
| 20:04 | For UPDATE and DELETE, use OP_DeferredSeek always. If the seek must later be resolved, add the OP_FinishSeek opcode after all WHERE clause terms have been processed. This obviates the need for the WHERE_SEEK_TABLE and WHERE_SEEK_UNIQ_TABLE flags to sqlite3WhereBegin() and the ensuing complication, and it allows the covering index optimization to be used further into WHERE clause processing. (check-in: a495f60d31 user: drh tags: delete-bytecode-optimization) | |
| 17:39 | Experimental change to try to get some DELETE operations to access values using the index rather than the main table, so as to avoid unnecessary main table seeks. (check-in: 2f7cb6ab39 user: drh tags: delete-bytecode-optimization) | |
| 16:14 | Fix an inconsequential memory leak in sqldiff. Update the "Sanitize" case in wapptest.tcl to use -fsanitize=address,undefined, and to run more tests. (check-in: 613fb5c252 user: dan tags: trunk) | |
| 13:55 | Merge the 3.33.0 release into the reuse-schema branch. (check-in: e456d43708 user: drh tags: reuse-schema) | |
| 13:23 | Version 3.33.0 (check-in: fca8dc8b57 user: drh tags: trunk, release, version-3.33.0) | |
|
2020-08-13
| ||
| 17:27 | Fix "make test" handling of environment variable QUICKTEST_OMIT so that it can be used to exclude test files in other than the main test directory. (check-in: b050976079 user: dan tags: trunk) | |
|
2020-08-12
| ||
| 16:19 | Improvement on the previous fix. (check-in: f6cffa2d50 user: drh tags: trunk) | |
| 15:39 | Fix an assertion() fault in ALTER TABLE found by OSSFuzz. Test case in TH3. (check-in: 41de742c57 user: drh tags: trunk) | |
|
2020-08-11
| ||
| 21:53 | Fix harmless USAN warnings from gcc9. (check-in: 72c4c69fea user: drh tags: trunk) | |
| 18:17 | New test cases for the use of the ieee754 and decimal extensions in the CLI. (check-in: bc1590f32f user: drh tags: trunk) | |
| 18:00 | Modify a test for corruption within the wal checkpoint code to account for the pending-byte page. And for the fact that test configurations might move the pending-byte page. (check-in: 7dfb74c37e user: dan tags: trunk) | |
| 17:20 | Minor comment fixes. No changes to code. (check-in: 533aeb9008 user: drh tags: trunk) | |
| 16:46 | Remove an unused #define from sqliteInt.h. (check-in: d5b254f94c user: drh tags: trunk) | |
| 14:55 | Merge all changes since the 3.32.0 release into the reuse-schema branch. (check-in: b1a77b7ead user: drh tags: reuse-schema) | |
| 14:06 | Update this branch with latest from begin-concurrent-pnu. (check-in: 3ee73880ed user: dan tags: begin-concurrent-report) | |
| 14:01 | Do not run tests in concreport.test for non SQLITE_ENABLE_PREUPDATE_HOOK builds. (check-in: e39e7a6fc7 user: dan tags: begin-concurrent-report) | |
| 13:22 | Merge all the latest changes into the begin-concurrent-pnu-wal2 branch. (check-in: ebefcb8607 user: drh tags: begin-concurrent-pnu-wal2) | |
| 11:34 | Merge latest trunk changes into this branch. (check-in: 91262e6657 user: dan tags: wal2) | |
|
2020-08-10
| ||
| 21:30 | Merge recent trunk fixes into the begin-concurrent-pnu branch. (check-in: 2ae78c993e user: drh tags: begin-concurrent-pnu) | |
| 21:16 | Merge recent trunk enhancements into begin-concurrent. (check-in: ed4c742c4e user: drh tags: begin-concurrent) | |
| 21:01 | Simplify #ifdefs associated with Parse.eParseMode. Fix an #ifdef error associated with SQLITE_OMIT_AUTOVACUUM. (check-in: 5bbd4bddd3 user: drh tags: trunk) | |
| 19:35 | Fix a problem causing test failures in corruptL.test for some permutations. (check-in: 680bdc6524 user: dan tags: trunk) | |
| 19:30 | Fix a problem building fts3 separately from the amalgamation. (check-in: 2a167cfbb2 user: dan tags: trunk) | |
| 14:34 | Fix a shell tool build error caused by some combinations of options. (check-in: 33cd5341ac user: dan tags: trunk) | |
| 14:18 | Fix harmless compiler warnings that surface in newer versions of GCC. (check-in: 9d670a3183 user: drh tags: trunk) | |
| 11:21 | Fix another test script problem in walvfs.test. (check-in: 1b89d3931e user: dan tags: trunk) | |
| 10:43 | Fix minor test script problems. (check-in: 5d54cd44d0 user: dan tags: trunk) | |
|
2020-08-09
| ||
| 17:58 | Fix a harmless compiler warning. (check-in: 6f91769fdb user: drh tags: trunk) | |
|
2020-08-08
| ||
| 20:15 | Fix the check-in at [41474548ef3f7454] so that it computes the pointer in time for error checking at the end of the routine in the case of a non-OOM error. (check-in: 13d2fed760 user: drh tags: trunk) | |
| 20:11 | Fix test script busy2.test so that it works with the inmemory-journal permutation. (check-in: b412d1d175 user: dan tags: trunk) | |
| 20:03 | Changes to busy2.test, corruptL.test and fkey5.test so that new test cases pass with all test permutations. (check-in: d62d1711e2 user: dan tags: trunk) | |
| 19:52 | Fix a test script problem causing an error for SQLITE_ENABLE_OVERSIZE_CELL_CHECK builds in corruptL.test. (check-in: a85520e007 user: dan tags: trunk) | |
| 17:55 | Move a pointer computation until after OOM checks to avoid a nuisance USAN warning. (check-in: 41474548ef user: drh tags: trunk) | |
| 17:02 | Change the name of sqlite3SelectTrace to sqlite3_unsupported_selecttrace. (check-in: 5ecd03a27b user: dan tags: trunk) | |
| 15:40 | Update requirement marks due to wording improvements in the documentation. (check-in: bf875a1c7f user: drh tags: trunk) | |
| 00:44 | Reorder declarations in the decimal extension for C89. (check-in: eface2da2c user: drh tags: trunk) | |
|
2020-08-07
| ||
| 19:52 | Do the oversize-WAL corruption test before the size hint is issued. (check-in: fdc5fb902d user: drh tags: trunk) | |
| 18:52 | Fix a file-descriptor leak in test script corruptL.test. (check-in: ec2c340c39 user: dan tags: trunk) | |
| 16:28 | Return an SQLITE_CORRUPT error if the final expected size of the database when checkpointing is not reasonable - where reasonable is defined (basically) as the sum of the sizes of the database and wal files. (check-in: e2799563c8 user: dan tags: trunk) | |
| 14:47 | Add the --checkpoint option to speedtest1. (check-in: 4cffa9bb44 user: drh tags: trunk) | |
| 14:22 | Fix compilation issues with MSVC. (check-in: c5a7e6d2c2 user: drh tags: trunk) | |
|
2020-08-06
| ||
| 16:45 | Fix the columnar output modes in the CLI so that they work with parameters. See https://sqlite.org/forum/forumpost/17ba6aac24 for details of the problem fixed. (check-in: d573aa9b12 user: drh tags: trunk) | |
|
2020-08-04
| ||
| 16:11 | Fix compilation issues with MSVC. (Closed-Leaf check-in: af07d8458a user: mistachkin tags: msvcWarn) | |
|
2020-07-31
| ||
| 23:34 | Back out a NEVER() that turns out to be reachable. (check-in: 8cf342d4e5 user: drh tags: trunk) | |
| 20:56 | Improved non-locking PRNG. (check-in: eb7a9c04bd user: drh tags: begin-concurrent) | |
| 17:08 | Merge latest wal2 changes into this branch. (check-in: ebd39665e5 user: dan tags: begin-concurrent-pnu-wal2) | |
| 16:01 | Merge latest trunk changes into this branch. (check-in: 0c0d0a77bc user: dan tags: wal2) | |
| 02:07 | Remove an ALWAYS() that turns out to be reachable. (check-in: 12bb75d9ed user: drh tags: trunk) | |
|
2020-07-30
| ||
| 23:47 | Test for schema corruption is reachable after all. (check-in: 2032236cce user: drh tags: trunk) | |
| 22:33 | Provide an alternative "guaranteed-safe" method for overwriting the WAL index on recovery, in case some platform is found for which memcpy() cannot do this safely. (check-in: 168cccbabb user: drh tags: trunk) | |
| 19:56 | Merge begin-concurrent-pnu changes into this branch. (check-in: fd01e78827 user: dan tags: begin-concurrent-report) | |
| 19:37 | Merge latest trunk change into this branch. (check-in: 2b3241cf67 user: dan tags: begin-concurrent-pnu) | |
| 19:19 | Merge latest trunk changes into this branch. (check-in: e8a6651539 user: dan tags: begin-concurrent) | |
| 17:37 | Fix compiler warnings in MSVC. (check-in: 96e3dba2ed user: drh tags: trunk) | |