| From: | Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com> |
|---|---|
| To: | Leshchuk Aleksey <leshchuk(dot)aleksey(at)aurea(dot)com> |
| Cc: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Unexpected behaviour, definitely looks like a bug. |
| Date: | 2019-04-09 22:03:59 |
| Message-ID: | CANNMO+LW4k-H00yxpxUT6bcQ9p1a2nkxAKp7fHf_XY8Oq2yanA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Why do think there is a bug here?
On Tue, Apr 9, 2019 at 15:02 Leshchuk Aleksey <leshchuk(dot)aleksey(at)aurea(dot)com>
wrote:
> 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
> [image: Aurea]
> <https://www.aurea.com/?utm_source=email-signature&utm_medium=email>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2019-04-09 23:02:07 | Re: Unexpected behaviour, definitely looks like a bug. |
| Previous Message | Leshchuk Aleksey | 2019-04-09 21:38:47 | Unexpected behaviour, definitely looks like a bug. |