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 1lZqQ9-0003P6-8c for pgsql-bugs@arkaria.postgresql.org; Fri, 23 Apr 2021 07:40:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lZqQ8-0003Mf-6u for pgsql-bugs@arkaria.postgresql.org; Fri, 23 Apr 2021 07:40:12 +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 1lZmuP-0004bw-Ro for pgsql-bugs@lists.postgresql.org; Fri, 23 Apr 2021 03:55:14 +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 1lZmuJ-0002Wf-CZ for pgsql-bugs@lists.postgresql.org; Fri, 23 Apr 2021 03:55:12 +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=5SOsOKD2GBNzPny1NfgeraS9Imq2mgVENzkmEq5oWIs=; b=Jsj2AlIVZmQtpP/wEbLUbQcXzb fui0PE+c3tRlgRT5k3Umjnf+bT5oILC+Lo/aoEE2klTfiYAFLb+iUdavNEqTISlKVYD98shKok3Sq e8Tm+iz3nnNMvVNPGcrE16Sb3SE2+8hANtTv6P7hrYiodzbbzGbHi8er55Uo/iPx1t7Tx9ipQaFmq kdI9hkB0tWeWkRlUAnPu462ePCNL6QQ0KmH+vIb+te//MhpKmyYSbSXCiFw+H9fiWPQwT3eaG7eSa LUjY+OjcA8HVgzjAOQCJn2PiFcePDZxV2bn40zS5mlcPWF3PS44O2bx0miNC6qFFEWoH6PUv2Vfpf GSFKvFHw==; 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 1lZmuH-0002Ej-Ty for pgsql-bugs@lists.postgresql.org; Fri, 23 Apr 2021 03:55:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lZmuE-0006oS-FO for pgsql-bugs@lists.postgresql.org; Fri, 23 Apr 2021 03:55:02 +0000 Content-Type: multipart/mixed; boundary="===============2980028247169209701==" MIME-Version: 1.0 Subject: BUG #16979: WITH RECURSIVE SQL crashes v13.x 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 03:54:58 +0000 Message-ID: <16979-45e2d5fc7ace1ad9@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 --===============2980028247169209701== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjk3OQpMb2dnZWQgYnk6ICAgICAgICAgIFJvYmlucyBUaGFyYWthbgpF bWFpbCBhZGRyZXNzOiAgICAgIHRoYXJha2FuQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246 IDEzLjIKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUKRGVzY3JpcHRpb246ICAgICAgICAKCkhp LA0KDQpUaGlzIFNRTCBpcyBhIHN0cmlwcGVkIGRvd24gdmVyc2lvbiAoZnJvbSBhIFNRTFNtaXRo IGNyYXNoKSBhbmQgYW0gcG9zdGluZwpoZXJlIHNpbmNlIHRoaXMgYXBwZWFycyB0byBiZSBhIHJl Z3Jlc3Npb24gaW4gdjEzLg0KDQpQZXIgZG9jdW1lbnRhdGlvbiwgaXQgaXMgcHJvYmFibHkgdW53 aXNlIHRvIGluY3JlYXNlIG1heF9zdGFja19kZXB0aCBqdXN0Cmxpa2UgdGhhdCwgYnV0IEkgYW0g dW5jbGVhciB3aHkgdGhpcyBTUUwgc2hvdWxkIHJlYWNoIGFueXdoZXJlIGNsb3NlIHRvIGEKc3Rh Y2sgZGVwdGggb2YgMzJrLg0KDQpUaGlzIGlzIHJlcHJvZHVjaWJsZSBvbiB2MTMuMiAoUkVMXzEz XzIpIGJ1dCB3b3JrcyBmaW5lIG9uIEhFQUQgKG1hc3RlcikuClRoZSBTUUwgYWxzbyB3b3JrZWQg ZmluZSBvbiB2MTIgYW5kIG9sZGVyIGluc3RhbmNlcyAoYWx0aG91Z2ggSSBkaWRuJ3QKY29tcGls ZSB0aGVtIGZyb20gc291cmNlIGZvciB0aGlzIGJ1ZyByZXBvcnQpLg0KDQpJcnJlc3BlY3RpdmUs IGRvIGxldCBtZSBrbm93IGlmIEkgY2FuIHByb3ZpZGUgYW55IGZ1cnRoZXIgZGV0YWlscyB0byBo ZWxwCmhlcmUuIEFsc28gKG1heSBiZSB1bnJlbGF0ZWQsIGJ1dCkgaXQgbWF5IGhlbHAgdGhhdCBC VUcgIzE2OTc4IGNhbWUgdXAgd2hlbgpyZXZpZXdpbmcgdGhpcyBpc3N1ZS4NCg0KPT09PT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09DQoNCuKGkiBwc3FsIC1oIGxvY2FsaG9zdA0K cHNxbCAoMTRkZXZlbCwgc2VydmVyIDEzLjIpDQpUeXBlICJoZWxwIiBmb3IgaGVscC4NCg0KcG9z dGdyZXM9IyBXSVRIIFJFQ1VSU0lWRSB3MShjMSkgQVMNCiAoV0lUSCB3MihjMikgQVMNCiAgKFdJ VEggdzMoYzMpIEFTDQogICAoV0lUSCB3NChjNCkgQVMNCihXSVRIIHc1KGM1KSBBUw0KIChXSVRI IFJFQ1VSU0lWRSB3NihjNikgQVMNCiAgKFdJVEggdzYoYzYpIEFTDQogICAoV0lUSCB3OChjOCkg QVMNCiAgIChXSVRIIHc5KGM5KSBBUw0KICAgKFdJVEggdzEwKGMxMCkgQVMNCiAgIChXSVRIIHcx MShjMTEpIEFTDQogICAoV0lUSCB3MTIoYzEyKSBBUw0KICAgKFdJVEggdzEzKGMxMykgQVMNCiAg IChXSVRIIHcxNChjMTQpIEFTDQogICAoV0lUSCB3MTUoYzE1KSBBUw0KKFNFTEVDVCAxKQ0KU0VM RUNUICogRlJPTSB3MTUpDQpTRUxFQ1QgKiBGUk9NIHcxNCkNClNFTEVDVCAqIEZST00gdzEzKQ0K U0VMRUNUICogRlJPTSB3MTIpDQpTRUxFQ1QgKiBGUk9NIHcxMSkNClNFTEVDVCAqIEZST00gdzEw KQ0KU0VMRUNUICogRlJPTSB3OSkNClNFTEVDVCAqIEZST00gdzgpDQogICBTRUxFQ1QgKiBGUk9N IHc2KQ0KICBTRUxFQ1QgKiBGUk9NIHc2KQ0KIFNFTEVDVCAqIEZST00gdzUpDQpTRUxFQ1QgKiBG Uk9NIHc0KQ0KICAgU0VMRUNUICogRlJPTSB3MykNCiAgU0VMRUNUICogRlJPTSB3MikNClNFTEVD VCAqIEZST00gdzE7DQpFUlJPUjogIHN0YWNrIGRlcHRoIGxpbWl0IGV4Y2VlZGVkDQpISU5UOiAg SW5jcmVhc2UgdGhlIGNvbmZpZ3VyYXRpb24gcGFyYW1ldGVyICJtYXhfc3RhY2tfZGVwdGgiIChj dXJyZW50bHkKMjA0OGtCKSwgYWZ0ZXIgZW5zdXJpbmcgdGhlIHBsYXRmb3JtJ3Mgc3RhY2sgZGVw dGggbGltaXQgaXMgYWRlcXVhdGUuDQoNCnBvc3RncmVzPSMgc2hvdyBtYXhfc3RhY2tfZGVwdGgg Ow0KIG1heF9zdGFja19kZXB0aA0KLS0tLS0tLS0tLS0tLS0tLS0NCiAyTUINCigxIHJvdykNCg0K cG9zdGdyZXM9IyBzZXQgbWF4X3N0YWNrX2RlcHRoID0gJzdNQic7DQpTRVQNCg0KcG9zdGdyZXM9 IyBXSVRIIFJFQ1VSU0lWRSB3MShjMSkgQVMNCiAoV0lUSCB3MihjMikgQVMNCiAgKFdJVEggdzMo YzMpIEFTDQogICAoV0lUSCB3NChjNCkgQVMNCihXSVRIIHc1KGM1KSBBUw0KIChXSVRIIFJFQ1VS U0lWRSB3NihjNikgQVMNCiAgKFdJVEggdzYoYzYpIEFTDQogICAoV0lUSCB3OChjOCkgQVMNCiAg IChXSVRIIHc5KGM5KSBBUw0KICAgKFdJVEggdzEwKGMxMCkgQVMNCiAgIChXSVRIIHcxMShjMTEp IEFTDQogICAoV0lUSCB3MTIoYzEyKSBBUw0KICAgKFdJVEggdzEzKGMxMykgQVMNCiAgIChXSVRI IHcxNChjMTQpIEFTDQogICAoV0lUSCB3MTUoYzE1KSBBUw0KKFNFTEVDVCAxKQ0KU0VMRUNUICog RlJPTSB3MTUpDQpTRUxFQ1QgKiBGUk9NIHcxNCkNClNFTEVDVCAqIEZST00gdzEzKQ0KU0VMRUNU ICogRlJPTSB3MTIpDQpTRUxFQ1QgKiBGUk9NIHcxMSkNClNFTEVDVCAqIEZST00gdzEwKQ0KU0VM RUNUICogRlJPTSB3OSkNClNFTEVDVCAqIEZST00gdzgpDQogICBTRUxFQ1QgKiBGUk9NIHc2KQ0K ICBTRUxFQ1QgKiBGUk9NIHc2KQ0KIFNFTEVDVCAqIEZST00gdzUpDQpTRUxFQ1QgKiBGUk9NIHc0 KQ0KICAgU0VMRUNUICogRlJPTSB3MykNCiAgU0VMRUNUICogRlJPTSB3MikNClNFTEVDVCAqIEZS T00gdzE7DQpzZXJ2ZXIgY2xvc2VkIHRoZSBjb25uZWN0aW9uIHVuZXhwZWN0ZWRseQ0KICAgICAg ICBUaGlzIHByb2JhYmx5IG1lYW5zIHRoZSBzZXJ2ZXIgdGVybWluYXRlZCBhYm5vcm1hbGx5DQog ICAgICAgIGJlZm9yZSBvciB3aGlsZSBwcm9jZXNzaW5nIHRoZSByZXF1ZXN0Lg0KVGhlIGNvbm5l Y3Rpb24gdG8gdGhlIHNlcnZlciB3YXMgbG9zdC4gQXR0ZW1wdGluZyByZXNldDogRmFpbGVkLg0K IT8+IFxxDQoNCg0KDQrihpIgd2MgLWwgZ2RiXzIwMjEwNDIzXzEwMjIudHh0DQozMjgwNyBnZGJf MjAyMTA0MjNfMTAyMi50eHQNCg0K4oaSIGhlYWQgZ2RiXzIwMjEwNDIzXzEwMjIudHh0DQpDb250 aW51aW5nLg0KDQpQcm9ncmFtIHJlY2VpdmVkIHNpZ25hbCBTSUdTRUdWLCBTZWdtZW50YXRpb24g ZmF1bHQuDQoweDAwMDAwMDAwMDA1N2I4MzIgaW4gbWFrZURlcGVuZGVuY3lHcmFwaFdhbGtlciAo KQ0KIzAgIDB4MDAwMDAwMDAwMDU3YjgzMiBpbiBtYWtlRGVwZW5kZW5jeUdyYXBoV2Fsa2VyICgp DQojMSAgMHgwMDAwMDAwMDAwNTdiODMyIGluIG1ha2VEZXBlbmRlbmN5R3JhcGhXYWxrZXIgKCkN CiMyICAweDAwMDAwMDAwMDA1N2I4MzIgaW4gbWFrZURlcGVuZGVuY3lHcmFwaFdhbGtlciAoKQ0K IzMgIDB4MDAwMDAwMDAwMDU3YjgzMiBpbiBtYWtlRGVwZW5kZW5jeUdyYXBoV2Fsa2VyICgpDQoj NCAgMHgwMDAwMDAwMDAwNTdiODMyIGluIG1ha2VEZXBlbmRlbmN5R3JhcGhXYWxrZXIgKCkNCiM1 ICAweDAwMDAwMDAwMDA1N2I4MzIgaW4gbWFrZURlcGVuZGVuY3lHcmFwaFdhbGtlciAoKQ0KDQri hpIgdGFpbCAtNDAgZ2RiXzIwMjEwNDIzXzEwMjIudHh0DQojMzI3NjMgMHgwMDAwMDAwMDAwNTdi NzI3IGluIG1ha2VEZXBlbmRlbmN5R3JhcGhXYWxrZXIgKCkNCiMzMjc2NCAweDAwMDAwMDAwMDA1 N2I3MjcgaW4gbWFrZURlcGVuZGVuY3lHcmFwaFdhbGtlciAoKQ0KIzMyNzY1IDB4MDAwMDAwMDAw MDU3YjcyNyBpbiBtYWtlRGVwZW5kZW5jeUdyYXBoV2Fsa2VyICgpDQojMzI3NjYgMHgwMDAwMDAw MDAwNTdiNzI3IGluIG1ha2VEZXBlbmRlbmN5R3JhcGhXYWxrZXIgKCkNCiMzMjc2NyAweDAwMDAw MDAwMDA1N2I3MjcgaW4gbWFrZURlcGVuZGVuY3lHcmFwaFdhbGtlciAoKQ0KIzMyNzY4IDB4MDAw MDAwMDAwMDU3YzVhOSBpbiB0cmFuc2Zvcm1XaXRoQ2xhdXNlICgpDQojMzI3NjkgMHgwMDAwMDAw MDAwNTU3N2JiIGluIHRyYW5zZm9ybVN0bXQgKCkNCiMzMjc3MCAweDAwMDAwMDAwMDA1NThiM2Mg aW4gcGFyc2Vfc3ViX2FuYWx5emUgKCkNCiMzMjc3MSAweDAwMDAwMDAwMDA1N2JmZDAgaW4gYW5h bHl6ZUNURSAoKQ0KIzMyNzcyIDB4MDAwMDAwMDAwMDU3YzkxNyBpbiB0cmFuc2Zvcm1XaXRoQ2xh dXNlICgpDQojMzI3NzMgMHgwMDAwMDAwMDAwNTU3N2JiIGluIHRyYW5zZm9ybVN0bXQgKCkNCiMz Mjc3NCAweDAwMDAwMDAwMDA1NThiM2MgaW4gcGFyc2Vfc3ViX2FuYWx5emUgKCkNCiMzMjc3NSAw eDAwMDAwMDAwMDA1N2JmZDAgaW4gYW5hbHl6ZUNURSAoKQ0KIzMyNzc2IDB4MDAwMDAwMDAwMDU3 YzkxNyBpbiB0cmFuc2Zvcm1XaXRoQ2xhdXNlICgpDQojMzI3NzcgMHgwMDAwMDAwMDAwNTU3N2Ji IGluIHRyYW5zZm9ybVN0bXQgKCkNCiMzMjc3OCAweDAwMDAwMDAwMDA1NThiM2MgaW4gcGFyc2Vf c3ViX2FuYWx5emUgKCkNCiMzMjc3OSAweDAwMDAwMDAwMDA1N2JmZDAgaW4gYW5hbHl6ZUNURSAo KQ0KIzMyNzgwIDB4MDAwMDAwMDAwMDU3YzkxNyBpbiB0cmFuc2Zvcm1XaXRoQ2xhdXNlICgpDQoj MzI3ODEgMHgwMDAwMDAwMDAwNTU3N2JiIGluIHRyYW5zZm9ybVN0bXQgKCkNCiMzMjc4MiAweDAw MDAwMDAwMDA1NThiM2MgaW4gcGFyc2Vfc3ViX2FuYWx5emUgKCkNCiMzMjc4MyAweDAwMDAwMDAw MDA1N2JmZDAgaW4gYW5hbHl6ZUNURSAoKQ0KIzMyNzg0IDB4MDAwMDAwMDAwMDU3YzkxNyBpbiB0 cmFuc2Zvcm1XaXRoQ2xhdXNlICgpDQojMzI3ODUgMHgwMDAwMDAwMDAwNTU3N2JiIGluIHRyYW5z Zm9ybVN0bXQgKCkNCiMzMjc4NiAweDAwMDAwMDAwMDA1NThiM2MgaW4gcGFyc2Vfc3ViX2FuYWx5 emUgKCkNCiMzMjc4NyAweDAwMDAwMDAwMDA1N2JmZDAgaW4gYW5hbHl6ZUNURSAoKQ0KIzMyNzg4 IDB4MDAwMDAwMDAwMDU3YzhhMCBpbiB0cmFuc2Zvcm1XaXRoQ2xhdXNlICgpDQojMzI3ODkgMHgw MDAwMDAwMDAwNTU3N2JiIGluIHRyYW5zZm9ybVN0bXQgKCkNCiMzMjc5MCAweDAwMDAwMDAwMDA1 NTk0OGYgaW4gcGFyc2VfYW5hbHl6ZSAoKQ0KIzMyNzkxIDB4MDAwMDAwMDAwMDc2OTEwMiBpbiBw Z19hbmFseXplX2FuZF9yZXdyaXRlICgpDQojMzI3OTIgMHgwMDAwMDAwMDAwNzY5NjczIGluIGV4 ZWNfc2ltcGxlX3F1ZXJ5ICgpDQojMzI3OTMgMHgwMDAwMDAwMDAwNzZiN2U1IGluIFBvc3RncmVz TWFpbiAoKQ0KIzMyNzk0IDB4MDAwMDAwMDAwMDZmNjBjZiBpbiBTZXJ2ZXJMb29wICgpDQojMzI3 OTUgMHgwMDAwMDAwMDAwNmY2ZmNmIGluIFBvc3RtYXN0ZXJNYWluICgpDQojMzI3OTYgMHgwMDAw MDAwMDAwNDg2Mjg5IGluIG1haW4gKCkNCg0KDQotDQpSb2JpbnMgVGhhcmFrYW4NCkRhdGFiYXNl IEVuZ2luZWVyDQpBbWF6b24gV2ViIFNlcnZpY2VzCgo= --===============2980028247169209701==--