BUG #13918: Simple query with Having clause returns incorrect results

From: tarasbob(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13918: Simple query with Having clause returns incorrect results
Date: 2016-02-04 22:13:23
Message-ID: 20160204221323.2780.14702@wrigleys.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: 13918
Logged by: Taras Bobrovytsky
Email address: tarasbob(at)gmail(dot)com
PostgreSQL version: 9.3.10
Operating system: Ubuntu
Description:

The following query incorrectly returns 1 row instead of 0:

SELECT 1
FROM some_table
WHERE FALSE
HAVING TRUE

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2016-02-04 23:04:54 Re: BUG #13908: Query returns too few rows
Previous Message David G. Johnston 2016-02-04 22:13:00 Re: BUG #13908: Query returns too few rows