Chun Chang created DRILL-591:
--------------------------------
Summary: explicit cast fail to convert 0.00000001 to int
Key: DRILL-591
URL: https://issues.apache.org/jira/browse/DRILL-591
Project: Apache Drill
Issue Type: Bug
Reporter: Chun Chang
The following number can be converted to int 0 on postgres:
foodmart=# select c_decimal9 from data where c_row =6;
c_decimal9
------------
0.00000001
(1 row)
foodmart=# select cast(c_decimal9 as int) from data where c_row = 6;
c_decimal9
------------
0
(1 row)
But with Drill, it fails:
0: jdbc:drill:schema=dfs> select cast(c_decimal9 as varchar(20)) from data
where c_row =6;
+------------+
| EXPR$0 |
+------------+
| 0.00000001 |
+------------+
1 row selected (0.117 seconds)
0: jdbc:drill:schema=dfs> select cast(c_decimal9 as int) from data where c_row
= 6;
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while
running query.[error_id: "ae039e8f-1c9a-435c-92fe-d4f0b7614cb8"
endpoint {
address: "qa-node118.qa.lab"
user_port: 31010
control_port: 31011
data_port: 31012
}
error_type: 0
message: "Failure while running fragment. < NumberFormatException:[ 0.00000001
]"
]
Error: exception while executing query (state=,code=0)
--
This message was sent by Atlassian JIRA
(v6.2#6252)
