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
Re: BUG #18429: Inconsistent results on similar queries with join lateral |
| Список | 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 по дате отправления: