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