Bug Report | Using ts_headline with the <-> operator - Mailing list pgsql-bugs

From
Subject Bug Report | Using ts_headline with the <-> operator
Date
Msg-id 011a01d6ef29$0e8e1b20$2baa5160$@games.no
Whole thread Raw
Responses Re: Bug Report | Using ts_headline with the <-> operator
List pgsql-bugs

PostgreSQL version: 10.15

Operating system:   Linux/Ubuntu

 

Bug when using ts_headline with the <-> operator

 

Assuming the following query:

SELECT ts_headline('simple','The Cyberpunk launch did not go as expected for Cyberpunk Fans around the world', phraseto_tsquery('simple','Cyberpunk Fans')::tsquery);

 

The returned result is:

The <b>Cyberpunk</b> launch did not go as expected for <b>Cyberpunk</b> <b>Fans</b> around the world

 

This highlights the Cyberpunk alone in addition to Cyberpunk Fans.

 

However, the expected output would be:

The Cyberpunk launch did not go as expected for <b>Cyberpunk</b> <b>Fans</b> around the world

 

Which only highlights *Cyberpunk Fans* due to the <-> operator in phraseto_tsquery.

 

SELECT phraseto_tsquery('simple','Cyberpunk Fans');

The above returns 'cyberpunk<-> 'fans' as expected, so presumably this is an issue with the ts_headline function.

 

I would be great to see this fixed/improved in the near future.

 

Christian

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Reproducible GIST index corruption under concurrent updates
Next
From: Tom Lane
Date:
Subject: Re: Reproducible GIST index corruption under concurrent updates