[hibernate-issues] [Hibernate-JIRA] Created: (HHH-3866) Wrong generated SQL while doing MultiTableDelete/Update!

[Ioan LUPU (JIRA)]

Wrong generated SQL while doing MultiTableDelete/Update!
--------------------------------------------------------

                 Key: HHH-3866
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3866
             Project: Hibernate Core
          Issue Type: Bug
          Components: core
    Affects Versions: 3.3.1
         Environment: hibernate-distribution-3.3.1.GA
HSQLDB is not affected, but the others are
            Reporter: Ioan LUPU
         Attachments: MultiTableProblem.zip

The generated SQL:

select
    bean04x0_.F_id as F_id
from
    T_Bean04 bean04x0_
inner join
    T_Bean03 bean04x0_1_
        on bean04x0_.F_id=bean04x0_1_.F_id
where
    F_id=?

The problem: the field "F_id" can be found in both tables. HSQLDB doesn't complain about this, but other DB will.

See the attached .zip file!


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