aboutsummaryrefslogtreecommitdiff
path: root/test/join8.test
Commit message (Expand)AuthorAge
* Further to [46639f682975dac6], the parameters of a table valued function thatdrh2023-02-27
* Do not use a Bloom filter if any outer loop lacks STAT1 data, since withoutdrh2023-02-05
* The query flattener should not run if the subquery is a compound that containsdrh2022-07-13
* Do not allow FROM-clause terms on the left side of a RIGHT or FULL JOIN todrh2022-06-20
* Do not allow an ON clause to references tables to its right if there is adrh2022-06-20
* The fix at [cab9b4cccd13bf0a] was incomplete, as demonstrated bydrh2022-06-20
* Fix the OP_NullRow opcode so that it works even if it applied to andrh2022-06-14
* Do not remove the EP_CanBeNull flag from expressions during a LEFT JOINdrh2022-06-13
* The same restrictions on the use of WHERE clause terms to drive indexesdrh2022-06-10
* Do not allow constant propagation between WHERE-clause terms and ON-clause termsdrh2022-06-10
* Fix the query flattener to deal with a RIGHT JOIN corner case describeddrh2022-06-07
* Test cases for [forum:/forumpost/323f86cc30|forum post 323f86cc30] addeddrh2022-06-07
* Extra test cases for outer joins.dan2022-06-06
* Do not allow a WHERE clause constraint to be used to drive an index fordrh2022-06-06
* Ensure that all necessary row-value subqueries are invoked while runningdrh2022-06-01
* Additional enhancements to the test cases.drh2022-06-01
* Fix test cases in the previous check-in to make them postgres-compatible.drh2022-06-01
* Test case for [forum:/forumpost/087de2d9ec|forum post 087de2d9ec] showingdrh2022-06-01
* Add test cases fordrh2022-05-31
* For an outer join, then ON-clause constraints need to be evaluated at justdrh2022-05-30
* Do not allow the right operand of a RIGHT JOIN to be reordered with otherdrh2022-05-25
* When an ON clause on an INNER JOIN references a table to the right ofdrh2022-05-24
* New test cases to further demonstrate the difference in name matching rulesdrh2022-05-23
* Do not allow an index scan on an index-on-expression for a RIGHT JOIN becausedrh2022-05-14
* Improvements to the decision of when to check ON constraints for an innerdrh2022-05-14
* Walk back the optimization from check-in [cc458317bd77046c] that tries todrh2022-05-13
* Ensure that ON clauses are applied to the correct outer join.drh2022-05-12
* New requirement marks.drh2022-05-10
* Fix ON-clause constraint usage for FULL and RIGHT JOINs.drh2022-05-04
* Simplified fix to the problem with subroutine reuse in the RIGHT JOIN no-matchdrh2022-04-30
* Further improvements to codeEqualityTerm() for cases when an IN operator withdrh2022-04-30
* Enhance the codeEqualityTerm() routine inside the code generator so that it isdrh2022-04-29
* Prevent the ORDER BY LIMIT optimization from running if the innermost loopdrh2022-04-23
* Previous fix to join8.test needs a return.drh2022-04-21
* Disable join8.test if the build lacks support for virtual tables.drh2022-04-21
* Make sure the code generator knows to invoke row-value subroutines whichdrh2022-04-21
* Change the row-value initialization subroutine call from within thedrh2022-04-18
* Do not allow an empty table bypass to jump outside of a right-join bodydrh2022-04-18
* New test cases, one of which is failing, indicating a bug that needs fixing.drh2022-04-16
* Record the three known big issues with the current RIGHT JOIN design indrh2022-04-14
* Ensure that the JT_LTORJ bit in the SrcItem.fg.jointype is preserved duringdrh2022-04-12
generated by cgit v1.2.3 (git 2.25.1) at 2025-05-19 00:17:32 +0000