IMPALA-9272: Fix PlannerTest.testHdfs depending on year(now())
FE test PlannerTest.testHdfs depends on the result of year(now()) to be
2019, which is wrong after we enter 2020. Replace it with another
expression not depending on now().
Change-Id: I7b3df560d69e40d3f2332ff242362bd36bbf6b64
Reviewed-on: http://gerrit.cloudera.org:8080/14965
Reviewed-by: Gabor Kaszab <gaborkaszab@cloudera.com>
Tested-by: Impala Public Jenkins <impala-public-jenkins@cloudera.com>
diff --git a/testdata/workloads/functional-planner/queries/PlannerTest/hdfs.test b/testdata/workloads/functional-planner/queries/PlannerTest/hdfs.test
index 5e7f685..a3d92f2 100644
--- a/testdata/workloads/functional-planner/queries/PlannerTest/hdfs.test
+++ b/testdata/workloads/functional-planner/queries/PlannerTest/hdfs.test
@@ -1189,7 +1189,7 @@
====
# Partition pruning when a binary predicate contains a constant expression (IMPALA-1636)
select * from functional.alltypesagg t1
-where t1.day = instr("this is a test", "this") or t1.year = year(now()) + 100
+where t1.day = instr("this is a test", "this") or t1.year = cast(pi() as int) + 2116
---- PLAN
PLAN-ROOT SINK
|
@@ -1201,7 +1201,7 @@
# Partition pruning when there is a constant expression in the IN predicate values
# (IMPALA-1636)
select * from functional.alltypesagg t1
-where t1.day in (1, cast(2.0 as INT), year(now()) + 100)
+where t1.day in (1, cast(2.0 as INT), cast(pi() as int) + 2116)
---- PLAN
PLAN-ROOT SINK
|
