pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #18636: I am seeing a difference in behavior between 13.12 and 15.6 for full text searching
2+ messages / 2 participants
[nested] [flat]
* BUG #18636: I am seeing a difference in behavior between 13.12 and 15.6 for full text searching
@ 2024-09-27 13:28 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2024-09-27 13:28 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: glenncipolla@gmail.com
The following bug has been logged on the website:
Bug reference: 18636
Logged by: Glenn Cipolla
Email address: glenncipolla@gmail.com
PostgreSQL version: 13.12
Operating system: Ubuntu 11.4
Description:
The following query
select to_tsvector('simple','RG147SW RG14 Greenham Road Newbury West
Berkshire')
@@ to_tsquery('simple', 'gree,west:*');
Returns false in PG 15.6, but returns true in pg 13.12. In 15.6 the code
returns 'gree:* <-> 'west':*.
In 13.12 it returns 'gree:* & 'west':*
This article says the 13.12 behavior was a bug that was fixed in 14.x
(https://akorotkov.github.io/blog/2021/05/22/pg-14-query-parsing/).
I have a dev team about to change their code to handle the new <->. Before
they do that, I would like a confirmation that this functionality is
1. A bug
2. The new functionality will not change back in newer versions. Do you
intent to stick with the <-> return value?
Thanks,
Glenn
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #18636: I am seeing a difference in behavior between 13.12 and 15.6 for full text searching
@ 2024-09-27 14:00 Laurenz Albe <laurenz.albe@cybertec.at>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 0 replies; 2+ messages in thread
From: Laurenz Albe @ 2024-09-27 14:00 UTC (permalink / raw)
To: glenncipolla@gmail.com; pgsql-bugs@lists.postgresql.org
On Fri, 2024-09-27 at 13:28 +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Bug reference: 18636
> Logged by: Glenn Cipolla
> Email address: glenncipolla@gmail.com
> PostgreSQL version: 13.12
> Operating system: Ubuntu 11.4
> Description:
>
> The following query
>
> select to_tsvector('simple','RG147SW RG14 Greenham Road Newbury West
> Berkshire')
> @@ to_tsquery('simple', 'gree,west:*');
>
> Returns false in PG 15.6, but returns true in pg 13.12. In 15.6 the code
> returns 'gree:* <-> 'west':*.
> In 13.12 it returns 'gree:* & 'west':*
>
> This article says the 13.12 behavior was a bug that was fixed in 14.x
> (https://akorotkov.github.io/blog/2021/05/22/pg-14-query-parsing/).
>
> I have a dev team about to change their code to handle the new <->. Before
> they do that, I would like a confirmation that this functionality is
> 1. A bug
> 2. The new functionality will not change back in newer versions. Do you
> intent to stick with the <-> return value?
We intend to stick with the way it works now... unless somebody comes
up with a very good reason why that behavior is buggy and worth the
compatibility pain the fix incurs.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-09-27 14:00 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-09-27 13:28 BUG #18636: I am seeing a difference in behavior between 13.12 and 15.6 for full text searching PG Bug reporting form <noreply@postgresql.org>
2024-09-27 14:00 ` Laurenz Albe <laurenz.albe@cybertec.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox