Re: custom average window function failure

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: custom average window function failure
Дата
Msg-id 19183.1476027964@sss.pgh.pa.us
обсуждение исходный текст
Ответ на custom average window function failure  (Seb <spluque@gmail.com>)
Ответы Re: custom average window function failure  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Seb <spluque@gmail.com> writes:
> Any thoughts on what has changed that is leading to this failure?

Clearly a bug --- the wrong type OIDs are being passed down to
array_append.  It should be told that it's getting called as

    (angle_vectors[], angle_vectors) returns angle_vectors[]

but what it's actually getting told is

    (vector, angle_vectors) returns vector

which naturally makes it spit up because "vector" isn't an array type.
I don't think control ever reaches your custom finalfunc at all.

Probably somebody fat-fingered this while refactoring code in the
aggregate/windowfunction area.  Possibly me :-(.  Haven't found
exactly where things are going off the rails, but it's clearly
a PG bug.  Thanks for the report!

            regards, tom lane


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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: custom average window function failure
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: custom average window function failure