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

[Suvasri M. (JIRA) <no...@at...>]

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