Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fgBPV-00019x-6P for pgsql-bugs@arkaria.postgresql.org; Thu, 19 Jul 2018 16:04:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fgBPS-0005HO-TN for pgsql-bugs@arkaria.postgresql.org; Thu, 19 Jul 2018 16:04:06 +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_SHA384:256) (Exim 4.89) (envelope-from ) id 1fgBPS-0005HH-NB for pgsql-bugs@lists.postgresql.org; Thu, 19 Jul 2018 16:04:06 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fgBPQ-0002JY-4k for pgsql-bugs@lists.postgresql.org; Thu, 19 Jul 2018 16:04:06 +0000 Content-Type: multipart/mixed; boundary="===============6446138298028913070==" MIME-Version: 1.0 Subject: BUG #15285: Query used index over field with ICU collation in some cases wrongly return 0 rows To: pgsql-bugs@lists.postgresql.org From: =?utf-8?q?PG_Bug_reporting_form?= Cc: roman.lytovchenko@gmail.com Reply-To: roman.lytovchenko@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 19 Jul 2018 16:03:05 +0000 Message-ID: <153201618542.1404.3611626898935613264@wrigleys.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============6446138298028913070== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNTI4NQpMb2dnZWQgYnk6ICAgICAgICAgIFJvbWFuIEx5dG92Y2hlbmtv CkVtYWlsIGFkZHJlc3M6ICAgICAgcm9tYW4ubHl0b3ZjaGVua29AZ21haWwuY29tClBvc3RncmVT UUwgdmVyc2lvbjogMTAuNApPcGVyYXRpbmcgc3lzdGVtOiAgIGZlZG9yYQpEZXNjcmlwdGlvbjog ICAgICAgIAoKSG93IHRvIHJlcHJvZHVjZToNCkNSRUFURSBDT0xMQVRJT04gZGlnaXRzbGFzdCAo cHJvdmlkZXIgPSBpY3UsIGxvY2FsZSA9CidlbkBjb2xSZW9yZGVyPWxhdG4tZGlnaXQnKTsNCkNS RUFURSBUQUJMRSB0IChiIENIQVIoNCkgTk9UIE5VTEwgQ09MTEFURSBkaWdpdHNsYXN0KTsNCmlu c2VydCBpbnRvIHQgc2VsZWN0ICcwMDAwJyBmcm9tIGdlbmVyYXRlX3NlcmllcyAoMCwgMTAwMCkg YXMgZih4KTsNCmluc2VydCBpbnRvIHQgc2VsZWN0ICcwMDAxJyBmcm9tIGdlbmVyYXRlX3Nlcmll cyAoMCwgMTAwMCkgYXMgZih4KTsNCmluc2VydCBpbnRvIHQgc2VsZWN0ICdBQkNEJyBmcm9tIGdl bmVyYXRlX3NlcmllcyAoMCwgMTAwMCkgYXMgZih4KTsNCg0KY3JlYXRlIGluZGV4IGkgb24gdChi KTsNCnNlbGVjdCAqIGZyb20gdCB3aGVyZSBiID0gJzAwMDAnIDsNCi0tIDAgcm93cywgYW5kIHRo aXMgaXMgYSBidWcNCg0KZXhwbGFpbiBhbmFseXplIHNlbGVjdCAqIGZyb20gdCB3aGVyZSBiID0g JzAwMDAnIDsNCkluZGV4IE9ubHkgU2NhbiB1c2luZyBpIG9uIHQgIChjb3N0PTAuMjguLjQxLjgw IHJvd3M9MTAwMSB3aWR0aD01KSAoYWN0dWFsCnRpbWU9MC4wNDUuLjAuMDQ1IHJvd3M9MCBsb29w cz0xKQ0KICBJbmRleCBDb25kOiAoYiA9ICcwMDAwJzo6YnBjaGFyKQ0KICBIZWFwIEZldGNoZXM6 IDANClBsYW5uaW5nIHRpbWU6IDAuMTQ2IG1zDQpFeGVjdXRpb24gdGltZTogMC4wODAgbXMNCg0K ZHJvcCBpbmRleCBpOw0Kc2VsZWN0ICogZnJvbSB0IHdoZXJlIGIgPSAnMDAwMCcgOw0KLS0gMTAw MSByb3dzDQoNClNvLCBzZWxlY3QgdmVyc2lvbigpOw0KUG9zdGdyZVNRTCAxMC40IG9uIHg4Nl82 NC1wYy1saW51eC1nbnUsIGNvbXBpbGVkIGJ5IGdjYyAoR0NDKSA4LjAuMSAyMDE4MDMyNAooUmVk IEhhdCA4LjAuMS0wLjIwKSwgNjQtYml0DQokY2F0IC9wcm9jL3ZlcnNpb24gDQpMaW51eCB2ZXJz aW9uIDMuMTAuMC01MTQuMTAuMi5lbDcueDg2XzY0IChidWlsZGVyQGtidWlsZGVyLmRldi5jZW50 b3Mub3JnKQooZ2NjIHZlcnNpb24gNC44LjUgMjAxNTA2MjMgKFJlZCBIYXQgNC44LjUtMTEpIChH Q0MpICkgIzEgU01QIEZyaSBNYXIgMwowMDowNDowNSBVVEMgMjAxNwoK --===============6446138298028913070==--