Re: [HACKERS] Regression test status (was type coersion) - Mailing list pgsql-hackers

Tom,

I was never able to reproduce the ORDER BY anomaly on my Linux box.   I will try
to reproduce it on my AIX box.  I have some porting issues I need to get through
first.

In the mean time, if you still see a problem, could you run the query as:
     SELECT a, upper(c) FROM test_missing_target ORDER BY upper;
to eliminate the junkfilter as a culprit.

Bruce Momjian wrote:

> Do any of these problems still exist?
>
> > "Thomas G. Lockhart" <lockhart@alumni.caltech.edu> writes:
> > > ... all of the
> > > regression tests pass, except for the select_view test, which has been
> > > core dumping for weeks. Anyone else seeing that, or is it just me? :(
> >
> > I rebuilt the system from current sources today, and ran the regression
> > tests for the first time in a long time.  select_views works fine for
> > me, but there are several other tests that look badly broken:
> > SELECT ... ORDER BY upper(c) is misordering the results in select_implicit,
> > GROUP BY on a datetime is not working right in select_having, and the
> > random test is failing because it "can't look up operator 713".
> >
> > I'm on HP-UX 9.03, PA-RISC 1.1, gcc 2.7.2.2 if that helps.
> >
> >                       regards, tom lane
> >
> >
> > *** expected/select_implicit.out      Sat Aug 15 11:56:03 1998
> > --- results/select_implicit.out       Sat Aug 15 13:44:16 1998
> > ***************
> > *** 213,226 ****
> >   QUERY: SELECT a FROM test_missing_target ORDER BY upper(c);
> >   a
> >   -
> > - 1
> >   2
> >   3
> >   4
> >   5
> >   6
> > - 7
> >   8
> >   9
> >   0
> >   (10 rows)
> > --- 213,226 ----
> >   QUERY: SELECT a FROM test_missing_target ORDER BY upper(c);
> >   a
> >   -
> >   2
> > + 1
> >   3
> >   4
> >   5
> >   6
> >   8
> > + 7
> >   9
> >   0
> >   (10 rows)
> >
> > ----------------------
> >
> > *** expected/select_having.out        Wed Jul  8 10:29:09 1998
> > --- results/select_having.out Sat Aug 15 13:44:16 1998
> > ***************
> > *** 2,12 ****
> >     GROUP BY d1 HAVING count(*) > 1;
> >   d1                          |count
> >   ----------------------------+-----
> > ! Thu Jun 13 00:00:00 1957 PDT|    2
> > ! Mon Feb 10 09:32:01 1997 PST|    3
> > ! Mon Feb 10 17:32:01 1997 PST|   13
> >   Sun Feb 16 17:32:01 1997 PST|    2
> >   Sat Mar 01 17:32:01 1997 PST|    2
> > ! invalid                     |    2
> > ! (6 rows)
> >
> > --- 2,13 ----
> >     GROUP BY d1 HAVING count(*) > 1;
> >   d1                          |count
> >   ----------------------------+-----
> > ! Thu Jun 13 00:00:00 1957 PST|    2
> > ! Mon Feb 10 17:32:01 1997 PST|    4
> > ! Mon Feb 10 09:32:01 1997 PST|    2
> > ! Mon Feb 10 17:32:01 1997 PST|    2
> > ! Mon Feb 10 17:32:01 1997 PST|    7
> >   Sun Feb 16 17:32:01 1997 PST|    2
> >   Sat Mar 01 17:32:01 1997 PST|    2
> > ! (7 rows)
> >
> >
> > ----------------------
> >
> > *** expected/random.out       Tue Apr 29 10:23:40 1997
> > --- results/random.out        Sat Aug 15 13:44:19 1998
> > ***************
> > *** 5,18 ****
> >   (1 row)
> >
> >   QUERY: SELECT count(*) FROM onek where oidrand(onek.oid, 10);
> > ! count
> > ! -----
> > !    92
> > ! (1 row)
> >
> >   QUERY: SELECT count(*) FROM onek where oidrand(onek.oid, 10);
> > ! count
> > ! -----
> > !    98
> > ! (1 row)
> >
> > --- 5,12 ----
> >   (1 row)
> >
> >   QUERY: SELECT count(*) FROM onek where oidrand(onek.oid, 10);
> > ! ERROR:  can't look up operator 713
> >
> >   QUERY: SELECT count(*) FROM onek where oidrand(onek.oid, 10);
> > ! ERROR:  can't look up operator 713
> >
> >
> > ----------------------
> >
> >
>
> --
> Bruce Momjian                          |  830 Blythe Avenue
> maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
>   +  If your life is a hard drive,     |  (610) 353-9879(w)
>   +  Christ can be your backup.        |  (610) 853-3000(h)