Sergey Soldatov created PHOENIX-2878:
----------------------------------------
Summary: 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
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)
