Make outer join reordering work for right outer joins
-----------------------------------------------------
Key: DERBY-4742
URL: https://issues.apache.org/jira/browse/DERBY-4742
Project: Derby
Issue Type: Improvement
Components: SQL
Affects Versions: 10.6.1.0
Reporter: Dag H. Wanvik
Currently, Derby only attempts to reorder (into left deep) left outer join
queries. Right outer join queries are commented out, apparently due to
implementation difficulties, cf. this comment in
HalfOuterJoinNode.LOJ_reorderable.
// It is much easier to do LOJ reordering if there is no ROJ.
// However, we ran into some problem downstream when we transform an ROJ
// into LOJ -- transformOuterJoin() didn't expect ROJ to be transformed
// into LOJ alread. So, we skip optimizing ROJ at the moment.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
