Re: Wrong results from function that selects from vier after "created or replace" - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: Wrong results from function that selects from vier after "created or replace"
Date
Msg-id CAKFQuwYmMpnE_ay+OP9Z2x-2+WhM9y53N6JfbFRyZDOZiViWsg@mail.gmail.com
Whole thread Raw
In response to Wrong results from function that selects from vier after "created or replace"  (Bryn Llewellyn <bryn@yugabyte.com>)
Responses Re: Wrong results from function that selects from vier after "created or replace"  (Bryn Llewellyn <bryn@yugabyte.com>)
List pgsql-bugs
On Mon, Oct 12, 2020 at 5:01 PM Bryn Llewellyn <bryn@yugabyte.com> wrote:
WRONG RESULTS FROM FUNCTION THAT SELECTS FROM VIER AFTER "CREATED OR REPLACE"

The attached self-contained testcase, "pg-bad-invalidation-bug.sql", seems to me definitely to demonstrate a bug. I've attached the spooled output as "pg-bad-invalidation-bug.txt" Do you agree that this is a bug?

Haven't experimented myself but the function declarations are themselves wrong - they are not immutable.

      Please use the information here to file it.
      What's the number of, and URL to, the newly-filed bug?

You've just filed a bug report.  Since you did so directly instead of using the form it doesn't get assigned a bug number.  All email sent to this list, or bugs filed using the form, get publicly posted to the mailing list and are archived as described on the mailing list related web pages.  This is the permanent link for this thread in the archive:


David J.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Wrong results from function that selects from vier after "created or replace"
Next
From: Bryn Llewellyn
Date:
Subject: Re: Wrong results from function that selects from vier after "created or replace"