Regression from 7.3 to 7.4

Поиск
Список
Период
Сортировка
Искать
От
Dennis Bjorklund
Тема
Regression from 7.3 to 7.4
Дата
Msg-id
Pine.LNX.4.44.0404050836480.4551-100000@zigo.dhs.org
Список
Дерево обсуждения
Regression from 7.3 to 7.4 Dennis Bjorklund <db@zigo.dhs.org>
Re: Regression from 7.3 to 7.4 Tom Lane <tgl@sss.pgh.pa.us>
Re: Regression from 7.3 to 7.4 Tom Lane <tgl@sss.pgh.pa.us>
Re: Regression from 7.3 to 7.4 Dennis Bjorklund <db@zigo.dhs.org>
Re: Regression from 7.3 to 7.4 Tom Lane <tgl@sss.pgh.pa.us>
This testcase works in 7.3 but not in 7.4:

------------------------------------------

create table t1 (a int);
create table t2 (b int);
select * from t1, (select b as a from t2 group by a) as foo;
------------------------------------------

ERROR:  column "t2.b" must appear in the GROUP BY clause or be used in an 
aggregate function

I don't know if it's supposed to work to do a group by of an alias, but 
why not and it used to work.

--
/Dennis Björklund


В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Magnus Hagander
Дата:
Сообщение: Re: Function to kill backend
FAQ