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 1lB57B-0002sS-Bp for pgsql-bugs@arkaria.postgresql.org; Sun, 14 Feb 2021 00:18:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lB57A-0000KC-AV for pgsql-bugs@arkaria.postgresql.org; Sun, 14 Feb 2021 00:18:16 +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 1lB4Fq-0001VS-0S for pgsql-bugs@lists.postgresql.org; Sat, 13 Feb 2021 23:23:10 +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 1lB4Fm-0005QY-RI for pgsql-bugs@lists.postgresql.org; Sat, 13 Feb 2021 23:23:09 +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=SAMLyxfZoHmIQKzH1FmTelk8R/GAljr3MJN9yjvCuUo=; b=nxOWnc97N8XlS6dNPP89b/1Ny6 wzeaKu+RdiKMYOIRkW5Y/tvG5DDfz+wRQOqSJzSqd4Mje7GA/VXR1GOGIeZTBDVTetPMIvVuUpJDc oZsE9Sw5V+ixs76T+WZ4gktx9Vdq2Zfp4o9QH55RXIYatRMyCu27wMjl9j+8VCjHUmMu/40x2vwZR 7Jp4gLXxK6XdWxjsul2+SekK5z/+zQ/Te+l4vZCNq6cJcIdFX7uD7OjKm3XU7hPVG7ovW2bX2SVn9 JhBqnMHY0bV2G6B23W6Gc07/3P2+FK9VtpyS3yDf7iDJDRONGrLhPQQAJzm8mauNfHJz6kDwtWUqV 74hhFY2A==; 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 1lB4Fl-0002fo-Ai for pgsql-bugs@lists.postgresql.org; Sat, 13 Feb 2021 23:23:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lB4Fi-0001Dp-4C for pgsql-bugs@lists.postgresql.org; Sat, 13 Feb 2021 23:23:02 +0000 Content-Type: multipart/mixed; boundary="===============7850757620435326203==" MIME-Version: 1.0 Subject: BUG #16865: Regression: GIN Negated prefix search returns results that contain the search term To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: dimitri.nuescheler@gmail.com Reply-To: dimitri.nuescheler@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sat, 13 Feb 2021 23:22:33 +0000 Message-ID: <16865-4ffdc3e682e6d75b@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============7850757620435326203== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjg2NQpMb2dnZWQgYnk6ICAgICAgICAgIERpbWl0cmkgTsO8c2NoZWxl cgpFbWFpbCBhZGRyZXNzOiAgICAgIGRpbWl0cmkubnVlc2NoZWxlckBnbWFpbC5jb20KUG9zdGdy ZVNRTCB2ZXJzaW9uOiAxMy4xCk9wZXJhdGluZyBzeXN0ZW06ICAgRGViaWFuCkRlc2NyaXB0aW9u OiAgICAgICAgCgpIZWxsbw0KDQpJJ20gd3JpdGluZyBhIHNtYWxsIHNlYXJjaCBlbmdpbmUgYXBw bGljYXRpb24gdGhhdCBhbHNvIHN1cHBvcnRzIG5lZ2F0aW9uCihleGNsdWRlIHJlc3VsdHMgdGhh dCBjb250YWluIHRlcm1zIHN0YXJ0aW5nIHdpdGggc3RyaW5nKS4NCg0KQWZ0ZXIgdXBncmFkaW5n IGZyb20gUG9zdGdyZVNRTCAxMi41IHRvIDEzLjEgdGhlIG5lZ2F0aW9uIHdpdGhpbiBhIHRzcXVl cnkKd2hlbiBtYXRjaGVkIHRvIGEgdHN2ZWN0b3IgdXNpbmcgdGhlIEBAIG9wZXJhdG9yIG5vIGxv bmdlciB3b3JrcyBwcm9wZXJseSwKc28gSSBzdGFydGVkIGJpc2VjdGluZyB0aGUgY29tbWl0IGhp c3RvcnkgYW5kIHRyYWNrZWQgaXQgZG93biB0byB0aGlzIGNvbW1pdAooc2VlIHRoZSBxdWVyeSBh bmQgZXhwZWN0ZWQgYW5kIGFjdHVhbCByZXN1bHQgZnVydGhlciBiZWxvdyk6DQoNCj4gY29tbWl0 IDJmMjAwN2ZiYjI1NWJlMTc4YWNhNTg2NzgwOTY3ZjQzODg1MjAzYTcgKEhFQUQsIHJlZnMvYmlz ZWN0L2JhZCkNCj4gQXV0aG9yOiBUb20gTGFuZSA8dGdsQHNzcy5wZ2gucGEudXM+DQo+IERhdGU6 ICAgRnJpIEp1bCAyNCAxNToyNjo1MSAyMDIwIC0wNDAwDQo+DQo+ICAgIEZpeCBhc3NvcnRlZCBi dWdzIGJ5IGNoYW5naW5nIFRTX2V4ZWN1dGUncyBjYWxsYmFjayBBUEkgdG8gdGVybmFyeQpsb2dp Yy4NCj4gLi4uDQoNCkknbSBzdGlsbCB3b3JraW5nIG9uIGNyZWF0aW5nIGEgcmVwcm9kdWNpYmxl IHRlc3QtY2FzZSB3aXRob3V0IGhhdmluZyB0bwpzaGFyZSBjb21wYW55IGRhdGEuIEknbSBhbHNv IHRyeWluZyB0byB1bmRlcnN0YW5kIHRoZSBjb2RlIGFzIGEgZnVuCmV4ZXJjaXNlLg0KDQpJIGNh biBhdCBsZWFzdCBzaGFyZSBzb21lIG9mIHRoZSBxdWVyaWVzIGFuZCByZXN1bHQgZGF0YToNCg0K RERMOg0KQ1JFQVRFIFRBQkxFIElGIE5PVCBFWElTVFMgc2hlcmxvY2tfY2F0YWxvZyAoDQp1cmkg dmFyY2hhciwNCmRlc2NyaXB0aW9uIHZhcmNoYXIgTk9UIE5VTEwsDQptZXRhZGF0YSB2YXJjaGFy IE5PVCBOVUxMLA0KdGV4dHNlYXJjaCB0c3ZlY3RvciBHRU5FUkFURUQgQUxXQVlTIEFTICh0b190 c3ZlY3RvcignZW5nbGlzaCcsCnNoZXJsb2NrX25vcm1hbGl6ZSh1cmkgfHwgJyAnIHx8IGRlc2Ny aXB0aW9uIHx8ICcgJyB8fCBtZXRhZGF0YSkpKSBTVE9SRUQsDQpsYXN0X3NlZW4gdGltZXN0YW1w dHosDQpQUklNQVJZIEtFWSAodXJpKQ0KKTsNCkNSRUFURSBPUiBSRVBMQUNFIEZVTkNUSU9OIHNo ZXJsb2NrX25vcm1hbGl6ZShzdHIgdmFyY2hhcikgUkVUVVJOUyB2YXJjaGFyDQpBUyAkJA0KQkVH SU4NCiAgICBSRVRVUk4gbG93ZXIocmVnZXhwX3JlcGxhY2UocmVnZXhwX3JlcGxhY2UocmVnZXhw X3JlcGxhY2Uoc3RyLAonW15hLXpBLVowLTldKycsICcgJywgJ2cnKSwnKFthLXpdKShbQS1aXSkn LCdcMQpcMicsJ2cnKSwnKFtBLVpdW0EtWjAtOV0pKFthLXpdKScsJ1wxIFwyJywnZycpKTsNCkVO RDsNCiQkDQpMQU5HVUFHRSBwbHBnc3FsIElNTVVUQUJMRSBSRVRVUk5TIE5VTEwgT04gTlVMTCBJ TlBVVDsNCg0KUXVlcnk6DQpTRUxFQ1QgKiBGUk9NIHNoZXJsb2NrX2NhdGFsb2cgV0hFUkUgdGV4 dHNlYXJjaCBAQCAnJydmdWxsJyc6KiAmCicnc3VwcGxpJyc6KiAmICEnJ2Rpc2NvbnRpbnUnJzoq Jzo6dHNxdWVyeSBBTkQgbWV0YWRhdGEgTElLRQonJURpc2NvbnRpbnVlZCUnIExJTUlUIDI7DQoN ClJlc3VsdDogMiByb3dzDQoNCkV4cGVjdGVkIHJlc3VsdDogMCByb3dzLCBiZWNhdXNlIHRoZSB0 ZXh0c2VhcmNoIHZlY3RvciBjb250YWluczoKJ2Rpc2NvbnRpbnUnOjg2DQoNClBsYW46DQogTGlt aXQgIChjb3N0PTEzMC42MS4uMTI3ODkuMjQgcm93cz0xIHdpZHRoPTEzNikNCiAgIC0+ICBCaXRt YXAgSGVhcCBTY2FuIG9uIHNoZXJsb2NrX2NhdGFsb2cgIChjb3N0PTEzMC42MS4uMTI3ODkuMjQg cm93cz0xCndpZHRoPTEzNikNCiAgICAgICAgIFJlY2hlY2sgQ29uZDogKHRleHRzZWFyY2ggQEAg JycnZnVsbCcnOiogJiAnJ3N1cHBsaScnOiogJgohJydkaXNjb250aW51Jyc6Kic6OnRzcXVlcnkp DQogICAgICAgICBGaWx0ZXI6ICgobWV0YWRhdGEpOjp0ZXh0IH5+ICclRGlzY29udGludWVkJSc6 OnRleHQpDQogICAgICAgICAtPiAgQml0bWFwIEluZGV4IFNjYW4gb24gc2hlcmxvY2tfY2F0YWxv Z190ZXh0c2VhcmNoIAooY29zdD0wLjAwLi4xMzAuNjEgcm93cz0zNTQ4IHdpZHRoPTApDQogICAg ICAgICAgICAgICBJbmRleCBDb25kOiAodGV4dHNlYXJjaCBAQCAnJydmdWxsJyc6KiAmICcnc3Vw cGxpJyc6KiAmCiEnJ2Rpc2NvbnRpbnUnJzoqJzo6dHNxdWVyeSkNCg0KVGhlIGdlbmVyYXRlZCBw bGFuIGlzIHN0cnVjdHVyYWxseSB0aGUgc2FtZSBmb3IgUG9zdGdyZVNRTCAxMi41IHJlc3BlY3Rp dmVseQp2ZXJzaW9ucyBiZWZvcmUgdGhhdCBjb21taXQsIGJ1dCBpZiBJIGFsdGVyIHRoZSBwbGFu IHVzaW5nIChTRVQgZW5hYmxlXypzY2FuCiA9IG9mZikgc28gdGhhdCB0aGUgcGxhbm5lciBjb21l cyB1cCB3aXRoIGEgc2VxdWVudGlhbCBzY2FuLCBJIHdpbGwgZ2V0IHRoZQpleHBlY3RlZCByZXN1 bHRzLg0KDQpTb21lIG90aGVyIHJlc3VsdHMgKGNvdW50KToNCg0KQ291bnQgb2YgdGhlIHNhbWUg cXVlcnk6DQp1c2VyPSMgU0VMRUNUIENPVU5UKCopIEZST00gc2hlcmxvY2tfY2F0YWxvZyBXSEVS RSB0ZXh0c2VhcmNoIEBAICcnJ2Z1bGwnJzoqCiYgJydzdXBwbGknJzoqICYgIScnZGlzY29udGlu dScnOionOjp0c3F1ZXJ5IEFORCBtZXRhZGF0YSBMSUtFCiclRGlzY29udGludSUnOw0KIGNvdW50 IA0KLS0tLS0tLQ0KICA0OTYyDQooMSBaZWlsZSkNCg0KDQpOZWdhdGlvbiwgYnV0IG5vdCBhIHBy ZWZpeCBzZWFyY2g6DQp1c2VyPSMgU0VMRUNUIENPVU5UKCopIEZST00gc2hlcmxvY2tfY2F0YWxv ZyBXSEVSRSB0ZXh0c2VhcmNoIEBAICcnJ2Z1bGwnJzoqCiYgJydzdXBwbGknJzoqICYgIScnZGlz Y29udGludScnJzo6dHNxdWVyeSBBTkQgbWV0YWRhdGEgTElLRQonJURpc2NvbnRpbnUlJzsNCiBj b3VudCANCi0tLS0tLS0NCiAgICAgMA0KKDEgWmVpbGUpDQoNCg0KV2l0aG91dCBuZWdhdGlvbjoN CnVzZXI9IyBTRUxFQ1QgQ09VTlQoKikgRlJPTSBzaGVybG9ja19jYXRhbG9nIFdIRVJFIHRleHRz ZWFyY2ggQEAgJycnZnVsbCcnOioKJiAnJ3N1cHBsaScnOiogJiAnJ2Rpc2NvbnRpbnUnJzoqJzo6 dHNxdWVyeSBBTkQgbWV0YWRhdGEgTElLRQonJURpc2NvbnRpbnUlJzsNCiBjb3VudCANCi0tLS0t LS0NCiAxMzEyNw0KKDEgWmVpbGUpDQoNCldpdGhvdXQgdGhlICJkaXNjb250aW51IiB0ZXJtIGF0 IGFsbA0KDQp1c2VyPSMgU0VMRUNUIENPVU5UKCopIEZST00gc2hlcmxvY2tfY2F0YWxvZyBXSEVS RSB0ZXh0c2VhcmNoIEBAICcnJ2Z1bGwnJzoqCiYgJydzdXBwbGknJzoqJzo6dHNxdWVyeSBBTkQg bWV0YWRhdGEgTElLRSAnJURpc2NvbnRpbnUlJzsNCiBjb3VudCANCi0tLS0tLS0NCiAxMzEyNw0K KDEgWmVpbGUpDQoNCg0KU28gaXQgc2VlbXMgbGlrZSB0aGUgbmVnYXRlZCBxdWVyeSBtYW5hZ2Vz IHRvIGZpbHRlciBvdXQgc29tZSBkYXRhLCBidXQgbm90CmFsbCAtIGFzIGlmIGl0IGZhaWxlZCB0 byByZWNoZWNrIGFuZCBkZWZpbml0ZWx5IGRldGVybWluZSB0aGUgVFNfWUVTCnJlc3BlY3RpdmVs eSBUU19OTyBhbnN3ZXIgZnJvbSBhbiBpbi1wcmVjaXNlIFRTX01BWUJFIGFuc3dlciBmcm9tIGFu CnVucHJlY2lzZSBpbmRleC1iYXNlZCBhbnN3ZXIgKHdpdGhvdXQgcG9zaXRpb24gaW5mb3JtYXRp b24/KT8gaWYgSSBldmVuCnVuZGVyc3RhbmQgdGhpcyByZW1vdGVseSBjb3JyZWN0bHksIEknbSBu ZXcgdG8gdGhpcy4NCkknbGwgdHJ5IHRvIGZpbmQgb3V0IG1vcmUgYW5kIHRvIHByZXBhcmUgc2hh cmVhYmxlIGRhdGEgdGhhdCByZXByb2R1Y2VzIHRoZQpwcm9ibGVtLCBidXQgSSBhbHNvIHdvbmRl ciBpZiBJIG1hbmFnZSB0byBkaXZlIGludG8gdGhlIGNvZGUgYW5kIHVuZGVyc3RhbmQKc29tZXRo aW5nIGFib3V0IGl0IDotKQ0KDQpLaW5kIFJlZ2FyZHMNCkRpbWl0cmkgTsO8c2NoZWxlcgoK --===============7850757620435326203==--