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

["Hudson (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/PHOENIX-1047?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14098283#comment-14098283 ] 

Hudson commented on PHOENIX-1047:
---------------------------------

FAILURE: Integrated in Phoenix | 4.0 | Hadoop2 #34 (See [https://builds.apache.org/job/Phoenix-4.0-hadoop2/34/])
PHOENIX-1047 Auto cast - add/sub decimal constant and integer (jtaylor: rev fcdcd697ccf13cd377980a186c32fb8b4121d1a1)
* phoenix-core/src/main/java/org/apache/phoenix/schema/PDataType.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/ArithmeticQueryIT.java
* phoenix-core/src/test/java/org/apache/phoenix/arithmetic/ArithmeticOperationTest.java


> 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
>            Assignee: James Taylor
>             Fix For: 5.0.0, 3.1, 4.1
>
>         Attachments: PHOENIX-1047.patch, 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)