[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-826) Unnecessary commas generated in sub-select left outer joins

[Steve Ebersole (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-826?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steve Ebersole closed HHH-826.
------------------------------


Closing stale resolved issues

> Unnecessary commas generated in sub-select left outer joins
> -----------------------------------------------------------
>
>                 Key: HHH-826
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-826
>             Project: Hibernate Core
>          Issue Type: Bug
>    Affects Versions: 3.0.5, 3.1 beta 1
>         Environment: Windows 2k, Oracle9
>            Reporter: M Manning
>            Assignee: Steve Ebersole
>            Priority: Minor
>         Attachments: subselectInJoin.zip
>
>
> The HQL statement :
> select w.id FROM  Work w  WHERE w.id in (Select w2.id from Work w2 left join w2.workDocTypes  wdt2  WHERE  wdt2.docDescription =  'Test type')
> gets parsed to the SQL:
> select work0_.BIB_ID as col_0_0_ from WORK work0_ where work0_.BIB_ID in (select work1_.BIB_ID from WORK work1_, left outer join WORK_DOC_TYPE workdoctyp2_ on work1_.BIB_ID=workdoctyp2_.WORK_ID_FK left outer join DOC_TYPE doctype3_ on workdoctyp2_.DOC_TYPE_ID_FK=doctype3_.ID where doctype3_.DOC_DESCRIPTION='Test type')
> With a comma after the work1_ in the subselect, causing the query to fail.
> This seems to be similar to/related to issue HHH-554 & HHH-706, however the comma appears after the table, not between the join clauses

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