Unexpected behaviour, definitely looks like a bug.

Поиск
Список
Период
Сортировка
От Leshchuk Aleksey
Тема Unexpected behaviour, definitely looks like a bug.
Дата
Msg-id 8120BE07-AC15-457B-B4CE-3E9BCC0D13E0@aurea.com
обсуждение исходный текст
Ответы Re: Unexpected behaviour, definitely looks like a bug.  (Nikolay Samokhvalov <samokhvalov@gmail.com>)
Re: Unexpected behaviour, definitely looks like a bug.  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-bugs
PostgresQL version 9.4.20

WITH test(id, not_id) AS (
SELECT * FROM (VALUES (1,1), (3,4)) AS t
),

test2(id1) AS (
SELECT * FROM (VALUES (2), (3) ) AS t
)
-- SELECT not_id FROM test2 -- ERROR column "not_id" does not exist

SELECT * FROM test WHERE id IN ( SELECT not_id FROM test2 ); -- <-- not_id selected from test table no ERROR, result is: 1,1


Aleksey Leshchuk
Ruby on Rails Chief Software Architect
  - o. +79262462693m. +79262462693
Skype: leshchuk

Aurea

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

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15745: WAL References Invalid Pages...that eventually resolves
Следующее
От: Nikolay Samokhvalov
Дата:
Сообщение: Re: Unexpected behaviour, definitely looks like a bug.