Search Result order changes on subsequent search

mrsnospam · **Joined:** Tue May 03, 2005 11:45 pm **Posts:** 43

Hibernate version: 3.2.5 - hibernate search 3.0.1.ga

We have noticed that when executing the same search over and over we're getting slightly different ordering of the results. I don't believe any of the underlying data is changing for these records in the database via hibernate.

I would think this order would be completely static if none of the data is changing.

hardy.ferentschik · **Posted:** Mon Oct 13, 2008 5:30 am

Hi,

if the data is not changing and you are executing exactly the same search you would expect the same results. If you still have the problem, can you somehow reproduce this behavior and maybe create some sort of test harness?

--Hardy

mrsnospam · **Joined:** Tue May 03, 2005 11:45 pm **Posts:** 43

We have fields like last_update that change when the row in the database is modified. However this field isn't in the index but I'm wondering if this is an issue.

I'm going to upgrade to 3.1.0 Beta 1 and see if I still get this problem.

sanne.grinovero · **Posted:** Wed Oct 15, 2008 3:56 pm

is "last_update" updated by Java code through hibernate, or is there a DB trigger?

mrsnospam · **Joined:** Tue May 03, 2005 11:45 pm **Posts:** 43

We are updating that timestamp via java code. Why would this cause the order of search results to change?

sanne.grinovero · **Posted:** Wed Oct 15, 2008 6:45 pm

as Hardy said, a testcase could help a lot to understand what you are doing.

of course this shouldn't have any effect on the order.