Postgres Pro
Downloads
Home   >   mailing lists

BUG #13918: Simple query with Having clause returns incorrect results - Mailing list pgsql-bugs

From tarasbob@gmail.com
Subject BUG #13918: Simple query with Having clause returns incorrect results
Date
Msg-id 20160204221323.2780.14702@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #13918: Simple query with Having clause returns incorrect results
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      13918
Logged by:          Taras Bobrovytsky
Email address:      tarasbob@gmail.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

pgsql-bugs by date:

Previous
From: xtracoder@gmail.com
Date:
Subject: BUG #13936: jsonb_object() -> ERROR: unknown type of jsonb container
Next
From: bear2k@mail.ru
Date:
Subject: BUG #13935: Duplicate row in pg_constraint table which is not accessible via indexes