Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
200 most recent check-ins using file ext/fts5/test/fts5colset.test version a304734513
|
2024-09-18
| ||
| 18:04 | Improvements to the scope of valueFromFunction(). (Leaf check-in: b021399a6e user: drh tags: branch-3.28) | |
|
2024-06-07
| ||
| 00:20 | Allow the query planner access to the argument of LIMIT even if that argument is a bound parameter. (check-in: 148d505ca0 user: drh tags: branch-3.28) | |
|
2024-06-06
| ||
| 16:06 | Better optimize queries that use parameters in the LIMIT clause. (Closed-Leaf check-in: b44f267671 user: drh tags: branch-3.28-var-in-limit) | |
|
2024-04-02
| ||
| 18:48 | Fix typos in comments. Provided ".wheretrace" debugging output for the interstage heuristic module. Do omit automatic index loops in the interstage heuristic. (check-in: 357d9513d2 user: drh tags: branch-3.28) | |
| 18:31 | Fix table-valued functions so that they will work as the right table in a LEFT JOIN. Ticket [2ae0c599b735d59e] (check-in: 1f97086d62 user: drh tags: branch-3.28) | |
| 11:54 | Add a heuristic in between the two solver() passes of the query planner that tries to prevent a very slow query plan in cases where the output row count estimate is imprecise. (check-in: 74b247d958 user: drh tags: branch-3.28) | |
|
2023-11-29
| ||
| 16:26 | Fix a duplicate assert() caused by the second cherrypick in the previous check-in. (check-in: f10d4fc4a8 user: drh tags: branch-3.28) | |
| 16:07 | Remove Window objects from the corresponding Select.pWin list when they are deleted, as they are, for example, when the ORDER BY clause is optimized out. (check-in: f9c6e6a710 user: drh tags: branch-3.28) | |
|
2023-10-19
| ||
| 21:05 | Ensure that when an ephemeral cursor is reopened with a second invocation of to OP_OpenEphemeral, the sequence counter is reset and the cache marked as stale. Fix for [9cdc5c46]. (check-in: d4bfa8d21a user: drh tags: branch-3.28) | |
|
2023-09-15
| ||
| 20:04 | Drop support for the view-scan optimization as it was causing multiple performance regressions. In its place, reduce the estimated row count for DISTINCT subsqueries by a factor of 8. (check-in: 796a65fa61 user: drh tags: branch-3.28) | |
|
2023-02-26
| ||
| 11:52 | In the omit-unused-subquery-columns optimization, be sure to remove the EP_Skip and EP_Unlikely flags from the result set expressions that get nulled-out. dbsqlfuzz bf1d3ed6e0e0dd8766027797d43db40c776d2b15. Also fix an incorrect ".selecttrace" code block. (check-in: 83a7f13edb user: drh tags: branch-3.28) | |
|
2023-02-16
| ||
| 21:01 | Fix an #ifdef that uses a different macro name from the main branch. (check-in: ad6ac5d3e8 user: drh tags: branch-3.28) | |
| 19:04 | Back-port omit-unused-subquery-column enhancements into the 3.28 branch. (check-in: 57a4e91f43 user: drh tags: branch-3.28) | |
| 14:29 | Do not compute result columns of subqueries that are never used. Make those columns NULL instead. This optimization potentially resolves the enhancement request described by [ticket baa5bb76c35a124c]. (check-in: 0163b697dd user: drh tags: branch-3.28) | |
| 01:29 | Do not compute unused result columns of subqueries. This optimization will potentially resolve the performance optimization request of [ticket baa5bb76c35a124c]. (Closed-Leaf check-in: 0c21b6a5f8 user: drh tags: branch-3.26) | |
| 01:21 | Update test cases so that they work with TCL 8.7 and later. (check-in: e9b762de0e user: drh tags: branch-3.26) | |
|
2023-02-15
| ||
| 13:00 | Update the configure script so that it contains the correct version number. (check-in: a7cbf30808 user: drh tags: branch-3.26) | |
|
2022-10-24
| ||
| 13:50 | Improve the ability of the query planner to recognize covering indexes even on tables with more than 63 columns and where the index is over columns beyond the 63rd column. (check-in: 3d1992de47 user: drh tags: branch-3.28) | |
|
2022-10-19
| ||
| 11:22 | If a query uses an index where one or more of the columns of the index is an expression and if the corresponding expression is used elsewhere in the query, then strive to read the value of the expression out of the index, rather than recomputing it. This is the "Indexed Expression Optimizations". (check-in: 3da1032878 user: drh tags: branch-3.28) | |
|
2022-09-01
| ||
| 10:41 | In the query planner, add a heuristic that will reduce the cost of a full table scan for a materialized view or subquery if the full scan is the outer-most loop. This is shown to speed up some queries. (check-in: e3754cc188 user: drh tags: branch-3.28) | |
|
2022-08-10
| ||
| 17:03 | Merge the branch-3.28a fixes into branch-3.28. (check-in: ba6bf33147 user: drh tags: branch-3.28) | |
|
2022-08-09
| ||
| 20:22 | Fix a rounding error caused by scalar->logarithm->scalar conversion when using stat4 data to estimate some range scans. (check-in: 68d86f2b20 user: drh tags: branch-3.28) | |
|
2021-08-11
| ||
| 18:56 | Fix an RBU problem with restarting an update after the *-oal file is already larger than 4GiB. (Leaf check-in: 56869f54f3 user: dan tags: rbu-replace-hack) | |
| 18:44 | If the special "sqlite_rbu_replace_hack" table is present in an RBU database, use REPLACE instead of INSERT when writing index entries to imposter tables. (check-in: 4b73e151cd user: dan tags: rbu-replace-hack) | |
|
2021-07-13
| ||
| 15:30 | Remove two incorrect assert() statements from the logic used to derive column names and types from subqueries. This allows the SQL associated with CVE-2020-13871 (ticket [c8d3b9f0a750a529]) to be tested. (Closed-Leaf check-in: d2e6722037 user: dan tags: branch-3.28a) | |
|
2021-07-12
| ||
| 15:00 | Fix a defect in the query-flattener optimization identified by ticket [8f157e8010b22af0]. This fix is associated with CVE-2020-15358. (Leaf check-in: bcd014c473 user: dan tags: branch-3.32a) | |
| 14:38 | Fix a defect in the query-flattener optimization identified by ticket [8f157e8010b22af0]. This fix is associated with CVE-2020-15358. (check-in: 9e001b635f user: dan tags: branch-3.28a) | |
|
2021-02-11
| ||
| 16:19 | In RBU, avoid passing VFS xShmLock calls through to the underlying VFS in cases where xShmMap calls may not be. This fixes a bad interaction with ZipVFS. (Leaf check-in: 0c3838d951 user: dan tags: reuse-schema-3.31) | |
|
2020-11-20
| ||
| 11:17 | Declare a variable "const" in order to avoid compiler warnings. (check-in: 4f5481bf29 user: dan tags: wal2) | |
|
2020-11-19
| ||
| 16:08 | Fix things so that sqlite3_database_file_object() works with wal2 filenames. (check-in: c2426ae8a8 user: dan tags: wal2) | |
|
2020-10-22
| ||
| 18:58 | Minor tweaks to query planning weights so that when STAT4 is enabled and functioning, a full table scan is more likely to be selected if that seems like the fastest solution. Only do this when STAT4 info is available because an error has a large potential downside. (check-in: 263293f1e6 user: drh tags: branch-3.28) | |
|
2020-10-02
| ||
| 13:57 | Import further corner-case fixes for the in-scan-vs-index or OP_SeekScan optimization from trunk. (check-in: c144d6404f user: drh tags: branch-3.28) | |
| 12:11 | For the OP_SeekScan optimization, the OP_IdxGT does not necessarily come right after the OP_SeekGE. So use the P2 operand of OP_SeekScan to point to the first instruction after OP_IdxGT. Problem found by dbsqlfuzz. (check-in: ec37744c6e user: drh tags: branch-3.28) | |
| 02:07 | Disable the OP_SeekScan opcode of the in-scan-vs-index optimization when in PRAGMA reverse_unordered_selects mode, as the OP_SeekScan only works with forwards scans. Thanks to OSSFuzz for pointing out the problem to us. (check-in: 9a1cdf7e9c user: drh tags: branch-3.28) | |
|
2020-09-30
| ||
| 18:22 | Improved query optimization for multi-column indexes where the second or later columns are constrained by an IN operator and the earlier index columns limit the search to a small number of rows. Use the new OP_SeekScan opcode which does scanning of the relevant range of the index but gives up and falls back to doing a seek if the number of rows scanned grows to large, in order to guard against pathological cases where the estimated number of rows to be scanned is far too small. (check-in: f07ac3fb38 user: drh tags: branch-3.28) | |
|
2020-09-16
| ||
| 16:55 | Merge bugfixes made since version 3.33.0 into this branch. (Leaf check-in: 2e269dcdef user: dan tags: reuse-schema-3.33) | |
| 16:49 | Fix a buffer overread found by OSSFuzz that could occur if a WITHOUT ROWID table with many columns was NATURAL JOINed against itself. (Leaf check-in: 807643c596 user: dan tags: branch-3.33) | |
| 16:48 | Do not invoke usleep() for more than 999999 microseconds. (check-in: 1f0055d0a2 user: dan tags: branch-3.33) | |
| 16:45 | Fix a tsan error that could occur when using shared-cache mode. (check-in: 61981b9747 user: dan tags: branch-3.33) | |
| 16:44 | Fix another (harmless in practice) tsan error in shared-cache mode. (check-in: 553e20c3d7 user: dan tags: branch-3.33) | |
| 16:41 | 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: 1b4801de2d user: dan tags: branch-3.33) | |
| 16:40 | Correctly handle expressions like "x IS (not) true/false" within the rhs of IN() expressions. Fix for [f3ff1472]. (check-in: 4236103379 user: dan tags: branch-3.33) | |
| 16:39 | Fix a crash that could occur in SQLITE_MAX_EXPR_DEPTH=0 builds when processing SQL containing syntax errors. (check-in: 6438db4570 user: dan tags: branch-3.33) | |
| 16:38 | 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: 8504161154 user: dan tags: branch-3.33) | |
|
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) | |
|
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: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) | |
|
2020-08-29
| ||
| 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) | |
|
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) | |
| 17:29 | Allow for page numbers as large as 4294967294 (0xfffffffe) which means database files as large as 281 TB. (check-in: 166e82dd20 user: drh tags: trunk) | |
| 17:14 | Fix unreachable branches. (Closed-Leaf check-in: 905752da98 user: drh tags: larger-databases) | |
|
2020-07-29
| ||
| 16:18 | Dozens and dozens of typo fixes in comments. This change adds no value to the end product and is disruptive, so it is questionable whether or not it will ever land on trunk. (Leaf check-in: a80ae2c98b user: drh tags: typos) | |
| 12:23 | Fix signed/unsigned compiler warnings. (check-in: 1d69eee8b0 user: drh tags: larger-databases) | |
|
2020-07-28
| ||
| 20:32 | Earlier detection of out-of-range page numbers in the btree layer. (check-in: 805bb67a82 user: drh tags: larger-databases) | |
| 17:51 | Merge enhancements from trunk. (check-in: 969c25bb14 user: drh tags: larger-databases) | |
| 17:29 | If a writer crashes in WAL mode and leave the SHM file in an inconsistent state, subsequent transactions are now able to recover the SHM file even if there are active read transactions. (check-in: ee8a108058 user: drh tags: trunk) | |
| 17:17 | Add an sqlite3FaultSim() to make an OOM case more accessible and remove the ALWAYS() on the conditional that is false when the OOM actually occurs. (Closed-Leaf check-in: 2a251af84f user: drh tags: unlocked-recovery) | |
|
2020-07-27
| ||
| 20:16 | On recovery, always overwrite the old with the new, even if they are the same. Add ALWAYS() macros on branches currently thought to be unreachable, pending additional testing. (check-in: 7052cf1d53 user: drh tags: unlocked-recovery) | |
| 15:05 | Fix a couple of test scripts to match the new wal recovery behaviour on this branch. (check-in: 3af61e8353 user: dan tags: unlocked-recovery) | |
| 15:01 | Improved error reporting if walLockExclusive() fails. (check-in: cf962d213a user: drh tags: unlocked-recovery) | |
|
2020-07-25
| ||
| 20:16 | When trying to read the index header, accept either of the two headers that have a valid checksum after 15 attempts to get exactly matching headers fail. (Closed-Leaf check-in: 3549faefea user: drh tags: more-aggressive-wal-recovery) | |
| 20:16 | Allow a wal mode recovery to proceed even if there are readers. (check-in: 74374aebf9 user: dan tags: unlocked-recovery) | |
|
2020-07-24
| ||
| 13:49 | Merge recent changes from trunk. (check-in: 22e8e6901a user: drh tags: larger-databases) | |
| 11:01 | Remove a surplus space from a comment (check-in: 73fecc688a user: drh tags: trunk) | |
| 09:17 | Fix other potentiall pointer aliasing problems associated with subclassing of the sqlite3_file object for various VFS implementations. (check-in: 270ac1a0f2 user: drh tags: trunk) | |
| 09:14 | Fix pointer aliasing problem in the in-memory journal code. Ref: forum post d44eb2fc44 (check-in: 892e9191dc user: drh tags: trunk) | |
|
2020-07-23
| ||
| 20:37 | Turns out this is an aliasing bug in SQLite, not a GCC bug. Was: Work-around for what appears to be another GCC bug - this one for GCC 8.3.0 on ARM. See the SQLite forum post for discussion. (Closed-Leaf check-in: 40c44d3810 user: drh tags: mistake) | |
| 18:03 | Add the OMIT_ZLIB compile-time option to sessionfuzz.c. (Originally checked into the wrong branch.) (check-in: 6019bf8a2d user: drh tags: trunk) | |
| 18:01 | Add the OMIT_ZLIB compile-time option to sessionfuzz.c. (Closed-Leaf check-in: 0785e3146e user: drh tags: wrong-branch) | |
| 15:23 | Fix a typo in an error message. (check-in: 849b03d8de user: drh tags: larger-databases) | |
| 14:27 | Merge fixes from trunk. (check-in: dd39418ee4 user: drh tags: larger-databases) | |
| 14:12 | An ORDER BY clause can slip into an SRT_Upfrom query via the query flattener, even without the SQLITE_ENABLE_UPDATE_DELETE_LIMIT compile-time option. So always enable the code to deal with that case. (check-in: 6a3111cd06 user: drh tags: trunk) | |
| 13:45 | Fix another case where a corrupt record could cause an assert() to fail in fts3. (check-in: 28515bbbae user: dan tags: trunk) | |
| 09:14 | Merge support for partial integrity checks. (check-in: b5443b47af user: drh tags: larger-databases) | |
| 00:45 | Add the ability to do a PRAGMA integrity_check (or quick_check) on a single table by specifying the table name as the argument. (check-in: 65dd321432 user: drh tags: trunk) | |
|
2020-07-22
| ||
| 21:11 | Detect out-of-bounds rootpage values in the schema. (check-in: e4a92688fc user: drh tags: larger-databases) | |
| 21:05 | Disable rootpage bounds checking when the SQLITE_TESTCTRL_EXTRA_SCHEMA_CHECKS setting is off, to facilitate reaching obscure error states during testing. (Closed-Leaf check-in: d7dd4fc464 user: drh tags: rootpage-bounds-check) | |
| 20:12 | Improvements to rootpage bounds checking during schema parse. (check-in: 75599a9731 user: drh tags: rootpage-bounds-check) | |
| 18:03 | When parsing the schema, detect out-of-bounds rootpage values and throw an error. (check-in: 6c3a2727dc user: drh tags: rootpage-bounds-check) | |
| 17:12 | All TCL tests now passing. (check-in: 4c5f3c6cac user: drh tags: larger-databases) | |
| 13:56 | Most test cases now passing. (check-in: 92e2ab3893 user: drh tags: larger-databases) | |
| 13:38 | Continuing work toward supporting unsigned 32-bit page numbers. (check-in: 9ce1710aad user: drh tags: larger-databases) | |
| 11:42 | Enhance showdb to be 32-bit clean. (check-in: a8200327d4 user: drh tags: larger-databases) | |
| 10:36 | Merge fixes from trunk. (check-in: d2aac00120 user: drh tags: larger-databases) | |
|
2020-07-21
| ||
| 18:36 | Work-around for GCC bug 96270. (check-in: 9679c0c611 user: drh tags: trunk) | |
| 18:25 | Add the sqlite3Int64ToText() routine and use it to convert integers to text, as it is much faster than the generic text formatter. (check-in: 14eed318aa user: drh tags: trunk) | |
|
2020-07-20
| ||
| 23:33 | Fix the ".read" command so that it gives an error when its argument is a directory. See forum message 4c53c434ca. (check-in: 6d258c3c7e user: drh tags: trunk) | |
| 18:07 | Fix a corner-case error in the new UPDATE FROM logic helpfully discovered by OSSFuzz. (check-in: 5cc200939d user: drh tags: trunk) | |
| 14:54 | Add the "enlargedb" utility program used to construct very large database files for testing. (check-in: 66858d8750 user: drh tags: larger-databases) | |
| 13:11 | Faster column name lookup in the columnIndex() routine using hashing. (check-in: de2a908124 user: drh tags: trunk) | |
| 12:47 | Initial changes to allow database up to 281TB in size. (check-in: 9cb7da9bdb user: drh tags: larger-databases) | |
|
2020-07-18
| ||
| 18:59 | Fix test case result on a DELETE with an INDEXED BY clause due to improvements in the query planner at [d901837fea1ed54d] (check-in: 020dbfa2ae user: drh tags: trunk) | |
| 18:44 | More harmless compiler warning fixes. (check-in: 4c0d208c45 user: drh tags: trunk) | |
| 18:03 | Fix a harmless compiler warning. (check-in: 5a0b0c6e11 user: drh tags: trunk) | |
| 15:52 | Add UPDATE FROM compatible with postgresql. (check-in: 88baf1eb07 user: drh tags: trunk) | |
|
2020-07-17
| ||
| 22:20 | Add ALWAYS() around a conditional that is always true. (Closed-Leaf check-in: 270e17bba1 user: drh tags: update-from) | |
| 18:07 | Use #ifdef to omit code that is only reachable when the SQLITE_ENABLE_UPDATE_DELETE_LIMIT compile-time option is used. (check-in: 587ded6035 user: drh tags: update-from) | |
| 16:31 | Make it an error to repeat the target object/alias of an UPDATE statement in its FROM clause. (check-in: d90a37e930 user: dan tags: update-from) | |
| 15:34 | Add a couple of "#ifdef SQLITE_ENABLE_UPDATE_DELETE_LIMIT" blocks missing from new code on this branch. (check-in: cc471df04a user: dan tags: update-from) | |
| 11:07 | Bring this branch up to date with begin-concurrent-pnu. (check-in: 12a909fb3d user: dan tags: begin-concurrent-report) | |
|
2020-07-16
| ||
| 20:57 | Allow BEGIN CONCURRENT transactions to contain schema modifications. However, this causes them to conflict with all other transactions. (check-in: 2160ede1d1 user: dan tags: begin-concurrent-pnu-wal2) | |
| 20:39 | Allow BEGIN CONCURRENT transactions to contain schema modifications. However, this causes them to conflict with all other transactions. (check-in: e9393a18cb user: dan tags: begin-concurrent-pnu) | |
| 20:24 | Allow BEGIN CONCURRENT transactions to contain schema modifications. However, this causes them to conflict with all other transactions. (check-in: 9a4a02304e user: dan tags: begin-concurrent) | |
| 18:55 | Relax pointless restrictions on allowing tables in the FROM clause from crossing over LEFT JOINs, as long as the table being moved is not the right table of the LEFT JOIN. (check-in: c1ea064948 user: drh tags: trunk) | |
| 14:52 | Modifications to test code so that the sqlite3MemdebugHastype() assert() statements are enabled for Tcl tests. (check-in: e3c423cb14 user: dan tags: update-from) | |
| 14:19 | Small performance improvement and size reduction in sqlite3DbStrNDup(). (check-in: 35cd87063d user: drh tags: trunk) | |
| 10:48 | Add OOM test for UPDATE...FROM statements inside triggers. (check-in: 917a479b0d user: dan tags: update-from) | |
| 02:36 | Fix a double-free of the FROM clause of an UPDATE inside of triggers. (check-in: 706c8da2f6 user: drh tags: update-from) | |
| 00:45 | Separate VdbeCoverage() macro for different jumps. (check-in: da593e57df user: drh tags: update-from) | |
|
2020-07-15
| ||
| 21:53 | Fix a problem in UPDATE FROM in which it tries to free using sqlite3_free() instead of sqlite3DbFree(). (check-in: 8ca8752652 user: drh tags: update-from) | |
| 20:01 | This was originally a merge to trunk. But after further testing, maybe it is better to run it a little longer on a branch. (check-in: 7d7d5ecbd7 user: dan tags: update-from) | |
| 19:38 | Add tests for UPDATE...FROM and foreign keys. (check-in: 6c3668f9ed user: dan tags: update-from) | |
| 18:30 | Fix problems that could occur if a table with the same name as the table being updated appeared in the FROM clause of an UPDATE statement. (check-in: 13224cbd75 user: dan tags: update-from) | |
| 15:32 | Fix a problem in SQLITE_ENABLE_HIDDEN_COLUMN builds occuring when an UPDATE...FROM fired an INSTEAD OF trigger. (check-in: 5176cb7a6a user: dan tags: update-from) | |
| 11:00 | Update this branch with changes from trunk. (check-in: 53b8b507a1 user: dan tags: update-from) | |
| 02:15 | New test cases for decimal and ieee754. (check-in: 73d62f82f9 user: drh tags: trunk) | |
|
2020-07-14
| ||
| 23:58 | Improvements to the min()/max() optimization so that it is able to use indexes where terms are constrained by IN operators. (check-in: b8ba2f17f9 user: drh tags: trunk) | |
| 22:20 | Now appears to work. All legacy tests pass. Need to add new tests, however. (Closed-Leaf check-in: 81e6450980 user: drh tags: minmax-opt-exp) | |
| 19:51 | Support UPDATE...FROM statements in trigger programs. (check-in: 4f6d8d0ebf user: dan tags: update-from) | |
| 15:30 | Fix an obsolete header comment on the sqlite3WhereIsOrdered() routine. (check-in: 5041f6a1c4 user: drh tags: trunk) | |