[hibernate-issues] [Hibernate-JIRA] Created: (HHH-5802) DiscriminatorOptions should not add sql clause

[Marc Schipperheyn (JIRA)]

DiscriminatorOptions should not add sql clause
----------------------------------------------

                 Key: HHH-5802
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5802
             Project: Hibernate Core
          Issue Type: Improvement
    Affects Versions: 3.6.0
            Reporter: Marc Schipperheyn
            Priority: Minor


@DiscriminatorOptions(force=true) 
makes sure discriminator values are processed in cases of table per class hierarchy.

it also leads to sql statement additions such as 
where this_.DTYPE in ('STD', 'EVT', 'HDY', 'CAR', 'HSE', 'OFF', 'JOB', 'RST', 'TKE', 'SPL')

since DTYPE is not a nullable field, this is superfluous, all records are loaded anyway without the this qualifier, and may also lead to performance degradation on the database side. 

I would suggest optimizing the query generator in order to preven this occurring

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