[
https://issues.apache.org/jira/browse/DRILL-1663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14202832#comment-14202832
]
Jinfeng Ni commented on DRILL-1663:
-----------------------------------
Hi Mehant,
Can you give an example query which originally failed and then run successful
with your patch? That will help to understand what the problem is. Thanks.
> 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)