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 |
Thread: | |
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
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.
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 |