Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1jI4HP-0000OP-E3 for pgsql-bugs@arkaria.postgresql.org; Sat, 28 Mar 2020 05:45:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1jI4GO-0004LK-7v for pgsql-bugs@arkaria.postgresql.org; Sat, 28 Mar 2020 05:44:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1jI4GN-0004J9-Vj for pgsql-bugs@lists.postgresql.org; Sat, 28 Mar 2020 05:44:08 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jI4GL-00041H-LV for pgsql-bugs@lists.postgresql.org; Sat, 28 Mar 2020 05:44:07 +0000 Content-Type: multipart/mixed; boundary="===============7613850932966562943==" MIME-Version: 1.0 Subject: BUG #16325: Assert failure on partitioning by int for a text value with a collation To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: exclusion@gmail.com Reply-To: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sat, 28 Mar 2020 05:43:05 +0000 Message-ID: <16325-809194cf742313ab@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============7613850932966562943== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjMyNQpMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBMYWtoaW4K RW1haWwgYWRkcmVzczogICAgICBleGNsdXNpb25AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTIuMgpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAxOC4wNApEZXNjcmlwdGlvbjogICAg ICAgIAoKVGhlIGZvbGxvd2luZyBxdWVyeToNCmNyZWF0ZSB0YWJsZSBwYXJ0ZWQgKGkgaW50KSBw YXJ0aXRpb24gYnkgbGlzdCAoaSk7DQpjcmVhdGUgdGFibGUgcGFydF9jb2xsIHBhcnRpdGlvbiBv ZiBwYXJ0ZWQgZm9yIHZhbHVlcyBpbiAoJzEnIGNvbGxhdGUKIlBPU0lYIik7DQoNCmxlYWRzIHRv IGFuIGFzc2VydCBmYWlsdXJlIHdpdGggdGhlIGZvbGxvd2luZyBzdGFjayB0cmFjZToNCkNvcmUg d2FzIGdlbmVyYXRlZCBieSBgcG9zdGdyZXM6IGxhdyByZWdyZXNzaW9uIFtsb2NhbF0gQ1JFQVRF IFRBQkxFICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgJy4NClByb2dyYW0gdGVybWlu YXRlZCB3aXRoIHNpZ25hbCBTSUdBQlJULCBBYm9ydGVkLg0KIzAgIF9fR0lfcmFpc2UgKHNpZz1z aWdAZW50cnk9NikgYXQgLi4vc3lzZGVwcy91bml4L3N5c3YvbGludXgvcmFpc2UuYzo1MQ0KNTEg ICAgICAuLi9zeXNkZXBzL3VuaXgvc3lzdi9saW51eC9yYWlzZS5jOiBObyBzdWNoIGZpbGUgb3Ig ZGlyZWN0b3J5Lg0KKGdkYikgYnQNCiMwICBfX0dJX3JhaXNlIChzaWc9c2lnQGVudHJ5PTYpIGF0 IC4uL3N5c2RlcHMvdW5peC9zeXN2L2xpbnV4L3JhaXNlLmM6NTENCiMxICAweDAwMDA3ZjRlNDU1 ZmE4MDEgaW4gX19HSV9hYm9ydCAoKSBhdCBhYm9ydC5jOjc5DQojMiAgMHgwMDAwNTVjZDNkMDgy ZjQwIGluIEV4Y2VwdGlvbmFsQ29uZGl0aW9uICgNCiAgICBjb25kaXRpb25OYW1lPWNvbmRpdGlv bk5hbWVAZW50cnk9MHg1NWNkM2QyYjFmNWIgIiEoc3RydmFsdWUgIT0gKCh2b2lkCiopMCkpIiwg DQogICAgZXJyb3JUeXBlPWVycm9yVHlwZUBlbnRyeT0weDU1Y2QzZDBkOWU4OCAiRmFpbGVkQXNz ZXJ0aW9uIiwKZmlsZU5hbWU9ZmlsZU5hbWVAZW50cnk9MHg1NWNkM2QyYjFmNTAgInNucHJpbnRm LmMiLCANCiAgICBsaW5lTnVtYmVyPWxpbmVOdW1iZXJAZW50cnk9NDQyKSBhdCBhc3NlcnQuYzo1 NA0KIzMgIDB4MDAwMDU1Y2QzZDBkMDkwMyBpbiBkb3ByICh0YXJnZXQ9dGFyZ2V0QGVudHJ5PTB4 N2ZmZTQzZWM2MzEwLApmb3JtYXQ9MHg1NWNkM2QxZmJmY2QgIlwiIiwgDQogICAgZm9ybWF0QGVu dHJ5PTB4NTVjZDNkMWZiZjcwICJjb2xsYXRpb24gb2YgcGFydGl0aW9uIGJvdW5kIHZhbHVlIGZv cgpjb2x1bW4gXCIlc1wiIGRvZXMgbm90IG1hdGNoIHBhcnRpdGlvbiBrZXkgY29sbGF0aW9uIFwi JXNcIiIsCmFyZ3M9MHg3ZmZlNDNlYzYzYzApIGF0IHNucHJpbnRmLmM6NDQyDQojNCAgMHgwMDAw NTVjZDNkMGQwZmY0IGluIHBnX3ZzbnByaW50ZiAoc3RyPTxvcHRpbWl6ZWQgb3V0PiwKY291bnQ9 PG9wdGltaXplZCBvdXQ+LCBjb3VudEBlbnRyeT0xMDI0LCANCiAgICBmbXQ9Zm10QGVudHJ5PTB4 NTVjZDNkMWZiZjcwICJjb2xsYXRpb24gb2YgcGFydGl0aW9uIGJvdW5kIHZhbHVlIGZvcgpjb2x1 bW4gXCIlc1wiIGRvZXMgbm90IG1hdGNoIHBhcnRpdGlvbiBrZXkgY29sbGF0aW9uIFwiJXNcIiIs CmFyZ3M9YXJnc0BlbnRyeT0weDdmZmU0M2VjNjNjMCkgYXQgc25wcmludGYuYzoxOTUNCiM1ICAw eDAwMDA1NWNkM2QwZDZlM2MgaW4gcHZzbnByaW50ZiAoYnVmPTxvcHRpbWl6ZWQgb3V0PiwKbGVu PWxlbkBlbnRyeT0xMDI0LCANCiAgICBmbXQ9Zm10QGVudHJ5PTB4NTVjZDNkMWZiZjcwICJjb2xs YXRpb24gb2YgcGFydGl0aW9uIGJvdW5kIHZhbHVlIGZvcgpjb2x1bW4gXCIlc1wiIGRvZXMgbm90 IG1hdGNoIHBhcnRpdGlvbiBrZXkgY29sbGF0aW9uIFwiJXNcIiIsCmFyZ3M9YXJnc0BlbnRyeT0w eDdmZmU0M2VjNjNjMCkgYXQgcHNwcmludGYuYzoxMTANCiM2ICAweDAwMDA1NWNkM2NlMWIzNTcg aW4gYXBwZW5kU3RyaW5nSW5mb1ZBIChzdHI9c3RyQGVudHJ5PTB4N2ZmZTQzZWM2M2EwLAoNCiAg ICBmbXQ9Zm10QGVudHJ5PTB4NTVjZDNkMWZiZjcwICJjb2xsYXRpb24gb2YgcGFydGl0aW9uIGJv dW5kIHZhbHVlIGZvcgpjb2x1bW4gXCIlc1wiIGRvZXMgbm90IG1hdGNoIHBhcnRpdGlvbiBrZXkg Y29sbGF0aW9uIFwiJXNcIiIsCmFyZ3M9YXJnc0BlbnRyeT0weDdmZmU0M2VjNjNjMCkgYXQgc3Ry aW5naW5mby5jOjEzNg0KIzcgIDB4MDAwMDU1Y2QzZDA4NzM3MSBpbiBlcnJtc2cgKA0KICAgIGZt dD1mbXRAZW50cnk9MHg1NWNkM2QxZmJmNzAgImNvbGxhdGlvbiBvZiBwYXJ0aXRpb24gYm91bmQg dmFsdWUgZm9yCmNvbHVtbiBcIiVzXCIgZG9lcyBub3QgbWF0Y2ggcGFydGl0aW9uIGtleSBjb2xs YXRpb24gXCIlc1wiIikgYXQKZWxvZy5jOjc5NA0KIzggIDB4MDAwMDU1Y2QzY2QzZTNhNCBpbiB0 cmFuc2Zvcm1QYXJ0aXRpb25Cb3VuZFZhbHVlCihwc3RhdGU9cHN0YXRlQGVudHJ5PTB4NTVjZDNl ZDU4MTQ4LCB2YWw9MHg1NWNkM2VjYmIxYTgsIA0KICAgIGNvbE5hbWU9Y29sTmFtZUBlbnRyeT0w eDU1Y2QzZWQ1ODY4MCAiaSIsIGNvbFR5cGU9Y29sVHlwZUBlbnRyeT0yMywKY29sVHlwbW9kPWNv bFR5cG1vZEBlbnRyeT0tMSwgDQogICAgcGFydENvbGxhdGlvbj1wYXJ0Q29sbGF0aW9uQGVudHJ5 PTApIGF0IHBhcnNlX3V0aWxjbWQuYzo0MDQzDQojOSAgMHgwMDAwNTVjZDNjZDQxMjMxIGluIHRy YW5zZm9ybVBhcnRpdGlvbkJvdW5kCihwc3RhdGU9cHN0YXRlQGVudHJ5PTB4NTVjZDNlZDU4MTQ4 LCANCiAgICBwYXJlbnQ9cGFyZW50QGVudHJ5PTB4N2Y0ZTQ2Zjg2MjkwLCBzcGVjPTxvcHRpbWl6 ZWQgb3V0PikgYXQKcGFyc2VfdXRpbGNtZC5jOjM4MDINCiMxMCAweDAwMDA1NWNkM2NkYTY3ZTQg aW4gRGVmaW5lUmVsYXRpb24gKHN0bXQ9c3RtdEBlbnRyeT0weDU1Y2QzZWQ1YTYyMCwKcmVsa2lu ZD1yZWxraW5kQGVudHJ5PTExNCAncicsIG93bmVySWQ9MTAsIA0KICAgIG93bmVySWRAZW50cnk9 MCwgdHlwYWRkcmVzcz10eXBhZGRyZXNzQGVudHJ5PTB4MCwgDQogICAgcXVlcnlTdHJpbmc9cXVl cnlTdHJpbmdAZW50cnk9MHg1NWNkM2VjOTdmZDggImNyZWF0ZSB0YWJsZSBwYXJ0X2NvbGwKcGFy dGl0aW9uIG9mIHBhcnRlZCBmb3IgdmFsdWVzIGluICgnMScgY29sbGF0ZSBcIlBPU0lYXCIpOyIp IGF0CnRhYmxlY21kcy5jOjk3Mg0KIzExIDB4MDAwMDU1Y2QzY2Y1ZWQxMiBpbiBQcm9jZXNzVXRp bGl0eVNsb3cKKHBzdGF0ZT1wc3RhdGVAZW50cnk9MHg1NWNkM2VkNWE1MDgsIHBzdG10PXBzdG10 QGVudHJ5PTB4NTVjZDNlYzk5MTM4LCANCiAgICBxdWVyeVN0cmluZz1xdWVyeVN0cmluZ0BlbnRy eT0weDU1Y2QzZWM5N2ZkOCAiY3JlYXRlIHRhYmxlIHBhcnRfY29sbApwYXJ0aXRpb24gb2YgcGFy dGVkIGZvciB2YWx1ZXMgaW4gKCcxJyBjb2xsYXRlIFwiUE9TSVhcIik7IiwKY29udGV4dD1jb250 ZXh0QGVudHJ5PVBST0NFU1NfVVRJTElUWV9UT1BMRVZFTCwgcGFyYW1zPXBhcmFtc0BlbnRyeT0w eDAsCnF1ZXJ5RW52PXF1ZXJ5RW52QGVudHJ5PTB4MCwgDQogICAgZGVzdD0weDU1Y2QzZWM5OTIz MCwgY29tcGxldGlvblRhZz0weDdmZmU0M2VjNmQzMCAiIikgYXQKdXRpbGl0eS5jOjEwMTQNCiMx MiAweDAwMDA1NWNkM2NmNWVhYzYgaW4gc3RhbmRhcmRfUHJvY2Vzc1V0aWxpdHkgKHBzdG10PTB4 NTVjZDNlYzk5MTM4LCANCiAgICBxdWVyeVN0cmluZz0weDU1Y2QzZWM5N2ZkOCAiY3JlYXRlIHRh YmxlIHBhcnRfY29sbCBwYXJ0aXRpb24gb2YgcGFydGVkCmZvciB2YWx1ZXMgaW4gKCcxJyBjb2xs YXRlIFwiUE9TSVhcIik7IiwgDQogICAgY29udGV4dD1QUk9DRVNTX1VUSUxJVFlfVE9QTEVWRUws IHBhcmFtcz0weDAsIHF1ZXJ5RW52PTB4MCwKZGVzdD0weDU1Y2QzZWM5OTIzMCwgY29tcGxldGlv blRhZz0weDdmZmU0M2VjNmQzMCAiIikNCiAgICBhdCB1dGlsaXR5LmM6OTI3DQojMTMgMHgwMDAw NTVjZDNjZjVlYjc0IGluIFByb2Nlc3NVdGlsaXR5IChwc3RtdD1wc3RtdEBlbnRyeT0weDU1Y2Qz ZWM5OTEzOCwKcXVlcnlTdHJpbmc9PG9wdGltaXplZCBvdXQ+LCANCiAgICBjb250ZXh0PWNvbnRl eHRAZW50cnk9UFJPQ0VTU19VVElMSVRZX1RPUExFVkVMLCBwYXJhbXM9PG9wdGltaXplZCBvdXQ+ LApxdWVyeUVudj08b3B0aW1pemVkIG91dD4sIA0KICAgIGRlc3Q9ZGVzdEBlbnRyeT0weDU1Y2Qz ZWM5OTIzMCwgY29tcGxldGlvblRhZz0weDdmZmU0M2VjNmQzMCAiIikgYXQKdXRpbGl0eS5jOjM2 MA0KIzE0IDB4MDAwMDU1Y2QzY2Y1YjAyNiBpbiBQb3J0YWxSdW5VdGlsaXR5Cihwb3J0YWw9cG9y dGFsQGVudHJ5PTB4NTVjZDNlY2ZmMjg4LCBwc3RtdD1wc3RtdEBlbnRyeT0weDU1Y2QzZWM5OTEz OCwgDQogICAgaXNUb3BMZXZlbD1pc1RvcExldmVsQGVudHJ5PXRydWUsCnNldEhvbGRTbmFwc2hv dD1zZXRIb2xkU25hcHNob3RAZW50cnk9ZmFsc2UsIGRlc3Q9ZGVzdEBlbnRyeT0weDU1Y2QzZWM5 OTIzMCwKDQogICAgY29tcGxldGlvblRhZz1jb21wbGV0aW9uVGFnQGVudHJ5PTB4N2ZmZTQzZWM2 ZDMwICIiKSBhdCBwcXVlcnkuYzoxMTc1DQojMTUgMHgwMDAwNTVjZDNjZjViYzcwIGluIFBvcnRh bFJ1bk11bHRpCihwb3J0YWw9cG9ydGFsQGVudHJ5PTB4NTVjZDNlY2ZmMjg4LCBpc1RvcExldmVs PWlzVG9wTGV2ZWxAZW50cnk9dHJ1ZSwgDQogICAgc2V0SG9sZFNuYXBzaG90PXNldEhvbGRTbmFw c2hvdEBlbnRyeT1mYWxzZSwKZGVzdD1kZXN0QGVudHJ5PTB4NTVjZDNlYzk5MjMwLCBhbHRkZXN0 PWFsdGRlc3RAZW50cnk9MHg1NWNkM2VjOTkyMzAsIA0KICAgIGNvbXBsZXRpb25UYWc9Y29tcGxl dGlvblRhZ0BlbnRyeT0weDdmZmU0M2VjNmQzMCAiIikgYXQgcHF1ZXJ5LmM6MTMyMQ0KIzE2IDB4 MDAwMDU1Y2QzY2Y1YzlkZiBpbiBQb3J0YWxSdW4gKHBvcnRhbD1wb3J0YWxAZW50cnk9MHg1NWNk M2VjZmYyODgsCmNvdW50PWNvdW50QGVudHJ5PTkyMjMzNzIwMzY4NTQ3NzU4MDcsIA0KICAgIGlz VG9wTGV2ZWw9aXNUb3BMZXZlbEBlbnRyeT10cnVlLCBydW5fb25jZT1ydW5fb25jZUBlbnRyeT10 cnVlLApkZXN0PWRlc3RAZW50cnk9MHg1NWNkM2VjOTkyMzAsIA0KICAgIGFsdGRlc3Q9YWx0ZGVz dEBlbnRyeT0weDU1Y2QzZWM5OTIzMCwgY29tcGxldGlvblRhZz0weDdmZmU0M2VjNmQzMCAiIikK YXQgcHF1ZXJ5LmM6Nzk2DQojMTcgMHgwMDAwNTVjZDNjZjU4Y2MzIGluIGV4ZWNfc2ltcGxlX3F1 ZXJ5ICgNCiAgICBxdWVyeV9zdHJpbmc9cXVlcnlfc3RyaW5nQGVudHJ5PTB4NTVjZDNlYzk3ZmQ4 ICJjcmVhdGUgdGFibGUgcGFydF9jb2xsCnBhcnRpdGlvbiBvZiBwYXJ0ZWQgZm9yIHZhbHVlcyBp biAoJzEnIGNvbGxhdGUgXCJQT1NJWFwiKTsiKSBhdApwb3N0Z3Jlcy5jOjEyMTUNCiMxOCAweDAw MDA1NWNkM2NmNWFjNjcgaW4gUG9zdGdyZXNNYWluIChhcmdjPTxvcHRpbWl6ZWQgb3V0PiwKYXJn dj1hcmd2QGVudHJ5PTB4NTVjZDNlY2MzMzg4LCBkYm5hbWU9PG9wdGltaXplZCBvdXQ+LCANCiAg ICB1c2VybmFtZT08b3B0aW1pemVkIG91dD4pIGF0IHBvc3RncmVzLmM6NDI0Nw0KIzE5IDB4MDAw MDU1Y2QzY2VjY2YzNyBpbiBCYWNrZW5kUnVuIChwb3J0PXBvcnRAZW50cnk9MHg1NWNkM2VjYmJh NjApIGF0CnBvc3RtYXN0ZXIuYzo0NDM3DQojMjAgMHgwMDAwNTVjZDNjZWQwMjI5IGluIEJhY2tl bmRTdGFydHVwIChwb3J0PXBvcnRAZW50cnk9MHg1NWNkM2VjYmJhNjApIGF0CnBvc3RtYXN0ZXIu Yzo0MTI4DQojMjEgMHgwMDAwNTVjZDNjZWQwNTQ1IGluIFNlcnZlckxvb3AgKCkgYXQgcG9zdG1h c3Rlci5jOjE3MDQNCiMyMiAweDAwMDA1NWNkM2NlZDE5NWUgaW4gUG9zdG1hc3Rlck1haW4gKGFy Z2M9MywgYXJndj08b3B0aW1pemVkIG91dD4pIGF0CnBvc3RtYXN0ZXIuYzoxMzc3DQojMjMgMHgw MDAwNTVjZDNjZTJjZGY0IGluIG1haW4gKGFyZ2M9MywgYXJndj0weDU1Y2QzZWM5MjYzMCkgYXQg bWFpbi5jOjIyOA0KDQpSZXByb2R1Y2VkIG9uIFJFTF8xMi4ubWFzdGVyLgoK --===============7613850932966562943==--