Thanks for that link Ben. It looks like we are kind of stuck until we get a
postgis driver that fufills all our needs.
The two Date test failures are unrelated to that issue however.
The test case defines:
DateFormat df = new SimpleDateFormat("yyyy-dd-MM");
df.setTimeZone( TimeZone.getTimeZone("PST"));
Then, it constructs a query, calling df.parse("2009-28-06"), which returns
a java.util.Date: "Sun Jun 28 00:00:00 PDT 2009" (Notice the timezone)
This query eventually has a simplifyingFilterVisitor called on it, which
causes the date to be cast to a java.sql.Date: "2009-27-06"
Since sql dates have no time component, the time is truncated and due to
the timezone results in the 27th.
I assume this test was intended to verify dates that are both < and = to a
value (Currently, the = portion is what is failing).
I am curious as to what has changed to make it fail now and not before.
Torben
On Wed, Feb 18, 2015 at 10:17 AM, Ben Caradoc-Davies <b...@transient.nz>
wrote:
> Torben,
>
> please see the discussion in this Jira issue about the various postgres
> driver versions and the differing failures they cause.
> https://jira.codehaus.org/browse/GEOT-4636
>
> You might add any new findings to this issue.
>
> Kind regards,
> Ben.
>
> On 19/02/15 07:05, Torben Barsballe wrote:
>
>> I have recently been running the Online PostGIS tests, and have run into a
>> number of existing failures:
>>
>> Failed tests:
>>
>> PostgisDateOnlineTest>OnlineTestCase.run:123->JDBCDateOnlineTest.
>> testFiltersByDate:45
>> expected:<2> but was:<1>
>>
>> PostgisLobOnlineTest>OnlineTestCase.run:123->
>> JDBCLobOnlineTest.testWrite:84
>> null
>>
>> PostgisLobOnlineTest>OnlineTestCase.run:123->
>> JDBCLobOnlineTest.testRead:66
>> null
>>
>> PostgisDateOnlineTest>OnlineTestCase.run:123->JDBCDateOnlineTest.
>> testFiltersByDate:45
>> expected:<2> but was:<1>
>>
>> PostgisLobOnlineTest>OnlineTestCase.run:123->
>> JDBCLobOnlineTest.testWrite:84
>> null
>>
>> PostgisLobOnlineTest>OnlineTestCase.run:123->
>> JDBCLobOnlineTest.testRead:66
>> null
>>
>> I also observed these failures when testing the 11.5 release.
>>
>> I see there is an existing unresolved issue for this problem here:
>> https://jira.codehaus.org/browse/GEOT-4594, with a viable solution
>> (upgrade
>> the postgres driver)
>>
>> Is there any reason we do not upgrade to a newer version of the postgres
>> driver?
>> I've tested locally with version 9.1-901.jdbc3
>> <http://mvnrepository.com/artifact/postgresql/postgresql/9.1-901.jdbc3>,
>> and it fixed the lob failures, but gave a bunch of new ones:
>>
>> Failed tests:
>>
>> PostGISFunctionTest>OnlineTestCase.run:123->JDBCFunctionTest.
>> testStrEndsWithOtherProperty:101->JDBCFunctionTest.assertFeatures:319
>> Expected to find 3 features, but was 1
>>
>> PostgisDataStoreTest>OnlineTestCase.run:123->JDBCDataStoreTest.
>> testSimpleIndex:208
>> expected:<[stringProperty]> but was:<["stringProperty"]>
>>
>> PostgisDataStoreTest>OnlineTestCase.run:123->JDBCDataStoreTest.
>> testMultiColumnIndex:249
>> expected:<[stringProperty]> but was:<["stringProperty"]>
>> PostgisDateTest>OnlineTestCase.run:123->JDBCDateTest.
>> testFiltersByDate:45
>> expected:<2> but was:<1>
>>
>> PostgisDataStoreTest>OnlineTestCase.run:123->JDBCDataStoreTest.
>> testSimpleIndex:208
>> expected:<[stringProperty]> but was:<["stringProperty"]>
>>
>> PostgisDataStoreTest>OnlineTestCase.run:123->JDBCDataStoreTest.
>> testMultiColumnIndex:249
>> expected:<[stringProperty]> but was:<["stringProperty"]>
>> PostgisDateTest>OnlineTestCase.run:123->JDBCDateTest.
>> testFiltersByDate:45
>> expected:<2> but was:<1>
>>
>> The two DateTest failures are the same, but the others are different, and
>> seem to be a simple change in result syntax.
>>
>> Thanks,
>> Torben
>>
>>
>>
>> Torben
>>
>>
>>
>> ------------------------------------------------------------
>> ------------------
>> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
>> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
>> with Interactivity, Sharing, Native Excel Exports, App Integration & more
>> Get technology previously reserved for billion-dollar corporations, FREE
>> http://pubads.g.doubleclick.net/gampad/clk?id=190641631&;
>> iu=/4140/ostg.clktrk
>>
>>
>>
>> _______________________________________________
>> GeoTools-Devel mailing list
>> GeoTools-Devel@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/geotools-devel
>>
>>
> --
> Ben Caradoc-Davies <b...@transient.nz>
> Software Engineer
> Transient Software <http://transient.nz>
> New Zealand
>
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=190641631&iu=/4140/ostg.clktrk
_______________________________________________
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
