Re: BUG #18429: Inconsistent results on similar queries with join lateral

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #18429: Inconsistent results on similar queries with join lateral
Дата
Msg-id CAKFQuwaTm7gWL7S3KVFJCit92-JSFBoQ3Ax-msU+5P5YAw=C2w@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #18429: Inconsistent results on similar queries with join lateral  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #18429: Inconsistent results on similar queries with join lateral  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: BUG #18429: Inconsistent results on similar queries with join lateral  (Benoit Ryder <b.ryder@ateme.com>)
Список pgsql-bugs
Дерево обсуждения
On Friday, April 12, 2024, PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      18429
Logged by:          Benoît Ryder
Email address:      b.ryder@ateme.com
PostgreSQL version: 15.6
Operating system:   Debian
Description:       

-- `where` clause should return false: (14 - 6) / 4 = (12 - 6) / 4 → false
select 1 from c2 where (14 - c2.t) / c2.d = (12 - c2.t) / c2.

You are doing integer division here and the right hand side equals, 1.5; I suppose something may have used to round that up to the integer 2 which would make both sides equals but now (v16) rounds it down (or more accurately truncates it) to 1.

David J.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #18428: Connection broken but DB service still alive.
Следующее
От: Benoit Ryder
Дата:
Сообщение: Re: BUG #18429: Inconsistent results on similar queries with join lateral