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 1p84jO-00022Z-1d for pgsql-bugs@arkaria.postgresql.org; Wed, 21 Dec 2022 19:26:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p84jM-000325-RM for pgsql-bugs@arkaria.postgresql.org; Wed, 21 Dec 2022 19:26:20 +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 1p84Ql-0000PK-Me for pgsql-bugs@lists.postgresql.org; Wed, 21 Dec 2022 19:07: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 1p84Qi-0001xa-Ax for pgsql-bugs@lists.postgresql.org; Wed, 21 Dec 2022 19:07:06 +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=5+b/kdLbU3hhvd7BY36nvpRil3Cy0e8GqC7/sNTdbmY=; b=Yg0tZylHblJMcvXj+0/ImAIsND jiPA4wYmbaNN3ShMmyglGJ7iUvkQeXP4ZPqBiD0WljoRwD3wCC6ZbYGsKIkA5tNiqaMcDPWrinhko QVPZTKeTrBmj2dhy9MVmz5dyALSQLkwYW4y1tS2XjnAzAJ/MkzfORoEWUctYdovTS9SwX+yN978nI gp86MmmYD5Clp0TwJBal+tQeBjCQ7Wt7pS7m/AWv3P71h5K2oxdXDJbc1qFMXzBAimbCjKJUxsPlc p8pvUU6Moj5tn5Re6MlyzBf0rS54Ft603VLf5RAXH3VbMJtSnwJAdXFdtSt5MZX2cul88iQmxlsCQ aqnIFYmw==; 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 1p84Qh-0005Lu-OJ for pgsql-bugs@lists.postgresql.org; Wed, 21 Dec 2022 19:07:03 +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 1p84Qg-001COD-1b for pgsql-bugs@lists.postgresql.org; Wed, 21 Dec 2022 19:07:02 +0000 Content-Type: multipart/mixed; boundary="===============2176908446945124398==" MIME-Version: 1.0 Subject: BUG #17727: A query crashes server process: ... was terminated by signal 7: Bus error / Segmentation Fault To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: oserov@clickup.com Reply-To: oserov@clickup.com, pgsql-bugs@lists.postgresql.org Date: Wed, 21 Dec 2022 19:06:32 +0000 Message-ID: <17727-c9a10259e190c8b1@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 --===============2176908446945124398== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzcyNwpMb2dnZWQgYnk6ICAgICAgICAgIE9sZWcgUwpFbWFpbCBhZGRy ZXNzOiAgICAgIG9zZXJvdkBjbGlja3VwLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDE0LjUKT3Bl cmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjIuMDQgTFRTCkRlc2NyaXB0aW9uOiAgICAgICAgCgpJ IGhhdmUgYSBxdWVyeSB0aGF0IGNvbnNpc3RlbnRseSByZXN1bHRzIGluIHNlcnZlciBjcmFzaCBh bmQgInNlcnZlciBwcm9jZXNzCi4uLiB3YXMgdGVybWluYXRlZCBieSBzaWduYWwgNzogQnVzIGVy cm9yIiBydW5uaW5nIG9uIGFueSByZXBsaWNhIG9yIG1hc3RlcgpvZiB0aGUgREIuIEkgYWxzbyBo YXZlIGEgbW9yZSBnZW5lcmljIHF1ZXJ5IHRoYXQgYWxzbyBjcmFzaGVzIG90aGVyCm1hc3RlcnMv cmVwbGljYXMgaW4gcHJvZCBlbnZpcm9ubWVudCBidXQgd2l0aCAnU2VnbWVudGF0aW9uIEZhdWx0 Jy4gSSBjYW4ndApyZXByb2R1Y2UgdGhlIHNhbWUgY3Jhc2ggaW4gb3RoZXIgbm9uLXByb2QgZW52 aXJvbm1lbnRzLiBJIGFtIHVuYWJsZSB0bwpwcm92aWRlIHJlcHJvIHN0ZXBzIHRoYXQgY291bGQg cmVwcm9kdWNlIHRoaXMgZXJyb3Igb24gYSBsb2NhbCBtYWNoaW5lIGFuZApsb29raW5nIGZvciBt b3JlIGd1aWRhbmNlIGhvdyB0byBkZWJ1Zy9taXRpZ2F0ZSB0aGlzIGVycm9yLiANCg0KVGhlIHF1 ZXJ5IGJlbG93IGlzIGEgbWluaW1hbCBxdWVyeSB0aGF0IHJlcHJvZHVjZXMgdGhpcyBlcnJvci4g UmVtb3ZpbmcgbW9yZQpjb2x1bW5zLCBjbGF1c2VzLCBjaGFuZ2luZyBjb25kaXRpb25zIG1ha2Vz IHRoZSBlcnJvciBnbyBhd2F5LiANCg0KUXVlcnk6DQpXSVRIIHVuaW9uX3RhYmxlIEFTICgNCiAg ICBTRUxFQ1QgaWQsICdkdW1teScsIE5PVygpLCAnZHVtbXknLCBOT1coKSwgTk9XKCksIE5PVygp LCAnZHVtbXknLAonZHVtbXknLCAnZHVtbXknLCBOT1coKSwgTk9XKCksICdkdW1teScsICdkdW1t eScsICdkdW1teScsICdkdW1teScsCmZpbmdlcnByaW50LCAnZHVtbXknLCAnZHVtbXknLCAnZHVt bXknLCAnZHVtbXknLCAnZHVtbXknLCBOT1coKSwKNDAwMDEwMjk0NDUwMDAwMDAwMA0KICAgIEZS T00gc2gwMDAxLmFzc2V0cw0KICAgIFVOSU9OIEFMTA0KICAgIFNFTEVDVCBpZCwgJ2R1bW15Jywg Tk9XKCksICdkdW1teScsIE5PVygpLCBOT1coKSwgTk9XKCksICdkdW1teScsCidkdW1teScsICdk dW1teScsIE5PVygpLCBOT1coKSwgJ2R1bW15JywgJ2R1bW15JywgJ2R1bW15JywgJ2R1bW15JywK ZmluZ2VycHJpbnQsICdkdW1teScsICdkdW1teScsICdkdW1teScsICdkdW1teScsICdkdW1teScs IE5PVygpLAo0MDAwMTAyOTQ0NTAwMDAwMDAwDQogICAgRlJPTSBzaDAwMDIuYXNzZXRzDQogICAg VU5JT04gQUxMDQogICAgU0VMRUNUIGlkLCAnZHVtbXknLCBOT1coKSwgJ2R1bW15JywgTk9XKCks IE5PVygpLCBOT1coKSwgJ2R1bW15JywKJ2R1bW15JywgJ2R1bW15JywgTk9XKCksIE5PVygpLCAn ZHVtbXknLCAnZHVtbXknLCAnZHVtbXknLCAnZHVtbXknLApmaW5nZXJwcmludCwgJ2R1bW15Jywg J2R1bW15JywgJ2R1bW15JywgJ2R1bW15JywgJ2R1bW15JywgTk9XKCksCjQwMDAxMDI5NDQ1MDAw MDAwMDANCiAgICBGUk9NIHNoMDAwMy5hc3NldHMNCiAgICBVTklPTiBBTEwNCiAgICBTRUxFQ1Qg aWQsICdkdW1teScsIE5PVygpLCAnZHVtbXknLCBOT1coKSwgTk9XKCksIE5PVygpLCAnZHVtbXkn LAonZHVtbXknLCAnZHVtbXknLCBOT1coKSwgTk9XKCksICdkdW1teScsICdkdW1teScsICdkdW1t eScsICdkdW1teScsCmZpbmdlcnByaW50LCAnZHVtbXknLCAnZHVtbXknLCAnZHVtbXknLCAnZHVt bXknLCAnZHVtbXknLCBOT1coKSwKNDAwMDEwMjk0NDUwMDAwMDAwMA0KICAgIEZST00gc2gwMDA0 LmFzc2V0cw0KICAgIFVOSU9OIEFMTA0KICAgIFNFTEVDVCBpZCwgJ2R1bW15JywgTk9XKCksICdk dW1teScsIE5PVygpLCBOT1coKSwgTk9XKCksICdkdW1teScsCidkdW1teScsICdkdW1teScsIE5P VygpLCBOT1coKSwgJ2R1bW15JywgJ2R1bW15JywgJ2R1bW15JywgJ2R1bW15JywKZmluZ2VycHJp bnQsICdkdW1teScsICdkdW1teScsICdkdW1teScsICdkdW1teScsICdkdW1teScsIE5PVygpLAo0 MDAwMTAyOTQ0NTAwMDAwMDAwDQogICAgRlJPTSBzaDAwMDUuYXNzZXRzDQogICAgVU5JT04gQUxM DQogICAgU0VMRUNUIGlkLCAnZHVtbXknLCBOT1coKSwgJ2R1bW15JywgTk9XKCksIE5PVygpLCBO T1coKSwgJ2R1bW15JywKJ2R1bW15JywgJ2R1bW15JywgTk9XKCksIE5PVygpLCAnZHVtbXknLCAn ZHVtbXknLCAnZHVtbXknLCAnZHVtbXknLApmaW5nZXJwcmludCwgJ2R1bW15JywgJ2R1bW15Jywg J2R1bW15JywgJ2R1bW15JywgJ2R1bW15JywgTk9XKCksCjQwMDAxMDI5NDQ1MDAwMDAwMDANCiAg ICBGUk9NIHNoMDAxMC5hc3NldHMNCiAgICBVTklPTiBBTEwNCiAgICBTRUxFQ1QgaWQsICdkdW1t eScsIE5PVygpLCAnZHVtbXknLCBOT1coKSwgTk9XKCksIE5PVygpLCAnZHVtbXknLAonZHVtbXkn LCAnZHVtbXknLCBOT1coKSwgTk9XKCksICdkdW1teScsICdkdW1teScsICdkdW1teScsICdkdW1t eScsCmZpbmdlcnByaW50LCAnZHVtbXknLCAnZHVtbXknLCAnZHVtbXknLCAnZHVtbXknLCAnZHVt bXknLCBOT1coKSwKNDAwMDEwMjk0NDUwMDAwMDAwMA0KICAgIEZST00gc2gwMDExLmFzc2V0cw0K KQ0KU0VMRUNUIHVuaW9uX3RhYmxlOjp0ZXh0DQpGUk9NIHVuaW9uX3RhYmxlDQpXSEVSRSBpZCA8 IDQwMDAxMDI5NDQ1MDAwMDAwMDAgQU5EIGlkID4gMDsNCg0KUXVlcnkgcGxhbjoNCiAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBRVUVSWSBQTEFODQotLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiBSZXN1bHQgIChjb3N0PTE2NzcuMzIuLjEw NDY2NS4yOCByb3dzPTExOTI4MyB3aWR0aD0zMikNCiAgIC0+ICBBcHBlbmQgIChjb3N0PTE2Nzcu MzIuLjEwMjg3Ni4wNCByb3dzPTExOTI4MyB3aWR0aD0zMikNCiAgICAgICAgIC0+ICBCaXRtYXAg SGVhcCBTY2FuIG9uIGFzc2V0cyAgKGNvc3Q9MTY3Ny4zMi4uMTAyMjYzLjYxCnJvd3M9MTE5Mjc3 IHdpZHRoPTMyKQ0KICAgICAgICAgICAgICAgUmVjaGVjayBDb25kOiAoKGlkIDwgJzQwMDAxMDI5 NDQ1MDAwMDAwMDAnOjpiaWdpbnQpIEFORCAoaWQgPgowKSkNCiAgICAgICAgICAgICAgIC0+ICBC aXRtYXAgSW5kZXggU2NhbiBvbiBhc3NldHNfcGtleSAgKGNvc3Q9MC4wMC4uMTY0Ny41MApyb3dz PTExOTI3NyB3aWR0aD0wKQ0KICAgICAgICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKChpZCA8 ICc0MDAwMTAyOTQ0NTAwMDAwMDAwJzo6YmlnaW50KSBBTkQKKGlkID4gMCkpDQogICAgICAgICAt PiAgSW5kZXggU2NhbiB1c2luZyBhc3NldHNfcGtleSBvbiBhc3NldHMgYXNzZXRzXzEgCihjb3N0 PTAuNDMuLjIuNjcgcm93cz0xIHdpZHRoPTMyKQ0KICAgICAgICAgICAgICAgSW5kZXggQ29uZDog KChpZCA8ICc0MDAwMTAyOTQ0NTAwMDAwMDAwJzo6YmlnaW50KSBBTkQgKGlkID4KMCkpDQogICAg ICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyBhc3NldHNfcGtleSBvbiBhc3NldHMgYXNzZXRzXzIg Cihjb3N0PTAuNDMuLjIuNjcgcm93cz0xIHdpZHRoPTMyKQ0KICAgICAgICAgICAgICAgSW5kZXgg Q29uZDogKChpZCA8ICc0MDAwMTAyOTQ0NTAwMDAwMDAwJzo6YmlnaW50KSBBTkQgKGlkID4KMCkp DQogICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyBhc3NldHNfcGtleSBvbiBhc3NldHMgYXNz ZXRzXzMgCihjb3N0PTAuNDMuLjIuNjcgcm93cz0xIHdpZHRoPTMyKQ0KICAgICAgICAgICAgICAg SW5kZXggQ29uZDogKChpZCA8ICc0MDAwMTAyOTQ0NTAwMDAwMDAwJzo6YmlnaW50KSBBTkQgKGlk ID4KMCkpDQogICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyBhc3NldHNfcGtleSBvbiBhc3Nl dHMgYXNzZXRzXzQgCihjb3N0PTAuNDMuLjIuNjcgcm93cz0xIHdpZHRoPTMyKQ0KICAgICAgICAg ICAgICAgSW5kZXggQ29uZDogKChpZCA8ICc0MDAwMTAyOTQ0NTAwMDAwMDAwJzo6YmlnaW50KSBB TkQgKGlkID4KMCkpDQogICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyBhc3NldHNfcGtleSBv biBhc3NldHMgYXNzZXRzXzUgCihjb3N0PTAuNDMuLjIuNjcgcm93cz0xIHdpZHRoPTMyKQ0KICAg ICAgICAgICAgICAgSW5kZXggQ29uZDogKChpZCA8ICc0MDAwMTAyOTQ0NTAwMDAwMDAwJzo6Ymln aW50KSBBTkQgKGlkID4KMCkpDQogICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyBhc3NldHNf cGtleSBvbiBhc3NldHMgYXNzZXRzXzYgCihjb3N0PTAuNDMuLjIuNjcgcm93cz0xIHdpZHRoPTMy KQ0KICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKChpZCA8ICc0MDAwMTAyOTQ0NTAwMDAwMDAw Jzo6YmlnaW50KSBBTkQgKGlkID4KMCkpDQogSklUOg0KICAgRnVuY3Rpb25zOiAyOQ0KICAgT3B0 aW9uczogSW5saW5pbmcgZmFsc2UsIE9wdGltaXphdGlvbiBmYWxzZSwgRXhwcmVzc2lvbnMgdHJ1 ZSwgRGVmb3JtaW5nCnRydWUNCigyMSByb3dzKQ0KDQpQRyBWZXJzaW9uOg0KIFBvc3RncmVTUUwg MTQuNSAoVWJ1bnR1IDE0LjUtMHVidW50dTAuMjIuMDQuMSkgb24KYWFyY2g2NC11bmtub3duLWxp bnV4LWdudSwgY29tcGlsZWQgYnkgZ2NjIChVYnVudHUgMTEuMi4wLTE5dWJ1bnR1MSkgMTEuMi4w LAo2NC1iaXQNCg0KTG9nOg0KDQoyMDIyLTEyLTIxIDEwOjQ4OjI0IFBTVCBbMTQ2Nl06IFsyNS0x XSB1c2VyPSxkYj0sYXBwPSBMT0c6ICBkYXRhYmFzZSBzeXN0ZW0KaXMgcmVhZHkgdG8gYWNjZXB0 IHJlYWQtb25seSBjb25uZWN0aW9ucw0KMjAyMi0xMi0yMSAxMDo0ODoyNCBQU1QgWzE0MTkyXTog WzYtMV0gdXNlcj0sZGI9LGFwcD0gTE9HOiAgaW52YWxpZCByZWNvcmQKbGVuZ3RoIGF0IERCMi9C OUU5REU3MDogd2FudGVkIDI0LCBnb3QgMA0KMjAyMi0xMi0yMSAxMDo0ODoyNCBQU1QgWzE0MTk4 XTogWzEtMV0gdXNlcj0sZGI9LGFwcD0gTE9HOiAgc3RhcnRlZApzdHJlYW1pbmcgV0FMIGZyb20g cHJpbWFyeSBhdCBEQjIvQjkwMDAwMDAgb24gdGltZWxpbmUgMQ0KMjAyMi0xMi0yMSAxMDo0OTox NCBQU1QgWzE0NjZdOiBbMjYtMV0gdXNlcj0sZGI9LGFwcD0gTE9HOiAgc2VydmVyIHByb2Nlc3MK KFBJRCAxNTQ1Mykgd2FzIHRlcm1pbmF0ZWQgYnkgc2lnbmFsIDc6IEJ1cyBlcnJvcg0KMjAyMi0x Mi0yMSAxMDo0OToxNCBQU1QgWzE0NjZdOiBbMjctMV0gdXNlcj0sZGI9LGFwcD0gREVUQUlMOiAg RmFpbGVkCnByb2Nlc3Mgd2FzIHJ1bm5pbmc6IFdJVEggdW5pb25fdGFibGUgQVMgKA0KCSAgICBT RUxFQ1QNCgkgICAgICAgIGlkLCAnZHVtbXknLCBOT1coKSwgJ2R1bW15JywgTk9XKCksIE5PVygp LCBOT1coKSwgJ2R1bW15JywgJ2R1bW15JywKJ2R1bW15JywgTk9XKCksIE5PVygpLCAnZHVtbXkn LCAnZHVtbXknLCAnZHVtbXknLCAnZHVtbXknLCBmaW5nZXJwcmludCwKJ2R1bW15JywgJ2R1bW15 JywgJ2R1bW15JywgJ2R1bW15JywgJ2R1bW15JywgTk9XKCksIDQwMDAxMDI5NDQ1MDAwMDAwMDAN CgkgICAgRlJPTQ0KCSAgICAgICAgc2gwMDAxLmFzc2V0cw0KCSAgICBVTklPTiBBTEwNCgkgICAg U0VMRUNUDQoJICAgICAgICBpZCwgJ2R1bW15JywgTk9XKCksICdkdW1teScsIE5PVygpLCBOT1co KSwgTk9XKCksICdkdW1teScsICdkdW1teScsCidkdW1teScsIE5PVygpLCBOT1coKSwgJ2R1bW15 JywgJ2R1bW15JywgJ2R1bW15JywgJ2R1bW15JywgZmluZ2VycHJpbnQsCidkdW1teScsICdkdW1t eScsICdkdW1teScsICdkdW1teScsICdkdW1teScsIE5PVygpLCA0MDAwMTAyOTQ0NTAwMDAwMDAw DQoJICAgIEZST00NCgkgICAgICAgIHNoMDAwMi5hc3NldHMNCgkgICAgVU5JT04gQUxMDQoJICAg IFNFTEVDVA0KCSAgICAgICAgaWQsICdkdW1teScsIE5PVygpLCAnZHVtbXknLCBOT1coKSwgTk9X KCksIE5PVygpLCAnZHVtbXknLCAnZHVtbXknLAonZHVtbXknLCBOT1coKSwgTk9XKCksICdkdW1t eScsICdkdW1teScsICdkdW1teScsICdkdW1teScsIGZpbmdlcnByaW50LAonZHVtbXknLCAnZHVt bXknLCAnZHVtbXknLCAnZHVtbXknLCAnZHVtbXknLCBOT1coKSwgNDAwMDEwMjk0NDUwMDAwMDAw MA0KCSAgICBGUk9NDQoJICAgICAgICBzaDAwMDMuYXNzZXRzDQoJICAgIFVOSU9OIEFMTA0KCSAg ICBTRUxFQ1QNCgkgICAgICAgIGlkLCAnZHVtbXknLCBOT1coKSwgJ2R1bW15JywgTk9XKCksIE5P VygpLCBOT1coKSwgJ2R1bW15JywgJ2R1bW15JywKJ2R1bW15JywgTk9XKCksIE5PVygpLCAnZHVt bXknLCAnZHVtbXknLCAnZHVtbXknLCAnZHVtbXknLCBmaW5nZXJwcmludCwKJ2R1bW15JywgJ2R1 bW0NCjIwMjItMTItMjEgMTA6NDk6MTQgUFNUIFsxNDY2XTogWzI4LTFdIHVzZXI9LGRiPSxhcHA9 IExPRzogIHRlcm1pbmF0aW5nIGFueQpvdGhlciBhY3RpdmUgc2VydmVyIHByb2Nlc3Nlcw0KMjAy Mi0xMi0yMSAxMDo0OToxNCBQU1QgWzE1NjQzXTogWzEtMV0gdXNlcj1wb3N0Z3JlcyxkYj08Pixh cHA9W3Vua25vd25dCkZBVEFMOiAgdGhlIGRhdGFiYXNlIHN5c3RlbSBpcyBpbiByZWNvdmVyeSBt b2RlDQoyMDIyLTEyLTIxIDEwOjQ5OjE0IFBTVCBbMTQ2Nl06IFsyOS0xXSB1c2VyPSxkYj0sYXBw PSBMT0c6ICBhbGwgc2VydmVyCnByb2Nlc3NlcyB0ZXJtaW5hdGVkOyByZWluaXRpYWxpemluZwoK --===============2176908446945124398==--