drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Victoria Markman (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-2015) Casting numeric value that does not fit in integer data type produces incorrect result
Date Thu, 15 Jan 2015 19:47:36 GMT

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

Victoria Markman commented on DRILL-2015:
-----------------------------------------

The default should be to throw an exception and give customer an option to turn off checking
if performance is very critical.
It should be their "choice" if they want to get wrong results. In any case, if we decide not
to implement an option for GA, it should be clearly documented. 

> Casting numeric value that does not fit in integer data type produces incorrect result
> --------------------------------------------------------------------------------------
>
>                 Key: DRILL-2015
>                 URL: https://issues.apache.org/jira/browse/DRILL-2015
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Data Types
>    Affects Versions: 0.8.0
>            Reporter: Victoria Markman
>            Assignee: Daniel Barclay (Drill/MapR)
>            Priority: Critical
>
> t1.json
> {code}
> { "a1": 1 ,    "b1" : 1}
> { "a1": 2 ,    "b1" : 1}
> { "a1": 2 ,    "b1" : 2}
> { "a1": 3 ,    "b1" : 2}
> { "a1": 5000147483647 , "b1" : 3}
> {code}
> We should throw an error, this is technically data corruption.
> {code}
> 0: jdbc:drill:schema=dfs> select cast(a1 as integer) from `t1.json`;
> +------------+
> |   EXPR$0   |
> +------------+
> | 1          |
> | 2          |
> | 2          |
> | 3          |
> | 805551103  |
> +------------+
> 5 rows selected (0.074 seconds)
> {code}
> {code}
> 0: jdbc:drill:schema=dfs> select cast(2147483648 as integer) from `t1.json`;
> +------------+
> |   EXPR$0   |
> +------------+
> | -2147483648 |
> | -2147483648 |
> | -2147483648 |
> | -2147483648 |
> | -2147483648 |
> +------------+
> 5 rows selected (0.076 seconds)
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message