PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID16511
PG Version10.7
OSMacOS
Opened2020-06-25 17:40:04+00
Reported byAnton Luhavy
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      16511
Logged by:          Anton Luhavy
Email address:      (redacted)
PostgreSQL version: 10.7
Operating system:   MacOS
Description:        

Given table is "task" (id uuid primary key, status text not null),
Query "select 'b' = all (select status from task where status = 'a')"
returns true if table "task" is empty

Messages

DateAuthorSubject
2020-06-25 17:40:04+00PG Bug reporting formBUG #16511: Using '= all ( )' with empty table returns true
2020-06-25 18:00:37+00Tom LaneRe: BUG #16511: Using '= all ( )' with empty table returns true