failed datetime regression tests
От | Jon Buller |
---|---|
Тема | failed datetime regression tests |
Дата | |
Msg-id | 199809020311.WAA04376@bullbox.heeia.hi.us обсуждение исходный текст |
Список | 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
В списке pgsql-hackers по дате отправления: