BUG #15689: Stemming of negation/not operator

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: ivanviragine(at)gmail(dot)com
Subject: BUG #15689: Stemming of negation/not operator
Date: 2019-03-12 20:00:43
Message-ID: 15689-3f2aba943354ac68@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: 15689
Logged by: Ivan Viragine
Email address: ivanviragine(at)gmail(dot)com
PostgreSQL version: 10.3
Operating system: MacOS and centOS
Description:

When using to_tsquery function it is stemming negation/not parts of the
query, where it probably shouldn't.
Some examples:

SELECT to_tsquery('english', 'car & !cars');
to_tsquery
----------------
'car' & !'car'

SELECT to_tsquery('english', 'corporation & !corporative');
to_tsquery
----------------------
'corpor' & !'corpor'

IMHO, it shouldn't stem cars to car, neither corporative to corpor. There
are several examples where it could lead to incorrect results.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2019-03-12 22:34:02 Re: BUG #15689: Stemming of negation/not operator
Previous Message Jon Wedell 2019-03-12 17:20:10 Re: Bug involving plus sign before newline in text field being duplicated or stripped