Re: pgsql/src/test/regress/expected (opr_sanity.out) - Mailing list pgsql-committers

From Thomas Lockhart
Subject Re: pgsql/src/test/regress/expected (opr_sanity.out)
Date
Msg-id 39819C31.A11633D@alumni.caltech.edu
Whole thread Raw
In response to pgsql/src/test/regress/expected (opr_sanity.out)  (Tom Lane <tgl>)
Responses Re: pgsql/src/test/regress/expected (opr_sanity.out)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-committers
> Add int2-vs-int8 comparison operators.  These are now necessary because
> the planner may try to generate them as a result of transitivity of the
> existing int2-vs-int4 and int4-vs-int8 operators.  In fact, it is now
> necessary that mergejoinable cross-datatype operators form closed sets.
> Add an opr_sanity regress test to detect missing operators.

I'm suprised that this required adding only one extra set of operators!
In general, would it be possible to allow the planner to reformulate the
plan using nested conversions *if* the required operator is not
available?

                     - Thomas

pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql/src/test/regress/sql (opr_sanity.sql)
Next
From: Thomas Lockhart
Date:
Subject: pgsql/src/backend/parser (gram.y)