The day shift happens in H2FilterToSQL.writeLiteral method.
It gets the correct arg: an SQL Date object "2009-06-28" but then line 220...
out.write("'" + DATE_FORMAT.format(literal) + "', 'yyyy-MM-dd'");
...formats that as 2009-06-27
I guess it's something to do with my timezone (in line with your
suggestion Andrea).
Meanwhile, my timezone being what it is - I'm going to bed :)
Michael
On 5 November 2011 22:35, Michael Bedward <[email protected]> wrote:
> 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
