Re: RULE regression test failure - Mailing list pgsql-hackers

From Tom Lane
Subject Re: RULE regression test failure
Date
Msg-id 27907.1030690852@sss.pgh.pa.us
Whole thread Raw
In response to Re: RULE regression test failure  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Responses Re: RULE regression test failure  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
>> Hm, what do you get from
>> explain SELECT * FROM shoe_ready WHERE total_avail >= 2;
>> in the regression database?
>
> [this plan]

That seems substantially the same plan as I see here.  I guess
that the different output order must reflect a platform-specific
difference in qsort()'s treatment of equal keys.

Probably the best answer is to add "ORDER BY shoename" to the test
query to eliminate the platform dependency.  Any objections out there?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Fulltextindex
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: RULE regression test failure