summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPavan Deolasee2017-06-28 09:14:20 +0000
committerPavan Deolasee2017-06-28 09:14:20 +0000
commit83ce29b63697945addbfda89ce970629d7bde25d (patch)
treeaced4e43dc7e0d3fa605bddb01b53f7f7bcff32a
parent78c7f94bd6bbebb2d4e5e6f91fc2de13f5c973c4 (diff)
Accept regression diff in timestamptz test case
The change is simply an addition of a Remote FQS node on top the SeqScan.
-rw-r--r--src/test/regress/expected/timestamptz.out12
1 files changed, 7 insertions, 5 deletions
diff --git a/src/test/regress/expected/timestamptz.out b/src/test/regress/expected/timestamptz.out
index 5b21f848fd..9afbcbd4d7 100644
--- a/src/test/regress/expected/timestamptz.out
+++ b/src/test/regress/expected/timestamptz.out
@@ -2500,11 +2500,13 @@ create temp table tmptz (f1 timestamptz primary key);
insert into tmptz values ('2017-01-18 00:00+00');
explain (costs off)
select * from tmptz where f1 at time zone 'utc' = '2017-01-18 00:00';
- QUERY PLAN
--------------------------------------------------------------------------------------------------
- Seq Scan on tmptz
- Filter: (timezone('utc'::text, f1) = 'Wed Jan 18 00:00:00 2017'::timestamp without time zone)
-(2 rows)
+ QUERY PLAN
+-------------------------------------------------------------------------------------------------------
+ Remote Fast Query Execution
+ Node/s: datanode_1, datanode_2
+ -> Seq Scan on tmptz
+ Filter: (timezone('utc'::text, f1) = 'Wed Jan 18 00:00:00 2017'::timestamp without time zone)
+(4 rows)
select * from tmptz where f1 at time zone 'utc' = '2017-01-18 00:00';
f1