Re: BUG #4479: Incorrect TSearch2 results when inserting after deleting

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #4479: Incorrect TSearch2 results when inserting after deleting
Дата
Msg-id 10204.1224624721@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #4479: Incorrect TSearch2 results when inserting after deleting  ("Dan Fabulich" <dan@fabulich.com>)
Ответы Re: BUG #4479: Incorrect TSearch2 results when inserting after deleting  (Teodor Sigaev <teodor@sigaev.ru>)
Re: BUG #4479: Incorrect TSearch2 results when inserting after deleting  (Teodor Sigaev <teodor@sigaev.ru>)
Список pgsql-bugs
"Dan Fabulich" <dan@fabulich.com> writes:
> Description:        Incorrect TSearch2 results when inserting after deleting

> EXPECTED: The last two SELECT statements should return the same results (1
> row)
> ACTUAL: The final SELECT statement returns 0 results.  The SELECT statement
> just before it returns 1 result.

Hmm.  I can reproduce this with the given script on 8.3 current, but
*not* in CVS HEAD.  Also, the script results in an indexscan plan,
but if you set enable_indexscan off (resulting in a bitmap scan of the
same index), the correct result is returned.  Fascinating.

Teodor, will you look at this?

            regards, tom lane

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

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Re: BUG #4488: jdbc : DatabaseMetaData.getPrimaryKeys no result
Следующее
От: "Prashant"
Дата:
Сообщение: BUG #4489: Installation error