[
https://issues.apache.org/jira/browse/DRILL-1663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14203386#comment-14203386
]
Mehant Baid commented on DRILL-1663:
------------------------------------
The implicit cast was added only for hash join. Reason being that we apply the
cast only on top of the expression for hash function and not comparison
functions. We have implementations of comparison functions which can take
different inputs so we don't need cast for those. Hence this bug exists only in
hash join code path. I disabled hash join and the query works fine for merge
join.
> 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)
