[
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)
