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

On Thu, Aug 4, 2022 at 6:37 PM Richard Guo <guofenglinux(at)gmail(dot)com> wrote:

>
> On Thu, Aug 4, 2022 at 4:28 PM PG Bug reporting form <
> noreply(at)postgresql(dot)org> wrote:
>
>> 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
>
>
> 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.

Thanks
Richard