btree_gist regression tests failing in 8.0 branch?

Started by Tom Laneover 20 years ago2 messages
#1Tom Lane
tgl@sss.pgh.pa.us

Say guys, could you look into why btree_gist is failing its timetz
regression test in the 8.0 branch, if built with
--enable-integer-datetimes? Several of the buildfarm machines
are showing this, and I've reproduced it locally.

When I saw it I said to myself, "Oh, I forgot to back-patch the code
to make the timetz time + zone calculation do the Right Thing".
But it still fails after back-patching. The same regression test
passes in CVS HEAD, so I'm thinking there must be some other bug fix
that needs to get propagated back to 8.0. I don't have enough knowledge
of the GIST code to figure it out quickly, though.

regards, tom lane

#2Teodor Sigaev
teodor@sigaev.ru
In reply to: Tom Lane (#1)
Re: btree_gist regression tests failing in 8.0 branch?

I'll have a look.

Tom Lane wrote:

Say guys, could you look into why btree_gist is failing its timetz
regression test in the 8.0 branch, if built with
--enable-integer-datetimes? Several of the buildfarm machines
are showing this, and I've reproduced it locally.

When I saw it I said to myself, "Oh, I forgot to back-patch the code
to make the timetz time + zone calculation do the Right Thing".
But it still fails after back-patching. The same regression test
passes in CVS HEAD, so I'm thinking there must be some other bug fix
that needs to get propagated back to 8.0. I don't have enough knowledge
of the GIST code to figure it out quickly, though.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

--
Teodor Sigaev E-mail: teodor@sigaev.ru
WWW: http://www.sigaev.ru/