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 1jlrBq-0008Ub-QU for pgsql-bugs@arkaria.postgresql.org; Thu, 18 Jun 2020 09:50:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jlrBp-0008Ab-OU for pgsql-bugs@arkaria.postgresql.org; Thu, 18 Jun 2020 09:50:33 +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 1jlr3d-0002LM-NY for pgsql-bugs@lists.postgresql.org; Thu, 18 Jun 2020 09:42:05 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jlr3a-0005g0-KK for pgsql-bugs@lists.postgresql.org; Thu, 18 Jun 2020 09:42:05 +0000 Content-Type: multipart/mixed; boundary="===============8575686832113905376==" MIME-Version: 1.0 Subject: BUG #16501: Incorrect result. select multi_key_columns_range_partition_table To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: hisanori.kobayashi.bp@nttdata.com Reply-To: hisanori.kobayashi.bp@nttdata.com, pgsql-bugs@lists.postgresql.org Date: Thu, 18 Jun 2020 09:41:44 +0000 Message-ID: <16501-5234a9a0394f6754@postgresql.org> X-Auto-Response-Suppress: All List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============8575686832113905376== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjUwMQpMb2dnZWQgYnk6ICAgICAgICAgIEtvYmF5YXNoaSBIaXNhbm9y aQpFbWFpbCBhZGRyZXNzOiAgICAgIGhpc2Fub3JpLmtvYmF5YXNoaS5icEBudHRkYXRhLmNvbQpQ b3N0Z3JlU1FMIHZlcnNpb246IDEyLjIKT3BlcmF0aW5nIHN5c3RlbTogICBXaW5kb3dzMTAKRGVz Y3JpcHRpb246ICAgICAgICAKCkkgZm91bmQgdGhhdCBJbmNvcnJlY3QtcmVzdWx0IHNxbC4NCg0K U2FtZSBmb3IgMTIuMiBhbmQgMTIuMw0KDQpJIGFtIG5vdCBnb29kIGF0IEVuZ2xpc2gsIHNvIEkg d2lsbCBzZW5kIGEgcmVwcm9kdWN0aW9uIHNjcmlwdC4NCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLQ0KLS0gKioqKiogZXhlY3V0ZSBmcm9tIHBzcWwNCi0tDQotLSAqKioqKiBDcmVhdGUg VGVzdCBUYWJsZQ0KZHJvcCB0YWJsZSBpZiBleGlzdHMgcHRfdGVzdDAyIDsNCmNyZWF0ZSB0YWJs ZSBwdF90ZXN0MDINCiAgICAoIGtibiAgIHNtYWxsaW50IG5vdCBudWxsDQogICAgLCBuZW4gICBj aGFyKDQpICBub3QgbnVsbA0KICAgICwgbW0gICAgY2hhcigyKSAgbm90IG51bGwNCiAgICAsIGNk ICAgIGNoYXIoMykgIG5vdCBudWxsDQogICAgLCB2YWwwMCBudW1lcmljKDE1LCAzKQ0KICAgICwg dXNyICAgdmFyY2hhcigxMCkNCiAgICApDQogICAgcGFydGl0aW9uIGJ5IGxpc3Qoa2JuKSB3aXRo IChvaWRzPWZhbHNlKQ0KOw0KY3JlYXRlIHRhYmxlIHB0X3Rlc3QwMl8xICAgICAgICAgcGFydGl0 aW9uIG9mIHB0X3Rlc3QwMiAgIGZvciB2YWx1ZXMgaW4gIAooMSkgcGFydGl0aW9uIGJ5IHJhbmdl KG5lbiwgbW0pIHdpdGggKG9pZHM9ZmFsc2UpIDsNCmNyZWF0ZSB0YWJsZSBwdF90ZXN0MDJfMV8y MDE5XzAxIHBhcnRpdGlvbiBvZiBwdF90ZXN0MDJfMSBmb3IgdmFsdWVzIGZyb20KKCcyMDE5Jywg JzAxJykgdG8gKCcyMDE5JywgJzA3JykgOw0KY3JlYXRlIHRhYmxlIHB0X3Rlc3QwMl8xXzIwMTlf MDIgcGFydGl0aW9uIG9mIHB0X3Rlc3QwMl8xIGZvciB2YWx1ZXMgZnJvbQooJzIwMTknLCAnMDcn KSB0byAoJzIwMTknLCAnMTMnKSA7DQpjcmVhdGUgdGFibGUgcHRfdGVzdDAyXzFfMjAyMF8wMSBw YXJ0aXRpb24gb2YgcHRfdGVzdDAyXzEgZm9yIHZhbHVlcyBmcm9tCignMjAyMCcsICcwMScpIHRv ICgnMjAyMCcsICcwNycpIDsNCmNyZWF0ZSB0YWJsZSBwdF90ZXN0MDJfMV8yMDIwXzAyIHBhcnRp dGlvbiBvZiBwdF90ZXN0MDJfMSBmb3IgdmFsdWVzIGZyb20KKCcyMDIwJywgJzA3JykgdG8gKCcy MDIwJywgJzEzJykgOw0KY3JlYXRlIHRhYmxlIHB0X3Rlc3QwMl8yICAgICAgICAgcGFydGl0aW9u IG9mIHB0X3Rlc3QwMiAgIGZvciB2YWx1ZXMgaW4gIAooMikgcGFydGl0aW9uIGJ5IHJhbmdlKG5l biwgbW0pIHdpdGggKG9pZHM9ZmFsc2UpIDsNCmNyZWF0ZSB0YWJsZSBwdF90ZXN0MDJfMl8yMDE5 XzAxIHBhcnRpdGlvbiBvZiBwdF90ZXN0MDJfMiBmb3IgdmFsdWVzIGZyb20KKCcyMDE5JywgJzAx JykgdG8gKCcyMDE5JywgJzA3JykgOw0KY3JlYXRlIHRhYmxlIHB0X3Rlc3QwMl8yXzIwMTlfMDIg cGFydGl0aW9uIG9mIHB0X3Rlc3QwMl8yIGZvciB2YWx1ZXMgZnJvbQooJzIwMTknLCAnMDcnKSB0 byAoJzIwMTknLCAnMTMnKSA7DQpjcmVhdGUgdGFibGUgcHRfdGVzdDAyXzJfMjAyMF8wMSBwYXJ0 aXRpb24gb2YgcHRfdGVzdDAyXzIgZm9yIHZhbHVlcyBmcm9tCignMjAyMCcsICcwMScpIHRvICgn MjAyMCcsICcwNycpIDsNCmNyZWF0ZSB0YWJsZSBwdF90ZXN0MDJfMl8yMDIwXzAyIHBhcnRpdGlv biBvZiBwdF90ZXN0MDJfMiBmb3IgdmFsdWVzIGZyb20KKCcyMDIwJywgJzA3JykgdG8gKCcyMDIw JywgJzEzJykgOw0KLS0NCi0tICoqKioqIFRlc3QgRGF0YSBJbnNlcnQNCmluc2VydCBpbnRvIHB0 X3Rlc3QwMiB2YWx1ZXMoMSwgJzIwMjAnLCAnMDEnLCAxLCBudWxsLCBudWxsKSA7DQotLQ0KLS0g KioqKiogVGVzdCBTUUwgYW5kIHJlc3VsdA0KLS0NCnNlbGVjdCBjb3VudCgqKSBmcm9tIHB0X3Rl c3QwMiAgICAgICAgICAgd2hlcmUga2JuID0gMSBhbmQgbmVuIDw9ICcyMDIwJyBhbmQKbW0gPSAn MDEnIDsNCi0tICoqKioqIFJlc3VsdCA9IDAgLi4uIGluY29ycmVjdA0KLS0NCnNlbGVjdCBjb3Vu dCgqKSBmcm9tIHB0X3Rlc3QwMl8xICAgICAgICAgd2hlcmUga2JuID0gMSBhbmQgbmVuIDw9ICcy MDIwJyBhbmQKbW0gPSAnMDEnIDsNCi0tICoqKioqIFJlc3VsdCA9IDAgLi4uIGluY29ycmVjdA0K LS0NCnNlbGVjdCBjb3VudCgqKSBmcm9tIHB0X3Rlc3QwMl8xXzIwMjBfMDEgd2hlcmUga2JuID0g MSBhbmQgbmVuIDw9ICcyMDIwJyBhbmQKbW0gPSAnMDEnIDsNCi0tICoqKioqIFJlc3VsdCA9IDEg Li4uIGNvcnJlY3QNCi0tDQpzZWxlY3QgY291bnQoKikgZnJvbSBwdF90ZXN0MDIgICAgICAgICAg IHdoZXJlIGtibiA9IDEgYW5kIG5lbiAgPSAnMjAyMCcgYW5kCm1tID0gJzAxJyA7DQotLSAqKioq KiBSZXN1bHQgPSAxIC4uLiBjb3JyZWN0DQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0K Cg== --===============8575686832113905376==--