slim bouguerra created CALCITE-2123:
---------------------------------------
Summary: 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)
