Skip site navigation (1) Skip section navigation (2)

Re: pgsql-server/src/test/regress sql/union.sql ex ...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql-server/src/test/regress sql/union.sql ex ...
Date: 2003-11-04 19:25:56
Message-ID: 24098.1067973956@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-committers
Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Tom Lane writes:
>> Log message:
>> Adjust data types in some of the UNION tests to avoid potentially
>> platform-dependent results, as per example from Larry Rosenman.

> The join test still fails on UnixWare:

Yeah.  I intended to leave that unfixed, since row-ordering differences
are specifically documented as a legitimate platform-specific
difference.

Our alternatives would be to add enough ORDER BY clauses to constrain
the results (which I don't want to do because it would limit the set
of join plans testable by the tests), or to add another result file
for this test.  I'd be in favor of the latter if there were more than
one platform showing this behavior, or if I thought that UnixWare's
behavior wouldn't change again next time SCO decides to tweak qsort.

			regards, tom lane

In response to

Responses

pgsql-committers by date

Next:From: Peter EisentrautDate: 2003-11-04 19:47:41
Subject: Re: pgsql-server/src/test/regress sql/union.sql ex ...
Previous:From: Peter EisentrautDate: 2003-11-04 19:18:40
Subject: Re: pgsql-server/src/test/regress sql/union.sql ex ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group