Re: Assert failure when CREATE TEMP TABLE

Поиск
Список
Период
Сортировка
От Richard Guo
Тема Re: Assert failure when CREATE TEMP TABLE
Дата
Msg-id CAMbWs4-VkYarbZsu-dFFo6=J5XgaJX4GDfBqVbGJPO6qrV+iZQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Assert failure when CREATE TEMP TABLE  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs

On Mon, Oct 16, 2023 at 11:46 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Richard Guo <guofenglinux@gmail.com> writes:
> And 'git bisect' says that the first bad commit is 2489d76c, which makes
> me confused because the problemed query does not seem to involve
> nullingrels stuff.

Probably the reason is that addition of nullingrels fields to the Vars
pushed it over the edge of needing to be out-of-line.  The test case
is very close to the line as stated --- for example, I found that it
didn't crash if I changed "en_AG.utf8" to "C", and wasted some time
pursuing the idea that the collation had something to do with it.
The crash got much more stable after adding a couple more dummy clauses
to the CHECK condition, and I've also reproduced it with clauses as
straightforward as "c0 < 'very-long-constant'".

Ah, this clears up my confusion.  Thanks for the fix.

Thanks
Richard

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #18155: Logical Apply Worker Timeout During TableSync Causes Either Stuckness or Data Loss
Следующее
От: Flavien GUEDEZ
Дата:
Сообщение: Insufficient memory access checks in pglz_decompress