From: | Olivier Leprêtre <o(dot)lepretre(at)gmail(dot)com> |
---|---|
To: | "'pgsql-general'" <pgsql-general(at)postgresql(dot)org> |
Subject: | Strange behavior |
Date: | 2020-10-10 15:59:11 |
Message-ID: | 001a01d69f1e$4c006d60$e4014820$@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
Im surprised by this behavior I noticed in pgadmin3 and postgresql 9.6
Suppose those two tables
create table test1 (v1 text)
create table test2 (v2 text)
insert into test1 (v1) values ('A')
insert into test2 (v2) values ('B')
query select v1 from test2 return v2 column doesnt exists. Right.
But the following query does not return any error but only an empty result
set.
select v1 from test1 where v1 not in (select v1 from test2)
In other words, a wrong query returns a valid result. This happens because
v1 is a column from test1, (select vx from test2) will return an error as
expected.
Did I missed something ?
Thanks,
Olivier
--
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast.
https://www.avast.com/antivirus
From | Date | Subject | |
---|---|---|---|
Next Message | Francisco Olarte | 2020-10-10 16:36:55 | Re: Strange behavior |
Previous Message | Cory Nemelka | 2020-10-10 14:21:02 | Re: Writing WAL files |