[hibernate-issues] [Hibernate-JIRA] Created: (HHH-4558) Problem with fetch="select" and discriminator

[Stephen Anastos (JIRA)]

Problem with fetch="select" and discriminator
---------------------------------------------

                 Key: HHH-4558
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4558
             Project: Hibernate Core
          Issue Type: Bug
          Components: core
    Affects Versions: 3.3.2
         Environment: Hibernate 3.3.2, Mysql 5.1
            Reporter: Stephen Anastos
            Priority: Minor
         Attachments: src.zip

When using table per subclass with a discriminator, if you specify that the join for the subclass should use fetch="select", hibernate appears to generate invalid SQL.

I would expect that an initial query against the parent table be used to retrieve the discriminator, and subsequent selects should retrieve the rest of the data from the child table.

Please see the the following forum post for: https://forum.hibernate.org/viewtopic.php?f=1&t=1000158

Test case attached.

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