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 1pNU76-0006A0-Es for pgsql-bugs@arkaria.postgresql.org; Thu, 02 Feb 2023 07:34:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pNU74-0002tb-0X for pgsql-bugs@arkaria.postgresql.org; Thu, 02 Feb 2023 07:34:30 +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 1pNPit-00005T-6k for pgsql-bugs@lists.postgresql.org; Thu, 02 Feb 2023 02:53:15 +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 1pNPik-0007VA-AB for pgsql-bugs@lists.postgresql.org; Thu, 02 Feb 2023 02:53:14 +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=9mOeb+nvia1xE0MoHkkB5Mrs1wNozOkZJGNqPUN1ajk=; b=QlGsVIO4IOGoKrWhnetp3dOpcJ EISmRZiX1V7DnHIFYzM2L4ijAt6UoDGT+PxCutEcEZPDJFC1ob018N9s78VPUTtDIOziqu72QbDXG B5+kt9QSWDCJJH8326mpB8iXzezJAQ6VRqiJi2zsKLA83VqFpiH/X9XVLIqqmYAQFLwrb68w1iJfM znMCNurK9mMPrKNRfixOkvUwpenEwSSfmW2Eod65pBKROK8VgBpJYRozSjk3rD73z/8KiBamF8LJ4 y8okGfRtxUU+HXPKAEJnsdkzOuWajNPPj8guh0tLOltzZs+uaeqy+e+v9uO6Nk7MGGjE2Ak6J6mjr BbOH5Dhg==; 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 1pNPii-00080k-56 for pgsql-bugs@lists.postgresql.org; Thu, 02 Feb 2023 02:53:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pNPig-003th7-40 for pgsql-bugs@lists.postgresql.org; Thu, 02 Feb 2023 02:53:02 +0000 Content-Type: multipart/mixed; boundary="===============7620274920483068511==" MIME-Version: 1.0 Subject: BUG #17768: Assert triggered on initsplan.c 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: Thu, 02 Feb 2023 02:52:49 +0000 Message-ID: <17768-5ac8730ece54478f@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 --===============7620274920483068511== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzc2OApMb2dnZWQgYnk6ICAgICAgICAgIFJvYmlucyBUaGFyYWthbgpF bWFpbCBhZGRyZXNzOiAgICAgIHRoYXJha2FuQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246 IDE1LjEKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjAuMDQKRGVzY3JpcHRpb246ICAgICAg ICAKClRoaXMgYXNzZXJ0KCkgaXMgbm90IGVhc2lseSByZXByb2R1Y2libGUsIGJ1dCB0aG91Z2h0 IG1heSBiZSBvZiBpbnRlcmVzdC4gDQpDYW4gcHJvdmlkZSBmdWxsIGJhY2t0cmFjZSwgaWYgcmVx dWlyZWQuDQoNCkdpdDogMjUzNDMyZjQyNkBtYXN0ZXINCk9TOiBVYnVudHUgMjAuMDQNCg0KVFJB UDogZmFpbGVkIEFzc2VydCgiai0+am9pbnR5cGUgPT0gSk9JTl9JTk5FUiIpLCBGaWxlOiAiaW5p dHNwbGFuLmMiLCBMaW5lOgoxMjA2LCBQSUQ6IDMyODU5NzgNCg0KQmFja3RyYWNlIC8gYmFja3Ry YWNlIGZ1bGwgZXhjZXJwdCAvIFNRTCBiZWxvdy4NCg0KQmFja3RyYWNlDQo9PT09PT09PT0NCkNv cmUgd2FzIGdlbmVyYXRlZCBieSBgcG9zdGdyZXM6IDI1MzQzMmY0MjZAbWFzdGVyQHNxaXRoOiB1 NzMgcG9zdGdyZXMKMTI3LjAuMC4xKDM1ODQwKSBTRUxFQ1QgICAgICAgJy4NClByb2dyYW0gdGVy bWluYXRlZCB3aXRoIHNpZ25hbCBTSUdBQlJULCBBYm9ydGVkLg0KIzAgIF9fR0lfcmFpc2UgKHNp Zz1zaWdAZW50cnk9NikgYXQgLi4vc3lzZGVwcy91bml4L3N5c3YvbGludXgvcmFpc2UuYzo1MA0K IzAgIF9fR0lfcmFpc2UgKHNpZz1zaWdAZW50cnk9NikgYXQgLi4vc3lzZGVwcy91bml4L3N5c3Yv bGludXgvcmFpc2UuYzo1MA0KIzEgIDB4MDAwMDdmMWQ3NmY3ODg1OSBpbiBfX0dJX2Fib3J0ICgp IGF0IGFib3J0LmM6NzkNCiMyICAweDAwMDA1NjI2ODRkMTJlOWEgaW4gRXhjZXB0aW9uYWxDb25k aXRpb24gKA0KICAgIGNvbmRpdGlvbk5hbWU9MHg1NjI2ODRlYzdkMjAgImotPmpvaW50eXBlID09 IEpPSU5fSU5ORVIiLA0KICAgIGZpbGVOYW1lPTB4NTYyNjg0ZWM3YjNhICJpbml0c3BsYW4uYyIs IGxpbmVOdW1iZXI9MTIwNikgYXQgYXNzZXJ0LmM6NjYNCiMzICAweDAwMDA1NjI2ODQ5ZWFkMTUg aW4gZGVjb25zdHJ1Y3RfZGlzdHJpYnV0ZSAocm9vdD0weDU2MjY4NzUxZjA3OCwNCiAgICBqdGl0 ZW09MHg1NjI2ODcwZmY2YTgsIHBvc3Rwb25lZF9xdWFsX2xpc3Q9MHg3ZmZjN2U2MTk2YzApDQog ICAgYXQgaW5pdHNwbGFuLmM6MTIwNg0KIzQgIDB4MDAwMDU2MjY4NDllOWIzZCBpbiBkZWNvbnN0 cnVjdF9qb2ludHJlZSAocm9vdD0weDU2MjY4NzUxZjA3OCkNCiAgICBhdCBpbml0c3BsYW4uYzo3 ODMNCiM1ICAweDAwMDA1NjI2ODQ5ZWVhZTQgaW4gcXVlcnlfcGxhbm5lciAocm9vdD0weDU2MjY4 NzUxZjA3OCwNCiAgICBxcF9jYWxsYmFjaz0weDU2MjY4NDlmNTNjOSA8c3RhbmRhcmRfcXBfY2Fs bGJhY2s+LA0KICAgIHFwX2V4dHJhPTB4N2ZmYzdlNjE5OGUwKSBhdCBwbGFubWFpbi5jOjE4Ng0K IzYgIDB4MDAwMDU2MjY4NDlmMTYxMCBpbiBncm91cGluZ19wbGFubmVyIChyb290PTB4NTYyNjg3 NTFmMDc4LA0KICAgIHR1cGxlX2ZyYWN0aW9uPTApIGF0IHBsYW5uZXIuYzoxNDk2DQojNyAgMHgw MDAwNTYyNjg0OWYwY2JmIGluIHN1YnF1ZXJ5X3BsYW5uZXIgKGdsb2I9MHg1NjI2ODcwYjZjZjgs DQogICAgcGFyc2U9MHg1NjI2ODcwYjZlMDgsIHBhcmVudF9yb290PTB4MCwgaGFzUmVjdXJzaW9u PWZhbHNlLA0KICAgIHR1cGxlX2ZyYWN0aW9uPTApIGF0IHBsYW5uZXIuYzoxMDY1DQojOCAgMHgw MDAwNTYyNjg0OWVmMjc3IGluIHN0YW5kYXJkX3BsYW5uZXIgKHBhcnNlPTB4NTYyNjg3MGI2ZTA4 LA0KICAgIHF1ZXJ5X3N0cmluZz0weDU2MjY4NmE2ZDE4OCAic2VsZWN0ICBcbiAgcHVibGljLmNv bnN0YW50X3JlZmN1cnNvcigpIGFzCmMwXG5mcm9tIFxuICBwdWJsaWMucnRlc3RfdDQgYXMgcmVm XzAsXG4gIGxhdGVyYWwgKHNlbGVjdCAgXG4gICAgICAgCnBnX2NhdGFsb2cubnVtbXVsdGlyYW5n ZSgpIGFzIGMwXG4gICAgICBmcm9tPg0KIzkgIDB4MDAwMDdmMWQ3M2Y2NjA4YiBpbiBwZ3NzX3Bs YW5uZXIgKHBhcnNlPTB4NTYyNjg3MGI2ZTA4LA0KDQoNCkJhY2t0cmFjZSBmdWxsIGV4Y2VycHQN Cj09PT09PT09PT09PT09PT09DQojMiAgMHgwMDAwNTYyNjg0ZDEyZTlhIGluIEV4Y2VwdGlvbmFs Q29uZGl0aW9uICgNCiAgICBjb25kaXRpb25OYW1lPTB4NTYyNjg0ZWM3ZDIwICJqLT5qb2ludHlw ZSA9PSBKT0lOX0lOTkVSIiwNCiAgICBmaWxlTmFtZT0weDU2MjY4NGVjN2IzYSAiaW5pdHNwbGFu LmMiLCBsaW5lTnVtYmVyPTEyMDYpIGF0IGFzc2VydC5jOjY2DQpObyBsb2NhbHMuDQojMyAgMHgw MDAwNTYyNjg0OWVhZDE1IGluIGRlY29uc3RydWN0X2Rpc3RyaWJ1dGUgKHJvb3Q9MHg1NjI2ODc1 MWYwNzgsDQogICAganRpdGVtPTB4NTYyNjg3MGZmNmE4LCBwb3N0cG9uZWRfcXVhbF9saXN0PTB4 N2ZmYzdlNjE5NmMwKQ0KICAgIGF0IGluaXRzcGxhbi5jOjEyMDYNCiAgICAgICAgcHEgPSAweDU2 MjY4NzBmZmFmOA0KICAgICAgICBsX19zdGF0ZSA9IHtsID0gMHg1NjI2ODcwZmZiMTgsIGkgPSAw fQ0KICAgICAgICBvanNjb3BlID0gMHgwDQogICAgICAgIGogPSAweDU2MjY4NzBmNTIyOA0KICAg ICAgICBuZXdfcG9zdHBvbmVkX3F1YWxzID0gMHgwDQogICAgICAgIG15X3F1YWxzID0gMHgwDQog ICAgICAgIHNqaW5mbyA9IDB4MA0KICAgICAgICBwb3N0cG9uZWRfb2pfcXVhbF9saXN0ID0gMHgw DQogICAgICAgIGwgPSAweDU2MjY4NzBmZmIzMA0KICAgICAgICBqdG5vZGUgPSAweDU2MjY4NzBm NTIyOA0KICAgICAgICBfX2Z1bmNfXyA9ICJkZWNvbnN0cnVjdF9kaXN0cmlidXRlIg0KIzQgIDB4 MDAwMDU2MjY4NDllOWIzZCBpbiBkZWNvbnN0cnVjdF9qb2ludHJlZSAocm9vdD0weDU2MjY4NzUx ZjA3OCkNCiAgICBhdCBpbml0c3BsYW4uYzo3ODMNCiAgICAgICAganRpdGVtID0gMHg1NjI2ODcw ZmY2YTgNCiAgICAgICAgbGNfX3N0YXRlID0ge2wgPSAweDU2MjY4NzBmZjAxOCwgaSA9IDZ9DQog ICAgICAgIHJlc3VsdCA9IDB4NTYyNjg3MGZmMmY4DQogICAgICAgIHRvcF9qZG9tYWluID0gMHg1 NjI2ODc1MWY2MjgNCiAgICAgICAgaXRlbV9saXN0ID0gMHg1NjI2ODcwZmYwMTgNCiAgICAgICAg cG9zdHBvbmVkX3F1YWxfbGlzdCA9IDB4NTYyNjg3MGZmYjE4DQogICAgICAgIGxjID0gMHg1NjI2 ODcwZmZhNDgNCiM1ICAweDAwMDA1NjI2ODQ5ZWVhZTQgaW4gcXVlcnlfcGxhbm5lciAocm9vdD0w eDU2MjY4NzUxZjA3OCwNCiAgICBxcF9jYWxsYmFjaz0weDU2MjY4NDlmNTNjOSA8c3RhbmRhcmRf cXBfY2FsbGJhY2s+LA0KICAgIHFwX2V4dHJhPTB4N2ZmYzdlNjE5OGUwKSBhdCBwbGFubWFpbi5j OjE4Ng0KICAgICAgICBwYXJzZSA9IDB4NTYyNjg3MGI2ZTA4DQogICAgICAgIGpvaW5saXN0ID0g MHg1NjI2ODRkOTg1ZTAgPF9fbGliY19jc3VfaW5pdD4NCiAgICAgICAgZmluYWxfcmVsID0gMHg3 ZmZjN2U2MTk3OTANCiAgICAgICAgX19mdW5jX18gPSAicXVlcnlfcGxhbm5lciINCg0KDQoNCg0K DQpTUUwNCj09PQ0Kc2VsZWN0DQogIHB1YmxpYy5jb25zdGFudF9yZWZjdXJzb3IoKSBhcyBjMA0K ZnJvbQ0KICBwdWJsaWMucnRlc3RfdDQgYXMgcmVmXzAsDQogIGxhdGVyYWwgKHNlbGVjdA0KICAg ICAgICBwZ19jYXRhbG9nLm51bW11bHRpcmFuZ2UoKSBhcyBjMA0KICAgICAgZnJvbQ0KICAgICAg ICBwdWJsaWMubWljX2lucHV0cyBhcyBzYW1wbGVfMCB0YWJsZXNhbXBsZSBzeXN0ZW0gKDMuMSkN CiAgICAgICAgICAgIGlubmVyIGpvaW4gcGdfY2F0YWxvZy5wZ19zdWJzY3JpcHRpb25fcmVsIGFz IHNhbXBsZV8xCnRhYmxlc2FtcGxlIGJlcm5vdWxsaSAoOC4zKQ0KICAgICAgICAgICAgb24gKHJl Zl8wLmIgaXMgTlVMTCkNCiAgICAgICAgICBpbm5lciBqb2luIHNxaXRoc2NoMTYuY2hyIGFzIHNh bXBsZV8yIHRhYmxlc2FtcGxlIGJlcm5vdWxsaQooNS4yKQ0KICAgICAgICAgICAgcmlnaHQgam9p biBwdWJsaWMubnVtX3Jlc3VsdCBhcyByZWZfMQ0KICAgICAgICAgICAgb24gKChzZWxlY3QgcyBm cm9tIHB1YmxpYy5sc2VnX3RibCBsaW1pdCAxIG9mZnNldCAyKQ0KICAgICAgICAgICAgICAgICAg IDw+IChzZWxlY3QgbHNlZyBmcm9tIHB1YmxpYy50YWJfY29yZV90eXBlcyBsaW1pdCAxIG9mZnNl dAoxKQ0KICAgICAgICAgICAgICAgICAgKQ0KICAgICAgICAgIG9uICh0cnVlKQ0KICAgICAgd2hl cmUgZmFsc2UpIGFzIHN1YnFfMA0Kd2hlcmUgZmFsc2U7DQoNClRoYW5rcyB0byBTUUxTbWl0aCBm b3IgdGhlIGZpbmQuDQoNCi0NClJvYmlucyBUaGFyYWthbg0KQW1hem9uIFdlYiBTZXJ2aWNlcwoK --===============7620274920483068511==--