Re: BUG #13863: Select from views gives wrong results

Поиск
Список
Период
Сортировка
От Dean Rasheed
Тема Re: BUG #13863: Select from views gives wrong results
Дата
Msg-id CAEZATCW1UtC7duDX6Bcf+7A26Ug3SDJTQrLfuqx3hH-u-fQ-vQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #13863: Select from views gives wrong results  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Ответы Re: BUG #13863: Select from views gives wrong results  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Список pgsql-bugs
On 18 January 2016 at 12:54, Andrew Gierth <andrew@tao11.riddles.org.uk> wrote:
> Obvious question is, can we keep the optimization in the case that the
> qual is strict? and if so, should we?
>

Perhaps. I don't think it's entirely obvious what it means for a qual
to be strict.

I think that it would have to be the case that for every nullable
expression (every expression appearing in at least one grouping set,
but not appearing in all the grouping sets) the qual would have to be
provably false or null when that expression was null, or the qual
would have to be independent of that expression.

That seems like a pretty tricky piece of code to get right. It might
be more reasonable if you limited yourself to the case where all the
expressions were Vars, then you could use find_nonnullable_vars().

Regards,
Dean

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

Предыдущее
От: "Igal @ Lucee.org"
Дата:
Сообщение: Re: BUG #13859: pg_upgrade permissions on Windows
Следующее
От: Volker Paul
Дата:
Сообщение: Error and wrong lenghth of non-ASCII Unicode string in plpythonu