[
https://issues.apache.org/jira/browse/OPTIQ-435?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde resolved OPTIQ-435.
-------------------------------
Resolution: Fixed
Fix Version/s: 0.9.2-incubating
Fixed in http://git-wip-us.apache.org/repos/asf/incubator-optiq/commit/99c7ff96.
> LoptOptimizeJoinRule incorrectly re-orders outer joins
> ------------------------------------------------------
>
> Key: OPTIQ-435
> URL: https://issues.apache.org/jira/browse/OPTIQ-435
> Project: Optiq
> Issue Type: Bug
> Affects Versions: 0.9.0-incubating
> Reporter: Laljo John Pullokkaran
> Assignee: Julian Hyde
> Fix For: 0.9.2-incubating
>
>
> Following query reproduces the problem:
> SELECT ss_item_sk, ss_ticket_number, ss_customer_sk, sr_return_quantity FROM
> store_sales LEFT OUTER JOIN store_returns ON (store_returns.sr_item_sk =
> store_sales.ss_item_sk AND store_returns.sr_ticket_number =
> store_sales.ss_ticket_number), reason WHERE store_returns.sr_reason_sk =
> reason.r_reason_sk AND r_reason_desc = 'reason 28';
> The Join graph given is:
> (SS --> SR) -- Reason gets transformed in to
> (SS x Reason) --> SR
> This is an invalid reordering.
> A short term solution may be to split join graph on outer join.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
