Fix a few mistakes in partition aggregate tests The pattern seems to be to EXPLAIN the query to ensure we get the expected partition-wise aggregate plan, then run the same query to check the results are what we expect. A couple of places didn't use the same query between the EXPLAIN and the checking of the results, which effectively voided the plan check.
Additionally, a comment claimed array_agg() didn't support partial mode, but that was made not true in 16fd03e95. Author: Matthias van de Meent <[email protected]> Reviewed-by: Pierre Forstmann <[email protected]> Reviewed-by: David Rowley <[email protected]> Discussion: https://postgr.es/m/caeze2wgjjuiqv-vzvrwqyz+etltd4okk2gbvbwxf1fo0is5...@mail.gmail.com Backpatch-through: 14 Branch ------ REL_18_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/e9fa8382df2d64ea3f8292cf3a39a9f7a308572d Modified Files -------------- src/test/regress/expected/partition_aggregate.out | 14 ++++++++------ src/test/regress/sql/partition_aggregate.sql | 8 ++++---- 2 files changed, 12 insertions(+), 10 deletions(-)
