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

On Thu, Aug 4, 2022 at 4:28 PM PG Bug reporting form <noreply@postgresql.org> wrote:

The following bug has been logged on the website:

Bug reference:      17570
Logged by:          Alexander Kozhemyakin
Email address:      a.kozhemyakin@postgrespro.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

Thanks for the report! I can reproduce it in HEAD. Propose the attached

for fix.