Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
144 check-ins related to "right-join"
|
2022-05-04
| ||
| 18:43 | Improvements for name resolution for parenthsized joins. (check-in: 006b2d9c user: drh tags: trunk) | |
|
2022-05-03
| ||
| 16:26 | Merge Bloom filter bug fix from trunk into the right-join branch. (Closed-Leaf check-in: 72131ad1 user: drh tags: right-join) | |
| 16:18 | Fix a typo in a comment. (check-in: c19c3c48 user: drh tags: right-join) | |
| 14:01 | Fix the Bloom filter pull-down optimization so that it jumps to the correct place if it encounters a NULL key. Fix for the bug described by forum thread 2482b32700384a0f. (check-in: 6eda9b1a user: drh tags: trunk) | |
|
2022-05-02
| ||
| 20:49 | Organize the various flag bits of the ExprList_item object into a substructure so that the whole lot can be copied all at once. Faster and smaller code. (check-in: 5341d4bb user: drh tags: right-join) | |
| 20:14 | Merge trunk fixes into the right-join branch. (check-in: e01f4c05 user: drh tags: right-join) | |
| 20:04 | Improved comments. (check-in: 158b80be user: drh tags: right-join) | |
| 19:59 | Name resolution and "*" wildcard expansion for parenthesized FROM clauses seems to work the same as PG. The code is chaos, however, and needs some cleanup. (check-in: 6f9c0b07 user: drh tags: right-join) | |
| 15:47 | Remove a testcase() macro taht was made obsolete by [a8da85c57e07721d]. (check-in: 053cf45e user: drh tags: trunk) | |
| 15:10 | Merge the latest trunk fixes and enhancements into the right-join branch. (check-in: afbcf075 user: drh tags: right-join) | |
| 14:32 | Improvement on check-in [a193749730d6cfba] so that the subroutine call to the IN operator right-hand side generator from the RIGHT JOIN no-match logic does not generate unreachable byte code. (check-in: cc458317 user: drh tags: trunk) | |
|
2022-04-29
| ||
| 17:13 | Multiple enhancements to the TreeView output for SrcItem, cherrypicked from the right-join experimental branch. (check-in: 293afa81 user: drh tags: trunk) | |
| 17:03 | Show the USING clause as part of the tree-view display of SrcItem. (check-in: 9cba3ce5 user: drh tags: right-join) | |
|
2022-04-28
| ||
| 18:17 | In treeview.c, show the columns of the table associated with each SrcItem. (check-in: 3aafccb5 user: drh tags: right-join) | |
| 17:35 | Tweaks to the name resolution on parenthesized joins. A small number of tests fail now due to extra columns appearing in the expansion of "*". (check-in: c8680491 user: drh tags: right-join) | |
| 12:52 | Merge trunk enhancements into the right-join branch. (check-in: 3fd9706b user: drh tags: right-join) | |
|
2022-04-27
| ||
| 18:38 | Fix a harmless typo in a comment. (check-in: e1f4a115 user: drh tags: trunk) | |
|
2022-04-23
| ||
| 19:26 | Merge enhancements and fixes from trunk into the right-join branch. (check-in: 2fb165cf user: drh tags: right-join) | |
| 19:21 | Prevent the ORDER BY LIMIT optimization from running if the innermost loop is a right-join, as doing so will get an incorrect answer. (check-in: 3aefc874 user: drh tags: trunk) | |
| 14:30 | Fix an operator typo - This indicates that the branch needs further investigation and verification. (check-in: f6ab6796 user: drh tags: right-join) | |
| 07:31 | Correctly resolve left and right USING columns of an outer join in a parenthesized subjoin. (check-in: ea91aba8 user: drh tags: right-join) | |
| 07:29 | Fix minor problems with the new join table name resolution logic. (Closed-Leaf check-in: 3a6b0db4 user: drh tags: right-join-colnames) | |
|
2022-04-22
| ||
| 23:18 | Add the ability to access the USING columns of the right or left tables of an OUTER JOIN even if the OUTER JOIN is in parentheses. Prototype code only. (check-in: c3a42757 user: drh tags: right-join-colnames) | |
| 19:52 | Merge the latest enhancements and fixes from trunk onto the right-join branch. (check-in: 7f898334 user: drh tags: right-join) | |
| 18:07 | Make use of the "%!S" format when running ExplainSubquery. (check-in: 9425d79c user: drh tags: trunk) | |
| 13:34 | Simplification of data structures in the wildcard expander for SF_NestedFrom queries. (check-in: f7c18262 user: drh tags: trunk) | |
| 12:46 | Minor simplification to the result-set wildcard expander for SF_NestedFrom. (check-in: d942530a user: drh tags: right-join) | |
| 09:57 | Merge the latest trunk fixes into the right-join branch. (check-in: c74dc574 user: drh tags: right-join) | |
|
2022-04-21
| ||
| 23:34 | Previous fix to join8.test needs a return. (check-in: 7b4cd705 user: drh tags: trunk) | |
| 19:38 | Add support for RIGHT and FULL JOIN. (check-in: f766dff0 user: drh tags: trunk) | |
| 19:25 | Fix harmless compiler warnings. (check-in: 29255664 user: drh tags: right-join) | |
| 14:48 | Make sure the code generator knows to invoke row-value subroutines which running the right-join post-processing loop. (check-in: fd328e52 user: drh tags: right-join) | |
| 14:08 | Ensure correct fg.isNestedFrom values even on crazy parses. (check-in: e611e8e6 user: drh tags: right-join) | |
| 13:11 | Avoid materializing columns of SF_NestedFrom subqueries that are never used. Other code improvements manually imported from the right-join-paren branch. (check-in: cd8272fc user: drh tags: right-join) | |
|
2022-04-20
| ||
| 21:58 | Try to avoid materializing unused columns when processing a parenthesized FROM clause. (check-in: 07906e3c user: drh tags: right-join-paren) | |
| 18:12 | Small correction to the new bUsed logic of sqlite3ProcessJoin(). (check-in: ba04142e user: drh tags: right-join) | |
| 16:54 | Merge window function fix from trunk. (check-in: b6b9e185 user: drh tags: right-join) | |
| 16:53 | Remove an unnecessary assignment operation. (check-in: ed46527a user: drh tags: right-join) | |
| 16:42 | Fix a problem with using multiple SQLITE_SUBTYPE function as window functions in a single query. (check-in: 9430ead7 user: dan tags: trunk) | |
| 16:26 | Comment fixes and improvements in sqlite3ProcessJoin(). (check-in: 1118655f user: drh tags: right-join) | |
| 15:07 | Improved tracking of nested SELECT objects used to implement parenthensized FROM terms. (check-in: 0da22326 user: drh tags: right-join) | |
| 12:15 | Also show the ENAME_SPAN value in sqlite3TreeViewExprList(), if there is one. (check-in: c1d42861 user: drh tags: right-join) | |
| 12:14 | Improved TreeView output for ExprList: Show the ENAME_TAB value, if there is one. (check-in: eb3f883b user: drh tags: right-join) | |
| 12:02 | Add a new comment to the body of lookupName(). No code changes. (check-in: 22fa9b9b user: drh tags: right-join) | |
|
2022-04-19
| ||
| 23:00 | Merge the ALTER TABLE fix from trunk. (check-in: d5ceaef3 user: drh tags: right-join) | |
| 20:47 | Fix a problem in ALTER TABLE with handling "table.*" expressions within SELECT statements in triggers. (check-in: 24755fd0 user: dan tags: trunk) | |
| 19:51 | Improved comment on the JF_LTORJ constant definition. (check-in: e0744da9 user: drh tags: right-join) | |
| 18:23 | Fix a NULL-pointer dereference that can occur on an aggregate query that uses FULL JOIN. dbsqlfuzz 496a35dd4eefcd7935aaaeb0c69056bf49785d28. (check-in: 63b8f8ae user: drh tags: right-join) | |
| 15:56 | Mark an unreachable "just-in-case" branch as unreachable. (check-in: b966d524 user: drh tags: right-join) | |
| 15:01 | Add 512 new join test cases derived from PostgreSQL output. (check-in: 78d58e46 user: drh tags: right-join) | |
| 09:39 | Remove unnecessary cases for the resolver. (check-in: 5bc9aa68 user: drh tags: right-join) | |
| 02:03 | Add the omitted "finish_test" to the end of joinA.test. (check-in: 0907505c user: drh tags: right-join) | |
| 00:24 | New test cases for RIGHT and FULL JOIN. (check-in: 5c2f670e user: drh tags: right-join) | |
|
2022-04-18
| ||
| 23:20 | Fix the query flattener so that it does not flatten a RIGHT or FULL JOIN into any position of the outer query other than the first. (check-in: 837322aa user: drh tags: right-join) | |
| 22:51 | New test cases, including one that gets a different result than Postgres. (check-in: 49ea11a4 user: drh tags: right-join) | |
| 19:48 | Disable the unused EU4_EXPR mode for the IdList object. (check-in: 5bcf4aa3 user: drh tags: right-join) | |
| 19:34 | Even more test cases. (check-in: 5f4310a1 user: drh tags: right-join) | |
| 19:28 | New test cases for parenthesized NATURAL FULL JOINs. (check-in: e34250ef user: drh tags: right-join) | |
| 18:01 | New test case demonstrating the ability to invoke OP_NullRow on a cursor that has never been opened. (check-in: d173edc2 user: drh tags: right-join) | |
| 16:23 | Merge the btree bug-fix from trunk. (check-in: a333c0b5 user: drh tags: right-join) | |
| 16:20 | Ensure that left-hand side WITHOUT ROWID tables are set to OP_NullRow prior to running the right-join loop. This fixes a problem introduced by the previous check-in. (check-in: aab7665c user: drh tags: right-join) | |
| 16:10 | Fix problems with WHERE clauses that follow multiple FULL JOINs. This introduces some new faults in the tests, probably due to something unrelated. (check-in: 95b242d4 user: drh tags: right-join) | |
| 15:56 | Avoid an assert() failure in allocateSpace() triggered by a corrupt database. dbsqlfuzz f022eb0ce64d27808574d1dcde5cf7d002dabde8. (check-in: 2de7f8cc user: dan tags: trunk) | |
| 14:41 | Merge the latest fixes from trunk. (check-in: 1ba3b3cc user: drh tags: right-join) | |
| 14:15 | Improved comment field in the bytecode generated for OP_Column and OP_Rowid. (check-in: 1b2c5cef user: drh tags: trunk) | |
| 13:57 | Improved comment field in the bytecode generated for OP_Column and OP_Rowid. (check-in: 009bbf80 user: drh tags: right-join) | |
| 13:08 | New RIGHT JOIN test cases, one of which is currently failing. (check-in: 9168cbbe user: drh tags: right-join) | |
| 11:22 | Change the row-value initialization subroutine call from within the right-join body subroutine from an issue to an optimization opportunity. (check-in: 829d49f2 user: drh tags: right-join) | |
| 10:26 | Do not allow an empty table bypass to jump outside of a right-join body subroutine. (check-in: 1549dcd2 user: drh tags: right-join) | |
| 10:09 | Fix the sqlite3SrcListAppendList() routine so that it correctly adds the JT_LTORJ attribute to the first SrcItem, if needed. (check-in: 07ed0dca user: drh tags: right-join) | |
| 09:59 | Leave sqlite3ProcessJoin() early if an OOM is encountered in the NATURAL to USING converter. This avoids NULL pointer dereferences further along in the code. (check-in: 0ccb224e user: drh tags: right-join) | |
| 00:57 | Fix to the coalesce() function generation in the resolver. (check-in: 584bd55e user: drh tags: right-join) | |
| 00:04 | When converting a NATURAL JOIN into a JOIN USING, make sure to insert the name correctly into the IdList even if it is a wierd quoted name. (check-in: e62156b6 user: drh tags: right-join) | |
|
2022-04-17
| ||
| 23:46 | Fix to the logic that computes coalesc() functions to resolve USING terms. (check-in: 20388548 user: drh tags: right-join) | |
| 22:58 | Deal with OP_Return bypass in the RIGHT JOIN subroutine by adding extra OP_Returns where needed. (check-in: 71abe564 user: drh tags: right-join) | |
| 20:30 | Change OP_Return such that if P3 is 1, the Return is a no-op when the P1 register contains a NULL. (check-in: c9060232 user: drh tags: right-join) | |
| 18:46 | Further improvements to USING() processing for RIGHT and FULL JOINs. All currently known issues are now resolved. Performace is improved. (check-in: 9fd3f22e user: drh tags: right-join) | |
|
2022-04-16
| ||
| 23:38 | New test cases, one of which is failing, indicating a bug that needs fixing. (check-in: bd5fd684 user: drh tags: right-join) | |
| 22:57 | Fix the USING to ON translation so that it works correctly for a sequence of two or more joins where one of the joins to the right-hand side of the list is a RIGHT or FULL JOIN. (check-in: 9ffc2b23 user: drh tags: right-join) | |
| 19:13 | Since the query planner is unable to cope with a LEFT JOIN on the left-hand side of a RIGHT JOIN, detect that situation early and raise a parsing error. This is a temporary measure that needs to be fixed. (check-in: 6d5d6e04 user: drh tags: right-join) | |
| 18:33 | Additional SELECT trace logic: Show the tree after result-set wildcard expansion but before name resolution. (check-in: a7babf75 user: drh tags: right-join) | |
| 13:55 | New test cases. One of the new test cases shows a flaw in the base design of RIGHT JOIN. (check-in: 4c3ce647 user: drh tags: right-join) | |
| 12:40 | RIGHT JOIN USING now appears to work the same as PG-14. Legacy tests pass. (check-in: 5bfb8624 user: drh tags: right-join) | |
|
2022-04-15
| ||
| 19:53 | Revamp the USING clause processing so that it works (mostly) with RIGHT and FULL JOIN. (check-in: 719c8d92 user: drh tags: right-join) | |
| 19:49 | Avoid deleting substructure of the Expr node in lookupName() until after the error message is generated. (Closed-Leaf check-in: b8e71766 user: drh tags: right-join-using) | |
| 18:30 | When expanding "*" in the result set of a SELECT, do not attach a table name to columns that are in subsequent USING clauses. (check-in: 91530990 user: drh tags: right-join-using) | |
| 17:08 | The sqlite3ProcessJoin() routine converts a NATURAL JOIN into a JOIN USING so that henceforth the NATURAL keyword can be ignored. (check-in: 8378e1e0 user: drh tags: right-join) | |
| 15:47 | Enhance the IdList object to exist in a single memory allocation (rather than a separate allocate for the base object and the array of IDs). Also permit an IdList object to store an Expr pointer together with each name. (check-in: 40f3c958 user: drh tags: right-join) | |
| 15:15 | Add the "3" in the name of the sqlite3ProcessJoin() function. (check-in: b925f72b user: drh tags: right-join) | |
|
2022-04-14
| ||
| 20:43 | Record the three known big issues with the current RIGHT JOIN design in the join8 test module, with tests that deliberately fail in order to remind us to fix the issues. (check-in: 2c4ee723 user: drh tags: right-join) | |
| 19:48 | Cherry pick subroutine indentation improvements and the hardening of OP_Gosub from the right-join branch back into trunk. (check-in: 12645f10 user: drh tags: trunk) | |
| 19:05 | Another instance of indenting a subroutine. (check-in: 73f4036b user: drh tags: right-join) | |
| 18:19 | Check for interrupts and invoke the progress handler following a Gosub opcode, to avoid and recover from infinite subroutine loops. (check-in: 647211e0 user: drh tags: right-join) | |
| 16:34 | Rerun the subroutines that compute row-values if necessary from within the RIGHT JOIN body subroutine. (check-in: 9b9038bc user: drh tags: right-join) | |
| 15:55 | Adjust the output formatting of bytecode listings so that subroutines used to implement subqueries are indented one level. (check-in: 079b7b12 user: drh tags: right-join) | |
| 14:58 | Disable autoindexing for the RIGHT JOIN loop. (check-in: 402a89e3 user: drh tags: right-join) | |
| 14:40 | Adjust assert() statements to account for the new always-NULL cursor type added by [4526c5d316508093]. (check-in: 7822faa4 user: drh tags: right-join) | |
| 14:19 | Previous check-in accidentally inverted a test on an assert(). Fix that. (Closed-Leaf check-in: 5ec4f806 user: drh tags: right-join-fix, right-join) | |
| 12:59 | Fix assert() statements associated with artifical null-value cursors created by RIGHT JOIN. (check-in: f5bce5f1 user: drh tags: right-join-fix, right-join) | |
|
2022-04-13
| ||
| 19:00 | Fix a harmless (false-positive) unused variable compiler warning on MSVC. (check-in: 63b04c63 user: drh tags: right-join) | |
| 18:32 | Make the sqlite3TreeViewSrcList() routine a no-op if called with a NULL SrcList object. (check-in: 185d2720 user: drh tags: right-join) | |
| 18:20 | Fix an assert() in OP_Column so that it accounts for the new type of pseudo-cursor that always returns NULL for any column. (check-in: 371ddc97 user: drh tags: right-join) | |
| 17:41 | If the OP_NullRow opcode is given a cursor that has not yet been opened, then go automatically open it to a special pseudo-cursor that allows returns NULL for every column. Used by the new RIGHT JOIN implementation. (check-in: 4526c5d3 user: drh tags: right-join) | |
| 16:46 | Move the explain comment for the RIGHT-JOIN post-processing loop to the verify beginning of the loop - to make the start of the loop clearer to human bytecode readers. (check-in: 7ed2a271 user: drh tags: right-join) | |
| 12:34 | This was the original landing of the RIGHT and FULL OUTER JOIN changes to trunk. It was moved back onto a branch due to problems discovered. (check-in: fa9d206f user: drh tags: right-join) | |
| 12:12 | The rows of a RIGHT JOIN might come out in any arbitrary order. So disable the ORDER-BY/GROUP-BY optimizations if a RIGHT JOIN is involved. (check-in: d168f245 user: drh tags: right-join) | |
| 10:49 | Fix an assert() in btree.c that might not be true for a corrupt database file. (check-in: dbd8e2e4 user: drh tags: trunk) | |
| 01:52 | Add missing VdbeCoverage() macros on new branch byte-code opcodes. (check-in: 218c7167 user: drh tags: right-join) | |
|
2022-04-12
| ||
| 20:20 | Ensure that the JT_LTORJ bit in the SrcItem.fg.jointype is preserved during query flattening. (check-in: 61259050 user: drh tags: right-join) | |
| 18:40 | For the bad join type error message "unknown or unsupported join type" remove the "or unsupported" clause, because we now support all valid join types. (check-in: ab0a0562 user: drh tags: right-join) | |
| 18:04 | Factor out the RIGHT JOIN non-matched row loop from sqlite3WhereEnd(). This reduces the register pressure on that routine and helps it to run faster in the common case where there is no RIGHT JOIN. (check-in: beeecf16 user: drh tags: right-join) | |
| 17:43 | Merge the latest enhancements from trunk into the right-join branch. (check-in: b3e57ba1 user: drh tags: right-join) | |
| 17:02 | Earlier detection of corruption in balance_nonroot(). dbsqlfuzz 9191ade77ebd3b7a3356e074957aa85b0c669d14. (check-in: bff4f083 user: dan tags: trunk) | |
| 14:23 | The multi-index OR optimization does not work for RIGHT join, so disallow it. (check-in: 34c2f7b2 user: drh tags: right-join) | |
| 13:46 | Always explicitly set each table cursor to NullRow before doing the RIGHT-JOIN unmatched row pass. This is a cheap opcode, and it adds an extra layer of defense against incorrect results. (check-in: a3d14e61 user: drh tags: right-join) | |
|
2022-04-11
| ||
| 21:00 | Fix RIGHT JOIN for virtual tables. (check-in: 75a9116e user: drh tags: right-join) | |
| 20:15 | The query flattener must add TK_IF_NULL_ROW opcodes on substituted values that land on the left operand of a RIGHT JOIN, just as it already does for the right operand of a LEFT JOIN. (check-in: 8e02cdf5 user: drh tags: right-join) | |
| 18:54 | New test cases added. (check-in: bdd1499c user: drh tags: right-join) | |
| 17:27 | Fix handling of "continue" and "break" from inside the loop for the right operand of a RIGHT JOIN. (check-in: b6e773a2 user: drh tags: right-join) | |
| 14:43 | Do not attempt the LEFT JOIN strength reduction optimization on a FULL JOIN. (check-in: 7ef3e99a user: drh tags: right-join) | |
| 14:26 | Show LEFT and RIGHT JOIN processing in the EXPLAIN QUERY PLAN output. (check-in: d91faeff user: drh tags: right-join) | |
| 13:13 | New test cases. (check-in: d5f6791b user: drh tags: right-join) | |
| 12:38 | Make a distinction between (1) WHERE clause constraints, (2) ON/USING constraints on outer joins, and (3) ON/USING clause constraints on inner joins. Formerly, there was no distinctionb between 1 and 3, but RIGHT JOIN needs to know the difference. Make RIGHT JOIN aware of this difference and add test cases. (check-in: 0f6f61c3 user: drh tags: right-join) | |
| 11:59 | Fix some comments that refer to LEFT JOIN that should refer to OUTER JOIN. No changes to code. (check-in: 5be5ede5 user: drh tags: right-join) | |
| 11:48 | Merge the Expr.w.iJoin name change from trunk into the right-join branch. (check-in: 29927926 user: drh tags: right-join) | |
| 11:25 | Rename the Expr.w.iRightJoinTable to just Expr.w.iJoin, so that the words "RightJoin" in the former name do not lead readers to believe that this has something to do with RIGHT JOINs in particular. (check-in: e8c00442 user: drh tags: trunk) | |
| 10:38 | Ensure that the JT_LTORJ flag is preserved when flattening a subquery that is on the left side of a RIGHT JOIN. (check-in: ccb61fb1 user: drh tags: right-join) | |
| 00:54 | Show the JT_LTORJ flag in TreeView debugging output. (check-in: 21eb4491 user: drh tags: right-join) | |
| 00:21 | Do not allow query flattening nor the push-down optimization on the right operand of a RIGHT JOIN. (check-in: 5aa0c9ea user: drh tags: right-join) | |
|
2022-04-10
| ||
| 23:48 | Cannot use an automatic index on the right table of a RIGHT JOIN because automatic indexes must be WHERE_IDX_ONLY, but the RIGHT JOIN post-processing does not know how to work with an index-only scan. (check-in: beb4401d user: drh tags: right-join) | |
| 23:01 | Revisit [f84b2beca7197589]: disallow co-routine implementations of tables that are to the left of a RIGHT JOIN, to avoid other complications. (check-in: cf00ebfc user: drh tags: right-join) | |
| 20:28 | Minor improvements to the sqlite3SrcListShiftJoinType() routine. This started out to be an effort to convert RIGHT JOIN to LEFT JOIN if the join was on the first pair of relations, but that messes up the "*" expansion and so won't work. (check-in: a48902c7 user: drh tags: right-join) | |
| 19:51 | When the left-most table of a RIGHT JOIN is implemented as a co-routine, make sure all its columns are flushed to NULL when it finishes so that they appear to be NULL during the RIGHT JOIN post-processing. (check-in: f84b2bec user: drh tags: right-join) | |
| 17:14 | More test cases and bug fixes. (check-in: 140e97fd user: drh tags: right-join) | |
| 16:13 | More RIGHT JOIN test cases and a bug fix. (check-in: 19e8ad69 user: drh tags: right-join) | |
|
2022-04-09
| ||
| 20:11 | Add a simple test case. (It is not difficult to create additional test cases that assert, at this point.) (check-in: f2201d5d user: drh tags: right-join) | |
| 18:48 | Bug fixes. A basic FULL OUTER JOIN now works. (check-in: 34bbeeb7 user: drh tags: right-join) | |
| 14:48 | Add byte-code that computes unmatched rows on the right table of a RIGHT JOIN. Compiles, and the code looks semi-reasonable, but still does not run. Incremental check-in. (check-in: 2db5a498 user: drh tags: right-join) | |
| 12:27 | The interior of the RIGHT JOIN loop is now a subroutine. (check-in: 549f5a7e user: drh tags: right-join) | |
| 03:16 | A few bits and bobs of code generation toward getting RIGHT JOIN to work. Much more remains to do. (check-in: 55b45431 user: drh tags: right-join) | |
| 03:12 | Merge the sqlite3WhereMalloc() routine from trunk into the right-join branch. (check-in: b1b3845a user: drh tags: right-join) | |
| 03:06 | The sqlite3WhereMalloc() routine allocates memory that is automatically deleted when the corresponding WhereInfo object is destroyed. (check-in: f237e1d8 user: drh tags: trunk) | |
|
2022-04-08
| ||
| 19:20 | Preliminary code to support RIGHT JOIN. Everything seems to work, except that the code to compute the unmatched rows for the RIGHT JOIN has not yet been added, so the result of a RIGHT JOIN is currently the same as an INNER JOIN. (check-in: 415abd67 user: drh tags: right-join) | |
| 17:01 | Enhance the sqlite_dbpage fix at check-in 642a0b4752743 from about a month ago such that it still takes a transaction on all attached databases, but it only starts a read transaction for read-only operations, rather than starting a write transaction for everything. (check-in: 8efd61e8 user: drh tags: trunk) | |