From: | "Patrick Welche" <prlw1(at)newn(dot)cam(dot)ac(dot)uk> |
---|---|
To: | tgl(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane) |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [HACKERS] Failures in 'rules' regression test |
Date: | 1999-02-14 14:34:38 |
Message-ID: | E10C2d4-00015I-00@quartz.newn.cam.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Tom Lane wrote:
>
> Is anyone else seeing failure of the "rules" regression test with
> current CVS sources, or is it just me?
"me too"
Though my output is in a slightly different order again, ie., different
system, so your qsort() theory seems good.
BTW, the error messages seem to have changed (running NetBSD-current),
so apart from rules, everything passes.
float8 .. failed
geometry .. failed
misc .. failed
rules .. failed
*** expected/float8-NetBSD.out Sat Feb 6 19:53:55 1999
--- results/float8.out Sun Feb 14 14:16:38 1999
***************
*** 209,217 ****
(5 rows)
QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('10e400');
! ERROR: Bad float8 input format '10e400'
QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400');
! ERROR: Bad float8 input format '-10e400'
QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('10e-400');
QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e-400');
QUERY: DELETE FROM FLOAT8_TBL;
--- 209,217 ----
(5 rows)
QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('10e400');
! ERROR: Input '10e400' is out of range for float8
QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400');
! ERROR: Input '-10e400' is out of range for float8
QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('10e-400');
QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e-400');
QUERY: DELETE FROM FLOAT8_TBL;
*** expected/geometry-NetBSD.out Sat Feb 6 19:53:55 1999
--- results/geometry.out Sun Feb 14 14:16:40 1999
***************
*** 87,93 ****
QUERY: SELECT '' AS count, p.f1, l.s, l.s # p.f1 AS intersection
FROM LSEG_TBL l, POINT_TBL p;
! ERROR: There is more than one possible operator '#' for types 'lseg' and 'point'
You will have to retype this query using an explicit cast
QUERY: SELECT '' AS thirty, p.f1, l.s, p.f1 ## l.s AS closest
FROM LSEG_TBL l, POINT_TBL p;
--- 87,93 ----
QUERY: SELECT '' AS count, p.f1, l.s, l.s # p.f1 AS intersection
FROM LSEG_TBL l, POINT_TBL p;
! ERROR: Unable to identify an operator '#' for types 'lseg' and 'point'
You will have to retype this query using an explicit cast
QUERY: SELECT '' AS thirty, p.f1, l.s, p.f1 ## l.s AS closest
FROM LSEG_TBL l, POINT_TBL p;
*** expected/misc.out Sun Feb 14 14:16:25 1999
--- results/misc.out Sun Feb 14 14:18:42 1999
***************
*** 6,19 ****
SET stringu1 = reverse_name(onek.stringu1)
WHERE onek.stringu1 = 'JBAAAA' and
onek.stringu1 = tmp.stringu1;
- NOTICE: Non-functional update, only first update is performed
- NOTICE: Non-functional update, only first update is performed
QUERY: UPDATE tmp
SET stringu1 = reverse_name(onek2.stringu1)
WHERE onek2.stringu1 = 'JCAAAA' and
onek2.stringu1 = tmp.stringu1;
- NOTICE: Non-functional update, only first update is performed
- NOTICE: Non-functional update, only first update is performed
QUERY: DROP TABLE tmp;
QUERY: COPY onek TO '/home/prlw1/pgsql/src/test/regress/input/../results/onek.data';
QUERY: DELETE FROM onek;
--- 6,15 ----
Cheers,
Patrick
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-02-14 18:35:03 | bushy plans |
Previous Message | Michael Meskes | 1999-02-14 10:08:17 | Re: [HACKERS] Source code cleanup |