pgsql: Clean up/tighten up coercibility checks in opr_sanityregression - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Clean up/tighten up coercibility checks in opr_sanityregression
Date
Msg-id E1gBizE-0001Y1-IN@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Clean up/tighten up coercibility checks in opr_sanity regression test.

With the removal of the old abstime type, there are no longer any cases
in this test where we need to use the weaker castcontext-ignoring form
of binary coercibility check.  (The other major source of such headaches,
apparently-incompatible hash functions, is now hashvalidate()'s problem
not this test script's problem.)  Hence, just use binary_coercible()
everywhere, and remove the comments explaining why we don't do so ---
which were broken anyway by cda6a8d01.

I left physically_coercible() in place but renamed it to better
match what it's actually testing, and added some comments.

Also, in test queries that have an assumption about the maximum number
of function arguments they need to handle, add a clause to make them fail
if someday there's a relevant function with more arguments.  Otherwise
we're likely not to notice that we need to extend the queries.

Discussion: https://postgr.es/m/27637.1539388060@sss.pgh.pa.us

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/e9f42d529f990f94e1b7bdcec4a1111465c85326

Modified Files
--------------
src/test/regress/expected/opr_sanity.out | 55 ++++++++++++++++++--------------
src/test/regress/sql/opr_sanity.sql      | 55 ++++++++++++++++++--------------
2 files changed, 62 insertions(+), 48 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pgsql: Add list of acknowledgments to release notes
Next
From: Tom Lane
Date:
Subject: pgsql: Use PlaceHolderVars within the quals of a FULL JOIN.