lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chris Hostetter <>
Subject Re: AW: Date field mystery
Date Mon, 22 Sep 2008 19:32:37 GMT

: - "date:[2005-01-01T00:00:00Z TO NOW]" or "date:[2005-01-01T00:00:00Z TO 2008-09-18T09:45:00Z]":
1 and 2 (incorrect)
: - "date:[2005-01-01T00:00:00Z TO 20080918T09:45:00Z]": 1, 2, 3 (correct)
: - "date:[2005-01-01T00:00:00Z TO 2007-12-31T23:59:59Z]": only 1 (incorrect)
: - "date:[2005-01-01T00:00:00Z TO 20071231T23:59:59Z]": 1 and 2 (correct)
: So as you can see using "-" in the second parameter of the range query 
: for the date field causes an error and doesn't find the record should 
: has to be found, using a malformed date value without "-" return the 
: correct records.

I can *not* reproduce any of the "incorrect" examples you listed above, 
either with Solr 1.2 or with Solr 1.3.  The "correct" examples you listed 
error (as i expected they would) on Solr 1.3 because of it's strict format 
checking.  they do pass on Solr 1.2, but that's just becuase it's just 
doing a simple lexigraphical range.

The test documents I used are listed below.  I indexed them using the 
stock example schema to try and reproduce your problem.  (wild shot in the 
dar: are you certain you are using DateFieldfor your "date" field?)

  <field name="id">1</field>
  <field name="test_dt">2006-03-04T12:23:19Z</field>
  <field name="id">2</field>
  <field name="test_dt">2007-08-12T19:07:03Z</field>
  <field name="id">3</field>
  <field name="test_dt">2008-09-16T12:56:19Z</field>


View raw message