I just updated to the latest HEAD, so I assume I have the cube_1.out that you changed. If you look at the order of the results expected in cube.out and cube_1.out, they are different. So I don't think we have a problem with the code, we just need to fix the ordering in cube_1.out.

The same problem appears in cube_2.out -- is this used by any platform?


Andrew Dunstan wrote:

Indeed. I am going to revert it.

The trouble is we currently have several orthogonal variations, which is a worry on its own:

. negative zero
. exponent format, and
. result ordering

Looking closer, the result ordering certainly does seem odd, as you say. Surely with ORDER BY it should be deterministic. What is the rule that describes the expected ordering of cube objects?



Rocco Altier wrote:

I think this will cause breakage for other people.

Right now I think the order is unique to AIX for some reason.

Recent buildfarm run of gazelle should have matched the -0 variant
(cube_1.out), but did not.

Also, what is worrisome is that there is an ORDER BY on the result set
that is failing on AIX, so I think there might be a deeper problem
lurking here.


-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Dunstan
Sent: Thursday, July 27, 2006 2:39 PM
To: pgsql-committers@postgresql.org
Subject: [COMMITTERS] pgsql: another try at keeping AIX/ppc happy on cube test.

Log Message:
another try at keeping AIX/ppc happy on cube test.

Modified Files:
       cube_1.out (r1.4 -> r1.5)

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?


Joshua Reich
Finance and Corporate Development
ROOT Exchange, A Division of ROOT Markets
601 W. 26th St. / Suite 1500
New York, NY 10001
W - (212) 645 6320 x 7101
M / T - (646) 427 7959

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

Reply via email to