From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | a(dot)kozhemyakin(at)postgrespro(dot)ru |
Subject: | BUG #17570: Unrecognized node type for query with statistics on expressions |
Date: | 2022-08-04 08:27:06 |
Message-ID: | 17570-f2f2e0f4bccf0965@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: 17570
Logged by: Alexander Kozhemyakin
Email address: a(dot)kozhemyakin(at)postgrespro(dot)ru
PostgreSQL version: 14.4
Operating system: ubunu 20.04
Description:
When executing the following script:
CREATE TABLE t(a INT, b VARCHAR);
INSERT INTO t(a, b) SELECT i, i FROM generate_series(1,100) s(i);
CREATE STATISTICS t_stats (mcv) ON (a), (b) FROM t;
ANALYZE t;
CREATE ROLE u;
--GRANT SELECT ON t TO u;
SET SESSION AUTHORIZATION u;
SELECT * FROM t WHERE a = 1 AND b::int = 1;
I get:
ERROR: unrecognized node type: 1697192808
And it fails with error "permission denied for table t" when condition is
just "a = 1" or "b::int = 1".
The same query executed successfully, if the select permission is granted to
user.
The first bad commit is a4d75c86b
From | Date | Subject | |
---|---|---|---|
Next Message | Mateusz Henicz | 2022-08-04 08:32:42 | Re: BUG #17567: Unable to Set Max_Connection in Postgresql which has replicas |
Previous Message | Kyotaro Horiguchi | 2022-08-04 08:12:39 | Re: [PATCH] BUG FIX: inconsistent page found in BRIN_REGULAR_PAGE |