Re: [BUG] false positive in bt_index_check in case of short 4B varlena datum

Поиск
Список
Период
Сортировка
От Alexander Lakhin
Тема Re: [BUG] false positive in bt_index_check in case of short 4B varlena datum
Дата
Msg-id 0b535249-a00c-a38a-85f6-d5a38c62dd55@gmail.com
обсуждение исходный текст
Ответ на Re: [BUG] false positive in bt_index_check in case of short 4B varlena datum  ("Andrey M. Borodin" <x4mmm@yandex-team.ru>)
Ответы Re: [BUG] false positive in bt_index_check in case of short 4B varlena datum  (Alexander Korotkov <aekorotkov@gmail.com>)
Список pgsql-bugs
Hi Andrey,

23.01.2024 21:09, Andrey M. Borodin wrote:
> PFA draft fixes for both this errors. Alexander, Michael, Jian, what do you think?
>
> I did not touch anything in first step - fix for original bug in this thread. However, I think that comments from
JianHe worth incorporating into the fix.
 
>

I''m confused by a NOTICE added, as it printed now even for cases, which
worked before, for example:
CREATE TABLE t(f1 text);
CREATE INDEX idx ON t(f1);
INSERT INTO t VALUES(repeat('1234567890', 1000));
SELECT bt_index_check('idx', true);
NOTICE:  Index contain tuples that cannot fit into index page, if toasted with current toast policy
  bt_index_check
----------------

(1 row)

Best regards,
Alexander



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

Предыдущее
От: Tender Wang
Дата:
Сообщение: Re: BUG #18310: Some SQL commands fail to process duplicate objects with error: tuple already updated by self
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Fwd: BUG #18016: REINDEX TABLE failure