Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
Description
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 |
--------------------------------