BUG #16511: Using '= all ( )' with empty table returns true

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: anton(dot)lugovoy(dot)hopni(at)gmail(dot)com
Subject: BUG #16511: Using '= all ( )' with empty table returns true
Date: 2020-06-25 17:40:04
Message-ID: 16511-ca1a7368d7453b7b@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 16511
Logged by: Anton Luhavy
Email address: anton(dot)lugovoy(dot)hopni(at)gmail(dot)com
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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2020-06-25 18:00:37 Re: BUG #16511: Using '= all ( )' with empty table returns true
Previous Message Pierre Mantha 2020-06-25 17:03:09 Re: BUG #16509: Unable to change from 32 bit to 64 bit