Win32 regression test status - Mailing list pgsql-hackers

From Claudio Natoli
Subject Win32 regression test status
Date
Msg-id A02DEC4D1073D611BAE8525405FCCE2B55F31C@harris.memetrics.local
Whole thread Raw
Responses Re: Win32 regression test status  (Joerg Hessdoerfer <Joerg.Hessdoerfer@sea-gmbh.com>)
Re: Win32 regression test status  ("Andrew Dunstan" <andrew@dunslane.net>)
Re: [pgsql-hackers-win32] Win32 regression test status  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi all,

my next TODO item for the Win32 port was to try to bring all the regression
tests up.

Pleased to report that, with a great deal of hackage + kludges (which I hope
to refine and submit as patches for review over the next couple weeks), all
but 10 tests pass!

7 of these fail pretty much *only* due to localtime returning NULL for
pre-1970 dates, specifically: date, timestamp, timestampz, abstime,
tinterval, horology, arrays. To resolve this, seems like there are 3
solutions:

a) Provide "post-1970-only" versions of the expected regression test output,
for use under win32
b) Remove pre-1970 dates from *all* regression test files
c) Code up "pg_localtime" for win32

None of these are appealing, particularly b). Any better ideas?


With this issue aside, that leaves three tests remaining for examination:
join, rules and stats. The regression diffs are attached.

The join and rules failures don't look material, AFAICS, as the right rows
are returned, just not necessarily in the expected order... is this an
issue? Is the order mandated in these cases. Again, afaIcs, it isn't, but
strictly I'm out of my depth here.

This leaves the stats test as possibly the only real remaining failure. An
analysis (collector not running?) based on the diff would be appreciated, as
well as pointers to which lines of code/functions one would expect to see
invoked if this test was running correctly, to help debugging.

Cheers,
Claudio


---
Certain disclaimers and policies apply to all email sent from Memetrics.
For the full text of these disclaimers and policies see
<a
href="http://www.memetrics.com/emailpolicy.html">http://www.memetrics.com/em
ailpolicy.html</a>



Attachment

pgsql-hackers by date:

Previous
From: "Thomas Hallgren"
Date:
Subject: Re: Pl/Java - next step?
Next
From: Joerg Hessdoerfer
Date:
Subject: Re: Win32 regression test status