Re: BUG #15172: Postgresql ts_headline with <-> operator does not highlight text properly

Поиск
Список
Период
Сортировка
От Alex Malek
Тема Re: BUG #15172: Postgresql ts_headline with <-> operator does not highlight text properly
Дата
Msg-id CAGH8cccS-9yb1VkgUTAaghz4P3aL8DneH_24bN7Y0LCLO8by1Q@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #15172: Postgresql ts_headline with <-> operator does nothighlight text properly  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #15172: Postgresql ts_headline with <-> operator does not highlight text properly  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-bugs

I can confirm this is still an issue in PostgreSQL 14.4

Best,
Alex


On Wed, Aug 3, 2022 at 1:58 PM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      15172
Logged by:          Ngigi Waithaka
Email address:      ngigi@at.co.ke
PostgreSQL version: 10.3
Operating system:   Linux
Description:       

I have a noticed a likely bug when using ts_headline with the <-> operator

Assuming the following query:

SELECT ts_headline('English','This Commercial Bank does not have any Equity
in Europe but European Commercial Bank does',
                    phraseto_tsquery('English','European Commercial
Bank')::tsquery);

The returned result is:
This <b>Commercial</b> <b>Bank</b> does not have any Equity in Europe but
<b>European</b> <b>Commercial</b> <b>Bank</b> does

This highlights the words Commercial & Bank separately in addition to
European Commercial Bank.

However, the correct output expected should be:
This Commercial Bank does not have any Equity in Europe but <b>European</b>
<b>Commercial</b> <b>Bank</b> does

Which only highlights *European Commercial Bank* due to the <-> operator in
phraseto_tsquery.

SELECT phraseto_tsquery('English','European Commercial Bank');
returns 'european' <-> 'commerci' <-> 'bank' as expected indicating the
problem is with ts_headline function.

Regards
NgigiW

В списке pgsql-bugs по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #17569: false negative / positive results when using <-> (followed by) and tsvector limit (16383) hit
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #17564: Planner bug in combination of generate_series(), unnest() and ORDER BY