Re: Segfault in 8.0.2beta1

Michael Fuhr <mike(at)fuhr(dot)org> writes:
> While investigating somebody's question I ran the following query,
> which caused the backend to segfault:

> SELECT * FROM foo WHERE first_date <= now() AND last_date >= now();

> I have to run so I can't put together a test case right now, but
> here's the stack trace:

> #0 convert_timevalue_to_scalar (value=1913, typid=1184) at selfuncs.c:2816
> #1 0x81aa3e5 in convert_to_scalar (value=138003712, valuetypid=1184, scaledvalue=0xbfbfea50,
> lobound=1913, hibound=1951, boundstypid=1082, scaledlobound=0xbfbfea58,
> scaledhibound=0xbfbfea60) at selfuncs.c:2393

Mumble ... that patch I put in last week doesn't work at all, does it?
Back to the drawing board.

regards, tom lane