[jira] [Updated] (PHOENIX-2878) CURRENT_TIME fails to provide correct time when projected table is using

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

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

Sergey Soldatov updated PHOENIX-2878:
-------------------------------------
    Attachment: PHOENIX-2878-1.patch

an additional check for projected table is added to {{context.getCurrentTime}}

> CURRENT_TIME fails to provide correct time when projected table is using
> ------------------------------------------------------------------------
>
>                 Key: PHOENIX-2878
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2878
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.7.0
>            Reporter: Sergey Soldatov
>            Assignee: Sergey Soldatov
>         Attachments: PHOENIX-2878-1.patch
>
>
> When the query is using projected table, the CURRENT_TIME() function may return zero or outdated value. Simple test case:
> {noformat}
> CREATE TABLE T1 ( ID integer primary key);
> CREATE TABLE T2 ( ID integer primary key);
> UPSERT INTO T1 VALUES (1);
> UPSERT INTO T2 VALUES (1);
> select /*+ USE_SORT_MERGE_JOIN */ op.id, current_time() from t1 op where op.id in (select id from t2);
> {noformat}
> The result: 
> {noformat}
> +--------+---------------------------------+
> | OP.ID  | TIME '1970-01-01 00:00:00.000'  |
> +--------+---------------------------------+
> | 1      | 1970-01-01 00:00:00.000         |
> +--------+---------------------------------+
> {noformat}



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