[
https://issues.apache.org/jira/browse/CALCITE-2123?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16316878#comment-16316878
]
Julian Hyde commented on CALCITE-2123:
--------------------------------------
OK, we are agreed. Let's tighten the type-checking rules for when these
RexNodes are created. There may be some pain, though; I'll do my best to help
you get through that.
> Bug in the Druid Filter Translation when Comparing String Ref to a Constant
> Number
> ----------------------------------------------------------------------------------
>
> Key: CALCITE-2123
> URL: https://issues.apache.org/jira/browse/CALCITE-2123
> Project: Calcite
> Issue Type: Bug
> Components: druid
> Reporter: slim bouguerra
> Assignee: Julian Hyde
>
> The following query {code} SELECT COUNT(*) FROM \"foodmart\" WHERE
> \"product_id\" = 16.0{code} Translates to a Druid Table Scan with a String to
> String Selector comparison filter.
> instead we need to have a Bound filter that cast the String to number.
> This is what we should expect.
> {code}
> {"type":"bound","dimension":"product_id","lower":"16.0","lowerStrict":false,"upper":"16.0","upperStrict":false,"ordering":"numeric"}
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
