From: | Jon Buller <jonb(at)metronet(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | failed datetime regression tests |
Date: | 1998-09-02 03:11:41 |
Message-ID: | 199809020311.WAA04376@bullbox.heeia.hi.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I'm taking a MS level database design class this semester, and didn't
really want to use the school's ORACLE database on their machines, so...
I built the postgres-6.3.2 package on my NetBSD-current/pc532 machine
over the last few days. For those of you who care slightly, this is
a NS32532 based machine from the early '90s and I had to add a couple
of lines af assembler to get the thing to build 8-) I'll send a set
of diffs in when I think it works.
My problem is that it failed several of the regression tests. int2 and int4
scared me until I saw that my machine said something like "number too big"
and the expected output was something like "bad format"... However, I
got the following lines out of the test with diff -c:
*** expected/datetime.out Sun Jan 4 19:35:27 1998
--- results/datetime.out Mon Aug 31 18:38:04 1998
***************
*** 19,31 ****
QUERY: SELECT ('current'::datetime = 'now'::datetime) as "True";
True
----
! t
(1 row)
QUERY: SELECT ('now'::datetime - 'current'::datetime) AS "ZeroSecs";
! ZeroSecs
! --------
! @ 0
(1 row)
QUERY: CREATE TABLE DATETIME_TBL( d1 datetime);
--- 19,31 ----
QUERY: SELECT ('current'::datetime = 'now'::datetime) as "True";
True
----
! f
(1 row)
QUERY: SELECT ('now'::datetime - 'current'::datetime) AS "ZeroSecs";
! ZeroSecs
! ---------------------------------------
! @ 486 days 22 hours 22 mins 13 secs ago
(1 row)
QUERY: CREATE TABLE DATETIME_TBL( d1 datetime);
That doesn't seem right 8-) Any suggestions?
Jon Buller
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1998-09-02 03:43:23 | Re: [HACKERS] Core dump in regression tests. |
Previous Message | Bruce Momjian | 1998-09-02 02:50:23 | Re: [HACKERS] Core dump in regression tests. |