parseCheckAggregates vs. assign_query_collations

Поиск
Список
Период
Сортировка
От Andrew Gierth
Тема parseCheckAggregates vs. assign_query_collations
Дата
Msg-id 87muo0k0c7.fsf@news-spur.riddles.org.uk
обсуждение исходный текст
Ответы Re: parseCheckAggregates vs. assign_query_collations  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Looking into a bug report on the -general list about grouping sets,
which turns out to be an issue of collation assignment: if the query has

  CASE GROUPING(expr) WHEN 1 ...

then the expression is rejected as not matching the one in the GROUP BY
clause, because CASE already assigned collations to the expression (as a
special case in its transform function) while the rest of the query
hasn't yet had them assigned, because parseCheckAggregates gets run
before assign_query_collations.

I'll be looking into this in detail later, but right now, cam anyone
think of any reason why parseCheckAggregates couldn't be moved to after
assign_query_collations?

-- 
Andrew (irc:RhodiumToad)


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

Предыдущее
От: Andreas Karlsson
Дата:
Сообщение: Re: [HACKERS] REINDEX CONCURRENTLY 2.0
Следующее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] generated columns