[hibernate-issues] [Hibernate-JIRA] Resolved: (HSEARCH-337) Search return the same row multiple times on Select

[Emmanuel Bernard (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-337?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Emmanuel Bernard resolved HSEARCH-337.
--------------------------------------

    Resolution: Cannot Reproduce

> Search return the same row multiple times on Select
> ---------------------------------------------------
>
>                 Key: HSEARCH-337
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-337
>             Project: Hibernate Search
>          Issue Type: Bug
>         Environment: Hibernate
>            Reporter: Santhosh Kumaran
>
> I have a table in the following pattern on MySQL 5.1
> Table1
> Key1 int
> Key2 int
> field1 tinyint
> field2 tinyint
> field3 tinyint
> I have the sql query like
> "SELECT {table1Entity.*} FROM TABLE1 table1 where Key1=?"
> This query will satify for 3 rows and has to get me the 3 filtered rows.
> and the code like this
> SQLQuery sqlQuery = session.createSQLQuery(query);
> sqlQuery.setInteger(0, 5001);
> sqlQuery = sqlQuery.addEntity("table1Entity", Table1Entity.class);
> List entityList = sqlQuery.list();
> The list contain 3 entity objects, but 3 copies of the first row. ( not all 3 rows). First row coming 3 times instead of 2nd and 3rd row values.
> Please let me know, is it a bug or not?
> - SANSSAN

-- 
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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira