[
https://issues.apache.org/jira/browse/DRILL-1631?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14199278#comment-14199278
]
Chun Chang commented on DRILL-1631:
-----------------------------------
postgres converts int to float before making the comparison. So, we should make
our behavior consistent with postgres/oracle.
> Integer comparison in JSON
> --------------------------
>
> Key: DRILL-1631
> URL: https://issues.apache.org/jira/browse/DRILL-1631
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Tomer Shiran
> Assignee: Mehant Baid
>
> {code}
> 0: jdbc:drill:zk=local> SELECT stars FROM
> dfs.yelp.`yelp_academic_dataset_business.json` WHERE stars = 5 LIMIT 1;
> +------------+
> | stars |
> +------------+
> | 4.5 |
> +------------+
> 1 row selected (0.234 seconds)
> 0: jdbc:drill:zk=local>
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
