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 1m1QL3-0007yV-Ir for pgsql-bugs@arkaria.postgresql.org; Thu, 08 Jul 2021 09:28:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m1QL2-0000bu-Ir for pgsql-bugs@arkaria.postgresql.org; Thu, 08 Jul 2021 09:28:56 +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 1m1PU1-0000nh-4L for pgsql-bugs@lists.postgresql.org; Thu, 08 Jul 2021 08:34:09 +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 1m1PTy-0004CY-ME for pgsql-bugs@lists.postgresql.org; Thu, 08 Jul 2021 08:34:08 +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=ahSQtoUrpecRni8E6bARygMTq7itKuhpB7IdREHicMY=; b=gXOE6/s/rAbSlzQrfI8V97+zeX vFEwhFiOImExbvUel5RTXVG5MD8sA18nbt2e4GyRPi4y5AUNZcxkJkJKUgX5/iouInP9y7APnFqtt P3RZr33ohsLZr6tz4JAp4za/XoNQJ7hO/3lyp6R2+TjgDhL9a3iMbfg0zUQNG4NMLLG3lQN+FjZjs yWpdF54U9Q7A6Xf/DsH+gDZeKL3R4nuzLX6wkx7skS8DfOHsKl54j7H841z/NohP1jWqjfJi6wM45 bREd+UCIW7UrhkrqqAphB3LHMaX6iU5b+nDKIXL/0G85CFdlRNCC3p1xZ2ZpmYFxoA7QS4ramRsTW uq9LJn/w==; 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 1m1PTx-0002LX-BO for pgsql-bugs@lists.postgresql.org; Thu, 08 Jul 2021 08:34:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m1PTu-0001d5-Dr for pgsql-bugs@lists.postgresql.org; Thu, 08 Jul 2021 08:34:02 +0000 Content-Type: multipart/mixed; boundary="===============5992705569558153966==" MIME-Version: 1.0 Subject: BUG #17094: FailedAssertion at planner.c To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: cyg0810@gmail.com Reply-To: cyg0810@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 08 Jul 2021 08:33:07 +0000 Message-ID: <17094-bf15dff55eaf2e28@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 --===============5992705569558153966== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzA5NApMb2dnZWQgYnk6ICAgICAgICAgIHlhb2d1YW5nIGNoZW4KRW1h aWwgYWRkcmVzczogICAgICBjeWcwODEwQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDE0 YmV0YTEKT3BlcmF0aW5nIHN5c3RlbTogICBMaW51eCBzdXBlcnNpeCA1LjQuMC0zOS1nZW5lcmlj ICM0My1VYnVudHUgU01QIEZyaQpEZXNjcmlwdGlvbjogICAgICAgIAoKcnVuIHRoZSBmb2xsb3dp bmcgc3FsIGNvbW1hbmQgdGhyb3VnaCBjbGllbnQgYW5kIHRoZSBQb3N0Z3JlU1FMIGRhdGFiYXNl CnByb2Nlc3Mgd2lsbCBjcmFzaDoNCg0KQ1JFQVRFIFRBQkxFIHYwICggdjQgSU5UICwgdjMgSU5U IFVOSVFVRSAsIHYyIElOVCAsIHYxIElOVCBVTklRVUUgKSA7IA0KIENSRUFURSBPUiBSRVBMQUNF IFJVTEUgdjEgQVMgT04gSU5TRVJUIFRPIHYwIERPIElOU1RFQUQgTk9USUZZIENPTVBSRVNTSU9O CjsNCiBDT1BZICggU0VMRUNUIDMyIEVYQ0VQVCBTRUxFQ1QgdjMgKyAxNiBGUk9NIHYwICkgVE8g U1RET1VUIENTViBIRUFERVIgOw0KIFdJVEggdjIgQVMgKCBJTlNFUlQgSU5UTyB2MCBWQUxVRVMg KCAwICkgKSBERUxFVEUgRlJPTSB2MCBXSEVSRSB2MyA9IC0gLSAtCi0gNDggOw0KDQoNCmFzYW4g cmVwb3J0Og0KDQpBZGRyZXNzU2FuaXRpemVyOkRFQURMWVNJR05BTD09PT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09DQo9PTQ1Mzg3 MD09RVJST1I6IEFkZHJlc3NTYW5pdGl6ZXI6IFNFR1Ygb24gdW5rbm93biBhZGRyZXNzIDB4MDAw MDAwMDAwMDA4CihwYyAweDAwMDAwMTYzZDlkNSBicCAweDdmZmY1YTM1Y2U1MCBzcCAweDdmZmY1 YTM1Y2UyMCBUMCkNCj09NDUzODcwPT1UaGUgc2lnbmFsIGlzIGNhdXNlZCBieSBhIFJFQUQgbWVt b3J5IGFjY2Vzcy4NCj09NDUzODcwPT1IaW50OiBhZGRyZXNzIHBvaW50cyB0byB0aGUgemVybyBw YWdlLg0KICAgICMwIDB4MTYzZDlkNCBpbiByZXBsYWNlX2VtcHR5X2pvaW50cmVlCi9ob21lL3N1 cGVyc2l4L2Z1enovc2VjdXJpdHkvUG9zdGdyZVNRTC9wb3N0Z3Jlcy9idWlsZC8uLi9zcmMvYmFj a2VuZC9vcHRpbWl6ZXIvcHJlcC9wcmVwam9pbnRyZWUuYzoxNTc6MjMNCiAgICAjMSAweDE1YWRi YWEgaW4gc3VicXVlcnlfcGxhbm5lcgovaG9tZS9zdXBlcnNpeC9mdXp6L3NlY3VyaXR5L1Bvc3Rn cmVTUUwvcG9zdGdyZXMvYnVpbGQvLi4vc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BsYW4vcGxhbm5l ci5jOjY1MDoyDQogICAgIzIgMHgxNjIwYjA2IGluIFNTX3Byb2Nlc3NfY3RlcwovaG9tZS9zdXBl cnNpeC9mdXp6L3NlY3VyaXR5L1Bvc3RncmVTUUwvcG9zdGdyZXMvYnVpbGQvLi4vc3JjL2JhY2tl bmQvb3B0aW1pemVyL3BsYW4vc3Vic2VsZWN0LmM6OTgyOjEzDQogICAgIzMgMHgxNWFkYjVhIGlu IHN1YnF1ZXJ5X3BsYW5uZXIKL2hvbWUvc3VwZXJzaXgvZnV6ei9zZWN1cml0eS9Qb3N0Z3JlU1FM L3Bvc3RncmVzL2J1aWxkLy4uL3NyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL3BsYW5uZXIuYzo2 NDQ6Mw0KICAgICM0IDB4MTVhYTU1NSBpbiBzdGFuZGFyZF9wbGFubmVyCi9ob21lL3N1cGVyc2l4 L2Z1enovc2VjdXJpdHkvUG9zdGdyZVNRTC9wb3N0Z3Jlcy9idWlsZC8uLi9zcmMvYmFja2VuZC9v cHRpbWl6ZXIvcGxhbi9wbGFubmVyLmM6NDAwOjkNCiAgICAjNSAweDE1YWEwM2QgaW4gcGxhbm5l cgovaG9tZS9zdXBlcnNpeC9mdXp6L3NlY3VyaXR5L1Bvc3RncmVTUUwvcG9zdGdyZXMvYnVpbGQv Li4vc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BsYW4vcGxhbm5lci5jOjI3MToxMg0KICAgICM2IDB4 MWM2MTEzYyBpbiBwZ19wbGFuX3F1ZXJ5Ci9ob21lL3N1cGVyc2l4L2Z1enovc2VjdXJpdHkvUG9z dGdyZVNRTC9wb3N0Z3Jlcy9idWlsZC8uLi9zcmMvYmFja2VuZC90Y29wL3Bvc3RncmVzLmM6ODQ3 OjkNCiAgICAjNyAweDFjNjExM2MgaW4gcGdfcGxhbl9xdWVyaWVzCi9ob21lL3N1cGVyc2l4L2Z1 enovc2VjdXJpdHkvUG9zdGdyZVNRTC9wb3N0Z3Jlcy9idWlsZC8uLi9zcmMvYmFja2VuZC90Y29w L3Bvc3RncmVzLmM6OTM5OjExDQogICAgIzggMHgxYzdhZDliIGluIGV4ZWNfc2ltcGxlX3F1ZXJ5 Ci9ob21lL3N1cGVyc2l4L2Z1enovc2VjdXJpdHkvUG9zdGdyZVNRTC9wb3N0Z3Jlcy9idWlsZC8u Li9zcmMvYmFja2VuZC90Y29wL3Bvc3RncmVzLmM6MTEzMzoxOQ0KICAgICM5IDB4MWM2YmI2NyBp biBQb3N0Z3Jlc01haW4KL2hvbWUvc3VwZXJzaXgvZnV6ei9zZWN1cml0eS9Qb3N0Z3JlU1FML3Bv c3RncmVzL2J1aWxkLy4uL3NyYy9iYWNrZW5kL3Rjb3AvcG9zdGdyZXMuYwogICAjMTAgMHgxN2Zm MGJhIGluIEJhY2tlbmRSdW4KL2hvbWUvc3VwZXJzaXgvZnV6ei9zZWN1cml0eS9Qb3N0Z3JlU1FM L3Bvc3RncmVzL2J1aWxkLy4uL3NyYy9iYWNrZW5kL3Bvc3RtYXN0ZXIvcG9zdG1hc3Rlci5jOjQ1 MDc6Mg0KICAgICMxMSAweDE3ZmI3MmYgaW4gQmFja2VuZFN0YXJ0dXAKL2hvbWUvc3VwZXJzaXgv ZnV6ei9zZWN1cml0eS9Qb3N0Z3JlU1FML3Bvc3RncmVzL2J1aWxkLy4uL3NyYy9iYWNrZW5kL3Bv c3RtYXN0ZXIvcG9zdG1hc3Rlci5jOjQyMjk6Mw0KICAgICMxMiAweDE3ZmI3MmYgaW4gU2VydmVy TG9vcAovaG9tZS9zdXBlcnNpeC9mdXp6L3NlY3VyaXR5L1Bvc3RncmVTUUwvcG9zdGdyZXMvYnVp bGQvLi4vc3JjL2JhY2tlbmQvcG9zdG1hc3Rlci9wb3N0bWFzdGVyLmM6MTc0NTo3DQogICAgIzEz IDB4MTdlNjE2YyBpbiBQb3N0bWFzdGVyTWFpbgovaG9tZS9zdXBlcnNpeC9mdXp6L3NlY3VyaXR5 L1Bvc3RncmVTUUwvcG9zdGdyZXMvYnVpbGQvLi4vc3JjL2JhY2tlbmQvcG9zdG1hc3Rlci9wb3N0 bWFzdGVyLmM6MTQxNzoxMQ0KICAgICMxNCAweDEzMWJhYzUgaW4gbWFpbgovaG9tZS9zdXBlcnNp eC9mdXp6L3NlY3VyaXR5L1Bvc3RncmVTUUwvcG9zdGdyZXMvYnVpbGQvLi4vc3JjL2JhY2tlbmQv bWFpbi9tYWluLmM6MjA5OjMNCiAgICAjMTUgMHg3ZjdmMDA0ZWYwYjIgaW4gX19saWJjX3N0YXJ0 X21haW4KL2J1aWxkL2dsaWJjLVpOOTVUNC9nbGliYy0yLjMxL2NzdS8uLi9jc3UvbGliYy1zdGFy dC5jOjMwODoxNg0KICAgICMxNiAweDRhZWMyZCBpbiBfc3RhcnQKKC9ob21lL3N1cGVyc2l4L2Z1 enovc2VjdXJpdHkvUG9zdGdyZVNRTC9pbnN0YWxsL2Jpbi9wb3N0Z3JlcysweDRhZWMyZCkNCg0K QWRkcmVzc1Nhbml0aXplciBjYW4gbm90IHByb3ZpZGUgYWRkaXRpb25hbCBpbmZvLg0KU1VNTUFS WTogQWRkcmVzc1Nhbml0aXplcjogU0VHVgovaG9tZS9zdXBlcnNpeC9mdXp6L3NlY3VyaXR5L1Bv c3RncmVTUUwvcG9zdGdyZXMvYnVpbGQvLi4vc3JjL2JhY2tlbmQvb3B0aW1pemVyL3ByZXAvcHJl cGpvaW50cmVlLmM6MTU3OjIzCmluIHJlcGxhY2VfZW1wdHlfam9pbnRyZWUNCj09NDUzODcwPT1B Qk9SVElORw0KDQpsb2cgZGV0YWlsOg0KDQpUUkFQOiBGYWlsZWRBc3NlcnRpb24oIiFwYXJzZS0+ cm93TWFya3MgJiYgcGFyc2UtPmNvbW1hbmRUeXBlID09CkNNRF9TRUxFQ1QiLCBGaWxlOgoiL2hv bWUvc3VwZXJzaXgvZnV6ei9zZWN1cml0eS9Qb3N0Z3JlU1FML3Bvc3RncmVzL2J1aWxkLy4uL3Ny Yy9iYWNrZW5kL29wdGltaXplci9wbGFuL3BsYW5uZXIuYyIsCkxpbmU6IDE4NjgsIFBJRDogNDA0 MjA3OSlwb3N0Z3Jlczogc3VwZXJzaXggeCAxMjcuMC4wLjEoMTI0MDIpCkRFTEVURShFeGNlcHRp b25hbENvbmRpdGlvbisweGJiKVsweDU1Y2I2OWRiZGZmYl0NCnBvc3RncmVzOiBzdXBlcnNpeCB4 IDEyNy4wLjAuMSgxMjQwMikgREVMRVRFKCsweDU5NDgwZilbMHg1NWNiNjk5Yzg4MGZdDQpwb3N0 Z3Jlczogc3VwZXJzaXggeCAxMjcuMC4wLjEoMTI0MDIpCkRFTEVURShzdWJxdWVyeV9wbGFubmVy KzB4ZjYzKVsweDU1Y2I2OTljOThlM10NCnBvc3RncmVzOiBzdXBlcnNpeCB4IDEyNy4wLjAuMSgx MjQwMikKREVMRVRFKFNTX3Byb2Nlc3NfY3RlcysweGI5KVsweDU1Y2I2OTlkNmIzOV0NCnBvc3Rn cmVzOiBzdXBlcnNpeCB4IDEyNy4wLjAuMSgxMjQwMikKREVMRVRFKHN1YnF1ZXJ5X3BsYW5uZXIr MHgxZjkpWzB4NTVjYjY5OWM4Yjc5XQ0KcG9zdGdyZXM6IHN1cGVyc2l4IHggMTI3LjAuMC4xKDEy NDAyKQpERUxFVEUoc3RhbmRhcmRfcGxhbm5lcisweDE2NSlbMHg1NWNiNjk5Y2E1MzVdDQpwb3N0 Z3Jlczogc3VwZXJzaXggeCAxMjcuMC4wLjEoMTI0MDIpCkRFTEVURShwZ19wbGFuX3F1ZXJ5KzB4 NmEpWzB4NTVjYjY5YjY3ZWFhXQ0KcG9zdGdyZXM6IHN1cGVyc2l4IHggMTI3LjAuMC4xKDEyNDAy KQpERUxFVEUocGdfcGxhbl9xdWVyaWVzKzB4NGQpWzB4NTVjYjY5YjY3ZmZkXQ0KcG9zdGdyZXM6 IHN1cGVyc2l4IHggMTI3LjAuMC4xKDEyNDAyKSBERUxFVEUoKzB4NzM1OWYyKVsweDU1Y2I2OWI2 OTlmMl0NCnBvc3RncmVzOiBzdXBlcnNpeCB4IDEyNy4wLjAuMSgxMjQwMikKREVMRVRFKFBvc3Rn cmVzTWFpbisweDFhZTcpWzB4NTVjYjY5YjZiZDU3XQ0KcG9zdGdyZXM6IHN1cGVyc2l4IHggMTI3 LjAuMC4xKDEyNDAyKSBERUxFVEUoKzB4NjE2NzFmKVsweDU1Y2I2OWE0YTcxZl0NCnBvc3RncmVz OiBzdXBlcnNpeCB4IDEyNy4wLjAuMSgxMjQwMikKREVMRVRFKFBvc3RtYXN0ZXJNYWluKzB4MTE4 MilbMHg1NWNiNjlhNGQ2NzJdDQpwb3N0Z3Jlczogc3VwZXJzaXggeCAxMjcuMC4wLjEoMTI0MDIp IERFTEVURShtYWluKzB4NTMzKVsweDU1Y2I2OTRmZDEzM10NCi9saWIveDg2XzY0LWxpbnV4LWdu dS9saWJjLnNvLjYoX19saWJjX3N0YXJ0X21haW4rMHhmMylbMHg3ZmRiYmY5N2QwYjNdDQpwb3N0 Z3Jlczogc3VwZXJzaXggeCAxMjcuMC4wLjEoMTI0MDIpIERFTEVURShfc3RhcnQrMHgyZSlbMHg1 NWNiNjk0ZmQyOGVdCgo= --===============5992705569558153966==--