Ambiguous response on TrieDateField

[Imran Rajjad <im...@elogic.pk>]

Hello,

I have observed a difference of Day in TrieDateField when queried from Solr Cloud web interface and SolrK (Java API)

Below is the query response from Web Interface

{
  "responseHeader":{
    "zkConnected":true,
    "status":0,
    "QTime":22,
    "params":{
      "q":"id:01af04e1-83ce-4eb0-8fb5-dc737115dcce",
      "indent":"on",
      "fl":"dateTime",
      "sort":"dateTime asc, id asc",
      "rows":"100",
      "wt":"json",
      "_":"1501792144786"}},
  "response":{"numFound":1,"start":0,"docs":[
      {
        "dateTime":"2017-06-17T00:00:00Z"}]
  }}

The same query run from SolrJ shows previous day in the same field

query.setQuery("id:01af04e1-83ce-4eb0-8fb5-dc737115dcce");
query.setFields(""dateTime");
query.addSort("dateTime", ORDER.asc);
query.addSort("id", ORDER.asc);			
query.add("wt","json");

gives
{responseHeader={zkConnected=true,status=0,QTime=24,params={q=id:01af04e1-83ce-4eb0-8fb5-dc737115dcce,_stateVer_=cdr2:818,fl=dateTime,sort=dateTime asc,id asc,wt=javabin,version=2}},response={numFound=1,start=0,docs=
[SolrDocument{dateTime=Fri Jun 16 17:00:00 PDT 2017}]}}

The problem was found when the a filter query (dateTime:[ 2017-06-17T00:00:00Z TO 2017-06-18T00:00:00Z]) was done for the records of 17 June only, however the solrJ response shows some documents with June16 also. Running facet query from web interface shows no records from June16


Regards,
Imran

Sent from Mail for Windows 10