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

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 majordomo@postgresql.org)
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (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