Thread: pgsql: Use ORDER BY on matview definitions were needed for stable plans

pgsql: Use ORDER BY on matview definitions were needed for stable plans

From
Kevin Grittner
Date:
Use ORDER BY on matview definitions were needed for stable plans.

Per report from Hadi Moshayedi of matview regression test failure
with optimization of aggregates.  A few ORDER BY clauses improve
code coverage for matviews while solving that problem.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/241139ae4baf6264c3c2cd053a547833c6e49a59

Modified Files
--------------
src/test/regress/expected/matview.out |   35 ++++++++++++++++++--------------
src/test/regress/sql/matview.sql      |    8 +++---
2 files changed, 24 insertions(+), 19 deletions(-)