From: Tom Lane <tgl@sss.pgh.pa.us>
To: Dmitry Dolgov <9erthalion6@gmail.com>
cc: "Poot, Bas (B.J.)" <bas.poot@politie.nl>,
        "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Subject: Re: XX000: unknown type of jsonb container.
In-reply-to: <20210531145131.b34sjhhgj7xkq36w@localhost>
References: <534fca83789c4a378c7de379e9067d4f@politie.nl>
 <20210407181105.lmi7hgifwzs3eeee@localhost>
 <20210413161500.kufk4iyrmcmhhbrc@localhost>
 <20210423151505.lxx5ti7ivcza3xqw@localhost>
 <2433209.1622416353@sss.pgh.pa.us> <2491424.1622422768@sss.pgh.pa.us>
 <20210531145131.b34sjhhgj7xkq36w@localhost>
Comments: In-reply-to Dmitry Dolgov <9erthalion6@gmail.com>
	message dated "Mon, 31 May 2021 16:51:31 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <2711243.1622477166.1@sss.pgh.pa.us>
Date: Mon, 31 May 2021 12:06:06 -0400
Message-ID: <2711244.1622477166@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/2711244.1622477166%40sss.pgh.pa.us>
Precedence: bulk

Dmitry Dolgov <9erthalion6@gmail.com> writes:
> On Sun, May 30, 2021 at 08:59:28PM -0400, Tom Lane wrote:
>> This test case only fails back to v13, as does the original example.
>> I suspect we should back-patch the code change further though,
>> since create_projection_plan will be just as confused by such cases
>> in earlier branches.

> That would be my assumption as well.

Done now.  I spent a little bit of time looking for a test case
that'd fail in the prior branches, without success.  I think
it's highly probable that there is one, but I didn't want to
spend any more time here.

			regards, tom lane