From a3aba68733f07477f77c15aa890d06b558863703 Mon Sep 17 00:00:00 2001 From: Tomas Vondra Date: Sun, 8 Oct 2017 19:22:36 +0200 Subject: [PATCH] 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. --- src/test/regress/expected/inherit.out | 26 +++++++++++++++----------- 1 file 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 -- 2.30.2