BUG #7653: Minor problem with join condition

Поиск
Список
Период
Сортировка
От stefano@sportilia.com
Тема BUG #7653: Minor problem with join condition
Дата
Msg-id E1TXr2X-000080-UB@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #7653: Minor problem with join condition  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      7653
Logged by:          Stefano Baccianella
Email address:      stefano@sportilia.com
PostgreSQL version: 9.2.1
Operating system:   Linux CentOS
Description:        =


Don't know if this is a bug or a correct behaviour, but in a query like
this:

SELECT t1.* FROM
table1 t1 JOIN
table2 t2 ON t1.id =3D t2.t1id JOIN
table3 t3 ON t1.id =3D t2.t1id

The parser should return an error because we are joining a table without
using any of its column.

I know this is a minor issue and a correct SQL syntax, but logically a JOIN
without condition is a Cartesian product between the two tables and not a
JOIN.
My proposal is to raise an error when a join condition doesn't contains the
table reference.

Regards

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

Предыдущее
От: Bernhard Reutner-Fischer
Дата:
Сообщение: Re: BUG #7644: Missing implicit types of Result and failing type-conversion
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #7653: Minor problem with join condition