PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15689
PG Version10.3
OSMacOS and centOS
Opened2019-03-12 20:00:43+00
Reported byIvan Viragine

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15689
Logged by:          Ivan Viragine
Email address:      (redacted)
PostgreSQL version: 10.3
Operating system:   MacOS and centOS

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');
 'car' & !'car'

SELECT to_tsquery('english', 'corporation & !corporative');
 '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.


2019-03-12 20:00:43+00PG Bug reporting formBUG #15689: Stemming of negation/not operator
2019-03-12 22:34:02+00Tom LaneRe: BUG #15689: Stemming of negation/not operator
2019-03-13 12:38:04+00Ivan ViragineRe: BUG #15689: Stemming of negation/not operator