Hi Hackers,
Here is a fix for findings D3 & D4 & D10 from [0].
The issue is that we evaluate FOR PORTION OF bounds even under
EXPLAIN. This causes various problems, like failing on `EXPLAIN
(GENERIC PLAN)`, failing on `FOR PORTION OF (null)`, and calling
functions for the bounds (beyond selectivity estimation). To fix it,
we add a guard for EXEC_FLAG_EXPLAIN_ONLY.
[0] https://www.postgresql.org/message-id/CA%2BrenyV6QLOJYmLo3gbsg1Y%2BCrho8NqME1jJXgPbO_NgxfBaKQ%40mail.gmail.com
Yours,
--
Paul ~{:-)
pj@illuminatedcomputing.com