BUG #17570: Unrecognized node type for query with statistics on expressions

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

Responses

Browse pgsql-bugs by date

  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