BUG #16592: websearch_to_tsquery() returns queries that don't result in expected matches - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #16592: websearch_to_tsquery() returns queries that don't result in expected matches
Date
Msg-id 16592-70b110ff9731c07d@postgresql.org
Whole thread Raw
Responses Re: BUG #16592: websearch_to_tsquery() returns queries that don't result in expected matches
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      16592
Logged by:          Barry Pederson
Email address:      bp@barryp.org
PostgreSQL version: 12.4
Operating system:   Ubuntu 20.04
Description:

In the regression tests src/test/regress/expected/tsearch.out there's an
example relating to double-quoted searches:

select websearch_to_tsquery('english', '"pg_class pg"');
    websearch_to_tsquery     
-----------------------------
 ( 'pg' & 'class' ) <-> 'pg'
(1 row)

However, if you ran a query like that against that exact text 'pg_class pg',
the result is false when I'd expect it should be true

   select to_tsvector('pg_class pg') @@ websearch_to_tsquery('"pg_class
pg"');

I'd think websearch_to_tsquery('english', '"pg_class pg"') should ideally
return
  
    'pg' <-> 'class'  <-> 'pg'

which does match the original string, e.g:

      select to_tsvector('pg_class pg') @@ to_tsquery('pg <-> class <->
pg');

does return true


pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: ALTER TABLE ALTER COLUMN SET TYPE crash
Next
From: "hans.wolters"
Date:
Subject: password saved in .psql_history