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 1lZqOJ-0003KH-Pj for pgsql-bugs@arkaria.postgresql.org; Fri, 23 Apr 2021 07:38:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lZqOI-00086v-L6 for pgsql-bugs@arkaria.postgresql.org; Fri, 23 Apr 2021 07:38:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lZjSU-0000AC-7m for pgsql-bugs@lists.postgresql.org; Fri, 23 Apr 2021 00:14:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lZjSP-0007Sm-K5 for pgsql-bugs@lists.postgresql.org; Fri, 23 Apr 2021 00:14:09 +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=y94lfngTb0w2GRTloVj3CoL6CzsAHBQUNtf90c1zsYE=; b=30yPJ2ctJ+ezJA+7uYv6LCXt8a jmTwT5MVB6TeIluYvkTvQ2pOp03UrtLJm/HQUz3ja8d/qfkRtc2v6pWG1a4nQ1R9E5uTxqrUlCC86 i/hQsdfAja8qfaNTBoaT1vJUSOP16QcYcLOEwwuiJMYb4NAVflB5m21XzDKvYbpaUZys7K0zYWs4k BLDCi9geBv9SEsFp++H2+eXQPDnVY2D/QMCSawSER0d10ly4VG/o/i0FpCJ1mJ75L0XmwWxwU/Nmw iNLfp1ndR3pmviO9BI9aMsf3k5xUWATnsDSzWrCcj6Q0USQ5rEovIPWJ4/UQTdnVopz+LqGKD0bI9 nJMxfzMA==; 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 1lZjSO-0004nP-A5 for pgsql-bugs@lists.postgresql.org; Fri, 23 Apr 2021 00:14:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lZjSM-0001UW-Jt for pgsql-bugs@lists.postgresql.org; Fri, 23 Apr 2021 00:14:02 +0000 Content-Type: multipart/mixed; boundary="===============0021488935602150317==" MIME-Version: 1.0 Subject: BUG #16978: Nested CTEs give ERROR in v13 To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: tharakan@gmail.com Reply-To: tharakan@gmail.com, pgsql-bugs@lists.postgresql.org Date: Fri, 23 Apr 2021 00:13:41 +0000 Message-ID: <16978-813ac0832f35db82@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 --===============0021488935602150317== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjk3OApMb2dnZWQgYnk6ICAgICAgICAgIFJvYmlucyBUaGFyYWthbgpF bWFpbCBhZGRyZXNzOiAgICAgIHRoYXJha2FuQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246 IDEzLjIKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUKRGVzY3JpcHRpb246ICAgICAgICAKClRo aXMgbmFycm93ZWQgZG93biBTUUwgKGZyb20gd2hhdCBTUUxTbWl0aCBnZW5lcmF0ZWQpIHNlZW1z IHRvIGVycm9yIG91dApvbmx5IHdpdGggTiBsZXZlbHMgb2YgQ1RFIG5lc3RpbmcgLSBubyB0YWJs ZXMgLyB2aWV3cyAvIDEtcm93IG91dHB1dC4gDQoNClRoZSBTUUwgd29ya3MgZmluZSB3aXRoIHYx Mi40IGJ1dCByYWlzZXMgYW4gRVJST1IgaW4gdjEzIHdoaWNoIHNlZW1zIGxpa2UgYQpyZWdyZXNz aW9uLiBJcyB0aGlzIG93aW5nIGEgcmVjZW50IGNoYW5nZSBpbiB2MTMgLSB0aGF0IGNvdWxkIGFm ZmVjdCB0aGlzPw0KDQooVGhpcyB3YXMgZm91bmQgZHVyaW5nIGEgbGFyZ2VyIGludmVzdGlnYXRp b24gYXJvdW5kIGEgdjEzIFNlZ0ZhdWx0IGJ1dCB0aGlzCmRvZXMgc2VlbSB3b3J0aHkgb2YgaXRz IG93biBidWctcmVwb3J0KS4NCg0K4oaSIHBzcWwgLWggbG9jYWxob3N0DQpwc3FsICgxNGRldmVs LCBzZXJ2ZXIgMTMuMikNClR5cGUgImhlbHAiIGZvciBoZWxwLg0KDQpwb3N0Z3Jlcz0jIC0tSGF2 aW5nIHdfZXJyIGluIHRoZSBTUUwgZ2l2ZXMgYW4gZXJyb3IgYWJvdXQgVU5JT04gQUxMDQpwb3N0 Z3Jlcz0jIFdJVEggUkVDVVJTSVZFIHc2KGM2KSBBUw0KcG9zdGdyZXMtIyAgICAgKFdJVEggdzYo YzYpIEFTDQpwb3N0Z3JlcygjICAgICAgIChXSVRIIHc4KGM4KSBBUw0KcG9zdGdyZXMoIyAgICAg ICAoV0lUSCB3OShjOSkgQVMNCnBvc3RncmVzKCMgICAgICAgKFdJVEggdzEwKGMxMCkgQVMNCnBv c3RncmVzKCMgICAgICAgKFdJVEggdzExKGMxMSkgQVMNCnBvc3RncmVzKCMgICAgICAgKFdJVEgg d19lcnIoYzEyKSBBUw0KcG9zdGdyZXMoIyAgICAoU0VMRUNUIDEpDQpwb3N0Z3JlcygjICAgICBT RUxFQ1QgKiBGUk9NIHdfZXJyKQ0KcG9zdGdyZXMoIyAgICAgU0VMRUNUICogRlJPTSB3MTEpDQpw b3N0Z3JlcygjICAgICBTRUxFQ1QgKiBGUk9NIHcxMCkNCnBvc3RncmVzKCMgICAgIFNFTEVDVCAq IEZST00gdzkpDQpwb3N0Z3JlcygjICAgICBTRUxFQ1QgKiBGUk9NIHc4KQ0KcG9zdGdyZXMoIyAg ICAgIFNFTEVDVCAqIEZST00gdzYpDQpwb3N0Z3Jlcy0jICAgICBTRUxFQ1QgKiBGUk9NIHc2Ow0K RVJST1I6ICByZWN1cnNpdmUgcXVlcnkgInc2IiBkb2VzIG5vdCBoYXZlIHRoZSBmb3JtIG5vbi1y ZWN1cnNpdmUtdGVybSBVTklPTgpbQUxMXSByZWN1cnNpdmUtdGVybQ0KTElORSAxOiBXSVRIIFJF Q1VSU0lWRSB3NihjNikgQVMNCiAgICAgICAgICAgICAgICAgICAgICAgXg0KcG9zdGdyZXM9Iw0K cG9zdGdyZXM9Iw0KcG9zdGdyZXM9Iw0KcG9zdGdyZXM9IyAtLSBSZW1vdmluZyB3X2VyciBpdCB3 b3Jrcw0KcG9zdGdyZXM9IyBXSVRIIFJFQ1VSU0lWRSB3NihjNikgQVMNCnBvc3RncmVzLSMgICAg IChXSVRIIHc2KGM2KSBBUw0KcG9zdGdyZXMoIyAgICAgICAoV0lUSCB3OChjOCkgQVMNCnBvc3Rn cmVzKCMgICAgICAgKFdJVEggdzkoYzkpIEFTDQpwb3N0Z3JlcygjICAgICAgIChXSVRIIHcxMChj MTApIEFTDQpwb3N0Z3JlcygjICAgICAgIChXSVRIIHcxMShjMTEpIEFTDQpwb3N0Z3JlcygjIC0t ICAgICAgKFdJVEggd19lcnIoYzEyKSBBUw0KcG9zdGdyZXMoIyAgICAoU0VMRUNUIDEpDQpwb3N0 Z3JlcygjIC0tICAgIFNFTEVDVCAqIEZST00gd19lcnIpDQpwb3N0Z3JlcygjICAgICBTRUxFQ1Qg KiBGUk9NIHcxMSkNCnBvc3RncmVzKCMgICAgIFNFTEVDVCAqIEZST00gdzEwKQ0KcG9zdGdyZXMo IyAgICAgU0VMRUNUICogRlJPTSB3OSkNCnBvc3RncmVzKCMgICAgIFNFTEVDVCAqIEZST00gdzgp DQpwb3N0Z3JlcygjICAgICAgU0VMRUNUICogRlJPTSB3NikNCnBvc3RncmVzLSMgICAgIFNFTEVD VCAqIEZST00gdzY7DQogYzYNCi0tLS0NCiAgMQ0KKDEgcm93KQ0KDQpwb3N0Z3Jlcz0+IFxxDQoN CuKGkiByLnNoIDEyDQpwc3FsICgxNGRldmVsLCBzZXJ2ZXIgMTIuNCkNClR5cGUgImhlbHAiIGZv ciBoZWxwLg0KDQpwb3N0Z3Jlcz0+IC0tIE5vIGVycm9yIG9uIHYxMiB3aXRoIG9yIHdpdGhvdXQg d19lcnINCnBvc3RncmVzPT4NCnBvc3RncmVzPT4gV0lUSCBSRUNVUlNJVkUgdzYoYzYpIEFTDQpw b3N0Z3Jlcy0+ICAgICAoV0lUSCB3NihjNikgQVMNCnBvc3RncmVzKD4gICAgICAgKFdJVEggdzgo YzgpIEFTDQpwb3N0Z3Jlcyg+ICAgICAgIChXSVRIIHc5KGM5KSBBUw0KcG9zdGdyZXMoPiAgICAg ICAoV0lUSCB3MTAoYzEwKSBBUw0KcG9zdGdyZXMoPiAgICAgICAoV0lUSCB3MTEoYzExKSBBUw0K cG9zdGdyZXMoPiAgICAgICAoV0lUSCB3X2VycihjMTIpIEFTDQpwb3N0Z3Jlcyg+ICAgIChTRUxF Q1QgMSkNCnBvc3RncmVzKD4gICAgIFNFTEVDVCAqIEZST00gd19lcnIpDQpwb3N0Z3Jlcyg+ICAg ICBTRUxFQ1QgKiBGUk9NIHcxMSkNCnBvc3RncmVzKD4gICAgIFNFTEVDVCAqIEZST00gdzEwKQ0K cG9zdGdyZXMoPiAgICAgU0VMRUNUICogRlJPTSB3OSkNCnBvc3RncmVzKD4gICAgIFNFTEVDVCAq IEZST00gdzgpDQpwb3N0Z3Jlcyg+ICAgICAgU0VMRUNUICogRlJPTSB3NikNCnBvc3RncmVzLT4g ICAgIFNFTEVDVCAqIEZST00gdzY7DQogYzYNCi0tLS0NCiAgMQ0KKDEgcm93KQ0KDQpwb3N0Z3Jl cz0+IC0tIE5vIGVycm9yIG9uIHYxMiB3aXRoIG9yIHdpdGhvdXQgd19lcnINCnBvc3RncmVzPT4N CnBvc3RncmVzPT4gV0lUSCBSRUNVUlNJVkUgdzYoYzYpIEFTDQpwb3N0Z3Jlcy0+ICAgICAoV0lU SCB3NihjNikgQVMNCnBvc3RncmVzKD4gICAgICAgKFdJVEggdzgoYzgpIEFTDQpwb3N0Z3Jlcyg+ ICAgICAgIChXSVRIIHc5KGM5KSBBUw0KcG9zdGdyZXMoPiAgICAgICAoV0lUSCB3MTAoYzEwKSBB Uw0KcG9zdGdyZXMoPiAgICAgICAoV0lUSCB3MTEoYzExKSBBUw0KcG9zdGdyZXMoPiAtLSAgICAg IChXSVRIIHdfZXJyKGMxMikgQVMNCnBvc3RncmVzKD4gICAgKFNFTEVDVCAxKQ0KcG9zdGdyZXMo PiAtLSAgICBTRUxFQ1QgKiBGUk9NIHdfZXJyKQ0KcG9zdGdyZXMoPiAgICAgU0VMRUNUICogRlJP TSB3MTEpDQpwb3N0Z3Jlcyg+ICAgICBTRUxFQ1QgKiBGUk9NIHcxMCkNCnBvc3RncmVzKD4gICAg IFNFTEVDVCAqIEZST00gdzkpDQpwb3N0Z3Jlcyg+ICAgICBTRUxFQ1QgKiBGUk9NIHc4KQ0KcG9z dGdyZXMoPiAgICAgIFNFTEVDVCAqIEZST00gdzYpDQpwb3N0Z3Jlcy0+ICAgICBTRUxFQ1QgKiBG Uk9NIHc2Ow0KIGM2DQotLS0tDQogIDENCigxIHJvdykKCg== --===============0021488935602150317==--