Bug in 7.1.3 and 7.2?

Поиск
Список
Период
Сортировка
От Hans-Jürgen Schönig
Тема Bug in 7.1.3 and 7.2?
Дата
Msg-id 3BEAA764.4D2AB9CC@cybertec.at
обсуждение исходный текст
Ответы Re: Bug in 7.1.3 and 7.2?
Re: Bug in 7.1.3 and 7.2?
Список pgsql-bugs
there seems to be a problem in 7.1.3 and 7.2:

test=# select * from a;id
---- 1 2 3
(3 rows)

test=# select * from b;id
---- 3 4
(2 rows)

test=# select a.*, d.* from a as c, b as d where a.id=b.id;
NOTICE:  Adding missing FROM-clause entry for table "a"
NOTICE:  Adding missing FROM-clause entry for table "b"id | id
----+---- 3 |  3 3 |  3 3 |  3 3 |  4 3 |  4 3 |  4
(6 rows)

Althoug c and d are aliases for a and b, the two tables are added to the

list in the from clause. Is this the desired behaviour or is it a bug?
   Hans



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

Предыдущее
От: pgsql-bugs@postgresql.org
Дата:
Сообщение: Bug #511: multiple foreign keys on same table fail update cascade
Следующее
От: Vincent.Gaboriau@answare.fr
Дата:
Сообщение: Curious problem with the character û é