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

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