HSavage bug in Postgresql beta?

Поиск
Список
Период
Сортировка
От Chris Bitmead
Тема HSavage bug in Postgresql beta?
Дата
Msg-id 3725484E.4D4453@bigfoot.com
обсуждение исходный текст
Ответы Re: [HACKERS] HSavage bug in Postgresql beta?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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?


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] Lock freeze ? in MVCC
Следующее
От: José Soares
Дата:
Сообщение: Re: [HACKERS] psql bug ?