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 1pEnQw-0003lY-2b for pgsql-bugs@arkaria.postgresql.org; Mon, 09 Jan 2023 08:23:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pEnQu-0002Ju-Jh for pgsql-bugs@arkaria.postgresql.org; Mon, 09 Jan 2023 08:23:04 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pEYXr-0000Ry-01 for pgsql-bugs@lists.postgresql.org; Sun, 08 Jan 2023 16:29:15 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pEYXi-0001h6-1v for pgsql-bugs@lists.postgresql.org; Sun, 08 Jan 2023 16:29:12 +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=c/IIzKuQSr2z0xvi84w8APIXw1lNFWD0LubanY360+8=; b=pnkhrN23OkzRvL55WG5uONkWku fvGkhvZu68slid+XnnKAFP544oi+npXJPmCLUSh1gsDNWjlgDELtJcKxZPJfAX8bPmAbdEWe0yp0e ARhiXIgTBQpjHNfnoIig/zLoFGDgjeLV2UL++GBVn0rHl751HyT6KfSfk01OlKTHCfagUSAAGsrVJ kE9WTGRMT75NoBFaCFKFgoZCn4SUT3rMxHTlD9F/Rnf+Du9kYOlAev+dyy5Np8K/zSltrPe+gEeFf 3QrYRlNI3utsZgPrfxb/CWh5eNIGftrF6frkl3S5W6Nx4w+6psYYq3UO9K09Iftq57gIR7cqYTxaE ffeCz8Pw==; 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 1pEYXh-0006mo-LV for pgsql-bugs@lists.postgresql.org; Sun, 08 Jan 2023 16:29:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pEYXd-009zPp-LV for pgsql-bugs@lists.postgresql.org; Sun, 08 Jan 2023 16:29:02 +0000 Content-Type: multipart/mixed; boundary="===============3405898992939261061==" MIME-Version: 1.0 Subject: BUG #17739: postgres ts_headline function is not returning matches it should during full text search To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: sssnarr1@gmail.com Reply-To: sssnarr1@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sun, 08 Jan 2023 16:28:24 +0000 Message-ID: <17739-2f20af14b5644ef9@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3405898992939261061== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzczOQpMb2dnZWQgYnk6ICAgICAgICAgIFNhbSBTCkVtYWlsIGFkZHJl c3M6ICAgICAgc3NzbmFycjFAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTUuMQpPcGVy YXRpbmcgc3lzdGVtOiAgIHVidW50dQpEZXNjcmlwdGlvbjogICAgICAgIAoKUHJldHR5IHZlcnNp b24gb2YgdGhpcyBxdWVzdGlvbiBvcmlnaW5hbGx5IHBvc3RlZCBvbiBTdGFja0V4Y2hhbmdlOgpo dHRwczovL2RiYS5zdGFja2V4Y2hhbmdlLmNvbS9xdWVzdGlvbnMvMzIxNzE4L3Bvc3RncmVzLXRz LWhlYWRsaW5lLWZ1bmN0aW9uLWlzLW5vdC1yZXR1cm5pbmctbWF0Y2hlcy1pdC1zaG91bGQtZHVy aW5nLWZ1bGwtdGV4DQoNCioqQmFja2dyb3VuZCoqOiANCkkndmUgYmVlbiB1c2luZyBQb3N0Z3Jl cyBmdWxsLXRleHQgc2VhcmNoIGFuZCBpdCBoYXMgbWV0IG15IG5lZWRzIHF1aXRlCndlbGwuIFRo b3VnaCB0aGVyZSBpcyBzb21lIHVuZXhwZWN0ZWQgYmVoYXZpb3IgdGhhdCBJIGNhbm5vdCBzZWVt IHRvIHdyYXAgbXkKaGVhZCBhcm91bmQuIEl0IGhhcyB0byBkbyB3aXRoIHRoZSBmdWxsLXRleHQg c2VhcmNoIHJlc3VsdHMgcmV0dXJuaW5nIHRoZQpoaWdobGlnaHRlZCBtYXRjaGVzIHVzaW5nIHRo ZSBgdHNfaGVhZGxpbmVgIGZ1bmN0aW9uLiBJdCByZXR1cm5zIHRoZSBjb3JyZWN0Cm1hdGNoZXMg bW9zdCBvZiB0aGUgdGltZSwgYnV0IG9mdGVuIGl0IHdpbGwgbm90IHJldHVybiBhIG1hdGNoIGFz IEkgZXhwZWN0Cml0LiBJIHRoaW5rIGFuIGV4YW1wbGUgaXMgdGhlIGJlc3Qgd2F5IHRvIGRlbW9u c3RyYXRlIHRoaXMuIA0KDQpSZWxldmFudCBQb3N0Z3JlcyBmdWxsLXRleHQgaGlnaGxpZ2h0aW5n IGRvY3M6Cmh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3MvY3VycmVudC90ZXh0c2VhcmNo LWNvbnRyb2xzLmh0bWwjVEVYVFNFQVJDSC1IRUFETElORQ0KDQoqKlZlcnNpb25zKio6IEkgaGF2 ZSB0cmllZCBQb3N0Z3JlcyAxNSBhbmQgMTIgYW5kIGV4cGVyaWVuY2VkIHRoaXMgYnVnCihmZWF0 dXJlPykgaW4gYm90aC4NCg0KKipFeGFtcGxlcyoqOg0KSW4gdGhlIGZvbGxvd2luZyAzIGZ1bGwt dGV4dCBzZWFyY2ggaGlnaGxpZ2h0aW5nIHF1ZXJpZXMsIHdoeSBkbyB0aGUgZmlyc3QKb25lJ3Mg cmVzdWx0cyBub3QgbWF0Y2ggdGhlIHNlY29uZCBhbmQgdGhpcmQncz8gSW0gdHJ5aW5nIHRvIGZp Z3VyZSBvdXQgd2hhdApJIGNhbiBkbyB0byBnZXQgbWF0Y2hlcyBvbiB0aGUgZmlyc3QgcXVlcnku IEkgZmlyc3Qgbm90aWNlZCB0aGF0IHNvbWUgb2YgbXkKaGlnaGxpZ2h0IHF1ZXJpZXMgd2VyZSBj b21pbmcgYmFjayB3aXRoIG5vICdoaXRzJy4gSSBjcmVhdGVkIHRoZSBmb2xsb3dpbmcgMwpxdWVy aWVzIHRvIHNob3cgdGhlIGlzc3VlIEknbSBoYXZpbmcuDQoNCkFjY29yZGluZyB0byB0aGUgZG9j cywgd2hlbiB0aGVyZSBhcmUgbm8gbWF0Y2hlcyAoaWRlbnRpZmllZCBieSBgPGI+PC9iPmAKdGFn cykgaXQgc2ltcGx5IHJldHVybnMgdGhlIGZpcnN0IGBNaW5Xb3Jkc2AuIFRoYXQncyB3aGF0IGlz IGhhcHBlbmluZyBpbgp0aGUgZmlyc3QgcXVlcnkgd2hlbiBJIHRoaW5rIHRoYXQgd2Ugc2hvdWxk IGFjdHVhbGx5IGdldCB0aGUgMiByZXN1bHRzIGJhY2sKYXMgd2UgZG8gaW4gdGhlIGZvbGxvd2lu ZyB0d28gcXVlcmllcy4NCg0KYGBgDQpwb3N0Z3Jlcz0jIFNFTEVDVCB0c19oZWFkbGluZSgnZW5n bGlzaCcsICdiZWdpbm5pbmcgd29yZCB3b3JkIHdvcmQgd29yZApDSElMRCB3b3JkIHdvcmQgd29y ZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQK d29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdv cmQgd29yZCB3b3JkIHdvcmQKd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3Jk IHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQKd29yZCB3b3JkIHdvcmQgd29yZCB3 b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQKd29y ZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQg d29yZCB3b3JkIHdvcmQKd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdv cmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQKd29yZCB3b3JkIHdvcmQgd29yZCB3b3Jk IHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCBTRVJWSUNFIGVuZGluZycsIA0KICAgIHRvX3RzcXVl cnkoJ2VuZ2xpc2gnLCAnQ0hJTEQgJiBTRVJWSUNFJyksIA0KICAgICdNYXhGcmFnbWVudHM9MixN aW5Xb3Jkcz01LE1heFdvcmRzPTEwJyk7DQoNCiAgICAgICAgICB0c19oZWFkbGluZSAgICAgICAg ICANCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiBiZWdpbm5pbmcgd29yZCB3b3Jk IHdvcmQgd29yZA0KKDEgcm93KQ0KYGBgDQpOb3cgbGV0J3MgaW5jcmVhc2UgYE1heFdvcmRzYCwg bm93IHdlIGdldCAyIG1hdGNoZXMNCmBgYA0KDQpwb3N0Z3Jlcz0jIFNFTEVDVCB0c19oZWFkbGlu ZSgnZW5nbGlzaCcsICdiZWdpbm5pbmcgd29yZCB3b3JkIHdvcmQgd29yZApDSElMRCB3b3JkIHdv cmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3Jk IHdvcmQKd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3 b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQKd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29y ZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQKd29yZCB3b3JkIHdvcmQg d29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdv cmQKd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3Jk IHdvcmQgd29yZCB3b3JkIHdvcmQKd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3 b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQKd29yZCB3b3JkIHdvcmQgd29y ZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCBTRVJWSUNFIGVuZGluZycsIA0KICAgIHRv X3RzcXVlcnkoJ2VuZ2xpc2gnLCAnQ0hJTEQgJiBTRVJWSUNFJyksIA0KICAgICdNYXhGcmFnbWVu dHM9MixNaW5Xb3Jkcz01LE1heFdvcmRzPTExJyk7DQoNCiAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHRzX2hlYWRsaW5lICAgICAgICAgICAKICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogYmVnaW5u aW5nIHdvcmQgd29yZCB3b3JkIHdvcmQgPGI+Q0hJTEQ8L2I+IHdvcmQgd29yZCB3b3JkIHdvcmQg d29yZCAuLi4Kd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIDxiPlNFUlZJQ0U8L2I+IGVuZGluZw0K KDEgcm93KQ0KYGBgDQpOb3cgbGV0J3MgaW5jcmVhc2UgYE1heEZyYWdtZW50c2AsIG5vdyB3ZSBn ZXQgMiBtYXRjaGVzDQpgYGANCnBvc3RncmVzPSMgU0VMRUNUIHRzX2hlYWRsaW5lKCdlbmdsaXNo JywgJ2JlZ2lubmluZyB3b3JkIHdvcmQgd29yZCB3b3JkCkNISUxEIHdvcmQgd29yZCB3b3JkIHdv cmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZAp3b3Jk IHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3 b3JkIHdvcmQgd29yZAp3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29y ZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZAp3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQg d29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZAp3b3JkIHdv cmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3Jk IHdvcmQgd29yZAp3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZCB3 b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29yZAp3b3JkIHdvcmQgd29yZCB3b3JkIHdvcmQgd29y ZCB3b3JkIHdvcmQgd29yZCB3b3JkIFNFUlZJQ0UgZW5kaW5nJywgDQogICAgdG9fdHNxdWVyeSgn ZW5nbGlzaCcsICdDSElMRCAmIFNFUlZJQ0UnKSwgDQogICAgJ01heEZyYWdtZW50cz0zLE1pbldv cmRzPTUsTWF4V29yZHM9MTAnKTsNCg0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICB0c19oZWFkbGluZSAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAg ICAgICAgICAgICAgICAgDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0NCiB3b3JkIHdvcmQgd29yZCB3b3JkIDxiPkNISUxEPC9iPiB3b3JkIHdvcmQgd29y ZCB3b3JkIHdvcmQgLi4uIHdvcmQgd29yZAp3b3JkIHdvcmQgPGI+U0VSVklDRTwvYj4gZW5kaW5n DQooMSByb3cpDQpgYGANCg0KSSBmZWVsIGxpa2Ugc29tZXRoaW5nIHN1YnRsZSBpcyBnb2luZyBv biBiZXR3ZWVuIGFsbCB0aGUgYE1heEZyYWdtZW50cywKTWluV29yZHMsIE1heFdvcmRzYCBzZXR0 aW5ncywgb3IgbWF5YmUgdGhpcyBpcyB1bmRlZmluZWQgYmVoYXZpb3Igb3IgYSBidWcuCkltIGhv cGluZyB0byBmaW5kIGEgd2F5IHRvIGdldCB0aGUgZmlyc3QgcXVlcnkgdG8gbWF0Y2ggYXMgSSBk byBiZWxpZXZlIGl0CnNob3VsZC4gUGxlYXNlIGNvcnJlY3QgbWUgaWYgSSdtIHdyb25nLgoK --===============3405898992939261061==--