[
https://issues.apache.org/jira/browse/DRILL-1663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14202962#comment-14202962
]
Jinfeng Ni commented on DRILL-1663:
-----------------------------------
The code fix in ChainedHashTable looks good to me.
Do we also need fix Merge Join as well? Can you try to disable hash join, and
run merge join with the original failing query, to see how it goes?
> Implicit cast to variable width type does not work in join conditions
> ---------------------------------------------------------------------
>
> Key: DRILL-1663
> URL: https://issues.apache.org/jira/browse/DRILL-1663
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Mehant Baid
> Assignee: Mehant Baid
> Priority: Minor
> Attachments: DRILL-1663.patch
>
>
> Currently if the two sides of a join condition are of different types then we
> implicitly add a cast on one side so that the join condition works as
> expected. However when we apply a cast to variable width type (varchar or
> varbinary) we don't include the length parameter as part of the arguments.
> This causes the function resolver to not match against any function
> implementation and return a NULL expression.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
