summaryrefslogtreecommitdiff
path: root/src/test
diff options
context:
space:
mode:
authorTomas Vondra2017-10-08 17:22:36 +0000
committerTomas Vondra2017-10-08 17:22:36 +0000
commita3aba68733f07477f77c15aa890d06b558863703 (patch)
tree6a851d71f2b4d930b84d343ef6acd68bf7c24e35 /src/test
parenta4f830d8fe58d891f76e5335ba1048602be8826b (diff)
Accept plan change in 'inherit' test suite
The plan change is expected, as it simply expands -> Limit to -> Limit -> Remote Subquery Scan -> Limit It wasn't accepted before probably because it was hidden by other failures in the test suite.
Diffstat (limited to 'src/test')
-rw-r--r--src/test/regress/expected/inherit.out26
1 files changed, 15 insertions, 11 deletions
diff --git a/src/test/regress/expected/inherit.out b/src/test/regress/expected/inherit.out
index c8d20aeb83..0f77b4378f 100644
--- a/src/test/regress/expected/inherit.out
+++ b/src/test/regress/expected/inherit.out
@@ -2245,22 +2245,26 @@ create table parted_minmax1 partition of parted_minmax for values from (1) to (1
create index parted_minmax1i on parted_minmax1 (a, b);
insert into parted_minmax values (1,'12345');
explain (costs off) select min(a), max(a) from parted_minmax where b = '12345';
- QUERY PLAN
--------------------------------------------------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------------------------------------------------------
Result
InitPlan 1 (returns $0)
-> Limit
- -> Merge Append
- Sort Key: parted_minmax1.a
- -> Index Only Scan using parted_minmax1i on parted_minmax1
- Index Cond: ((a IS NOT NULL) AND (b = '12345'::text))
+ -> Remote Subquery Scan on all (datanode_1,datanode_2)
+ -> Limit
+ -> Merge Append
+ Sort Key: parted_minmax1.a
+ -> Index Only Scan using parted_minmax1i on parted_minmax1
+ Index Cond: ((a IS NOT NULL) AND (b = '12345'::text))
InitPlan 2 (returns $1)
-> Limit
- -> Merge Append
- Sort Key: parted_minmax1_1.a DESC
- -> Index Only Scan Backward using parted_minmax1i on parted_minmax1 parted_minmax1_1
- Index Cond: ((a IS NOT NULL) AND (b = '12345'::text))
-(13 rows)
+ -> Remote Subquery Scan on all (datanode_1,datanode_2)
+ -> Limit
+ -> Merge Append
+ Sort Key: parted_minmax1_1.a DESC
+ -> Index Only Scan Backward using parted_minmax1i on parted_minmax1 parted_minmax1_1
+ Index Cond: ((a IS NOT NULL) AND (b = '12345'::text))
+(17 rows)
select min(a), max(a) from parted_minmax where b = '12345';
min | max