From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | daniel(dot)farkas(at)datoris(dot)com |
Subject: | BUG #17502: View based on window functions returns wrong results when queried |
Date: | 2022-05-28 22:54:18 |
Message-ID: | 17502-281a7aaacfaa872a@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: 17502
Logged by: Daniel Farkaš
Email address: daniel(dot)farkas(at)datoris(dot)com
PostgreSQL version: 10.10
Operating system: Linux
Description:
Hey,
Please be gentle, I've never been in contact with Postgres developers.
In short, I've created a view, which has rather sketchy window functions,
but it gives me results I need.
When I do select * on it, it gives me what I expect. One of the columns has
five distinct values.
But when I do group by on that column, it gives me only one of the values.
When I drop the view and create materialized view, all is good, I get all
five values.
My guess is that some parts of the inner select are affecting outer, view's
select, which is not something I would expect.
My current Postgres is PostgreSQL 10.10 on x86_64-pc-linux-musl, compiled by
gcc (Alpine 8.3.0) 8.3.0, 64-bit.
If you think this is worth investigating further, I will try composing a
simpler example, and test it in a more recent Postgres version.
Maybe it's a known limitation I'm not aware of.
Let me know what you think.
Daniel
From | Date | Subject | |
---|---|---|---|
Next Message | Nathan Bossart | 2022-05-29 03:30:33 | Re: Extension pg_trgm, permissions and pg_dump order |
Previous Message | Vitaly V. Voronov | 2022-05-28 20:57:25 | Re: BUG #17501: COPY is failing with "ERROR: invalid byte sequence for encoding "UTF8": 0xe5" |