Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
38 most recent 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) | |