You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "Vaclav Loffelmann (JIRA)" <ji...@apache.org> on 2014/06/21 16:27:24 UTC

[jira] [Created] (PHOENIX-1047) Auto cast - add/sub decimal constant and integer

Vaclav Loffelmann created PHOENIX-1047:
------------------------------------------

             Summary: Auto cast - add/sub decimal constant and integer
                 Key: PHOENIX-1047
                 URL: https://issues.apache.org/jira/browse/PHOENIX-1047
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 5.0.0, 3.1, 4.1
            Reporter: Vaclav Loffelmann


Automatic casting to decimal doesn't works in arithmetic expression (add or subtract decimal constant). For example query like this (col1 and col2 are integers):
bq. SELECT col1 / (col2 + 0.5) FROM test_table
Returns integer with truncated decimal part.

In older versions of phoenix this worked fine.



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