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.
Oops.. sorry I didn't notice Japin's email before I hit the 'send' for my reply. The two patches are almost the same, except that before we check against whole-row reference, I also adjust the attnum by FirstLowInvalidHeapAttributeNumber.
