Re: Wrong aggregate result when sorting by a NULL value

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Wrong aggregate result when sorting by a NULL value
Дата
Msg-id 20181103230837.6rv63tajaodxmp6j@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: Wrong aggregate result when sorting by a NULL value  (Andres Freund <andres@anarazel.de>)
Ответы Re: Wrong aggregate result when sorting by a NULL value  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-bugs
Hi,

On 2018-11-03 15:27:09 -0700, Andres Freund wrote:
> On 2018-11-03 18:18:40 -0400, Tom Lane wrote:
> > Andres Freund <andres@anarazel.de> writes:
> > > And pushed. Thanks Ondřej for the report, thanks Tom & Andrew for
> > > identifying the issue.
> > 
> > Hm, buildfarm seems less than pleased.  Did you miss making a
> > corresponding change in the JIT code?
> 
> Hm, I'm somewhat confused, let me look into that. The JIT code shouldn't
> really need to be changed here - it's the *generation* of expression
> steps that's going wrong - which then later get turned into JITed code,
> but that part worked previously for other expressions.

Turns out it's not a great idea to generate EEOP_AGG_STRICT_INPUT_CHECK
expressions with nargs = 0. Head -> Desk.  Pushed a fix (+ new
assertion).

Thanks!

Andres Freund


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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Wrong aggregate result when sorting by a NULL value
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Unable to copy large (>2GB) files using PostgreSQL 11 (Windows)