[Hibernate-issues] [Hibernate-JIRA] Created: (HHH-1720) Incorrect Results from multi-valued query containing one-to-one

[Mike R. (JIRA) <no...@at...>]

Incorrect Results from multi-valued query containing one-to-one
---------------------------------------------------------------

         Key: HHH-1720
         URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1720
     Project: Hibernate3
        Type: Bug

  Components: query-hql  
    Versions: 3.1.3    
 Environment: Hibernate 3.1.3, Oracle 10
    Reporter: Mike Ringrose
 Attachments: Record.hbm.xml, RecordRegistry.hbm.xml

The Query below used to work correctly when using the classic query translator; however, no long returns the correct results with the ast query translator. WIth the ast query translator, the third result from the select, which is a one-to-one, always returns null even when the value exists.

SELECT t.nameFirst, t.nameLast, t.registryRecord FROM Record t WHERE t.recordId = ?").setLong(0, 1);

Running the query below with the ast query translator, works fine and always returns the correct results, that's why I beleive the problem to be only with multi-valued queries.

SELECT t.registryRecord FROM Record t WHERE t.recordId = ?").setLong(0, 1);

The code between session open and close is below:

return (Object[])session.createQuery("SELECT t.recordId, t.registryRecord FROM com.imsweb.seerdms.shared.entity.Record t WHERE t.recordId = ?").setLong(0, 1).uniqueResult();



-- 
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