Andrea - I traced the date throught the debugger and when the
SimplifyingFilterVisistor is called on the Filter, the java.util.Date is
cast to a java.sql.Date. Since the SQL date has no time component, the time
zone information is discarded, and we are left with "2009-27-06" instead of
the expected value of "2009-28-06"
Torben
On Thu, Feb 19, 2015 at 1:11 AM, Andrea Aime <[email protected]>
wrote:
> Hi,
> quick peek, the fact that we mess with dates and we don't have a good
> story about them has been
> well known for a number of years now, see this search over the GeoServer
> jira:
>
> http://jira.codehaus.org/browse/GEOS-4951?jql=project%20%3D%20GEOS%20AND%20status%20%3D%20Open%20AND%20text%20~%20%22date%22
>
> I've actually opened the oldest tickets on the subject, around 9 years ago:
> http://jira.codehaus.org/browse/GEOS-811
> http://jira.codehaus.org/browse/GEOS-1235
>
> So far, we had no funding/volounteer time directed at the problem, in our
> company
> we normally just set the database and server time zones to GMT and call it
> a day,
> although it's pretty clear this is not an ideal solution.
>
> About the filter simplifier changes, the part that could cause issues is
> the range simplifier,
> but that code just collects Comparable range start/end and eventually
> merges them,
> without altering the range ends themselves.
> Ben, on what basis do you claim the simplifier could be the cause? You
> forgot to
> include a rationale of what operations in the simplifier migth have caused
> the date
> shift issue.
>
> Cheers
> Andrea
>
> --
> ==
> GeoServer Professional Services from the experts! Visit
> http://goo.gl/NWWaa2 for more information.
> ==
>
> Ing. Andrea Aime
> @geowolf
> Technical Lead
>
> GeoSolutions S.A.S.
> Via Poggio alle Viti 1187
> 55054 Massarosa (LU)
> Italy
> phone: +39 0584 962313
> fax: +39 0584 1660272
> mob: +39 339 8844549
>
> http://www.geo-solutions.it
> http://twitter.com/geosolutions_it
>
> *AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*
>
> Le informazioni contenute in questo messaggio di posta elettronica e/o
> nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
> loro utilizzo è consentito esclusivamente al destinatario del messaggio,
> per le finalità indicate nel messaggio stesso. Qualora riceviate questo
> messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
> darcene notizia via e-mail e di procedere alla distruzione del messaggio
> stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
> divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
> utilizzarlo per finalità diverse, costituisce comportamento contrario ai
> principi dettati dal D.Lgs. 196/2003.
>
>
>
> The information in this message and/or attachments, is intended solely for
> the attention and use of the named addressee(s) and may be confidential or
> proprietary in nature or covered by the provisions of privacy act
> (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
> Code).Any use not in accord with its purpose, any disclosure, reproduction,
> copying, distribution, or either dissemination, either whole or partial, is
> strictly forbidden except previous formal approval of the named
> addressee(s). If you are not the intended recipient, please contact
> immediately the sender by telephone, fax or e-mail and delete the
> information in this message that has been received in error. The sender
> does not give any warranty or accept liability as the content, accuracy or
> completeness of sent messages and accepts no responsibility for changes
> made after they were sent or for other risks which arise as a result of
> e-mail transmission, viruses, etc.
>
> -------------------------------------------------------
>
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
