BUG #13501: Bug with subqueries in WHERE clause

Поиск
Список
Период
Сортировка
От me@egidiocaprino.it
Тема BUG #13501: Bug with subqueries in WHERE clause
Дата
Msg-id 20150715111247.2347.48754@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #13501: Bug with subqueries in WHERE clause
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      13501
Logged by:          Egidio Caprino
Email address:      me@egidiocaprino.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.

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

Предыдущее
От: Jeevan Chalke
Дата:
Сообщение: Grouping Sets: Fix unrecognized node type bug
Следующее
От: "宏病毒"
Дата:
Сообщение: ERROR: missing chunk number 0 for toast value 149761 in pg_toast_2619