diff options
author | Tomas Vondra | 2017-10-08 17:22:36 +0000 |
---|---|---|
committer | Tomas Vondra | 2017-10-08 17:22:36 +0000 |
commit | a3aba68733f07477f77c15aa890d06b558863703 (patch) | |
tree | 6a851d71f2b4d930b84d343ef6acd68bf7c24e35 /src/test | |
parent | a4f830d8fe58d891f76e5335ba1048602be8826b (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.out | 26 |
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 |