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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.7.0
• Fix Version/s: 4.8.0
• Assignee: Sergey Soldatov
• Reporter: Sergey Soldatov
• Created: 04/May/16 19:58
• Updated: 11/Aug/16 08:29
• Resolved: 05/May/16 15:51

Description

When the query is using projected table, the CURRENT_TIME() function may return zero or outdated value. Simple test case:

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);

The result:

+--------+---------------------------------+
| OP.ID  | TIME '1970-01-01 00:00:00.000'  |
+--------+---------------------------------+
| 1      | 1970-01-01 00:00:00.000         |
+--------+---------------------------------+