BUG #16146: ts_headline does not find phrase matches correctly

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: augustinas(at)spotlightdata(dot)co(dot)uk
Subject: BUG #16146: ts_headline does not find phrase matches correctly
Date: 2019-12-04 08:39:48
Message-ID: 16146-494211a8f1aacbaa@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 16146
Logged by: Augustinas Jokubauskas
Email address: augustinas(at)spotlightdata(dot)co(dot)uk
PostgreSQL version: 12.0
Operating system: Ubuntu 18.04.3

When query:
select ts_headline(
$$Lorem ipsum urna. Nullam nullam ullamcorper urna.$$,
to_tsquery('Lorem') && phraseto_tsquery('ullamcorper urna'),
'StartSel=#$#, StopSel=#$#, FragmentDelimiter=$#$, MaxFragments=100,
MaxWords=100, MinWords=1'
is ran, a fragment of
> Lorem ipsum urna. Nullam nullam ullamcorper urna.
should be returned, however, the result is a single word of #$#Lorem#$# is
returned, meaning that ts_headline did not find the queried string.

Browse pgsql-bugs by date

  From Date Subject
Next Message Konstantin Knizhnik 2019-12-04 09:28:11 Re: Numeric is not leakproof
Previous Message Thomas Munro 2019-12-04 05:16:43 Re: Create database from template very slow