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-1018) small decimal(38,18) numbers compared equal to zero
Date Wed, 18 Jun 2014 21:32:24 GMT
Chun Chang created DRILL-1018:
---------------------------------

             Summary: small decimal(38,18) numbers compared equal to zero
                 Key: DRILL-1018
                 URL: https://issues.apache.org/jira/browse/DRILL-1018
             Project: Apache Drill
          Issue Type: Bug
          Components: Functions - Drill
            Reporter: Chun Chang
            Assignee: Mehant Baid


small decimal(38,18) numbers such as 0.000000010000000000 or -0.000000000000000010 are all
compared to equal to zero.

Postgres:
foodmart=# select c_row, cast(c_decimal38 as decimal(38,18)), mod(c_bigint, cast(c_decimal38
as decimal(38,18))) from data where c_row < 15 and cast(c_decimal38 as decimal(38,18))
<> 0;
 c_row |              c_decimal38               |                  mod
-------+----------------------------------------+----------------------------------------
     2 |                   1.000000000000000000 |                   0.000000000000000000
     3 |           123456789.000000000000000000 |                  -1.000000000000000000
     4 |           999999999.000000000000000000 |                  12.000000000000000000
     5 |          -999999999.000000000000000000 |                 123.000000000000000000
     6 |                   0.000000010000000000 |                   0.000000000000000000
     7 |                  -0.000000010000000000 |                   0.000000000000000000
     8 |               12345.678900000000000000 |               12243.822600000000000000
     9 |           123456789.123456789000000000 |           -36999908.918111010000000000
    10 |  999999999999999999.000000000000000000 |     920320399049584.000000000000000000
    11 | -999999999999999999.000000000000000000 | -922337203685477580.000000000000000000
    12 |                   0.000000000000000010 |                   0.000000000000000000
    13 |                  -0.000000000000000010 |                   0.000000000000000000
    14 |      12345678901234.123456789012340000 |          2147483647.000000000000000000
(13 rows)

Drill:
0: jdbc:drill:schema=dfs> select c_row, cast(c_decimal38 as decimal(38,18)), mod(c_bigint,
cast(c_decimal38 as decimal(38,18))) from data where c_row < 15 and cast(c_decimal38 as
decimal(38,18)) <> 0;
+------------+------------+------------+
|   c_row    |   EXPR$1   |   EXPR$2   |
+------------+------------+------------+
| 2          | 1.000000000000000000 | 0E-18      |
| 3          | 123456789.000000000000000000 | 1.000000000000000000 |
| 4          | 999999999.000000000000000000 | 12.000000000000000000 |
| 5          | -999999999.000000000000000000 | 123.000000000000000000 |
| 8          | 12345.678900000000000000 | 12243.822600000000000000 |
| 9          | 123456789.123456789000000000 | 36999908.918111010000000000 |
| 10         | 999999999999999999.000000000000000000 | 920320399049584.000000000000000000
|
| 11         | -999999999999999999.000000000000000000 | 922337203685477580.000000000000000000
|
| 14         | 12345678901234.123456789012340000 | 2147483647.000000000000000000 |
+------------+------------+------------+
9 rows selected (0.38 seconds)

Notice c_row 6, 7, 12 and 13 are missing for Drill due to the comparison error.



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message