OK, patch attached that adds ORDER BY to the problem regression query.
---------------------------------------------------------------------------
Christopher Kings-Lynne wrote:
> > 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?
>
> None here.
>
> Chris
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
>
--
Bruce Momjian | http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
Index: src/test/regress/expected/rules.out
===================================================================
RCS file: /cvsroot/pgsql-server/src/test/regress/expected/rules.out,v
retrieving revision 1.62
diff -c -c -r1.62 rules.out
*** src/test/regress/expected/rules.out 2 Sep 2002 02:13:02 -0000 1.62
--- src/test/regress/expected/rules.out 2 Sep 2002 04:47:26 -0000
***************
*** 1002,1008 ****
sl8 | 1 | brown | 40 | inch | 101.6
(8 rows)
! SELECT * FROM shoe_ready WHERE total_avail >= 2;
shoename | sh_avail | sl_name | sl_avail | total_avail
------------+----------+------------+----------+-------------
sh1 | 2 | sl1 | 5 | 2
--- 1002,1008 ----
sl8 | 1 | brown | 40 | inch | 101.6
(8 rows)
! SELECT * FROM shoe_ready WHERE total_avail >= 2 ORDER BY 1;
shoename | sh_avail | sl_name | sl_avail | total_avail
------------+----------+------------+----------+-------------
sh1 | 2 | sl1 | 5 | 2
Index: src/test/regress/sql/rules.sql
===================================================================
RCS file: /cvsroot/pgsql-server/src/test/regress/sql/rules.sql,v
retrieving revision 1.21
diff -c -c -r1.21 rules.sql
*** src/test/regress/sql/rules.sql 2 Sep 2002 02:13:02 -0000 1.21
--- src/test/regress/sql/rules.sql 2 Sep 2002 04:47:29 -0000
***************
*** 585,591 ****
-- SELECTs in doc
SELECT * FROM shoelace ORDER BY sl_name;
! SELECT * FROM shoe_ready WHERE total_avail >= 2;
CREATE TABLE shoelace_log (
sl_name char(10), -- shoelace changed
--- 585,591 ----
-- SELECTs in doc
SELECT * FROM shoelace ORDER BY sl_name;
! SELECT * FROM shoe_ready WHERE total_avail >= 2 ORDER BY 1;
CREATE TABLE shoelace_log (
sl_name char(10), -- shoelace changed
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
