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

Поиск
Список
Период
Сортировка
От Richard Guo
Тема Re: BUG #17570: Unrecognized node type for query with statistics on expressions
Дата
Msg-id CAMbWs4_PPrJ7JFXqewQfkMLP6-2kHi+5=11U0csQVTx7iq7esw@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #17570: Unrecognized node type for query with statistics on expressions  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #17570: Unrecognized node type for query with statistics on expressions  (Richard Guo <guofenglinux@gmail.com>)
Список pgsql-bugs

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.

Thanks
Richard
Вложения

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Japin Li
Дата:
Сообщение: Re: BUG #17570: Unrecognized node type for query with statistics on expressions
Следующее
От: Richard Guo
Дата:
Сообщение: Re: BUG #17570: Unrecognized node type for query with statistics on expressions