Re: BUG #5472: Postgres hard crash in ...WHERE <bigint_col> IN (SELECT * FROM (VALUES (<int_value>), ...) AS t(col))

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alex Hunsaker <badalex(at)gmail(dot)com>
Cc: Vlad Romascanu <vromascanu(at)accurev(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5472: Postgres hard crash in ...WHERE <bigint_col> IN (SELECT * FROM (VALUES (<int_value>), ...) AS t(col))
Date: 2010-05-25 17:49:19
Message-ID: 26941.1274809759@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Alex Hunsaker <badalex(at)gmail(dot)com> writes:
> On Tue, May 25, 2010 at 10:39, Vlad Romascanu <vromascanu(at)accurev(dot)com> wrote:
>> The following reproducibly crashes Postgres 8.4.3 (segfault) inside
>> int84eq() on both Windows and Linux, but works just fine in 8.3.4:

> Hrm... Both work for me (8.4.3 and 8.4.4).

I think it wouldn't crash if you're using a build with pass-by-value
int8. It might even accidentally give correct answers, depending on
endianness etc.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Vlad Romascanu 2010-05-25 18:18:46 Re: BUG #5472: Postgres hard crash in ...WHERE <bigint_col> IN (SELECT * FROM (VALUES (<int_value>),...) AS t(col))
Previous Message Tom Lane 2010-05-25 17:47:33 Re: BUG #5472: Postgres hard crash in ...WHERE <bigint_col> IN (SELECT * FROM (VALUES (<int_value>), ...) AS t(col))