11:20 p.m.
Sort + Pagination returns wrong results.
----------------------------------------
Key: HSEARCH-159
URL:
http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-159
Project: Hibernate Search
Issue Type: Bug
Affects Versions: 3.0.1.GA
Environment: hib 3.2.5ga
Reporter: Jason Eacott
Perhaps I am doing something wrong?
Using the code below if I call
getSearchResults("test",0,10); //returns incorrect data
I get a different item at the head of the list than if I call
getSearchResults("test",0,100);// (this one has correct data, total results for
this search is 196 in my ndx & db)
if I dont try to paginate the results then the sort items are in order and are correct.
and if I paginate with just 1 result
getSearchResults("test",0,1);
and change the sort order I get the same result for each attempt: ie:
Sort datesort=new Sort( new SortField( "date_time", SortField.STRING, true ) );
and
Sort datesort=new Sort( new SortField( "date_time", SortField.STRING, false )
);
return the same entry - which is NOT the correct result either.
This behavious seems to indicate that the data is being sorted after the limit is set
and whats worse, if there are 50,000,000 results, even though I only want 10 and hibernate
has already correctly hydrated those 10 (albeit the wrong 10) hibernatesearch then loops
over all 50,000,000 hits and creates a new (empty) hibernate proxy object for each &
discard all but 10!
...
@Field(name="date_time", index=Index.UN_TOKENIZED, store=Store.NO)
@DateBridge(resolution=Resolution.MINUTE)
private Date publishDate;
...
public List getSearchResults(Query query,int firstResult,int maxResults) {
List result=null;
Session sess=null;
Transaction tx = null;
try {
sess=getSessionFactory().openSession();
FullTextSession fullTextSession = Search.createFullTextSession(sess);
tx = fullTextSession.beginTransaction();
tx.begin();
org.hibernate.search.FullTextQuery hibQuery= fullTextSession.createFullTextQuery(
query, FeedItem.class );
Sort datesort=new Sort( new SortField( "date_time", SortField.STRING, true )
);
hibQuery.setSort(datesort);
Criteria dbCr=fullTextSession.createCriteria(FeedItem.class);
hibQuery.setCriteriaQuery(dbCr);
dbCr.setFirstResult(firstResult);
dbCr.setMaxResults(maxResults);
}
long resultSize=hibQuery.getResultSize();
if (resultSize>0){
result = hibQuery.list()
}
tx.commit();
}
finally
{
releaseSession(sess);
tx=null;
}
log.debug("<getSearchResults");
return result;
}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:20 a.m.
New subject: [Hibernate-JIRA] Commented: (HSEARCH-159) Sort + Pagination returns wrong results.
[
http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-159?pag...
]
Emmanuel Bernard commented on HSEARCH-159:
------------------------------------------
Could you attach a minimal test case.
Sort is applied at the Lucene level, before any kind of pagination, so the behavior you
see is odd.
Sort + Pagination returns wrong results.
----------------------------------------
Key: HSEARCH-159
URL:
http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-159
Project: Hibernate Search
Issue Type: Bug
Affects Versions: 3.0.1.GA
Environment: hib 3.2.5ga
Reporter: Jason Eacott
Perhaps I am doing something wrong?
Using the code below if I call
getSearchResults("test",0,10); //returns incorrect data
I get a different item at the head of the list than if I call
getSearchResults("test",0,100);// (this one has correct data, total results for
this search is 196 in my ndx & db)
if I dont try to paginate the results then the sort items are in order and are correct.
and if I paginate with just 1 result
getSearchResults("test",0,1);
and change the sort order I get the same result for each attempt: ie:
Sort datesort=new Sort( new SortField( "date_time", SortField.STRING, true ) );
and
Sort datesort=new Sort( new SortField( "date_time", SortField.STRING, false )
);
return the same entry - which is NOT the correct result either.
This behavious seems to indicate that the data is being sorted after the limit is set
and whats worse, if there are 50,000,000 results, even though I only want 10 and
hibernate has already correctly hydrated those 10 (albeit the wrong 10) hibernatesearch
then loops over all 50,000,000 hits and creates a new (empty) hibernate proxy object for
each & discard all but 10!
...
@Field(name="date_time", index=Index.UN_TOKENIZED, store=Store.NO)
@DateBridge(resolution=Resolution.MINUTE)
private Date publishDate;
...
public List getSearchResults(Query query,int firstResult,int maxResults) {
List result=null;
Session sess=null;
Transaction tx = null;
try {
sess=getSessionFactory().openSession();
FullTextSession fullTextSession = Search.createFullTextSession(sess);
tx = fullTextSession.beginTransaction();
tx.begin();
org.hibernate.search.FullTextQuery hibQuery= fullTextSession.createFullTextQuery(
query, FeedItem.class );
Sort datesort=new Sort( new SortField( "date_time", SortField.STRING, true )
);
hibQuery.setSort(datesort);
Criteria dbCr=fullTextSession.createCriteria(FeedItem.class);
hibQuery.setCriteriaQuery(dbCr);
dbCr.setFirstResult(firstResult);
dbCr.setMaxResults(maxResults);
}
long resultSize=hibQuery.getResultSize();
if (resultSize>0){
result = hibQuery.list()
}
tx.commit();
}
finally
{
releaseSession(sess);
tx=null;
}
log.debug("<getSearchResults");
return result;
}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:01 p.m.
New subject: [Hibernate-JIRA] Updated: (HSEARCH-159) Sort + Pagination returns wrong results.
[
http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-159?pag...
]
Hardy Ferentschik updated HSEARCH-159:
--------------------------------------
Description:
Perhaps I am doing something wrong?
Using the code below if I call
{code}
getSearchResults("test",0,10); //returns incorrect data
{code}
I get a different item at the head of the list than if I call
{code}
getSearchResults("test",0,100);// (this one has correct data, total results for
this search is 196 in my ndx & db)
{code}
if I dont try to paginate the results then the sort items are in order and are correct.
and if I paginate with just 1 result
{code}
getSearchResults("test",0,1);
{code}
and change the sort order I get the same result for each attempt: ie:
{code}
Sort datesort=new Sort( new SortField( "date_time", SortField.STRING, true ) );
{code}
and
{code}
Sort datesort=new Sort( new SortField( "date_time", SortField.STRING, false )
);
{code}
return the same entry - which is NOT the correct result either.
This behavior seems to indicate that the data is being sorted after the limit is set
and whats worse, if there are 50,000,000 results, even though I only want 10 and hibernate
has already correctly hydrated those 10 (albeit the wrong 10) hibernate-search then loops
over all 50,000,000 hits and creates a new (empty) hibernate proxy object for each &
discard all but 10!
{code}
...
@Field(name="date_time", index=Index.UN_TOKENIZED, store=Store.NO)
@DateBridge(resolution=Resolution.MINUTE)
private Date publishDate;
...
public List getSearchResults(Query query,int firstResult,int maxResults) {
List result=null;
Session sess=null;
Transaction tx = null;
try {
sess=getSessionFactory().openSession();
FullTextSession fullTextSession = Search.createFullTextSession(sess);
tx = fullTextSession.beginTransaction();
tx.begin();
org.hibernate.search.FullTextQuery hibQuery= fullTextSession.createFullTextQuery(
query, FeedItem.class );
Sort datesort=new Sort( new SortField( "date_time", SortField.STRING, true )
);
hibQuery.setSort(datesort);
Criteria dbCr=fullTextSession.createCriteria(FeedItem.class);
hibQuery.setCriteriaQuery(dbCr);
dbCr.setFirstResult(firstResult);
dbCr.setMaxResults(maxResults);
}
long resultSize=hibQuery.getResultSize();
if (resultSize>0){
result = hibQuery.list()
}
tx.commit();
}
finally
{
releaseSession(sess);
tx=null;
}
log.debug("<getSearchResults");
return result;
}
{code}
was:
Perhaps I am doing something wrong?
Using the code below if I call
getSearchResults("test",0,10); //returns incorrect data
I get a different item at the head of the list than if I call
getSearchResults("test",0,100);// (this one has correct data, total results for
this search is 196 in my ndx & db)
if I dont try to paginate the results then the sort items are in order and are correct.
and if I paginate with just 1 result
getSearchResults("test",0,1);
and change the sort order I get the same result for each attempt: ie:
Sort datesort=new Sort( new SortField( "date_time", SortField.STRING, true ) );
and
Sort datesort=new Sort( new SortField( "date_time", SortField.STRING, false )
);
return the same entry - which is NOT the correct result either.
This behavious seems to indicate that the data is being sorted after the limit is set
and whats worse, if there are 50,000,000 results, even though I only want 10 and hibernate
has already correctly hydrated those 10 (albeit the wrong 10) hibernatesearch then loops
over all 50,000,000 hits and creates a new (empty) hibernate proxy object for each &
discard all but 10!
...
@Field(name="date_time", index=Index.UN_TOKENIZED, store=Store.NO)
@DateBridge(resolution=Resolution.MINUTE)
private Date publishDate;
...
public List getSearchResults(Query query,int firstResult,int maxResults) {
List result=null;
Session sess=null;
Transaction tx = null;
try {
sess=getSessionFactory().openSession();
FullTextSession fullTextSession = Search.createFullTextSession(sess);
tx = fullTextSession.beginTransaction();
tx.begin();
org.hibernate.search.FullTextQuery hibQuery= fullTextSession.createFullTextQuery(
query, FeedItem.class );
Sort datesort=new Sort( new SortField( "date_time", SortField.STRING, true )
);
hibQuery.setSort(datesort);
Criteria dbCr=fullTextSession.createCriteria(FeedItem.class);
hibQuery.setCriteriaQuery(dbCr);
dbCr.setFirstResult(firstResult);
dbCr.setMaxResults(maxResults);
}
long resultSize=hibQuery.getResultSize();
if (resultSize>0){
result = hibQuery.list()
}
tx.commit();
}
finally
{
releaseSession(sess);
tx=null;
}
log.debug("<getSearchResults");
return result;
}
Sort + Pagination returns wrong results.
----------------------------------------
Key: HSEARCH-159
URL:
http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-159
Project: Hibernate Search
Issue Type: Bug
Affects Versions: 3.0.1.GA
Environment: hib 3.2.5ga
Reporter: Jason Eacott
Perhaps I am doing something wrong?
Using the code below if I call
{code}
getSearchResults("test",0,10); //returns incorrect data
{code}
I get a different item at the head of the list than if I call
{code}
getSearchResults("test",0,100);// (this one has correct data, total results for
this search is 196 in my ndx & db)
{code}
if I dont try to paginate the results then the sort items are in order and are correct.
and if I paginate with just 1 result
{code}
getSearchResults("test",0,1);
{code}
and change the sort order I get the same result for each attempt: ie:
{code}
Sort datesort=new Sort( new SortField( "date_time", SortField.STRING, true ) );
{code}
and
{code}
Sort datesort=new Sort( new SortField( "date_time", SortField.STRING, false )
);
{code}
return the same entry - which is NOT the correct result either.
This behavior seems to indicate that the data is being sorted after the limit is set
and whats worse, if there are 50,000,000 results, even though I only want 10 and
hibernate has already correctly hydrated those 10 (albeit the wrong 10) hibernate-search
then loops over all 50,000,000 hits and creates a new (empty) hibernate proxy object for
each & discard all but 10!
{code}
...
@Field(name="date_time", index=Index.UN_TOKENIZED, store=Store.NO)
@DateBridge(resolution=Resolution.MINUTE)
private Date publishDate;
...
public List getSearchResults(Query query,int firstResult,int maxResults) {
List result=null;
Session sess=null;
Transaction tx = null;
try {
sess=getSessionFactory().openSession();
FullTextSession fullTextSession = Search.createFullTextSession(sess);
tx = fullTextSession.beginTransaction();
tx.begin();
org.hibernate.search.FullTextQuery hibQuery= fullTextSession.createFullTextQuery(
query, FeedItem.class );
Sort datesort=new Sort( new SortField( "date_time", SortField.STRING, true )
);
hibQuery.setSort(datesort);
Criteria dbCr=fullTextSession.createCriteria(FeedItem.class);
hibQuery.setCriteriaQuery(dbCr);
dbCr.setFirstResult(firstResult);
dbCr.setMaxResults(maxResults);
}
long resultSize=hibQuery.getResultSize();
if (resultSize>0){
result = hibQuery.list()
}
tx.commit();
}
finally
{
releaseSession(sess);
tx=null;
}
log.debug("<getSearchResults");
return result;
}
{code}
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:01 p.m.
New subject: [Hibernate-JIRA] Reopened: (HSEARCH-159) Sort + Pagination returns wrong results.
[
http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-159?pag...
]
Hardy Ferentschik reopened HSEARCH-159:
---------------------------------------
Sort + Pagination returns wrong results.
----------------------------------------
Key: HSEARCH-159
URL:
http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-159
Project: Hibernate Search
Issue Type: Bug
Affects Versions: 3.0.1.GA
Environment: hib 3.2.5ga
Reporter: Jason Eacott
Perhaps I am doing something wrong?
Using the code below if I call
{code}
getSearchResults("test",0,10); //returns incorrect data
{code}
I get a different item at the head of the list than if I call
{code}
getSearchResults("test",0,100);// (this one has correct data, total results for
this search is 196 in my ndx & db)
{code}
if I dont try to paginate the results then the sort items are in order and are correct.
and if I paginate with just 1 result
{code}
getSearchResults("test",0,1);
{code}
and change the sort order I get the same result for each attempt: ie:
{code}
Sort datesort=new Sort( new SortField( "date_time", SortField.STRING, true ) );
{code}
and
{code}
Sort datesort=new Sort( new SortField( "date_time", SortField.STRING, false )
);
{code}
return the same entry - which is NOT the correct result either.
This behavior seems to indicate that the data is being sorted after the limit is set
and whats worse, if there are 50,000,000 results, even though I only want 10 and
hibernate has already correctly hydrated those 10 (albeit the wrong 10) hibernate-search
then loops over all 50,000,000 hits and creates a new (empty) hibernate proxy object for
each & discard all but 10!
{code}
...
@Field(name="date_time", index=Index.UN_TOKENIZED, store=Store.NO)
@DateBridge(resolution=Resolution.MINUTE)
private Date publishDate;
...
public List getSearchResults(Query query,int firstResult,int maxResults) {
List result=null;
Session sess=null;
Transaction tx = null;
try {
sess=getSessionFactory().openSession();
FullTextSession fullTextSession = Search.createFullTextSession(sess);
tx = fullTextSession.beginTransaction();
tx.begin();
org.hibernate.search.FullTextQuery hibQuery= fullTextSession.createFullTextQuery(
query, FeedItem.class );
Sort datesort=new Sort( new SortField( "date_time", SortField.STRING, true )
);
hibQuery.setSort(datesort);
Criteria dbCr=fullTextSession.createCriteria(FeedItem.class);
hibQuery.setCriteriaQuery(dbCr);
dbCr.setFirstResult(firstResult);
dbCr.setMaxResults(maxResults);
}
long resultSize=hibQuery.getResultSize();
if (resultSize>0){
result = hibQuery.list()
}
tx.commit();
}
finally
{
releaseSession(sess);
tx=null;
}
log.debug("<getSearchResults");
return result;
}
{code}
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:03 p.m.
New subject: [Hibernate-JIRA] Resolved: (HSEARCH-159) Sort + Pagination returns wrong results.
[
http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-159?pag...
]
Hardy Ferentschik resolved HSEARCH-159.
---------------------------------------
Resolution: Cannot Reproduce
Never received testcase
Sort + Pagination returns wrong results.
----------------------------------------
Key: HSEARCH-159
URL:
http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-159
Project: Hibernate Search
Issue Type: Bug
Affects Versions: 3.0.1.GA
Environment: hib 3.2.5ga
Reporter: Jason Eacott
Perhaps I am doing something wrong?
Using the code below if I call
{code}
getSearchResults("test",0,10); //returns incorrect data
{code}
I get a different item at the head of the list than if I call
{code}
getSearchResults("test",0,100);// (this one has correct data, total results for
this search is 196 in my ndx & db)
{code}
if I dont try to paginate the results then the sort items are in order and are correct.
and if I paginate with just 1 result
{code}
getSearchResults("test",0,1);
{code}
and change the sort order I get the same result for each attempt: ie:
{code}
Sort datesort=new Sort( new SortField( "date_time", SortField.STRING, true ) );
{code}
and
{code}
Sort datesort=new Sort( new SortField( "date_time", SortField.STRING, false )
);
{code}
return the same entry - which is NOT the correct result either.
This behavior seems to indicate that the data is being sorted after the limit is set
and whats worse, if there are 50,000,000 results, even though I only want 10 and
hibernate has already correctly hydrated those 10 (albeit the wrong 10) hibernate-search
then loops over all 50,000,000 hits and creates a new (empty) hibernate proxy object for
each & discard all but 10!
{code}
...
@Field(name="date_time", index=Index.UN_TOKENIZED, store=Store.NO)
@DateBridge(resolution=Resolution.MINUTE)
private Date publishDate;
...
public List getSearchResults(Query query,int firstResult,int maxResults) {
List result=null;
Session sess=null;
Transaction tx = null;
try {
sess=getSessionFactory().openSession();
FullTextSession fullTextSession = Search.createFullTextSession(sess);
tx = fullTextSession.beginTransaction();
tx.begin();
org.hibernate.search.FullTextQuery hibQuery= fullTextSession.createFullTextQuery(
query, FeedItem.class );
Sort datesort=new Sort( new SortField( "date_time", SortField.STRING, true )
);
hibQuery.setSort(datesort);
Criteria dbCr=fullTextSession.createCriteria(FeedItem.class);
hibQuery.setCriteriaQuery(dbCr);
dbCr.setFirstResult(firstResult);
dbCr.setMaxResults(maxResults);
}
long resultSize=hibQuery.getResultSize();
if (resultSize>0){
result = hibQuery.list()
}
tx.commit();
}
finally
{
releaseSession(sess);
tx=null;
}
log.debug("<getSearchResults");
return result;
}
{code}
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4586
days inactive
5909
days old
hibernate-issues@lists.jboss.org
4 comments
3 participants
participants (3)
-
Emmanuel Bernard (JIRA) -
Hardy Ferentschik (JIRA)
-
Jason Eacott (JIRA)