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