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

Hudson commented on PHOENIX-2475:
---------------------------------

SUCCESS: Integrated in Phoenix-master #1036 (See 
[https://builds.apache.org/job/Phoenix-master/1036/])
PHOENIX-2475 Date arithmetic broken for time and timestamp (Ram) (ramkrishna: 
rev a7fb222555be601b0f3e2bd10a4185c487e1e32d)
* 
phoenix-core/src/it/java/org/apache/phoenix/end2end/ClientTimeArithmeticQueryIT.java
* 
phoenix-core/src/main/java/org/apache/phoenix/expression/TimestampAddExpression.java
* 
phoenix-core/src/main/java/org/apache/phoenix/expression/TimestampSubtractExpression.java
* 
phoenix-core/src/main/java/org/apache/phoenix/expression/DateAddExpression.java
* 
phoenix-core/src/main/java/org/apache/phoenix/expression/DateSubtractExpression.java


> Date arithmetic broken for time and timestamp
> ---------------------------------------------
>
>                 Key: PHOENIX-2475
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2475
>             Project: Phoenix
>          Issue Type: New Feature
>    Affects Versions: 4.6.0
>            Reporter: Kevin Liew
>            Assignee: ramkrishna.s.vasudevan
>            Priority: Minor
>              Labels: date, newbie, phoenix, timestamp
>             Fix For: 4.7.0
>
>         Attachments: PHOENIX-2475_1_master.patch, 
> PHOENIX-2475_2_master.patch, PHOENIX-2475_3_master.patch, 
> PHOENIX-2475_master.patch
>
>
> Create a timestamp table and insert a timestamp
> {noformat}create table timestamp_table (ts timestamp primary key)upsert into 
> timestamp_table values ('1995-05-02 01:01:01'){noformat}
> Example test case
> {noformat}select ts + 1 from timestamp_table{noformat}
> Expected result:
> The timestamp with one day added to it
> {noformat}1995-05-03 01:01:01{noformat}
> Actual result:
> the unmodified timestamp



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to