Re: BUG #5025: Aggregate function with subquery in 8.3 and 8.4.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #5025: Aggregate function with subquery in 8.3 and 8.4.
Дата
Msg-id 15375.1251817595@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #5025: Aggregate function with subquery in 8.3 and 8.4.  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Ответы Re: BUG #5025: Aggregate function with subquery in 8.3 and 8.4.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
> I can see two possible interpretations for this:

> 1. The subquery pull-up code is broken, the transformation of a
> whole-row reference to ROW(...) is not valid.

I think the problem is probably that we need a PlaceHolderVar wrapper
around the ROW() constructor.

> 2. The semantics of STRICT with row arguments is broken. It should be
> made consistent with IS NULL.

Well, that's a different argument.  The immediate problem is that this
case doesn't behave consistently with pre-8.4 behavior, which was not
an intended change --- so I think we'd better make it work like before.

            regards, tom lane

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

Предыдущее
От: "Dmitry"
Дата:
Сообщение: BUG #5027: SQL query error?
Следующее
От: "Joseph Shraibman"
Дата:
Сообщение: BUG #5028: CASE returns ELSE value always when type is "char"