drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chun Chang (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-1016) decimal18 comparison with decimal38 fails on some values
Date Wed, 18 Jun 2014 19:20:24 GMT
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)

Mime
View raw message