Thread: Re: [GENERAL] regression test

Regarding regression tests in my machine. I crossed from general to ports
as described under /usr/share/doc/postgresql-7.2.1/README.rpm-dist

My box is a linux i386 Pentium III, RedHat 7.3

I was able to run the regression tests. I have got 3 tests failed
during my run. See below.

parallel group (20 tests):  comments lseg type_sanity box reltime polygon
tinterval date point time circle path tim
etz abstime interval opr_sanity oidjoins inet timestamp timestamptz
     point                ... ok
     lseg                 ... ok
     box                  ... ok
     path                 ... ok
     polygon              ... ok
     circle               ... ok
     date                 ... ok
     time                 ... ok
     timetz               ... ok
     timestamp            ... ok
     timestamptz          ... ok
     interval             ... ok
     abstime              ... FAILED
     reltime              ... ok
     tinterval            ... FAILED
     inet                 ... ok
     comments             ... ok
     oidjoins             ... ok
     type_sanity          ... ok
     opr_sanity           ... ok
test geometry             ... ok
test horology             ... FAILED
test create_function_1    ... ok
test create_type          ... ok
test create_table         ... ok
test create_function_2    ... ok
test copy                 ... ok


Looking and inspecting the regression.diffs I have got lots of things
which somebody could explain me ?

I have attached the regression.diffs . Can I make sure my PG is properly
installed in this way, having 3 steps failed ?

stefan




On Wed, 24 Jul 2002, Lamar Owen wrote:

> On Wednesday 24 July 2002 06:13 am, stefan@extum.com wrote:
> > I am trying to run the regression tests under PG 7.2.1 RedHat 7.3-
> > I have installed PG from rpms , so from package, not source code. Right
> > now I have no idea if I need the source code of PG in order to start and
> > compile the regression tests ?
>
> See /usr/share/doc/postgresql-7.2.1/README.rpm-dist -- it has your answers.
>
> You will first need to see if the package 'postgresql-test' is installed -- if
> not, you can get it from ftp.postgresql.org in
> /pub/binary/v7.2.1/RPMS/redhat-7.3
>

On Friday 26 July 2002 05:32 am, stefan@extum.com wrote:
> I was able to run the regression tests. I have got 3 tests failed
> during my run. See below.

>      abstime              ... FAILED
>      tinterval            ... FAILED
> test horology             ... FAILED

> Looking and inspecting the regression.diffs I have got lots of things
> which somebody could explain me ?

> I have attached the regression.diffs . Can I make sure my PG is properly
> installed in this way, having 3 steps failed ?

These are due to Red Hat's decision to change the behavior of mktime(3), which
is used in those tests for timezone.  They did this without any heads up of
any kind, and now claim it was to be 'standards compliant'.  A heads up would
have allowed us to made a workaround available earlier.

The solution is not to do timestamp with timezone calculations for dates prior
to 1970, until such time this problem is fixed.  Red Hat believes it is not
their problem, and we believe it's not our problem.  But a workaround is
possible.

You must have run the tests under the C locale, as nothing else failed.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11