[CAY-1128] Switch JOINT prefetches to generate OUTER Joins.

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0
• Fix Version/s: 3.0M5, 3.0
• Component/s: Core Library
• Assignee: Andrus Adamchik
• Reporter: Andrus Adamchik
• Created: 19/Oct/08 12:15
• Updated: 08/May/10 10:34
• Resolved: 19/Oct/08 12:27

Description

Switch JOINT prefetches to OUTER Joins. This is related to CAY-1025. JOINT_PREFETCH_SEMANTICS using inner joins makes little sense and is a complete hack. Changing it to use OUTER joins suddenly makes it usable (and in fact even more robust than DISJOINT prefetches - see the problem described in CAY-1025).

Needed code was committed as a part of CAY-1025 work, so here we'll need to update the docs and the UPGRADE-NOTES.txt.