I am replacing our current search service based on MySQL query with a new service using Elasticsearch. I am running an integration test to make sure that all the existing query match with the new query using Elasticsearch and I noticed that when I order the result by a non timestamp field the result between mysql and ES mismatch.
Let say the order field used is
price, I see that MySQL returns the results ordered by price and, if there are some results having the same price, it order the result using the
created_at field as time breaker.
Elasticsearch has a different behavior to return the ordered field by price. Given that the
_score parameter is null (I am not using any sort of scoring) at the moment, what is the parameter used by ES to perform the final order if the query returns multiple results with the same price.
Thanks in Advance,