pgsql: Fix bugs in polymorphic-argument resolution for multiranges.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix bugs in polymorphic-argument resolution for multiranges.
Date: 2021-07-27 19:02:01
Message-ID: E1m8SL3-0005WO-OV@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix bugs in polymorphic-argument resolution for multiranges.

We failed to deal with an UNKNOWN-type input for
anycompatiblemultirange; that should throw an error indicating
that we don't know how to resolve the multirange type.

We also failed to infer the type of an anycompatiblerange output
from an anycompatiblemultirange input or vice versa.

Per bug #17066 from Alexander Lakhin. Back-patch to v14
where multiranges were added.

Discussion: https://postgr.es/m/17066-16a37f6223a8470b@postgresql.org

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/336ea6e6ff1109e7b83370565e3cb211804fda0c

Modified Files
--------------
src/backend/parser/parse_coerce.c | 316 ++++++++++++++++-------------
src/test/regress/expected/polymorphism.out | 68 ++++++-
src/test/regress/expected/rangefuncs.out | 2 +-
src/test/regress/sql/polymorphism.sql | 48 +++++
4 files changed, 293 insertions(+), 141 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Alvaro Herrera 2021-07-27 19:51:55 pgsql: Set pg_setting.pending_restart when pertinent config lines are r
Previous Message Andrew Dunstan 2021-07-27 18:24:12 Re: pgsql: Re-enable TAP tests of pg_receivewal for ZLIB on Windows