Re: BUG #13391: when use in/= & subquery, non exists column can elected.

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #13391: when use in/= & subquery, non exists column can elected.
Дата
Msg-id CAKFQuwbHQEfUBFGGFW=pD4zbZjmXsh6JW7qwunpt7MjwVUgWwQ@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #13391: when use in/= & subquery, non exists column can elected.  (digoal@126.com)
Список pgsql-bugs
Дерево обсуждения 
On Tuesday, June 2, 2015, <digoal@126.com> wrote:

> The following bug has been logged on the website:
>
> Bug reference:      13391
> Logged by:          digoal
> Email address:      digoal@126.com <javascript:;>
> PostgreSQL version: 9.4.2
> Operating system:   CentOS 6.x x64
> Description:
>
> when use in/= & subquery, non exists column can elected.
> for exp:
>
> postgres=# explain (analyze,verbose) select * from table1 where c1 =
> (select
> c1 from table2 limit 1);
>
>
This is a correlated subquery, not a bug.

David J.

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

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: BUG #13368: standby cluster immediately promotes after pg_basebackup from previously promoted master
Следующее
От: Gavin Flower
Дата:
Сообщение: Re: postgres documentation - proposed improvement/clarification