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 1muEBz-0008Iz-1B for pgsql-bugs@arkaria.postgresql.org; Mon, 06 Dec 2021 13:38:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1muEBx-0003Oy-S9 for pgsql-bugs@arkaria.postgresql.org; Mon, 06 Dec 2021 13:38:05 +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 1mu7iQ-0002np-F3 for pgsql-bugs@lists.postgresql.org; Mon, 06 Dec 2021 06:43:10 +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 1mu7iJ-0003g9-Qg for pgsql-bugs@lists.postgresql.org; Mon, 06 Dec 2021 06:43: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=nAhXiyKN1fJNyeMISisdZgaFBfIl2tmmHU1f1zJ/tnc=; b=qIDlmNe9xg6qYt4APnURNLIMui oCJ2vrPW2ZOi8aRESbWU4F21jScQy8Dy7Hs4ZOrf+QXCEMrAVaelW4UTuGZeZXiFTW/W0quz71EWt AMKKhKPrK6zUqwcaAQSYhVVjLow/u6L7w0LpdeJXsjUEFz3rnsZU0+c5mu5sbvB9JQTllTEMRVuxq TpmLxVPYb2schEzHULOzh3/sl0mzlij/tER4T8aimyw+m6/8qyXftq1KP5tmnhX6nnNpUl3vcusXy inbedNmsjBCcncL7gYhtFfWj4f5/Sy4jklLdR6wxPaET/SxCOmq8ao1dtil37YZajqMv/XqNiUQPb +mPpSu2A==; 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 1mu7iJ-0001MB-Fn for pgsql-bugs@lists.postgresql.org; Mon, 06 Dec 2021 06:43:03 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mu7iI-0005CP-AB for pgsql-bugs@lists.postgresql.org; Mon, 06 Dec 2021 06:43:02 +0000 Content-Type: multipart/mixed; boundary="===============6688696446361601293==" MIME-Version: 1.0 Subject: BUG #17320: A SEGV in optimizer To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: 253540651@qq.com Reply-To: 253540651@qq.com, pgsql-bugs@lists.postgresql.org Date: Mon, 06 Dec 2021 06:42:57 +0000 Message-ID: <17320-70e37868182512ab@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 --===============6688696446361601293== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzMyMApMb2dnZWQgYnk6ICAgICAgICAgIFpoaXlvbmcgV3UKRW1haWwg YWRkcmVzczogICAgICAyNTM1NDA2NTFAcXEuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTQuMQpP cGVyYXRpbmcgc3lzdGVtOiAgIExpbnV4IHZlcnNpb24gNS4xMy4wLTEtTUFOSkFSTyAoYnVpbGR1 c2VyQExFR0lPTikKRGVzY3JpcHRpb246ICAgICAgICAKClBvQzoNCldJVEggUkVDVVJTSVZFIHgg KCB4ICkgQVMgKCBTRUxFQ1QgNCBVTklPTiAoIFdJVEggeCBBUyAoIFNFTEVDVCA1IFVOSU9OICgK V0lUSCBUSU1FU1RBTVAgQVMgKCBTRUxFQ1QgMiBVTklPTiAoIFdJVEggeCAoIHggKSBBUyAoIFNF TEVDVCAxIFVOSU9OICggV0lUSAp4IEFTICggU0VMRUNUIDYgRlJPTSAoIFZBTFVFUyAoIFJPVyAo IDEgLCAyICkgKSAsICggUk9XICggMSAsIDQgKSApICkgeCAoIHgKKSBVTklPTiAoIFdJVEggeCBB UyAoIFNFTEVDVCA3ICkgU0VMRUNUICogRlJPTSB4ICkgKSBTRUxFQ1QgKiBGUk9NIHggVU5JT04K U0VMRUNUICogRlJPTSB4ICkgKSBTRUxFQ1QgKiBGUk9NIHggKSApIFNFTEVDVCAqIEZST00gKCBT RUxFQ1QgKiBGUk9NIHgKV0hFUkUgeCA9IHggKSB4ICkgKSBTRUxFQ1QgKiBGUk9NIHggKSApIFNF QVJDSCBCUkVBRFRIIEZJUlNUIEJZIHggU0VUIE5DSEFSClNFTEVDVCAqIEZST00geCBXSEVSRSB4 IEJFVFdFRU4gMCBBTkQgMTAwMDAwMCA7DQogQ09QWSB4IEZST00gU1RESU4gV0hFUkUgeCBJTiAo IHggKCAxICwgNSApICkgOw0KIENSRUFURSBPUiBSRVBMQUNFIFRFTVAgVklFVyB4IEFTIFNFTEVD VCB4ICwgeCAoIHggKSBPVkVSICggT1JERVIgQlkgeCBST1dTCkJFVFdFRU4gMSBQUkVDRURJTkcg QU5EIDEgRk9MTE9XSU5HIEVYQ0xVREUgTk8gT1RIRVJTICkgQVMgeCBGUk9NIHggKCAxICwgMTAK KSB4IDsNCiBFWEVDVVRFIHggKCAnLTkyMjMzNzIwMzY4NTQ3NzU4MDAnICkgOw0KDQpBc2FuIExv RzoNCj09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09DQo9PTQyMTg9PUVSUk9SOiBBZGRyZXNzU2FuaXRpemVyOiBTRUdWIG9uIHVu a25vd24gYWRkcmVzcyAweDAwMDAwMDAwMDAwOCAocGMKMHgwMDAwMDBkYTIxNWMgYnAgMHgwMDAw MDAwMDAwMDEgc3AgMHg3ZmZkMzlkZTFkNTAgVDApDQo9PTQyMTg9PVRoZSBzaWduYWwgaXMgY2F1 c2VkIGJ5IGEgUkVBRCBtZW1vcnkgYWNjZXNzLg0KPT00MjE4PT1IaW50OiBhZGRyZXNzIHBvaW50 cyB0byB0aGUgemVybyBwYWdlLg0KICAgICMwIDB4ZGEyMTVjIGluIGJtc19hZGRfbWVtYmVycwov cm9vdC9wb3N0Z3Jlcy9ibGQvLi4vc3JjL2JhY2tlbmQvbm9kZXMvYml0bWFwc2V0LmM6ODA2OjkN CiAgICAjMSAweGYyNTUxOCBpbiBhZGRfdmFyc190b190YXJnZXRsaXN0Ci9yb290L3Bvc3RncmVz L2JsZC8uLi9zcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGxhbi9pbml0c3BsYW4uYzoyNTk6MzANCiAg ICAjMiAweGYyNTBjNyBpbiBidWlsZF9iYXNlX3JlbF90bGlzdHMKL3Jvb3QvcG9zdGdyZXMvYmxk Ly4uL3NyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL2luaXRzcGxhbi5jOjE5MjozDQogICAgIzMg MHhmMzJjNDUgaW4gcXVlcnlfcGxhbm5lcgovcm9vdC9wb3N0Z3Jlcy9ibGQvLi4vc3JjL2JhY2tl bmQvb3B0aW1pemVyL3BsYW4vcGxhbm1haW4uYzoxNzg6Mg0KICAgICM0IDB4ZjNmMjRlIGluIGdy b3VwaW5nX3BsYW5uZXIKL3Jvb3QvcG9zdGdyZXMvYmxkLy4uL3NyYy9iYWNrZW5kL29wdGltaXpl ci9wbGFuL3BsYW5uZXIuYzoxNDQ4OjE3DQogICAgIzUgMHhmMzk0YTcgaW4gc3VicXVlcnlfcGxh bm5lcgovcm9vdC9wb3N0Z3Jlcy9ibGQvLi4vc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BsYW4vcGxh bm5lci5jOjEwMjU6Mg0KICAgICM2IDB4ZTg1OWE2IGluIHNldF9zdWJxdWVyeV9wYXRobGlzdAov cm9vdC9wb3N0Z3Jlcy9ibGQvLi4vc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BhdGgvYWxscGF0aHMu YzoyMjI5OjE3DQogICAgIzcgMHhlODU5YTYgaW4gc2V0X3JlbF9zaXplCi9yb290L3Bvc3RncmVz L2JsZC8uLi9zcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGF0aC9hbGxwYXRocy5jOjQyMzo1DQogICAg IzggMHhlN2EwY2IgaW4gc2V0X2Jhc2VfcmVsX3NpemVzCi9yb290L3Bvc3RncmVzL2JsZC8uLi9z cmMvYmFja2VuZC9vcHRpbWl6ZXIvcGF0aC9hbGxwYXRocy5jOjMyNDozDQogICAgIzkgMHhlN2Ew Y2IgaW4gbWFrZV9vbmVfcmVsCi9yb290L3Bvc3RncmVzL2JsZC8uLi9zcmMvYmFja2VuZC9vcHRp bWl6ZXIvcGF0aC9hbGxwYXRocy5jOjE4NjoyDQogICAgIzEwIDB4ZjMyY2QyIGluIHF1ZXJ5X3Bs YW5uZXIKL3Jvb3QvcG9zdGdyZXMvYmxkLy4uL3NyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL3Bs YW5tYWluLmM6Mjc2OjE0DQogICAgIzExIDB4ZjNmMjRlIGluIGdyb3VwaW5nX3BsYW5uZXIKL3Jv b3QvcG9zdGdyZXMvYmxkLy4uL3NyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL3BsYW5uZXIuYzox NDQ4OjE3DQogICAgIzEyIDB4ZjM5NGE3IGluIHN1YnF1ZXJ5X3BsYW5uZXIKL3Jvb3QvcG9zdGdy ZXMvYmxkLy4uL3NyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL3BsYW5uZXIuYzoxMDI1OjINCiAg ICAjMTMgMHhmYTExNmMgaW4gcmVjdXJzZV9zZXRfb3BlcmF0aW9ucwovcm9vdC9wb3N0Z3Jlcy9i bGQvLi4vc3JjL2JhY2tlbmQvb3B0aW1pemVyL3ByZXAvcHJlcHVuaW9uLmM6MjM5OjI4DQogICAg IzE0IDB4ZmEwNGVhIGluIGdlbmVyYXRlX3JlY3Vyc2lvbl9wYXRoCi9yb290L3Bvc3RncmVzL2Js ZC8uLi9zcmMvYmFja2VuZC9vcHRpbWl6ZXIvcHJlcC9wcmVwdW5pb24uYzo0Njk6OQ0KICAgICMx NSAweGZhMDRlYSBpbiBwbGFuX3NldF9vcGVyYXRpb25zCi9yb290L3Bvc3RncmVzL2JsZC8uLi9z cmMvYmFja2VuZC9vcHRpbWl6ZXIvcHJlcC9wcmVwdW5pb24uYzoxNTY6MTUNCiAgICAjMTYgMHhm M2MwMzUgaW4gZ3JvdXBpbmdfcGxhbm5lcgovcm9vdC9wb3N0Z3Jlcy9ibGQvLi4vc3JjL2JhY2tl bmQvb3B0aW1pemVyL3BsYW4vcGxhbm5lci5jOjEyODY6MTcNCiAgICAjMTcgMHhmMzk0YTcgaW4g c3VicXVlcnlfcGxhbm5lcgovcm9vdC9wb3N0Z3Jlcy9ibGQvLi4vc3JjL2JhY2tlbmQvb3B0aW1p emVyL3BsYW4vcGxhbm5lci5jOjEwMjU6Mg0KICAgICMxOCAweGY3OTBjZCBpbiBTU19wcm9jZXNz X2N0ZXMKL3Jvb3QvcG9zdGdyZXMvYmxkLy4uL3NyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL3N1 YnNlbGVjdC5jOjk4MDoxMw0KICAgICMxOSAweGYzNTUyYyBpbiBzdWJxdWVyeV9wbGFubmVyCi9y b290L3Bvc3RncmVzL2JsZC8uLi9zcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGxhbi9wbGFubmVyLmM6 NjUwOjMNCiAgICAjMjAgMHhmMzMzMDQgaW4gc3RhbmRhcmRfcGxhbm5lcgovcm9vdC9wb3N0Z3Jl cy9ibGQvLi4vc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BsYW4vcGxhbm5lci5jOjQwNjo5DQogICAg IzIxIDB4ZjMyZmE4IGluIHBsYW5uZXIKL3Jvb3QvcG9zdGdyZXMvYmxkLy4uL3NyYy9iYWNrZW5k L29wdGltaXplci9wbGFuL3BsYW5uZXIuYzoyNzc6MTINCiAgICAjMjIgMHgxMzM3OWM3IGluIHBn X3BsYW5fcXVlcnkKL3Jvb3QvcG9zdGdyZXMvYmxkLy4uL3NyYy9iYWNrZW5kL3Rjb3AvcG9zdGdy ZXMuYzo4NDc6OQ0KICAgICMyMyAweDEzMzc5YzcgaW4gcGdfcGxhbl9xdWVyaWVzCi9yb290L3Bv c3RncmVzL2JsZC8uLi9zcmMvYmFja2VuZC90Y29wL3Bvc3RncmVzLmM6OTM5OjExDQogICAgIzI0 IDB4MTM0NTQ4NyBpbiBleGVjX3NpbXBsZV9xdWVyeQovcm9vdC9wb3N0Z3Jlcy9ibGQvLi4vc3Jj L2JhY2tlbmQvdGNvcC9wb3N0Z3Jlcy5jOjExMzM6MTkNCiAgICAjMjUgMHgxMzNkYTczIGluIFBv c3RncmVzTWFpbgovcm9vdC9wb3N0Z3Jlcy9ibGQvLi4vc3JjL2JhY2tlbmQvdGNvcC9wb3N0Z3Jl cy5jDQogICAgIzI2IDB4MTA5NGQ2MyBpbiBCYWNrZW5kUnVuCi9yb290L3Bvc3RncmVzL2JsZC8u Li9zcmMvYmFja2VuZC9wb3N0bWFzdGVyL3Bvc3RtYXN0ZXIuYzo0NTg0OjINCiAgICAjMjcgMHgx MDkzMzNkIGluIEJhY2tlbmRTdGFydHVwCi9yb290L3Bvc3RncmVzL2JsZC8uLi9zcmMvYmFja2Vu ZC9wb3N0bWFzdGVyL3Bvc3RtYXN0ZXIuYzo0MzEyOjMNCiAgICAjMjggMHgxMDkzMzNkIGluIFNl cnZlckxvb3AKL3Jvb3QvcG9zdGdyZXMvYmxkLy4uL3NyYy9iYWNrZW5kL3Bvc3RtYXN0ZXIvcG9z dG1hc3Rlci5jOjE4MDE6Nw0KICAgICMyOSAweDEwODk4ZTMgaW4gUG9zdG1hc3Rlck1haW4KL3Jv b3QvcG9zdGdyZXMvYmxkLy4uL3NyYy9iYWNrZW5kL3Bvc3RtYXN0ZXIvcG9zdG1hc3Rlci5jOjE0 NzM6MTENCiAgICAjMzAgMHhkOWQ0NjMgaW4gbWFpbgovcm9vdC9wb3N0Z3Jlcy9ibGQvLi4vc3Jj L2JhY2tlbmQvbWFpbi9tYWluLmM6MTk4OjMNCiAgICAjMzEgMHg3ZjlhOWYyY2UwYjIgaW4gX19s aWJjX3N0YXJ0X21haW4KL2J1aWxkL2dsaWJjLWVYMXRNQi9nbGliYy0yLjMxL2NzdS8uLi9jc3Uv bGliYy1zdGFydC5jOjMwODoxNg0KICAgICMzMiAweDQ5YmMxZCBpbiBfc3RhcnQgKC91c3IvbG9j YWwvcGdzcWwvYmluL3Bvc3RncmVzKzB4NDliYzFkKQ0KDQpBZGRyZXNzU2FuaXRpemVyIGNhbiBu b3QgcHJvdmlkZSBhZGRpdGlvbmFsIGluZm8uDQpTVU1NQVJZOiBBZGRyZXNzU2FuaXRpemVyOiBT RUdWCi9yb290L3Bvc3RncmVzL2JsZC8uLi9zcmMvYmFja2VuZC9ub2Rlcy9iaXRtYXBzZXQuYzo4 MDY6OSBpbgpibXNfYWRkX21lbWJlcnMNCj09NDIxOD09QUJPUlRJTkcKCg== --===============6688696446361601293==--