You are here: Foswiki>Tasks Web>Item9196 (14 Mar 2011, GeorgeClark)Edit Attach

Item9196: Query search for date= fails in some timezones.

pencil
Priority: Normal
Current State: Confirmed
Released In: n/a
Target Release: n/a
Applies To: Engine
Component: SEARCH
Branches:
Reported By: GeorgeClark
Waiting For:
Last Change By: GeorgeClark
Test system running with GMT clock, timezone set to EST5EDT.

Test Fn_SEARCH::verify_date_param_PurePerlSearch Fails to find the topic with the Date stamp "1" - date 1970-01-01. The date query search appears to be using a timezone corrected date, and any timestamp less than 18000 (5:00 am) is actually for the prior date - 1969-12-31.

The topic timestamp appears to be using the server GMT time, while the search used in the test:

%SEARCH{"1" type="query" date="1969-12-31" format="$topic"}%

is offset for the system timezone.

  • Server hardware time = GMT
  • Server timezone EST5EDT
  • Topic timestamp 18000 is found with date="1970"
  • Topic timestamp 1, set in the unit test, found with date="1969-12-31" not, 1970.

-- GeorgeClark - 24 Jun 2010

Note that the unit tests that have been failing forever in negative timezones have been modified to work. But the underlying problem is still there.

-- GeorgeClark - 14 Mar 2011
 

ItemTemplate edit

Summary Query search for date= fails in some timezones.
ReportedBy GeorgeClark
Codebase
SVN Range
AppliesTo Engine
Component SEARCH
Priority Normal
CurrentState Confirmed
WaitingFor
Checkins
TargetRelease n/a
ReleasedIn n/a
Topic revision: r2 - 14 Mar 2011, GeorgeClark
The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License    Legal Imprint    Privacy Policy