Re: Problems with infinity - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Problems with infinity
Date
Msg-id Pine.BSO.4.56.0501251310390.7880@leary.csoft.net
Whole thread Raw
In response to Re: Problems with infinity  (Oliver Siegmar <o.siegmar@vitrado.de>)
Responses Re: Problems with infinity  (Oliver Siegmar <o.siegmar@vitrado.de>)
List pgsql-jdbc

On Tue, 25 Jan 2005, Oliver Siegmar wrote:

> On Tuesday 25 January 2005 09:35, Kris Jurka wrote:
> > I was getting ready to apply this patch when I decided to add a couple
> > more tests and I'm getting a failure for getDate() that I do not have time
> > at the momemnt to investigate.  Could you take a look at the attached
> > patch and see what's going on.
>
> I applied the patch and run the tests. No problems were detected. I'm willing
> to help, but a little more information would be very helpful :)
>


runtest:
    [junit] Testsuite: org.postgresql.test.jdbc2.Jdbc2TestSuite
    [junit] Tests run: 176, Failures: 1, Errors: 0, Time elapsed: 151.39 sec

    [junit] Testcase: testInfinity(org.postgresql.test.jdbc2.TimestampTest):   FAILED
    [junit] expected:<9223372036825200000> but was:<9223372036767600000>
    [junit] junit.framework.AssertionFailedError: expected:<9223372036825200000> but was:<9223372036767600000>
    [junit]     at org.postgresql.test.jdbc2.TimestampTest.runInfinityTests(TimestampTest.java:93)
    [junit]     at org.postgresql.test.jdbc2.TimestampTest.testInfinity(TimestampTest.java:53)
    [junit]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    [junit]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    [junit]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

So it appears the constant you have selected only works as a date for
your timezone.

Kris Jurka

pgsql-jdbc by date:

Previous
From: Oliver Siegmar
Date:
Subject: Re: Problems with infinity
Next
From: Oliver Jowett
Date:
Subject: Re: setObject on PGInterval throws "Unknown Type null"