Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1maO46-0005hc-01 for pgsql-bugs@arkaria.postgresql.org; Tue, 12 Oct 2021 20:07:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1maO44-0007UY-Ou for pgsql-bugs@arkaria.postgresql.org; Tue, 12 Oct 2021 20:07:56 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1maMyW-0005rM-Mp for pgsql-bugs@lists.postgresql.org; Tue, 12 Oct 2021 18:58:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1maMyR-0008Fa-Q0 for pgsql-bugs@lists.postgresql.org; Tue, 12 Oct 2021 18:58:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=Rh8MrDnA6foAAZGApbdzCAkKCxZBfSS4QHlwIH7lrj8=; b=lnL1G3lYFiHFIIOgZ0GJBDh7mk 4NEDoYYiog+GyZkR1KjEvoiaw/PMk40tPXpaCFE2N8zHa6X5tw4egVuiLdsZz8hy9WUOQ7bZZW6fP FpFHxx88tBF37X05ylu6kNW/ljP5uCbbmdI8vF99WitSSJPYVBnjVHQ1vXr1SOBNDXDe3LVGCId8/ 7xlEvyiaBkpBvg7vAYQVJlRyWdBUXLlPL4K5s7wp0nO3t4/fp2psCKAMJms9Gg/4oAkt0ZsZ5b1nM EqxULjgKGhAIRftohSSKFC9hLVJau8mNASNbkstYeddIAPv3I0c+ZfJOgw96oG+DWNjRMfF+FhKwb Q2m7KMbw==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1maMyR-0005FQ-0U for pgsql-bugs@lists.postgresql.org; Tue, 12 Oct 2021 18:58:03 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1maMyP-0004zW-Ra for pgsql-bugs@lists.postgresql.org; Tue, 12 Oct 2021 18:58:01 +0000 Content-Type: multipart/mixed; boundary="===============5706054015546584765==" MIME-Version: 1.0 Subject: BUG #17225: Query with CTE failed after upgrade Postgres from 11 to 12/13 To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: karllos88@gmail.com Reply-To: karllos88@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 12 Oct 2021 18:57:21 +0000 Message-ID: <17225-15393593a2d11003@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5706054015546584765== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzIyNQpMb2dnZWQgYnk6ICAgICAgICAgIEthcm9sIEsKRW1haWwgYWRk cmVzczogICAgICBrYXJsbG9zODhAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTIuMApP cGVyYXRpbmcgc3lzdGVtOiAgIERlYmlhbiAxMS4xCkRlc2NyaXB0aW9uOiAgICAgICAgCgpBZnRl ciB1cGdyYWRpbmcgUG9zdGdyZXMgSSBoYXZlIGEgd2VpcmQgZXJyb3Igd2l0aCBTRUxFQ1QgcXVl cnkuDQoNCkVSUk9SOiBpbnZhbGlkIGlucHV0IHN5bnRheCBmb3IgdHlwZSBpbnRlZ2VyOiAiMzYt MDA0Ig0KDQpRdWVyeSB3b3JrcyBvbiBwcmV2aW91cyBEQiB2ZXJzaW9uIGFuZCBub3cgZG9lc24n dC4gUXVlcnkgdXNlIGEgbG90IG9mIENURQooVG8gYmUgbW9yZSBzcGVjaWZpYyAtIDgpIGFuZCBs b29rcyBsaWtlOg0KDQpXSVRIIC4uLigpLA0KbGFzdF9pbnNwZWN0aW9uX2luZm8gQVMgKA0KICAg IFNFTEVDVCANCiAgICAgICAgc29ydF9jb2x1bW4gfHwgJzxzcGFuIHN0eWxlPSInIHx8IGNvbG9y IHx8ICciICcgfHwgb25fY2xpY2sgfHwgJz4nCnx8IHRhc2tfaWNvbiB8fCAnKCcgfHwgZGF5c190 b19uZXh0X2luc3BlY3Rpb24gfHwgJykgJyB8fCBsaS5zdGFydF86OmRhdGUgfHwKJzwvc3Bhbj4n IEFTIGxhc3RfaW5zcGVjdGlvbl9pbmZvLA0KICAgICAgICBkZXZjaWQsIGxpLmV2bnRpZA0KICAg IEZST00gbGFzdF9pbnNwZWN0aW9uIEFTIGxpIA0KICAgIElOTkVSIEpPSU4gbmV4dF9pbnNwZWN0 aW9uIEFTIG5pIFVTSU5HIChkZXZjaWQpLCBpY29uDQopDQpTRUxFQ1QgKiBGUk9NIGRldmljZXMg QVMgZA0KTEVGVCBKT0lOIGxhc3RfaW5zcGVjdGlvbl9pbmZvIEFTIGxpaQ0KVVNJTkcgKGRldmNp ZCkNCg0KDQoNCkluZm86IGRldmljZXMgaXMgYSBUYWJsZSwgdGhlIHJlc3QgKGxhc3RfaW5zcGVj dGlvbiwgbmV4dF9pbnNwZWN0aW9uLApsYXN0X2luc3BlY3Rpb25faW5mbywgaWNvbikgYXJlIENU RSB3aGljaCB1c2Ugb3RoZXIgQ1RFIG9mIHRoZSByZW1haW5pbmcKOC4NCg0KV2hhdCdzIGludGVy ZXN0aW5nIGlmIHRoZSBsYXN0IG9uZSBDVEUgKGxhc3RfaW5zcGVjdGlvbl9pbmZvKSB3aWxsIGJl CnJlcGxhY2VkIHdpdGggRlJPTSwgcXVlcnkgcnVuczoNCg0KV0lUSCAuLi4gKCkNClNFTEVDVCAq IEZST00gZGV2aWNlcyBBUyBkIA0KTEVGVCBKT0lOICgNCiAgICBTRUxFQ1QgDQogICAgICAgIHNv cnRfY29sdW1uIHx8ICc8c3BhbiBzdHlsZT0iJyB8fCBjb2xvciB8fCAnIiAnIHx8IG9uX2NsaWNr IHx8ICc+Jwp8fCB0YXNrX2ljb24gfHwgJygnIHx8IGRheXNfdG9fbmV4dF9pbnNwZWN0aW9uIHx8 ICcpICcgfHwgbGkuc3RhcnRfOjpkYXRlIHx8Cic8L3NwYW4+JyBBUyBsYXN0X2luc3BlY3Rpb25f aW5mbywNCiAgICAgICAgZGV2Y2lkLCBsaS5ldm50aWQNCiAgICBGUk9NIGxhc3RfaW5zcGVjdGlv biBBUyBsaSANCiAgICBJTk5FUiBKT0lOIG5leHRfaW5zcGVjdGlvbiBBUyBuaSBVU0lORyAoZGV2 Y2lkKSwgaWNvbg0KKSBBUyBsaWkNClVTSU5HIChkZXZjaWQpDQoNCkkgZG9uJ3QgYXNzdW1lIHRo YXQgdGhlIHF1ZXJ5IGlzIGluY29ycmVjdCwgcHJlY2lzZWx5IGJlY2F1c2Ugb2YgdGhpcy4gVHdv Ogp0aGF0IHRoZSBtZXNzYWdlIHBvaW50cyB0byBkYXRhIHRoYXQgaXMgbm90IGV2ZW4gdXNlZCBp biB0aGUgQ1RFCidsYXN0X2luc3BlY3Rpb25faW5mbycsIGJlY2F1c2UgaWYgSSB0cnkgU0VMRUNU ICogRlJPTSBsYXN0X2luc3BlY3Rpb25faW5mbwpJIGdldCBvbmUgcmVjb3JkLCBhbmQgbm9uZSBv ZiB0aGUgY29sdW1ucyBjb250YWlucyAiMzYtMDA0IiBhbHNvIHRoZXJlIGlzIG5vCnN1Y2ggZGF0 YSBpbiBkZXZpY2VzLiBJbiBmYWN0IHRoYXQgZGF0YSBpcyBpbiBmaXJzdCBDVEUgd2hpY2ggdXNl IHRhYmxlCndoZXJlIHRoZSBkYXRhIGlzIGluLCBidXQgdGhlcmUgaXMgbm8gY2FzdGluZyBhbmQg dGhlIGRhdGEgaXMgaW4gdGV4dCBjb2x1bW4KYW5kIGlzIGZpbHRlcmVkIGluIHN1Y2ggYSB3YXkg dGhhdCBpdCBpcyBubyBsb25nZXIgcHJlc2VudCBpbiB0aGUgQ1RFLg0KDQpUaGVyZSB3YXMgdHdv IHdheXMgb2YgcG9zdGdyZXMgdXBncmFkZToNCg0KICAgIDEuIHBnX3VwZ3JhZGVjbHVzdGVyDQog ICAgMi4gSW5zdGFsYXRpb24gUG9zdGdyZXMgMTMsIHJ1biBwb3N0Z3Jlc3FsMTMgc2VydmljZSwg YW5kIHBnX2R1bXAgZnJvbQoxMSBhbmQgcmVzdG9yZSBvbiAxMy4NCg0KSW4gYm90aCB3YXlzIHRo ZXJlIHdhcyBldmVyeXRoaW5nIGZpbmUgYnV0IHF1ZXJ5IHJ1bnMgd2l0aCB0aGUgYWJvdmUgZXJy b3IuCgo= --===============5706054015546584765==--