Re: Wrong result with constant quals

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Vik Fearing <vik(at)postgresfriends(dot)org>
Cc: pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Wrong result with constant quals
Date: 2022-11-04 00:14:28
Message-ID: 2198598.1667520868@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Vik Fearing <vik(at)postgresfriends(dot)org> writes:
> I allowed for this by saying it could be a single group with no rows if
> you preferred to look at it that way.

That is exactly what the standard says.

> This does not explain why the WHERE FALSE is being ignored and producing
> rows.

It's not ignored, but it applies to the pre-grouping rows, of which
there aren't any to remove. But there's still a group.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Vik Fearing 2022-11-04 08:07:54 Re: Wrong result with constant quals
Previous Message Pantelis Theodosiou 2022-11-04 00:12:35 Re: Wrong result with constant quals