[jira] [Commented] (DRILL-435) Update Optiq's SqlTypeUtil.isCharTypeComparable() to consider ANY values as comparable

["Jacques Nadeau (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-435?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13945211#comment-13945211 ] 

Jacques Nadeau commented on DRILL-435:
--------------------------------------

This is required to complete numerous TPC-H queries as otherwise we get the following when using like.

For example, if we try to write p.p_name like '%yellow%'

Error:
 "Failure while parsing sql. 
ValidationException:[ org.eigenbase.util.EigenbaseContextException: From line 0, column 0 to line 26, column 34 ]
EigenbaseContextException:[ From line 0, column 0 to line 26, column 34 ]
SqlValidatorException:[ Operands p.p_name, \'%yellow%\' not comparable to each other ]"


> Update Optiq's SqlTypeUtil.isCharTypeComparable() to consider ANY values as comparable
> --------------------------------------------------------------------------------------
>
>                 Key: DRILL-435
>                 URL: https://issues.apache.org/jira/browse/DRILL-435
>             Project: Apache Drill
>          Issue Type: Improvement
>            Reporter: Jacques Nadeau
>            Assignee: Mehant Baid
>
> Tracking bug for Optiq issue: https://github.com/julianhyde/optiq/issues/199



--
This message was sent by Atlassian JIRA
(v6.2#6252)