failed datetime regression tests

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

Responses

Browse pgsql-hackers by date

  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.