From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Regression test status (was type coersion) |
Date: | 1998-08-15 18:18:30 |
Message-ID: | 22282.903205110@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
"Thomas G. Lockhart" <lockhart(at)alumni(dot)caltech(dot)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
----------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 1998-08-15 23:45:03 | Rules: first fix on monday |
Previous Message | Jan Wieck | 1998-08-15 18:17:07 | Psql doesn't allow multiple action rules |