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:31:25 UTC

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

     [ https://issues.apache.org/jira/browse/PHOENIX-1047?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Vaclav Loffelmann updated PHOENIX-1047:
---------------------------------------

    Attachment: PHOENIX-1047.patch

Add integration test for bug reproduction.

> 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
>         Attachments: PHOENIX-1047.patch
>
>
> 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)