Re: [patch]HashJoin crash

2022-08-13 Thread Tom Lane
Zhang Mingli writes: > In ExecChooseHashTableSize(), commit b154ee63bb uses func pg_nextpower2_size_t > whose param must not be 0. Right. Fix pushed, thanks. regards, tom lane

Re: [patch]HashJoin crash

2022-08-13 Thread Justin Pryzby
+ Tom Lane On Fri, Aug 12, 2022 at 11:05:06PM +0800, Zhang Mingli wrote: > I got a coredump when using hash join on a Postgres derived > Database(Greenplum DB). > And I find a way to reproduce it on Postgres. > > Root cause: > > In ExecChooseHashTableSize(), commit b154ee63bb uses func pg_nextp

[patch]HashJoin crash

2022-08-12 Thread Zhang Mingli
Hi, I got a coredump when using hash join on a Postgres derived Database(Greenplum DB). And I find a way to reproduce it on Postgres. Root cause: In ExecChooseHashTableSize(), commit b154ee63bb uses func pg_nextpower2_size_t whose param must not be 0. ``` sbuckets = pg_nextpower2_size_t(hash_