[
https://issues.apache.org/jira/browse/DRILL-712?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13999202#comment-13999202
]
Jacques Nadeau commented on DRILL-712:
--------------------------------------
Fixed in 86e565a
> Right side of Left join has zero values when should be null
> -----------------------------------------------------------
>
> Key: DRILL-712
> URL: https://issues.apache.org/jira/browse/DRILL-712
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Zhiyong Liu
> Assignee: Steven Phillips
> Attachments: DRILL-712.patch
>
>
> git.commit.id=e7a486d784c072458d44b7692ea0262da368f001
> 2014-05-13 11:16:03 INFO QuerySubmitter:89 - Submitting query:
>
> select count(*)
>
> from (select l.l_orderkey as x, c.c_custkey as y
>
> from lineitem l
>
> left outer join customer c
>
> on l.l_orderkey = c.c_custkey) as foo
>
> where y < 10000
>
> 2014-05-13 11:16:10 INFO DrillTestBase:201 - Query submit end time:
> 2014/05/13 11:16:10.0010
> 2014-05-13 11:16:10 INFO DrillTestBase:202 - The execution time for the
> query: 7 seconds.
> 2014-05-13 11:16:10 INFO TestVerifier:203 - These rows are not expected:
>
> 2014-05-13 11:16:10 INFO TestVerifier:206 - 60175 : 1 time(s).
>
> 2014-05-13 11:16:10 INFO TestVerifier:213 - Total number of unexpected rows:
> 1
> 2014-05-13 11:16:10 INFO TestVerifier:217 - These rows are expected but are
> not in result set:
> 2014-05-13 11:16:10 INFO TestVerifier:220 - 1467 : 1 time(s).
>
> 2014-05-13 11:16:10 INFO TestVerifier:227 - Total number of expected but
> missing: 1
> also,resultset from drill is inconsistent.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
