Chun Chang created DRILL-1017:
---------------------------------
Summary: Comparison (<>) between decimal38 and decimal18 fails on
some value
Key: DRILL-1017
URL: https://issues.apache.org/jira/browse/DRILL-1017
Project: Apache Drill
Issue Type: Bug
Components: Functions - Drill
Reporter: Chun Chang
Assignee: Mehant Baid
The not equal comparison between decimal38 and decimal18 failed on the value:
12345.678900000. Same value was not compared as equal.
0: jdbc:drill:schema=dfs> select c_row, cast(c_decimal38 as decimal(38,9)) as
decimal38, cast(c_decimal18 as decimal(18,9)) as decimal18 from data where
c_row < 10 and cast(c_decimal38 as decimal(38,9)) <> cast(c_decimal18 as
decimal(18,9));
+------------+------------+------------+
| c_row | decimal38 | decimal18 |
+------------+------------+------------+
| 8 | 12345.678900000 | 12345.678900000 |
+------------+------------+------------+
--
This message was sent by Atlassian JIRA
(v6.2#6252)
