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 1okmTh-0006DR-HZ for pgsql-bugs@arkaria.postgresql.org; Tue, 18 Oct 2022 13:17:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1okmTf-0001G2-DG for pgsql-bugs@arkaria.postgresql.org; Tue, 18 Oct 2022 13:17:51 +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 1okmOC-0000V2-Ci for pgsql-bugs@lists.postgresql.org; Tue, 18 Oct 2022 13:12:12 +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 1okmO8-00011x-08 for pgsql-bugs@lists.postgresql.org; Tue, 18 Oct 2022 13:12:11 +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=kMXtwbYj8u4+/WnWlVyRcK/bEPLWAoT7CqtWXCT0KVI=; b=2MZTYDFSWuCb7asdj/eMBhWoQl V7b0BP96+cYlcxkoo28C0cGrvbdCpycuwVHVCHqy0Q7y7TpSNIg7Wj3xvgKDEMC5vEJlkyyR87qrP 8OZtkE7ZTMAoroUrjiahE6DLqwarBIjA6bisZKPoCDfNVJahSDMNbmu7uFIaUYQFFT3dqXBTmtjdn 66dpMcY8OnPGDSLBHnLrqnK19JvW2Mx2F+lxG2/29b6E2l5xOs1VWR5oiVOidrn1vRvWeTIO0Cctg mMb5Z8X8cr3Qj+VOEFA4ihOe3Wir3Z16SGDhMrCCQXyeXIrOFg+mtpEVBvT1ffmFqSRy6HSMouLbL XiRMEWIQ==; 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 1okmO5-0002k2-9w for pgsql-bugs@lists.postgresql.org; Tue, 18 Oct 2022 13:12:06 +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 1okmO2-009N0B-0X for pgsql-bugs@lists.postgresql.org; Tue, 18 Oct 2022 13:12:02 +0000 Content-Type: multipart/mixed; boundary="===============5387316796273738587==" MIME-Version: 1.0 Subject: BUG #17650: For the sixth time, the clipping function in the 120 partition table planning stage fails To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: dafoer_x@163.com Reply-To: dafoer_x@163.com, pgsql-bugs@lists.postgresql.org Date: Tue, 18 Oct 2022 13:11:13 +0000 Message-ID: <17650-4523221bc4eb0c33@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 --===============5387316796273738587== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzY1MApMb2dnZWQgYnk6ICAgICAgICAgIGRhZm9lcgpFbWFpbCBhZGRy ZXNzOiAgICAgIGRhZm9lcl94QDE2My5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAxNC4wCk9wZXJh dGluZyBzeXN0ZW06ICAgY2VudG9zNy42CkRlc2NyaXB0aW9uOiAgICAgICAgCgpUaGUgY2xpcHBp bmcgZnVuY3Rpb24gb2YgcGFydGl0aW9uIHRhYmxlIGNhbm5vdCBiZSBjYXJyaWVkIG91dCBub3Jt YWxseSBpbgp0aGUgcGxhbm5pbmcgc3RhZ2UuIFRoZSBleHRlbnNpb24gcHJvdG9jb2wgY2Fubm90 IGJlIGNsaXBwZWQgaW4gdGhlIHNpeHRoCmV4ZWN1dGlvbi4gV2hlbiBjb25jdXJyZW5jeSBpcyBo aWdoLCBsb2NrIGNvbnRlbnRpb24gaXMgc2VyaW91cw0KDQpwb3N0Z3Jlcz0jIHByZXBhcmUgZnVu MyhpbnQsIGludCkgYXMgIHNlbGVjdCAqIGZyb20gdF9yYW5nZSB3aGVyZSBmMT0kMSBhbmQKZjIg PSAkMiArIDI7DQpQUkVQQVJFDQpUaW1lOiAwLjQzOSBtcw0KcG9zdGdyZXM9IyBleGVjdXRlIGZ1 bjMoMzQ4NiwyMDE3MDMpOw0KICBmMSAgfCAgIGYyICAgfCAgZjMgIHwgICAgICAgICAgICAgICAg ZjQgICAgICAgICAgICAgICAgDQotLS0tLS0rLS0tLS0tLS0rLS0tLS0tKy0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0NCiAzNDg2IHwgMjAxNzA1IHwgMzQ4NiB8IGFiNGYyYjVmZDk2 Y2E2NTM0OTExOTkwOWMxZWFkYTJkDQooMSByb3cpDQoNClRpbWU6IDEuNDMxIG1zDQpwb3N0Z3Jl cz0jIA0KcG9zdGdyZXM9IyBleGVjdXRlIGZ1bjMoMzQ4NiwyMDE3MDMpOw0KICBmMSAgfCAgIGYy ICAgfCAgZjMgIHwgICAgICAgICAgICAgICAgZjQgICAgICAgICAgICAgICAgDQotLS0tLS0rLS0t LS0tLS0rLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiAzNDg2IHwg MjAxNzA1IHwgMzQ4NiB8IGFiNGYyYjVmZDk2Y2E2NTM0OTExOTkwOWMxZWFkYTJkDQooMSByb3cp DQoNClRpbWU6IDAuNDUxIG1zDQpwb3N0Z3Jlcz0jIGV4ZWN1dGUgZnVuMygzNDg2LDIwMTcwMyk7 DQogIGYxICB8ICAgZjIgICB8ICBmMyAgfCAgICAgICAgICAgICAgICBmNCAgICAgICAgICAgICAg ICANCi0tLS0tLSstLS0tLS0tLSstLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLQ0KIDM0ODYgfCAyMDE3MDUgfCAzNDg2IHwgYWI0ZjJiNWZkOTZjYTY1MzQ5MTE5OTA5YzFl YWRhMmQNCigxIHJvdykNCg0KVGltZTogMC40MzAgbXMNCnBvc3RncmVzPSMgZXhlY3V0ZSBmdW4z KDM0ODYsMjAxNzAzKTsNCiAgZjEgIHwgICBmMiAgIHwgIGYzICB8ICAgICAgICAgICAgICAgIGY0 ICAgICAgICAgICAgICAgIA0KLS0tLS0tKy0tLS0tLS0tKy0tLS0tLSstLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tDQogMzQ4NiB8IDIwMTcwNSB8IDM0ODYgfCBhYjRmMmI1ZmQ5NmNh NjUzNDkxMTk5MDljMWVhZGEyZA0KKDEgcm93KQ0KDQpUaW1lOiAwLjQyMSBtcw0KcG9zdGdyZXM9 IyBleGVjdXRlIGZ1bjMoMzQ4NiwyMDE3MDMpOw0KICBmMSAgfCAgIGYyICAgfCAgZjMgIHwgICAg ICAgICAgICAgICAgZjQgICAgICAgICAgICAgICAgDQotLS0tLS0rLS0tLS0tLS0rLS0tLS0tKy0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiAzNDg2IHwgMjAxNzA1IHwgMzQ4NiB8 IGFiNGYyYjVmZDk2Y2E2NTM0OTExOTkwOWMxZWFkYTJkDQooMSByb3cpDQoNClRpbWU6IDAuNDE2 IG1zDQpwb3N0Z3Jlcz0jIGV4ZWN1dGUgZnVuMygzNDg2LDIwMTcwMyk7DQogIGYxICB8ICAgZjIg ICB8ICBmMyAgfCAgICAgICAgICAgICAgICBmNCAgICAgICAgICAgICAgICANCi0tLS0tLSstLS0t LS0tLSstLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIDM0ODYgfCAy MDE3MDUgfCAzNDg2IHwgYWI0ZjJiNWZkOTZjYTY1MzQ5MTE5OTA5YzFlYWRhMmQNCigxIHJvdykN Cg0KVGltZTogNy41NjggbXMg77yILS0gSXQgdG9vayB0b28gbXVjaCB0aW1lIDw8PDw8PDw8PT09 PT09PT09PT09PT09PT09PT09PT3vvIkNCnBvc3RncmVzPSMgZXhlY3V0ZSBmdW4zKDM0ODYsMjAx NzAzKTsNCiAgZjEgIHwgICBmMiAgIHwgIGYzICB8ICAgICAgICAgICAgICAgIGY0ICAgICAgICAg ICAgICAgIA0KLS0tLS0tKy0tLS0tLS0tKy0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tDQogMzQ4NiB8IDIwMTcwNSB8IDM0ODYgfCBhYjRmMmI1ZmQ5NmNhNjUzNDkxMTk5 MDljMWVhZGEyZA0KKDEgcm93KQ0KDQpUaW1lOiAwLjQ1MCBtcw0KcG9zdGdyZXM9IyBleGVjdXRl IGZ1bjMoMzQ4NiwyMDE3MDMpOw0KICBmMSAgfCAgIGYyICAgfCAgZjMgIHwgICAgICAgICAgICAg ICAgZjQgICAgICAgICAgICAgICAgDQotLS0tLS0rLS0tLS0tLS0rLS0tLS0tKy0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiAzNDg2IHwgMjAxNzA1IHwgMzQ4NiB8IGFiNGYyYjVm ZDk2Y2E2NTM0OTExOTkwOWMxZWFkYTJkDQooMSByb3cpDQoNCnVzZSBjYXNlczoNCnByZXBhcmUg ZnVuMyhpbnQsIGludCkgYXMgIHNlbGVjdCAqIGZyb20gdF9yYW5nZSB3aGVyZSBmMT0kMSBhbmQg ZjIgPSAkMiArCjI7DQpleGVjdXRlIGZ1bjMoMzQ4NiwyMDE3MDMpOw0KDQotLSBjcmVhdGUgdGFi bGUNCmNyZWF0ZSBvciByZXBsYWNlIGZ1bmN0aW9uIGluaXRfdF9yYW5nZV9kYXRhKHN0YXJ0X2Rh dGUgaW50KSByZXR1cm5zIHZvaWQKYXMNCiQkDQpERUNMQVJFDQppIGludDsNCnNxbCB0ZXh0Ow0K cGQgaW50Ow0KQkVHSU4NCnBkIDo9IHN0YXJ0X2RhdGU7DQoJZm9yIGkgaW4gMS4uMTEgbG9vcA0K CQlzcWw6PWZvcm1hdCgnY3JlYXRlIHRhYmxlIGlmIG5vdCBleGlzdHMgdF9yYW5nZV8lcyBQQVJU SVRJT04gT0YgdF9yYW5nZQpmb3IgdmFsdWVzIGZyb20gKCVzKSB0byAoJXMpOycsIHBkLCBwZCwg cGQrMSk7DQoJCWV4ZWN1dGUgc3FsOw0KCQlyYWlzZSBub3RpY2UgJyUnLHNxbDsNCg0KCQlzcWw6 PWZvcm1hdCgnaW5zZXJ0IGludG8gdF9yYW5nZShmMSxmMixmMyxmNCkgc2VsZWN0IHQsICVzLCBt b2QodCwxMDAwMCksCm1kNSh0Ojp2YXJjaGFyKSBmcm9tIGdlbmVyYXRlX3NlcmllcygxLDEwMDAw MCkgdDsnLCBwZCk7DQoJCWV4ZWN1dGUgc3FsOw0KCQlyYWlzZSBub3RpY2UgJyUnLHNxbDsNCgkJ DQoJCXNxbDo9Zm9ybWF0KCdjcmVhdGUgaW5kZXggaWYgbm90IGV4aXN0cyB0X3JhbmdlXyVzX2Yz X2lkeCBvbgp0X3JhbmdlXyVzKGYzKTsnLHBkLHBkKTsNCgkJZXhlY3V0ZSBzcWw7DQoJCXJhaXNl IG5vdGljZSAnJScsc3FsOw0KCQkNCgkJc3FsOj1mb3JtYXQoJ2NyZWF0ZSBpbmRleCBpZiBub3Qg ZXhpc3RzIHRfcmFuZ2VfJXNfZjFfaWR4IG9uCnRfcmFuZ2VfJXMoZjEpOycscGQscGQpOw0KCQll eGVjdXRlIHNxbDsNCgkJcmFpc2Ugbm90aWNlICclJyxzcWw7IA0KCQkNCgkJcGQ6PXBkKzE7DQoJ ZW5kIGxvb3A7DQoNCglwZCA6PSBzdGFydF9kYXRlOw0KCXNxbDo9Zm9ybWF0KCdjcmVhdGUgdGFi bGUgaWYgbm90IGV4aXN0cyB0X3JhbmdlXyVzIFBBUlRJVElPTiBPRiB0X3JhbmdlIGZvcgp2YWx1 ZXMgZnJvbSAoJXMpIHRvICglcyk7JywgcGQrMTEsIHBkKzExLCBwZCsxMDApOw0KCWV4ZWN1dGUg c3FsOw0KCXJhaXNlIG5vdGljZSAnJScsc3FsOw0KCXNxbDo9Zm9ybWF0KCdpbnNlcnQgaW50byB0 X3JhbmdlKGYxLGYyLGYzLGY0KSBzZWxlY3QgdCwgJXMsIG1vZCh0LDEwMDAwKSwKbWQ1KHQ6OnZh cmNoYXIpIGZyb20gZ2VuZXJhdGVfc2VyaWVzKDEsMTAwMDAwKSB0OycsIHBkKzExKTsNCglleGVj dXRlIHNxbDsNCglyYWlzZSBub3RpY2UgJyUnLHNxbDsNCglzcWw6PWZvcm1hdCgnY3JlYXRlIGlu ZGV4IGlmIG5vdCBleGlzdHMgdF9yYW5nZV8lc19mM19pZHggb24KdF9yYW5nZV8lcyhmMyk7Jyxw ZCsxMSxwZCsxMSk7DQoJZXhlY3V0ZSBzcWw7DQoJcmFpc2Ugbm90aWNlICclJyxzcWw7DQoJc3Fs Oj1mb3JtYXQoJ2NyZWF0ZSBpbmRleCBpZiBub3QgZXhpc3RzIHRfcmFuZ2VfJXNfZjFfaWR4IG9u CnRfcmFuZ2VfJXMoZjEpOycscGQrMTEscGQrMTEpOw0KCWV4ZWN1dGUgc3FsOw0KCXJhaXNlIG5v dGljZSAnJScsc3FsOyANCmVuZDsNCiQkDQpsYW5ndWFnZSBwbHBnc3FsOw0KDQpkcm9wIHRhYmxl IGlmIGV4aXN0cyB0X3JhbmdlIGNhc2NhZGU7IA0KY3JlYXRlIHRhYmxlIHRfcmFuZ2UgKGYxIGJp Z2ludCxmMiBpbnQgLCBmMyBpbnRlZ2VyLCBmNCB2YXJjaGFyKDEwMCkgKQpwYXJ0aXRpb24gYnkg cmFuZ2UgKCBmMiApOw0Kc2VsZWN0IGluaXRfdF9yYW5nZV9kYXRhKDIwMTcwMSk7DQoNCmNyZWF0 ZSBvciByZXBsYWNlIGZ1bmN0aW9uIGluaXRfdF9yYW5nZV9kYXRhKHN0YXJ0X2RhdGUgaW50KSBy ZXR1cm5zIHZvaWQKYXMNCiQkDQpERUNMQVJFDQppIGludDsNCnNxbCB0ZXh0Ow0KcGQgaW50Ow0K QkVHSU4NCnBkIDo9IHN0YXJ0X2RhdGU7DQoJZm9yIGkgaW4gMS4uMTEgbG9vcA0KCQlzcWw6PWZv cm1hdCgnY3JlYXRlIHRhYmxlIGlmIG5vdCBleGlzdHMgdF9yYW5nZV8lcyBQQVJUSVRJT04gT0Yg dF9yYW5nZQpmb3IgdmFsdWVzIGZyb20gKCVzKSB0byAoJXMpOycsIHBkLCBwZCwgcGQrMSk7DQoJ CWV4ZWN1dGUgc3FsOw0KCQlyYWlzZSBub3RpY2UgJyUnLHNxbDsNCg0KCQktLXNxbDo9Zm9ybWF0 KCdpbnNlcnQgaW50byB0X3JhbmdlKGYxLGYyLGYzLGY0KSBzZWxlY3QgdCwgJXMsCm1vZCh0LDEw MDAwKSwgbWQ1KHQ6OnZhcmNoYXIpIGZyb20gZ2VuZXJhdGVfc2VyaWVzKDEsMTAwMDAwKSB0Oycs IHBkKTsNCgkJLS1leGVjdXRlIHNxbDsNCgkJLS1yYWlzZSBub3RpY2UgJyUnLHNxbDsNCgkJDQoJ CXNxbDo9Zm9ybWF0KCdjcmVhdGUgaW5kZXggaWYgbm90IGV4aXN0cyB0X3JhbmdlXyVzX2YzX2lk eCBvbgp0X3JhbmdlXyVzKGYzKTsnLHBkLHBkKTsNCgkJZXhlY3V0ZSBzcWw7DQoJCXJhaXNlIG5v dGljZSAnJScsc3FsOw0KCQkNCgkJc3FsOj1mb3JtYXQoJ2NyZWF0ZSBpbmRleCBpZiBub3QgZXhp c3RzIHRfcmFuZ2VfJXNfZjFfaWR4IG9uCnRfcmFuZ2VfJXMoZjEpOycscGQscGQpOw0KCQlleGVj dXRlIHNxbDsNCgkJcmFpc2Ugbm90aWNlICclJyxzcWw7IA0KCQkNCgkJcGQ6PXBkKzE7DQoJZW5k IGxvb3A7DQoNCglwZCA6PSBzdGFydF9kYXRlOw0KCXNxbDo9Zm9ybWF0KCdjcmVhdGUgdGFibGUg aWYgbm90IGV4aXN0cyB0X3JhbmdlXyVzIFBBUlRJVElPTiBPRiB0X3JhbmdlIGZvcgp2YWx1ZXMg ZnJvbSAoJXMpIHRvICglcyk7JywgcGQrMTEsIHBkKzExLCBwZCsxMDApOw0KCWV4ZWN1dGUgc3Fs Ow0KCXJhaXNlIG5vdGljZSAnJScsc3FsOw0KCS0tc3FsOj1mb3JtYXQoJ2luc2VydCBpbnRvIHRf cmFuZ2UoZjEsZjIsZjMsZjQpIHNlbGVjdCB0LCAlcywgbW9kKHQsMTAwMDApLAptZDUodDo6dmFy Y2hhcikgZnJvbSBnZW5lcmF0ZV9zZXJpZXMoMSwxMDAwMDApIHQ7JywgcGQrMTEpOw0KCS0tZXhl Y3V0ZSBzcWw7DQoJLS1yYWlzZSBub3RpY2UgJyUnLHNxbDsNCglzcWw6PWZvcm1hdCgnY3JlYXRl IGluZGV4IGlmIG5vdCBleGlzdHMgdF9yYW5nZV8lc19mM19pZHggb24KdF9yYW5nZV8lcyhmMyk7 JyxwZCsxMSxwZCsxMSk7DQoJZXhlY3V0ZSBzcWw7DQoJcmFpc2Ugbm90aWNlICclJyxzcWw7DQoJ c3FsOj1mb3JtYXQoJ2NyZWF0ZSBpbmRleCBpZiBub3QgZXhpc3RzIHRfcmFuZ2VfJXNfZjFfaWR4 IG9uCnRfcmFuZ2VfJXMoZjEpOycscGQrMTEscGQrMTEpOw0KCWV4ZWN1dGUgc3FsOw0KCXJhaXNl IG5vdGljZSAnJScsc3FsOyANCmVuZDsNCiQkDQpsYW5ndWFnZSBwbHBnc3FsOw0KDQpzZWxlY3Qg aW5pdF90X3JhbmdlX2RhdGEoMjAxNjAxKTsNCnNlbGVjdCBpbml0X3RfcmFuZ2VfZGF0YSgyMDE4 MDEpOw0Kc2VsZWN0IGluaXRfdF9yYW5nZV9kYXRhKDIwMTkwMSk7DQpzZWxlY3QgaW5pdF90X3Jh bmdlX2RhdGEoMjAyMDAxKTsNCnNlbGVjdCBpbml0X3RfcmFuZ2VfZGF0YSgyMDIxMDEpOw0Kc2Vs ZWN0IGluaXRfdF9yYW5nZV9kYXRhKDIwMjIwMSk7DQpzZWxlY3QgaW5pdF90X3JhbmdlX2RhdGEo MjAyMzAxKTsNCnNlbGVjdCBpbml0X3RfcmFuZ2VfZGF0YSgyMDI0MDEpOw0Kc2VsZWN0IGluaXRf dF9yYW5nZV9kYXRhKDIwMjUwMSk7DQp2YWN1dW0gKGFuYWx5emUsIHZlcmJvc2UpIHRfcmFuZ2U7 Cgo= --===============5387316796273738587==--