Use ORDER BY on matview definitions were needed for stable plans.
Kevin Grittner <kgrittn@postgresql.org>
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.
Files
| Path | Change | +/− |
|---|---|---|
| src/test/regress/expected/matview.out | modified | +20 −15 |
| src/test/regress/sql/matview.sql | modified | +4 −4 |