[
https://issues.apache.org/jira/browse/PHOENIX-2878?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergey Soldatov reassigned PHOENIX-2878:
----------------------------------------
Assignee: Sergey Soldatov
> 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
>
> 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)
