Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-bugs-owner+M47034=pgsql+2Dbugs=arkaria.postgresql.org@postgresql.org>)
	id 1cgYKK-0003ba-En
	for pgsql-bugs@arkaria.postgresql.org; Wed, 22 Feb 2017 14:55:32 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84_2)
	(envelope-from
 <pgsql-bugs-owner+M47034=pgsql+2Dbugs=arkaria.postgresql.org@postgresql.org>)
	id 1cgYKK-0000MV-1l
	for pgsql-bugs@arkaria.postgresql.org; Wed, 22 Feb 2017 14:55:32 +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.84_2)
	(envelope-from <isayko.alexey@gmail.com>)
	id 1cgUt3-0007WN-U8
	for pgsql-bugs@postgresql.org; Wed, 22 Feb 2017 11:15:09 +0000
Received: from wrigleys.postgresql.org ([204.145.124.246])
	by magus.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from <isayko.alexey@gmail.com>)
	id 1cgUsx-0008A0-J5
	for pgsql-bugs@postgresql.org; Wed, 22 Feb 2017 11:15:09 +0000
MIME-Version: 1.0
Subject: BUG #14563: count(*) gives a wrong result in PostgreSQL for some
 regex with pg_trm/GIN index
To: pgsql-bugs@postgresql.org
From: isayko.alexey@gmail.com
Date: Wed, 22 Feb 2017 11:14:46 +0000
Message-ID: <20170222111446.1256.67547@wrigleys.postgresql.org>
X-Pg-Spam-Score: -0.3 (/)
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64
List-Archive: <http://archives.postgresql.org/pgsql-bugs>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-bugs.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@postgresql.org>
List-Post: <mailto:pgsql-bugs@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-bugs>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-bugs>
X-Mailing-List: pgsql-bugs
Precedence: bulk
Sender: pgsql-bugs-owner@postgresql.org

VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDU2MwpMb2dnZWQgYnk6ICAg
ICAgICAgIEFsZXhleSBJc2F5a28KRW1haWwgYWRkcmVzczogICAgICBpc2F5
a28uYWxleGV5QGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDkuNi4x
Ck9wZXJhdGluZyBzeXN0ZW06ICAgV2luZG93cyAxMC4wLjE0MzkzIHg2NApE
ZXNjcmlwdGlvbjogICAgICAgIAoKV2hlbiB1c2luZyBzb21lIFJFIHRvIGZp
bHRlciByb3dzIG9uIGdpbi1pbmRleGVkIGNvbHVtbiB3aXRoIHBnX3RybSwK
Y291bnQoKikgY291bGQgZ2l2ZSBhIHdyb25nIHJlc3VsdCAoemVybyBpbnN0
ZWFkIG9mIHJlYWwgY291bnQpOg0KDQpDUkVBVEUgRVhURU5TSU9OIHBnX3Ry
Z207DQpDUkVBVEUgVEFCTEUgdCAoDQogIHMgdGV4dA0KKTsNCkNSRUFURSBJ
TkRFWCBPTiB0IFVTSU5HIGdpbiAocyBnaW5fdHJnbV9vcHMpOw0KSU5TRVJU
IElOVE8gdCBWQUxVRVMgKCcxMi0zNCcpOw0KDQpTRVQgZW5hYmxlX3NlcXNj
YW4gPSBPRkY7IC0tIHRvIGZvcmNlIHVzaW5nIHRoZSBpbmRleCBvbiBvdXIg
c21hbGwgdGFibGUNClNFTEVDVCBjb3VudCgqKSBGUk9NIHQgV0hFUkUgc34n
XGR7Mn1bLV0/XGR7Mn0nOyAtLSBnaXZlcyBtZSAwIGFuZCBpdCdzCndyb25n
DQoNCkJ1dCBpZiB3ZSB3aWxsIHR1cm4gb24gc2VxIHNjYW5zLCB3ZSB3aWxs
IGdldCB0aGUgY29ycmVjdCByZXN1bHQ6DQoNClNFVCBlbmFibGVfc2Vxc2Nh
biA9IE9OOw0KU0VMRUNUIGNvdW50KCopIEZST00gdCBXSEVSRSBzfidcZHsy
fVstXT9cZHsyfSc7IC0tIGdpdmVzIG1lIDEgYW5kIGl0J3MKY29ycmVjdA0K
DQpTYW1lIGJlaGF2aW91ciBJIGdldCB3aXRoIDkuNS40ICh3aW5kb3dzIGFu
ZCBsaW51eCkgYW5kIDkuNi4xICh3aW5kb3dzKQp2ZXJzaW9ucyBvZiB0aGUg
UG9zdGdyZVNRTAoKCi0tIApTZW50IHZpYSBwZ3NxbC1idWdzIG1haWxpbmcg
bGlzdCAocGdzcWwtYnVnc0Bwb3N0Z3Jlc3FsLm9yZykKVG8gbWFrZSBjaGFu
Z2VzIHRvIHlvdXIgc3Vic2NyaXB0aW9uOgpodHRwOi8vd3d3LnBvc3RncmVz
cWwub3JnL21haWxwcmVmL3Bnc3FsLWJ1Z3MK