diff options
Diffstat (limited to 'src/test/regress/sql/partition_prune.sql')
| -rw-r--r-- | src/test/regress/sql/partition_prune.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/src/test/regress/sql/partition_prune.sql b/src/test/regress/sql/partition_prune.sql index 825dedb5f07..61ef6e637e4 100644 --- a/src/test/regress/sql/partition_prune.sql +++ b/src/test/regress/sql/partition_prune.sql @@ -838,6 +838,13 @@ execute mt_q1(35); deallocate mt_q1; +prepare mt_q2 (int) as select * from ma_test where a >= $1 order by b limit 1; + +-- Ensure output list looks sane when the MergeAppend has no subplans. +explain (verbose, costs off) execute mt_q2 (35); + +deallocate mt_q2; + -- ensure initplan params properly prune partitions explain (analyze, costs off, summary off, timing off) select * from ma_test where a >= (select min(b) from ma_test_p2) order by b; |