Ambiguous response on TrieDateField

[Imran Rajjad]

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