Chun Chang created DRILL-1016:
---------------------------------
Summary: decimal18 comparison with decimal38 fails on some values
Key: DRILL-1016
URL: https://issues.apache.org/jira/browse/DRILL-1016
Project: Apache Drill
Issue Type: Bug
Components: Functions - Drill
Reporter: Chun Chang
Assignee: Mehant Baid
Comparison (<) between decimal18 and decimal38 fails for the following values:
0: jdbc:drill:schema=dfs> select c_row, cast(c_decimal18 as decimal(18,9)),
cast(c_decimal38 as decimal(38,9)) from data where c_row < 10 and
cast(c_decimal18 as decimal(18,9)) < cast(c_decimal38 as decimal(38,9));
+------------+------------+------------+
| c_row | EXPR$1 | EXPR$2 |
+------------+------------+------------+
| 5 | -999999999.000000000 | -999999999.000000000 |
| 7 | -1.0E-8 | -1.0E-8 |
+------------+------------+------------+
This two values are identical, not less than one another.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
