I just tried to follow the tests in the debugger. I'm way out of my
depth with the JDBC code but there does seem to be something odd going
on with that test.

The failing test sets up this filter:
Filter f = ff.lessOrEqual( ff.property( aname("d") ), ff.literal(
/*df.parse(*/"2009-06-28"/*)*/ ) );

But following that through to JDBCDataStore.getAggregateValue, we end
up with the following sql:

"SELECT count(*) FROM "geotools"."dates" WHERE  "d" <=
PARSEDATETIME('2009-06-27', 'yyyy-MM-dd')"

The date has shifted by one day somewhere along the line.

Michael

On 5 November 2011 21:57, Michael Bedward <[email protected]> wrote:
> Good suggestion, but being lazy my default locale has been left as en_US.
>
> I guess it's most likely caused by something particular to my system
> since it's working for Justin and Jody hasn't complained, but I can't
> think of anything obvious that I've changed in the last day or two.
>
> Michael
>
> On 5 November 2011 20:39, Andrea Aime <[email protected]> wrote:
>>
>> DateTest huh? Makes me wonder if this could be not OSX related, but
>> default timezone related (or maybe Locale? though I cannot imagine how
>> australian one would be different than US one)
>>
>> Cheers
>> Andrea
>>
>>
>> --
>> -------------------------------------------------------
>> Ing. Andrea Aime
>> GeoSolutions S.A.S.
>> Tech lead
>>
>> Via Poggio alle Viti 1187
>> 55054  Massarosa (LU)
>> Italy
>>
>> phone: +39 0584 962313
>> fax:      +39 0584 962313
>>
>> http://www.geo-solutions.it
>> http://geo-solutions.blogspot.com/
>> http://www.youtube.com/user/GeoSolutionsIT
>> http://www.linkedin.com/in/andreaaime
>> http://twitter.com/geowolf
>>
>> -------------------------------------------------------
>>
>

------------------------------------------------------------------------------
RSA(R) Conference 2012
Save $700 by Nov 18
Register now
http://p.sf.net/sfu/rsa-sfdev2dev1
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel

Reply via email to