[HACKERS] postgres_fdw aggregation pushdown has collation change in 10beta.

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема [HACKERS] postgres_fdw aggregation pushdown has collation change in 10beta.
Дата
Msg-id CAMkU=1xmQpmsfzis8+-PGKgYPQMOMf5CJq4coDeRzxuLK1uO+Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: [HACKERS] postgres_fdw aggregation pushdown has collation changein 10beta.  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
Список pgsql-hackers
It is shipping collation-sensitive aggregates between servers which have different collations.

commit 7012b132d07c2b4ea15b0b3cb1ea9f3278801d98
Author: Robert Haas <rhaas@postgresql.org>
Date:   Fri Oct 21 09:54:29 2016 -0400

    postgres_fdw: Push down aggregates to remote servers.


I've attached a reproducing case.  Before this commit, the two final queries give the same answer, and after they give different answers.  Maybe this isn't considered a bug?  Is it just one of the "surprising semantic anomalies may arise when types or collations do not match"?  It should be able to know what collation the local definition of the foreign table has; couldn't it pass that collation over the foreign side?

I don't really care, I was just using min as a way to get an arbitrary value in the cases where there are more than one, but I found the change surprising.

Cheers,

Jeff
Вложения

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

Предыдущее
От: Jeevan Ladhe
Дата:
Сообщение: Re: [HACKERS] fix hard-coded index in make_partition_op_expr
Следующее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] Hash Functions