Skip site navigation (1) Skip section navigation (2)

exists <==> not exists ???

From: Christian Breimann <chr(at)math(dot)uni-muenster(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: exists <==> not exists ???
Date: 2001-05-10 08:25:10
Message-ID: 3AFA5066.F851227B@math.uni-muenster.de (view raw or flat)
Thread:
Lists: pgsql-bugs
Hello,

I think, that I've found one bug in PostgreSQL 7.1 on
sparc-sun-Solaris2.7, compilied by GCC 2.7.2.3:


When executing a SQL-Query with a "where not exists (...)" Statement,
the result is wrong. It's the same result as I execute "where exists
(...)" This mustn't be true.

Is this a known bug?

Greetings

Christian Breimann

-- 
Christian Breimann
chr(at)math(dot)uni-muenster(dot)de       Institut fuer Informatik
Tel.: (+49) 251 - 83 38442     Westfaelische Wilhelms-Universitaet
FAX.: (+49) 251 - 83 33755     Einsteinstr. 62, 48149 Muenster, Germany

Responses

pgsql-bugs by date

Next:From: McCoy MunDate: 2001-05-10 09:33:54
Subject: createdb test shown as number in data directory
Previous:From: Jerome O'NeilDate: 2001-05-10 08:13:42
Subject: RE: SELECT updatability clause defective.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group