[Hibernate-issues] [Hibernate-JIRA] Closed: (HB-1564) Incorrect generation of SQL query

[Max R. A. (JIRA) <no...@at...>]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HB-1564?page=all ]
     
Max Rydahl Andersen closed HB-1564:
-----------------------------------

    Resolution: Incomplete

Sorry, but you will need to provide a failing testcase and put Hibernate3 bugs in the Hibernate3 project.



> Incorrect generation of SQL query
> ---------------------------------
>
>          Key: HB-1564
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HB-1564
>      Project: Hibernate2
>         Type: Bug

>     Versions: 3.0 beta 2
>  Environment: 3.0.2,Oracle10g
>     Reporter: Suvasri Mandal

>
>
> Whenever i try to execute the following hql :
> From ProductGeneralCondition pgc left join fetch pgc.GeneralConditionPrice pgcp left join fetch  pgcp.GeneralConditionPriceVersion pgcpv  WHERE ( pgcpv.objectID in (select pv.objectID From rabobank.cpl.productpricing.PriceVersion pv left join pv.GeneralConditionPrice gcp left join gcp.pricePack gcppp  where  ((gcppp.objectID =:pricesheet) ) )) 
> the sql query getting generated is 
> select * from PR_GEN_COND productgen0_ left outer join GEN_COND_PRC price_gene1_ on productgen0_.OBJ_ID=price_gene1_.SUBJ_PR_GEN_COND_ID left outer join GEN_COND_PRC_VERS version_ge2_ on price_gene1_.OBJ_ID=version_ge2_.CONT_GEN_COND_PRC_ID where version_ge2_.OBJ_ID in (select generalcon3_.OBJ_ID from GEN_COND_PRC_VERS generalcon3_, left outer join GEN_COND_PRC generalcon4_ on generalcon3_.CONT_GEN_COND_PRC_ID=generalcon4_.OBJ_ID, left outer join PRC_SH pricesheet5_ on generalcon4_.PRC_PACK_PRC_SH_ID=pricesheet5_.OBJ_ID where pricesheet5_.OBJ_ID=?  )
> When this is executed it saystable or view does not exist
> Whereas the subquery on its own is properly executed

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