EXPLAIN ... FOR PORTION OF should not evaluate bounds - Mailing list pgsql-hackers

From Paul A Jungwirth
Subject EXPLAIN ... FOR PORTION OF should not evaluate bounds
Date
Msg-id CA+renyXci9khYXJ8uSwzF30DVw+zc4QwGb1RdsuOu_YtrFuy1g@mail.gmail.com
Whole thread
List pgsql-hackers
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

Attachment

pgsql-hackers by date:

Previous
From: Henson Choi
Date:
Subject: Re: Row pattern recognition
Next
From: Paul A Jungwirth
Date:
Subject: FOR PORTION OF elog on non-polymorphic opcintype