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 1pOuGd-0005pX-7D for pgsql-bugs@arkaria.postgresql.org; Mon, 06 Feb 2023 05:42:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pOuGc-000660-2v for pgsql-bugs@arkaria.postgresql.org; Mon, 06 Feb 2023 05:42:14 +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 1pOtrO-0005Jt-E6 for pgsql-bugs@lists.postgresql.org; Mon, 06 Feb 2023 05:16: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 1pOtrJ-00043Z-Kw for pgsql-bugs@lists.postgresql.org; Mon, 06 Feb 2023 05:16:10 +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=hQwp5FmdQ4Py7J5X35l5sBHpyMwmm6tt/ZAgKwLlU6w=; b=JTfMF7sbwIC6FTeA6qh6Gazl1s u4XbJ+7I4g6AyH2VysbTFTc2m95ZEbCydPkBOQT8qIknD9m6bhODsTXTFG8K3fQFbEExVRBNgp9+s bACCmOuvAZCU69ns//Sf3VUIHurAChMSQI3yQYPpVuj7wq0u0oVtM9HxNkPcdqHQQMGlh+4VDtO4o sroB6RxYf/mnZ1jPdnXca+xN5YOii6NyrMbaMmQIdowv1egU2achZhgu/Lff/7qIqdvNQA7FyIwuM jkqxwR7G5Tl0CDmC2OLkUM02EyXQdnHoIdqhdOlNquIcnyJjgmHztRYCiVL+QL8kVjsgXbJxai50f /LGBXdGQ==; 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 1pOtrI-0003UG-6L for pgsql-bugs@lists.postgresql.org; Mon, 06 Feb 2023 05:16: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 1pOtrG-006LrR-2o for pgsql-bugs@lists.postgresql.org; Mon, 06 Feb 2023 05:16:02 +0000 Content-Type: multipart/mixed; boundary="===============5002091839867195029==" MIME-Version: 1.0 Subject: BUG #17773: Assert triggered on analyzejoins.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: Mon, 06 Feb 2023 05:15:58 +0000 Message-ID: <17773-a592e6cedbc7bac5@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 --===============5002091839867195029== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzc3MwpMb2dnZWQgYnk6ICAgICAgICAgIFJvYmlucyBUaGFyYWthbgpF bWFpbCBhZGRyZXNzOiAgICAgIHRoYXJha2FuQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246 IDE1LjEKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjAuMDQKRGVzY3JpcHRpb246ICAgICAg ICAKClRoaXMgYXNzZXJ0KCkgaXMgZWFzaWx5IHJlcHJvZHVjaWJsZSBhcyBvZiA3MWMzNzc5N2Q3 QG1hc3RlciBhbmQgc3VyZmFjZWQKYWZ0ZXIgdGhlIHJlY2VudCA4NTM4NTE5ZGIxLg0KDQpUUkFQ OiBmYWlsZWQgQXNzZXJ0KCIhYm1zX2lzX21lbWJlcihpbm5lcnJlbGlkLApyZXN0cmljdGluZm8t PmNsYXVzZV9yZWxpZHMpIiksIEZpbGU6ICJhbmFseXplam9pbnMuYyIsIExpbmU6IDI3OSwgUElE Ogo4NjE3ODYNCg0KQmFja3RyYWNlIC8gU1FMIC8gYmFja3RyYWNlIGZ1bGwgKGV4Y2VycHQpIGJl bG93Lg0KDQoNClNRTA0KPT09DQpjcmVhdGUgdGFibGUgdHh0KCk7DQpTRUxFQ1QNCkZST00gcGdf Y2F0YWxvZy5wZ19yb2xlcyBBUyByZWZfMA0KICAgICBSSUdIVCBKT0lOIHR4dCBBUyByZWZfMSBP TiBOVUxMLA0KICAgICBMQVRFUkFMIChTRUxFQ1QNCiAgICAgICAgICAgICAgV0hFUkUgcmVmXzAu cm9scGFzc3dvcmQgfj49fiByZWZfMC5yb2xwYXNzd29yZCkgQVMgc3VicV8yOw0KDQoNCkNoZWNr aW5nICg3MWMzNzc5N2Q3fjApIC0gNzFjMzc3OTdkN2JkNzgyNjYxNDZhNTgyOWFiNjJiMzY4N2M0 NzI5NSAtIENyYXNoDQpDaGVja2luZyAoNzFjMzc3OTdkN34xKSAtIDJmNmUxNWFjOTNjNThjMTE0 MGU0YTRhZmZlNjFlNzhmNzM0NjQ5N2EgLSBDcmFzaA0KQ2hlY2tpbmcgKDcxYzM3Nzk3ZDd+Mikg LSBiMmQwZTEzYTBhNGMzMTE2N2QwMWU5ODcxZjkwNzA2MGM4MGI4ZmFlIC0gQ3Jhc2gNCkNoZWNr aW5nICg3MWMzNzc5N2Q3fjMpIC0gOWY0NTJmZWVlYjgzMDUzNGRjMmNlNzQzYTJhMTRiMTA5MTI4 MzI2ZCAtIENyYXNoDQpDaGVja2luZyAoNzFjMzc3OTdkN340KSAtIDg1Mzg1MTlkYjEwNzc3N2E2 YjA2YjcyNzcxODVlNjYwNWNhZjhkNGMgLSBDcmFzaA0KQ2hlY2tpbmcgKDcxYzM3Nzk3ZDd+NSkg LSA1ODQwYzIwMjcyNjRkNWRmYWQ3NDNjNTA4NzRlMGViZjhiODQwZjNmIC0KU3VjY2Vzcw0KQ2hl Y2tpbmcgKDcxYzM3Nzk3ZDd+NikgLSBmYWZmOGY4ZTQ3ZjE4YzdkNTg5NDUzZTJlMGQ4NDFkMmJk OTZjMWFjIC0KU3VjY2Vzcw0KQ2hlY2tpbmcgKDcxYzM3Nzk3ZDd+NykgLSAxYjZmNjMyYTM1Zjg3 MTVmOGM2NGU3OTMwYWRlYmM3ZjFkMjkyMDc0IC0KU3VjY2Vzcw0KDQoNCkJhY2t0cmFjZQ0KPT09 PT09PT09DQpDb3JlIHdhcyBnZW5lcmF0ZWQgYnkgYHBvc3RncmVzOiA3MWMzNzc5N2Q3QG1hc3Rl ckBzcWl0aDogdWJ1bnR1IHQKMTI3LjAuMC4xKDU3NzUyKSBTRUxFQ1QgICAgICAgICAgICcuDQpQ cm9ncmFtIHRlcm1pbmF0ZWQgd2l0aCBzaWduYWwgU0lHQUJSVCwgQWJvcnRlZC4NCiMwICBfX0dJ X3JhaXNlIChzaWc9c2lnQGVudHJ5PTYpIGF0IC4uL3N5c2RlcHMvdW5peC9zeXN2L2xpbnV4L3Jh aXNlLmM6NTANCiMwICBfX0dJX3JhaXNlIChzaWc9c2lnQGVudHJ5PTYpIGF0IC4uL3N5c2RlcHMv dW5peC9zeXN2L2xpbnV4L3JhaXNlLmM6NTANCiMxICAweDAwMDA3ZjdhY2Q4NzM4NTkgaW4gX19H SV9hYm9ydCAoKSBhdCBhYm9ydC5jOjc5DQojMiAgMHgwMDAwNTYwZTU4MGFhMDQ1IGluIEV4Y2Vw dGlvbmFsQ29uZGl0aW9uIChjb25kaXRpb25OYW1lPTB4NTYwZTU4MjVlZjY4CiIhYm1zX2lzX21l bWJlcihpbm5lcnJlbGlkLCByZXN0cmljdGluZm8tPmNsYXVzZV9yZWxpZHMpIiwKZmlsZU5hbWU9 MHg1NjBlNTgyNWVmM2YgImFuYWx5emVqb2lucy5jIiwNCiAgICBsaW5lTnVtYmVyPTI3OSkgYXQg YXNzZXJ0LmM6NjYNCiMzICAweDAwMDA1NjBlNTdkNzAwYjMgaW4gam9pbl9pc19yZW1vdmFibGUg KHJvb3Q9MHg1NjBlNTllOGYzZTgsCnNqaW5mbz0weDU2MGU1OWU5N2U4MCkgYXQgYW5hbHl6ZWpv aW5zLmM6Mjc5DQojNCAgMHgwMDAwNTYwZTU3ZDZmYjJiIGluIHJlbW92ZV91c2VsZXNzX2pvaW5z IChyb290PTB4NTYwZTU5ZThmM2U4LApqb2lubGlzdD0weDU2MGU1OWU5N2RjMCkgYXQgYW5hbHl6 ZWpvaW5zLmM6NzgNCiM1ICAweDAwMDA1NjBlNTdkODU3YmYgaW4gcXVlcnlfcGxhbm5lciAocm9v dD0weDU2MGU1OWU4ZjNlOCwKcXBfY2FsbGJhY2s9MHg1NjBlNTdkOGMwNTUgPHN0YW5kYXJkX3Fw X2NhbGxiYWNrPiwgcXBfZXh0cmE9MHg3ZmZmOTU5N2VmMTApCmF0IHBsYW5tYWluLmM6MjIzDQoj NiAgMHgwMDAwNTYwZTU3ZDg4MjljIGluIGdyb3VwaW5nX3BsYW5uZXIgKHJvb3Q9MHg1NjBlNTll OGYzZTgsCnR1cGxlX2ZyYWN0aW9uPTApIGF0IHBsYW5uZXIuYzoxNDk2DQojNyAgMHgwMDAwNTYw ZTU3ZDg3OTRiIGluIHN1YnF1ZXJ5X3BsYW5uZXIgKGdsb2I9MHg1NjBlNTllODM3ODAsCnBhcnNl PTB4NTYwZTU5ZDVlNzY4LCBwYXJlbnRfcm9vdD0weDAsIGhhc1JlY3Vyc2lvbj1mYWxzZSwgdHVw bGVfZnJhY3Rpb249MCkKYXQgcGxhbm5lci5jOjEwNjUNCiM4ICAweDAwMDA1NjBlNTdkODVmMDMg aW4gc3RhbmRhcmRfcGxhbm5lciAocGFyc2U9MHg1NjBlNTlkNWU3NjgsDQogICAgcXVlcnlfc3Ry aW5nPTB4NTYwZTU5ZDVkMmU4ICJTRUxFQ1RcbkZST00gcGdfY2F0YWxvZy5wZ19yb2xlcyBBUyBy ZWZfMFxuCiAgICBSSUdIVCBKT0lOIHR4dCBBUyByZWZfMSBPTiBOVUxMLFxuICAgICBMQVRFUkFM IChTRUxFQ1RcbiIsICcgJyA8cmVwZWF0cwoxNCB0aW1lcz4sICJXSEVSRSByZWZfMC5yb2xwYXNz d29yZCB+DQo+PX4gcmVmXzAucm9scGFzc3dvcmQpIEFTIHN1YnFfMjsiLCBjdXJzb3JPcHRpb25z PTIwNDgsIGJvdW5kUGFyYW1zPTB4MCkgYXQKcGxhbm5lci5jOjQxMQ0KDQoNCg0KQmFja3RyYWNl IGZ1bGwgZXhjZXJwdA0KPT09PT09PT09PT09PT09PT0NCiMyICAweDAwMDA1NjBlNTgwYWEwNDUg aW4gRXhjZXB0aW9uYWxDb25kaXRpb24gKGNvbmRpdGlvbk5hbWU9MHg1NjBlNTgyNWVmNjgKIiFi bXNfaXNfbWVtYmVyKGlubmVycmVsaWQsIHJlc3RyaWN0aW5mby0+Y2xhdXNlX3JlbGlkcykiLApm aWxlTmFtZT0weDU2MGU1ODI1ZWYzZiAiYW5hbHl6ZWpvaW5zLmMiLA0KICAgIGxpbmVOdW1iZXI9 Mjc5KSBhdCBhc3NlcnQuYzo2Ng0KTm8gbG9jYWxzLg0KIzMgIDB4MDAwMDU2MGU1N2Q3MDBiMyBp biBqb2luX2lzX3JlbW92YWJsZSAocm9vdD0weDU2MGU1OWU4ZjNlOCwKc2ppbmZvPTB4NTYwZTU5 ZTk3ZTgwKSBhdCBhbmFseXplam9pbnMuYzoyNzkNCiAgICAgICAgcmVzdHJpY3RpbmZvID0gMHg1 NjBlNTllOTgwYTANCiAgICAgICAgbF9fc3RhdGUgPSB7bCA9IDB4NTYwZTU5ZTk4NWMwLCBpID0g MX0NCiAgICAgICAgaW5uZXJyZWxpZCA9IDYNCiAgICAgICAgaW5uZXJyZWwgPSAweDU2MGU1OWU5 Njg1OA0KICAgICAgICBpbnB1dHJlbGlkcyA9IDB4NTYwZTU5ZTk5NTEwDQogICAgICAgIGpvaW5y ZWxpZHMgPSAweDU2MGU1OWU5OTg2MA0KICAgICAgICBjbGF1c2VfbGlzdCA9IDB4MA0KICAgICAg ICBsID0gMHg1NjBlNTllOTk4ODgNCiAgICAgICAgYXR0cm9mZiA9IC0xDQojNCAgMHgwMDAwNTYw ZTU3ZDZmYjJiIGluIHJlbW92ZV91c2VsZXNzX2pvaW5zIChyb290PTB4NTYwZTU5ZThmM2U4LApq b2lubGlzdD0weDU2MGU1OWU5N2RjMCkgYXQgYW5hbHl6ZWpvaW5zLmM6NzgNCiAgICAgICAgc2pp bmZvID0gMHg1NjBlNTllOTdlODANCiAgICAgICAgam9pbnJlbGlkcyA9IDB4ZmZmZmZmZmUwMDAw MDAwMw0KICAgICAgICBpbm5lcnJlbGlkID0gMA0KICAgICAgICBucmVtb3ZlZCA9IDANCiAgICAg ICAgbGNfX3N0YXRlID0ge2wgPSAweDU2MGU1OWU5ODQ4MCwgaSA9IDB9DQogICAgICAgIGxjID0g MHg1NjBlNTllOTg1ZjANCiAgICAgICAgX19mdW5jX18gPSAicmVtb3ZlX3VzZWxlc3Nfam9pbnMi DQojNSAgMHgwMDAwNTYwZTU3ZDg1N2JmIGluIHF1ZXJ5X3BsYW5uZXIgKHJvb3Q9MHg1NjBlNTll OGYzZTgsCnFwX2NhbGxiYWNrPTB4NTYwZTU3ZDhjMDU1IDxzdGFuZGFyZF9xcF9jYWxsYmFjaz4s IHFwX2V4dHJhPTB4N2ZmZjk1OTdlZjEwKQphdCBwbGFubWFpbi5jOjIyMw0KICAgICAgICBwYXJz ZSA9IDB4NTYwZTU5ZDVlNzY4DQogICAgICAgIGpvaW5saXN0ID0gMHg1NjBlNTllOTdkYzANCiAg ICAgICAgZmluYWxfcmVsID0gMHg3ZmZmOTU5N2VkYzANCiAgICAgICAgX19mdW5jX18gPSAicXVl cnlfcGxhbm5lciINCiM2ICAweDAwMDA1NjBlNTdkODgyOWMgaW4gZ3JvdXBpbmdfcGxhbm5lciAo cm9vdD0weDU2MGU1OWU4ZjNlOCwKdHVwbGVfZnJhY3Rpb249MCkgYXQgcGxhbm5lci5jOjE0OTYN CiAgICAgICAgc29ydF9pbnB1dF90YXJnZXRzID0gMHgwDQogICAgICAgIHNvcnRfaW5wdXRfdGFy Z2V0X3BhcmFsbGVsX3NhZmUgPSAxNDkNCiAgICAgICAgZ3JvdXBpbmdfdGFyZ2V0ID0gMHhmZmZm ZmZmZmZmZmZmZmZmDQogICAgICAgIHNjYW5qb2luX3RhcmdldCA9IDB4NTYwZTU5ZTgwMzk4DQog ICAgICAgIGFjdGl2ZVdpbmRvd3MgPSAweDANCiAgICAgICAgcXBfZXh0cmEgPSB7YWN0aXZlV2lu ZG93cyA9IDB4MCwgZ3NldF9kYXRhID0gMHgwfQ0KICAgICAgICBzb3J0X2lucHV0X3RhcmdldHNf Y29udGFpbl9zcmZzID0gMHg1NjBlNTllOTYwNzANCiAgICAgICAgaGF2ZV9ncm91cGluZyA9IGZh bHNlDQogICAgICAgIHdmbGlzdHMgPSAweDANCiAgICAgICAgZ3NldF9kYXRhID0gMHgwDQogICAg ICAgIHNvcnRfaW5wdXRfdGFyZ2V0ID0gMHg1NjBlMDAwMDAwMDENCiAgICAgICAgZ3JvdXBpbmdf dGFyZ2V0cyA9IDB4MA0KICAgICAgICBncm91cGluZ190YXJnZXRfcGFyYWxsZWxfc2FmZSA9IDI1 NQ0KICAgICAgICBzY2Fuam9pbl90YXJnZXRzID0gMHg3ZmZmOTU5N2VlNTANCiAgICAgICAgc2Nh bmpvaW5fdGFyZ2V0X3BhcmFsbGVsX3NhZmUgPSAxMjcNCiAgICAgICAgZ3JvdXBpbmdfdGFyZ2V0 c19jb250YWluX3NyZnMgPSAweGNlYTZhODI1MDAwMDAwMDANCiAgICAgICAgc2NhbmpvaW5fdGFy Z2V0c19jb250YWluX3NyZnMgPSAweDANCiAgICAgICAgc2NhbmpvaW5fdGFyZ2V0X3NhbWVfZXhw cnMgPSBmYWxzZQ0KICAgICAgICBwYXJzZSA9IDB4NTYwZTU5ZDVlNzY4DQogICAgICAgIG9mZnNl dF9lc3QgPSAwDQogICAgICAgIGNvdW50X2VzdCA9IDANCiAgICAgICAgbGltaXRfdHVwbGVzID0g LTENCiAgICAgICAgaGF2ZV9wb3N0cG9uZWRfc3JmcyA9IGZhbHNlDQogICAgICAgIGZpbmFsX3Rh cmdldCA9IDB4OTk1OTdlZTUwDQogICAgICAgIGZpbmFsX3RhcmdldHMgPSAweDg1OWU5NjA3MA0K ICAgICAgICBmaW5hbF90YXJnZXRzX2NvbnRhaW5fc3JmcyA9IDB4ZmZmZmZmZmY1OWQ1ZTc2OA0K ICAgICAgICBmaW5hbF90YXJnZXRfcGFyYWxsZWxfc2FmZSA9IDE1MQ0KICAgICAgICBjdXJyZW50 X3JlbCA9IDB4NTYwZTU5ZTgwNjM4DQogICAgICAgIGZpbmFsX3JlbCA9IDB4NTYwZTU5ZTgwMzk4 DQogICAgICAgIGV4dHJhID0ge2xpbWl0X25lZWRlZCA9IGZhbHNlLCBsaW1pdF90dXBsZXMgPSAw LCBjb3VudF9lc3QgPSAwLApvZmZzZXRfZXN0ID0gMH0NCiAgICAgICAgbGMgPSAweDE5NTk3ZWU1 MA0KICAgICAgICBfX2Z1bmNfXyA9ICJncm91cGluZ19wbGFubmVyIg0KIzcgIDB4MDAwMDU2MGU1 N2Q4Nzk0YiBpbiBzdWJxdWVyeV9wbGFubmVyIChnbG9iPTB4NTYwZTU5ZTgzNzgwLApwYXJzZT0w eDU2MGU1OWQ1ZTc2OCwgcGFyZW50X3Jvb3Q9MHgwLCBoYXNSZWN1cnNpb249ZmFsc2UsIHR1cGxl X2ZyYWN0aW9uPTApCmF0IHBsYW5uZXIuYzoxMDY1DQogICAgICAgIHJvb3QgPSAweDU2MGU1OWU4 ZjNlOA0KICAgICAgICBuZXdXaXRoQ2hlY2tPcHRpb25zID0gMHgwDQogICAgICAgIG5ld0hhdmlu ZyA9IDB4MA0KICAgICAgICBoYXNPdXRlckpvaW5zID0gdHJ1ZQ0KICAgICAgICBoYXNSZXN1bHRS VEVzID0gdHJ1ZQ0KICAgICAgICBmaW5hbF9yZWwgPSAweDU2MGU1OWQ1ZTc2OA0KICAgICAgICBs ID0gMHgwDQoNCg0KVGhhbmtzIHRvIFNRTFNtaXRoIC8gU1FMUmVkdWNlIGZvciB0aGUgZmluZC4N Cg0KLQ0KUm9iaW5zIFRoYXJha2FuDQpBbWF6b24gV2ViIFNlcnZpY2VzCgo= --===============5002091839867195029==--