From: | Chris Bitmead <chris(dot)bitmead(at)bigfoot(dot)com> |
---|---|
To: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | HSavage bug in Postgresql beta? |
Date: | 1999-04-27 05:17:03 |
Message-ID: | 3725484E.4D4453@bigfoot.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I'm using the 990329 snap shot.
I was doing this query...
SELECT story.approved, story.oid FROM story, webuser, category* WHERE
story.webuser = webuser.oid AND story.category = category.oid;
approved| oid
--------+------
f |181760
t |179383
t |179384
t |179385
t |179386
t |179387
(6 rows)
So far, so good. "approved" is a boolean field. Now I try...
SELECT story.approved, story.oid FROM story, webuser, category* WHERE
story.webuser = webuser.oid AND story.category = category.oid and
approved;
approved|oid
--------+---
(0 rows)
Yow! I expect 5 of the above 6 rows, but now I get none!
I tried simplifying the SELECT to only join 2 of the above tables but
the problem didn't arise.
Has anything been fixed recently that might account for this? If not, is
there anyway I can help you guys to get it fixed?
From | Date | Subject | |
---|---|---|---|
Next Message | José Soares | 1999-04-27 07:19:20 | Re: [HACKERS] psql bug ? |
Previous Message | Bruce Momjian | 1999-04-27 04:32:39 | Re: [HACKERS] Lock freeze ? in MVCC |