I was unable to reproduce the issue in the most recent version.
Just to test: Can you undo all datetime-related indexes? and then reindex them. If it works, we certainly have a bug somewhere.
Query
{
q(func: has(entryDate), orderasc:entryDate) @filter(ge(entryDate,"2000-01-01") ) {
count(uid)
status
entryDate
}
}
# {
# q(func: ge(entryDate,"2019-01-01"), orderasc:entryDate) {
# uid
# status
# entryDate
# }
# }
I have tested several combinations of the query above.
JSON sample
It has 200 nodes.
{
"set": [
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-01-01"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-01-02"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-01-03"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-01-04"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-01-05"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-01-06"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-01-07"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-01-08"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-01-09"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-01-10"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-02-01"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-02-02"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-02-03"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-02-04"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-02-05"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-02-06"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-02-07"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-02-08"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-02-09"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-02-10"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-03-01"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-03-02"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-03-03"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-03-04"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-03-05"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-03-06"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-03-07"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-03-08"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-03-09"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-03-10"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-04-01"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-04-02"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-04-03"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-04-04"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-04-05"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-04-06"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-04-07"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-04-08"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-04-09"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-04-10"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-05-01"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-05-02"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-05-03"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-05-04"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-05-05"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-05-06"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-05-07"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-05-08"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-05-09"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2000-05-10"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-01-01"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-01-02"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-01-03"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-01-04"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-01-05"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-01-06"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-01-07"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-01-08"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-01-09"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-01-10"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-02-01"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-02-02"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-02-03"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-02-04"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-02-05"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-02-06"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-02-07"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-02-08"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-02-09"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-02-10"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-03-01"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-03-02"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-03-03"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-03-04"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-03-05"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-03-06"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-03-07"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-03-08"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-03-09"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-03-10"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-04-01"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-04-02"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-04-03"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-04-04"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-04-05"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-04-06"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-04-07"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-04-08"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-04-09"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-04-10"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-05-01"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-05-02"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-05-03"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-05-04"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-05-05"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-05-06"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-05-07"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-05-08"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-05-09"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2002-05-10"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-01-01"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-01-02"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-01-03"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-01-04"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-01-05"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-01-06"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-01-07"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-01-08"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-01-09"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-01-10"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-02-01"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-02-02"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-02-03"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-02-04"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-02-05"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-02-06"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-02-07"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-02-08"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-02-09"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-02-10"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-03-01"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-03-02"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-03-03"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-03-04"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-03-05"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-03-06"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-03-07"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-03-08"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-03-09"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-03-10"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-04-01"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-04-02"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-04-03"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-04-04"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-04-05"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-04-06"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-04-07"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-04-08"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-04-09"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-04-10"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-05-01"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-05-02"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-05-03"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-05-04"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-05-05"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-05-06"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-05-07"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-05-08"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-05-09"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2019-05-10"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-01-01"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-01-02"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-01-03"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-01-04"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-01-05"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-01-06"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-01-07"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-01-08"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-01-09"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-01-10"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-02-01"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-02-02"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-02-03"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-02-04"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-02-05"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-02-06"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-02-07"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-02-08"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-02-09"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-02-10"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-03-01"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-03-02"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-03-03"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-03-04"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-03-05"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-03-06"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-03-07"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-03-08"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-03-09"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-03-10"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-04-01"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-04-02"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-04-03"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-04-04"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-04-05"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-04-06"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-04-07"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-04-08"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-04-09"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-04-10"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-05-01"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-05-02"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-05-03"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-05-04"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-05-05"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-05-06"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-05-07"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-05-08"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-05-09"
},
{
"dgraph.type": "Test",
"status": "new",
"entryDate": "2020-05-10"
}
]
}