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

От

Richard Guo

Тема

Дата

5 августа 2022 г. в 01:25:08

Msg-id

CAMbWs4-w6qW-_Kr3771Y1VaJMHstSYDjLb8L7Vu++kUdev057g@mail.gmail.com

обсуждение

Ответ на

Re: BUG #17570: Unrecognized node type for query with statistics on expressions (Tom Lane)

Список

pgsql-bugs

Дерево обсуждения

BUG #17570: Unrecognized node type for query with statistics on expressions PG Bug reporting form <noreply@postgresql.org> 4 августа 2022 г. в 08:27:06

Re: BUG #17570: Unrecognized node type for query with statistics on expressions Richard Guo <guofenglinux@gmail.com> 4 августа 2022 г. в 10:37:43

Re: BUG #17570: Unrecognized node type for query with statistics on expressions Richard Guo <guofenglinux@gmail.com> 4 августа 2022 г. в 11:25:58

Re: BUG #17570: Unrecognized node type for query with statistics on expressions Japin Li <japinli@hotmail.com> 4 августа 2022 г. в 14:59:07

Re: BUG #17570: Unrecognized node type for query with statistics on expressions Tom Lane <tgl@sss.pgh.pa.us> 4 августа 2022 г. в 15:42:38

Re: BUG #17570: Unrecognized node type for query with statistics on expressions Richard Guo <guofenglinux@gmail.com> 5 августа 2022 г. в 00:49:30

Re: BUG #17570: Unrecognized node type for query with statistics on expressions Richard Guo <guofenglinux@gmail.com> 5 августа 2022 г. в 09:03:13

Re: BUG #17570: Unrecognized node type for query with statistics on expressions Tom Lane <tgl@sss.pgh.pa.us> 5 августа 2022 г. в 15:08:27

Re: BUG #17570: Unrecognized node type for query with statistics on expressions Richard Guo <guofenglinux@gmail.com> 5 августа 2022 г. в 01:25:08

Re: BUG #17570: Unrecognized node type for query with statistics on expressions Japin Li <japinli@hotmail.com> 4 августа 2022 г. в 10:33:35

On Thu, Aug 4, 2022 at 11:42 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:

* The comments for statext_is_compatible_clause suck. If they'd
defined what the arguments are, perhaps this mess would have been
prevented. For extra credit, it'd be really nice to define what
"is compatible" means. I'd sure not have thought that that would
include permissions checks.

I think by 'compatible' it just means the clause is in the form that can
be estimated using MCV lists. Maybe we can define it as that.

In statext_is_compatible_clause() we have the permission checks to see
if we are allowed to read all required attributes, which indeed needs to
be mentioned in the function comments.

Thanks
Richard

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

Предыдущее

От: Richard Guo

Дата: 5 августа 2022 г. в 00:49:30

Сообщение: Re: BUG #17570: Unrecognized node type for query with statistics on expressions

Следующее

От: Richard Guo

Дата: 5 августа 2022 г. в 09:03:13

Сообщение: Re: BUG #17570: Unrecognized node type for query with statistics on expressions