undocumented feature or bug in subquery : psql (PostgreSQL) 9.4.6 on SLES12 SP1

Поиск
Список
Период
Сортировка
От otter117@yahoo.de
Тема undocumented feature or bug in subquery : psql (PostgreSQL) 9.4.6 on SLES12 SP1
Дата
Msg-id 20160825162900.15675.78433@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: undocumented feature or bug in subquery : psql (PostgreSQL) 9.4.6 on SLES12 SP1  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.4/static/functions-subquery.html
Description:

psql (PostgreSQL) 9.4.6 on SLES12 SP1
2 tables a and b
               Table "public.a"
     Column      |           Type           |   Modifiers
-----------------+--------------------------+---------------
 foo             | integer                  | not null
 bar             | integer                  | not null

               Table "public.b"
     Column      |           Type           |   Modifiers
-----------------+--------------------------+---------------
 bar             | integer                  | not null

No error when executing this statement even though table b does not contain
column foo
SELECT foo,bar FROM a WHERE foo=1 AND bar NOT IN (SELECT bar FROM b WHERE
bar > 2 AND foo=2)

Get an error on this one ERROR:  column b.foo does not exist
SELECT foo,bar FROM a WHERE foo=1 AND bar NOT IN (SELECT bar FROM b WHERE
b.bar > 2 AND b.foo=2)

It works if I remove foo from the subquery.
SELECT foo,bar FROM a WHERE foo=1 AND bar NOT IN (SELECT bar FROM b WHERE
b.bar > 2)

Do I need to qualify all columns in the subquery or is this a bug is psql
9.4.6?


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

Предыдущее
От: jens.timmerman@gmail.com
Дата:
Сообщение: does md5 really help against sniffing?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: does md5 really help against sniffing?