Regression results from HPUX 9/PA-RISC - Mailing list pgsql-hackers

The regression tests are starting to look pretty good.  Aside
from the usual minor discrepancies in math error message wording
&etc, I see only two things that look wrong.

First, the "tinterval" test is giving differently sorted results
than the regression test expects for two queries that sort on
tintervals.  Now, I'm not too sure what it means to sort on a
tinterval, but the tinterval comparison operators in adt/date.c
seem to think that the way to compare tintervals is to compare
their duration.  If that's how it's supposed to work, then
*neither* the regression reference data nor my output is right!
The regression reference sorts in order:
    infinite interval
    25-year 8-month interval
    25-year 4-month interval
    1-month interval
    8-years-and-growing interval
My result puts the epoch-to-1995 interval at the end, which is
just as broken.

I expect the reason the infinite interval sorts first is internal
overflow in the comparison routines, which after all are only using
32-bit integer arithmetic to compute the interval lengths.  But
I don't understand why the other intervals don't sort properly.

BTW, this regression test has a time bomb: as "current" increases
the correct sort order will change, about 16 years from now...

There is a second case failing with similar symptoms in tinterval,
but I didn't bother to look at it closely.

Secondly, the "rules" test emits the same tuples in a different order
in one case.  It's from an unordered SELECT so it's hard to claim
that the output is wrong.  I think this might just indicate an obsolete
reference file, but I don't know enough to know if that's true.
Are other people getting comparison failures for "rules", or not?

            regards, tom lane


*** expected/tinterval.out    Sun Jan  4 22:35:46 1998
--- results/tinterval.out    Sat Sep 19 19:22:58 1998
***************
*** 99,107 ****

----+---------------------------------------------------------------+---------------------------------------------------------------
      |["-infinity" "infinity"]                                       |["-infinity" "infinity"]
              
      |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]|["Sat May 10 23:59:12 1947 PST" "Sun Jan 14
03:14:211973 PST"] 
-     |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       |["epoch" "Mon May 01 00:30:30 1995 PDT"]
              
      |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]|["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04
23:59:121983 PDT"] 
      |["Thu Feb 15 12:15:03 1990 PST" "current"]                     |["Thu Feb 15 12:15:03 1990 PST" "current"]
              
  (5 rows)

  QUERY: SELECT '' AS fourteen, t1.f1 AS interval1, t2.f1 AS interval2
--- 99,107 ----

----+---------------------------------------------------------------+---------------------------------------------------------------
      |["-infinity" "infinity"]                                       |["-infinity" "infinity"]
              
      |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]|["Sat May 10 23:59:12 1947 PST" "Sun Jan 14
03:14:211973 PST"] 
      |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]|["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04
23:59:121983 PDT"] 
      |["Thu Feb 15 12:15:03 1990 PST" "current"]                     |["Thu Feb 15 12:15:03 1990 PST" "current"]
              
+     |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       |["epoch" "Mon May 01 00:30:30 1995 PDT"]
              
  (5 rows)

  QUERY: SELECT '' AS fourteen, t1.f1 AS interval1, t2.f1 AS interval2
***************
*** 110,129 ****
     ORDER BY interval1, interval2;
  fourteen|interval1                                                      |interval2
                  

--------+---------------------------------------------------------------+---------------------------------------------------------------
          |["-infinity" "infinity"]                                       |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14
03:14:211973 PST"] 
          |["-infinity" "infinity"]                                       |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04
23:59:121983 PDT"] 
-         |["-infinity" "infinity"]                                       |["epoch" "Mon May 01 00:30:30 1995 PDT"]
                  
-         |["-infinity" "infinity"]                                       |["Thu Feb 15 12:15:03 1990 PST" "current"]
                  
          |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]|["-infinity" "infinity"]
                  
          |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       |["-infinity" "infinity"]
                  
-         |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]|["-infinity" "infinity"]
                  
          |["Thu Feb 15 12:15:03 1990 PST" "current"]                     |["-infinity" "infinity"]
                  
          |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14
03:14:211973 PST"] 
          |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]|["epoch" "Mon May 01 00:30:30 1995 PDT"]
                  
          |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04
23:59:121983 PDT"] 
          |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       |["Thu Feb 15 12:15:03 1990 PST" "current"]
                  
          |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]|["epoch" "Mon May 01 00:30:30 1995 PDT"]
                  
!         |["Thu Feb 15 12:15:03 1990 PST" "current"]                     |["epoch" "Mon May 01 00:30:30 1995 PDT"]
                  
  (14 rows)

  QUERY: SELECT '' AS five, t1.f1
--- 110,129 ----
     ORDER BY interval1, interval2;
  fourteen|interval1                                                      |interval2
                  

--------+---------------------------------------------------------------+---------------------------------------------------------------
+         |["-infinity" "infinity"]                                       |["Thu Feb 15 12:15:03 1990 PST" "current"]
                  
+         |["-infinity" "infinity"]                                       |["epoch" "Mon May 01 00:30:30 1995 PDT"]
                  
          |["-infinity" "infinity"]                                       |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14
03:14:211973 PST"] 
          |["-infinity" "infinity"]                                       |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04
23:59:121983 PDT"] 
          |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]|["-infinity" "infinity"]
                  
          |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       |["-infinity" "infinity"]
                  
          |["Thu Feb 15 12:15:03 1990 PST" "current"]                     |["-infinity" "infinity"]
                  
          |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14
03:14:211973 PST"] 
+         |["Thu Feb 15 12:15:03 1990 PST" "current"]                     |["epoch" "Mon May 01 00:30:30 1995 PDT"]
                  
          |["Sat May 10 23:59:12 1947 PST" "Sun Jan 14 03:14:21 1973 PST"]|["epoch" "Mon May 01 00:30:30 1995 PDT"]
                  
          |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04
23:59:121983 PDT"] 
          |["epoch" "Mon May 01 00:30:30 1995 PDT"]                       |["Thu Feb 15 12:15:03 1990 PST" "current"]
                  
          |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]|["epoch" "Mon May 01 00:30:30 1995 PDT"]
                  
!         |["Sun Sep 04 23:59:12 1983 PDT" "Tue Oct 04 23:59:12 1983 PDT"]|["-infinity" "infinity"]
                  
  (14 rows)

  QUERY: SELECT '' AS five, t1.f1

----------------------

*** expected/rules.out    Wed Sep 16 10:35:06 1998
--- results/rules.out    Sat Sep 19 19:29:16 1998
***************
*** 315,322 ****
  pname |sysname
  ------+-------
  bm    |pluto
- jwieck|orion
  jwieck|notjw
  (3 rows)

  QUERY: delete from rtest_system where sysname = 'orion';
--- 315,322 ----
  pname |sysname
  ------+-------
  bm    |pluto
  jwieck|notjw
+ jwieck|orion
  (3 rows)

  QUERY: delete from rtest_system where sysname = 'orion';

----------------------