PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID16345
PG Version12.0
OSUbuntu 18.04.3
Opened2020-04-05 21:49:23+00
Reported byAugustinas Jokubauskas
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      16345
Logged by:          Augustinas Jokubauskas
Email address:      (redacted)
PostgreSQL version: 12.0
Operating system:   Ubuntu 18.04.3
Description:        

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.

Messages

DateAuthorSubject
2020-04-05 21:49:23+00PG Bug reporting formBUG #16345: ts_headline does not find phrase matches correctly
2020-04-09 03:02:21+00Tom LaneRe: BUG #16345: ts_headline does not find phrase matches correctly