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
|
| Список | 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 по дате отправления: