BUG #14552: tsquery converts AND operator into OR when nested inside OR operations

From: bjorn(at)eventmy(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14552: tsquery converts AND operator into OR when nested inside OR operations
Date: 2017-02-18 00:36:21
Message-ID: 20170218003621.6098.76708@wrigleys.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: 14552
Logged by: Bjorn Linder
Email address: bjorn(at)eventmy(dot)com
PostgreSQL version: 9.4.5
Operating system: OS 10.11.6
Description:

Working correctly, no results:
SELECT ts_rank(to_tsvector('lets eat a cat'), ('fat & bat | rat'::tsquery &&
'cat'::tsquery));
ts_rank
---------
1e-20
(1 row)

Should also yield no results:
SELECT ts_rank(to_tsvector('lets eat a fat cat'), ('fat & bat |
rat'::tsquery && 'cat'::tsquery));
ts_rank
-----------
0.0991032
(1 row)

Is this intended behavior? Is there a recommended way to nest AND operators
inside OR operations? The relevant documentation looks to be the same for
newer versions so I'm assuming this behavior hasn't been changed between
versions - let me know. Thanks!

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2017-02-18 01:08:53 Re: BUG #14494: Regression - Null arrays are not queryable
Previous Message Linas Vepstas 2017-02-18 00:17:54 Re: BUG #14494: Regression - Null arrays are not queryable