| From: | me(at)egidiocaprino(dot)it |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #13501: Bug with subqueries in WHERE clause |
| Date: | 2015-07-15 11:12:47 |
| Message-ID: | 20150715111247.2347.48754@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 13501
Logged by: Egidio Caprino
Email address: me(at)egidiocaprino(dot)it
PostgreSQL version: 9.3.6
Operating system: Linux (don't know the distribution)
Description:
This query returns one record
select *
from merge.organization
where school_id = 1000056
This query returns no record
select *
from merge.account
where school_id = 1000056
This query returns no record
select *
from merge.sd3_hierarchy
where school_id = 1000056
This query returns no record
select *
from merge.organization
where school_id not in (select school_id from merge.account)
or school_id not in (select school_id from merge.sd3_hierarchy)
So I have one organisation that does not exists in the account table and
does not exist in the sd3_hierarchy. The last should return at least one
record.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeevan Chalke | 2015-07-15 13:40:45 | Grouping Sets: Fix unrecognized node type bug |
| Previous Message | 田中 翔太 | 2015-07-15 07:01:25 | 9.4.4 max_wal_sendersについて |