diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2024-11-19 18:26:19 -0500 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2024-11-19 18:26:19 -0500 |
| commit | f286f64bcf01106fc08ea1c14252ae2c26b7d189 (patch) | |
| tree | f67ea21a2213fabd76ace9c42a6ca17f680d518b /src/backend/utils/adt/ruleutils.c | |
| parent | 1f47e7b59b92c58eee6840325d1aaa6acee84194 (diff) | |
| download | postgresql-f286f64bcf01106fc08ea1c14252ae2c26b7d189.tar.gz postgresql-f286f64bcf01106fc08ea1c14252ae2c26b7d189.zip | |
Compare collations before merging UNION operations.
In the dim past we figured it was okay to ignore collations
when combining UNION set-operation nodes into a single N-way
UNION operation. I believe that was fine at the time, but
it stopped being fine when we added nondeterministic collations:
the semantics of distinct-ness are affected by those. v17 made
it even less fine by allowing per-child sorting operations to
be merged via MergeAppend, although I think we accidentally
avoided any live bug from that.
Add a check that collations match before deciding that two
UNION nodes are equivalent. I also failed to resist the
temptation to comment plan_union_children() a little better.
Back-patch to all supported branches (v13 now), since they
all have nondeterministic collations.
Discussion: https://postgr.es/m/3605568.1731970579@sss.pgh.pa.us
Diffstat (limited to 'src/backend/utils/adt/ruleutils.c')
0 files changed, 0 insertions, 0 deletions