[Hibernate-JIRA] Created: (HHH-3139) select elements(collection) does not return all composite key segments when used in subquery
11:31 a.m.
select elements(collection) does not return all composite key segments when used in
subquery
--------------------------------------------------------------------------------------------
Key: HHH-3139
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3139
Project: Hibernate3
Issue Type: Bug
Components: query-hql
Affects Versions: 3.2.4
Environment: HB 3, Oracle 10g
Reporter: Carl Allain
Priority: Blocker
When dealing with collection of entities having composite keys, elements() seems to return
all key segment columns, which seems fine.
So, in our case (CountrySubdivision has a composite PK, :CTRSD_CD + CTR_ISO_CD), when we
do
select elements(mks.countrySubdivisions) from MarketSegmentPdo mks
it gives this:
select
countrysub1_.CTRSD_CD as col_0_0_,
countrysub1_.CTR_ISO_CD as col_0_1_
from
MKSG_MKS marketsegm0_,
MKSG_MKSCTRSD countrysub1_
where
marketsegm0_.MKS_NRI=countrysub1_.MKS_NRI
while using the same elements() function construct in a subquery, only one PK segment is
included by Hibernate!. So:
from CountrySubdivisionPdo cs where cs.id in (select elements(mks.countrySubdivisions)
from MarketSegmentPdo mks)
gives this:
select
countrysub0_.CTRSD_CD as CTRSD1_65_,
countrysub0_.CTR_ISO_CD as CTR2_65_,
countrysub0_.CTRSD_TS as CTRSD3_65_
from
PLGE_CTRSD countrysub0_
where
(
countrysub0_.CTRSD_CD, countrysub0_.CTR_ISO_CD
) in (
select
countrysub2_.CTRSD_CD <---------------------------------- WHERE is
CTR_ISO_CD???????
from
MKSG_MKS marketsegm1_,
MKSG_MKSCTRSD countrysub2_
where
marketsegm1_.MKS_NRI=countrysub2_.MKS_NRI
)
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:35 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3139) select elements(collection) does not return all composite key segments when used in subquery
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3139?page=c...
]
Carl Allain commented on HHH-3139:
----------------------------------
For your information, our collection of CountrySubdivison in MarketSegmentPdo is a List
and we use @IdClass to annotate the PrimaryKey class (an inner class in
CountrySubdivision).
select elements(collection) does not return all composite key
segments when used in subquery
--------------------------------------------------------------------------------------------
Key: HHH-3139
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3139
Project: Hibernate3
Issue Type: Bug
Components: query-hql
Affects Versions: 3.2.4
Environment: HB 3, Oracle 10g
Reporter: Carl Allain
Priority: Blocker
When dealing with collection of entities having composite keys, elements() seems to
return all key segment columns, which seems fine.
So, in our case (CountrySubdivision has a composite PK, :CTRSD_CD + CTR_ISO_CD), when we
do
select elements(mks.countrySubdivisions) from MarketSegmentPdo mks
it gives this:
select
countrysub1_.CTRSD_CD as col_0_0_,
countrysub1_.CTR_ISO_CD as col_0_1_
from
MKSG_MKS marketsegm0_,
MKSG_MKSCTRSD countrysub1_
where
marketsegm0_.MKS_NRI=countrysub1_.MKS_NRI
while using the same elements() function construct in a subquery, only one PK segment is
included by Hibernate!. So:
from CountrySubdivisionPdo cs where cs.id in (select elements(mks.countrySubdivisions)
from MarketSegmentPdo mks)
gives this:
select
countrysub0_.CTRSD_CD as CTRSD1_65_,
countrysub0_.CTR_ISO_CD as CTR2_65_,
countrysub0_.CTRSD_TS as CTRSD3_65_
from
PLGE_CTRSD countrysub0_
where
(
countrysub0_.CTRSD_CD, countrysub0_.CTR_ISO_CD
) in (
select
countrysub2_.CTRSD_CD <---------------------------------- WHERE is
CTR_ISO_CD???????
from
MKSG_MKS marketsegm1_,
MKSG_MKSCTRSD countrysub2_
where
marketsegm1_.MKS_NRI=countrysub2_.MKS_NRI
)
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:41 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3139) select elements(collection) does not return all composite key segments when used in subquery
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3139?page=c...
]
Carl Allain commented on HHH-3139:
----------------------------------
Also, we nailed down the problem to what is shown in the description, although our hql
request is much more complicated.
select elements(collection) does not return all composite key
segments when used in subquery
--------------------------------------------------------------------------------------------
Key: HHH-3139
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3139
Project: Hibernate3
Issue Type: Bug
Components: query-hql
Affects Versions: 3.2.4
Environment: HB 3, Oracle 10g
Reporter: Carl Allain
Priority: Blocker
When dealing with collection of entities having composite keys, elements() seems to
return all key segment columns, which seems fine.
So, in our case (CountrySubdivision has a composite PK, :CTRSD_CD + CTR_ISO_CD), when we
do
select elements(mks.countrySubdivisions) from MarketSegmentPdo mks
it gives this:
select
countrysub1_.CTRSD_CD as col_0_0_,
countrysub1_.CTR_ISO_CD as col_0_1_
from
MKSG_MKS marketsegm0_,
MKSG_MKSCTRSD countrysub1_
where
marketsegm0_.MKS_NRI=countrysub1_.MKS_NRI
while using the same elements() function construct in a subquery, only one PK segment is
included by Hibernate!. So:
from CountrySubdivisionPdo cs where cs.id in (select elements(mks.countrySubdivisions)
from MarketSegmentPdo mks)
gives this:
select
countrysub0_.CTRSD_CD as CTRSD1_65_,
countrysub0_.CTR_ISO_CD as CTR2_65_,
countrysub0_.CTRSD_TS as CTRSD3_65_
from
PLGE_CTRSD countrysub0_
where
(
countrysub0_.CTRSD_CD, countrysub0_.CTR_ISO_CD
) in (
select
countrysub2_.CTRSD_CD <---------------------------------- WHERE is
CTR_ISO_CD???????
from
MKSG_MKS marketsegm1_,
MKSG_MKSCTRSD countrysub2_
where
marketsegm1_.MKS_NRI=countrysub2_.MKS_NRI
)
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:47 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3139) select elements(collection) does not return all composite key segments when used in subquery
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3139?page=c...
]
Carl Allain commented on HHH-3139:
----------------------------------
There is a note in the HB reference manual that says:
"Note that these constructs - size, elements, indices, minindex, maxindex,
minelement, maxelement - may
only be used in the where clause in Hibernate3."
So I think it is not a bug after all, but a limitation of Hibernate?
select elements(collection) does not return all composite key
segments when used in subquery
--------------------------------------------------------------------------------------------
Key: HHH-3139
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3139
Project: Hibernate3
Issue Type: Bug
Components: query-hql
Affects Versions: 3.2.4
Environment: HB 3, Oracle 10g
Reporter: Carl Allain
Priority: Blocker
When dealing with collection of entities having composite keys, elements() seems to
return all key segment columns, which seems fine.
So, in our case (CountrySubdivision has a composite PK, :CTRSD_CD + CTR_ISO_CD), when we
do
select elements(mks.countrySubdivisions) from MarketSegmentPdo mks
it gives this:
select
countrysub1_.CTRSD_CD as col_0_0_,
countrysub1_.CTR_ISO_CD as col_0_1_
from
MKSG_MKS marketsegm0_,
MKSG_MKSCTRSD countrysub1_
where
marketsegm0_.MKS_NRI=countrysub1_.MKS_NRI
while using the same elements() function construct in a subquery, only one PK segment is
included by Hibernate!. So:
from CountrySubdivisionPdo cs where cs.id in (select elements(mks.countrySubdivisions)
from MarketSegmentPdo mks)
gives this:
select
countrysub0_.CTRSD_CD as CTRSD1_65_,
countrysub0_.CTR_ISO_CD as CTR2_65_,
countrysub0_.CTRSD_TS as CTRSD3_65_
from
PLGE_CTRSD countrysub0_
where
(
countrysub0_.CTRSD_CD, countrysub0_.CTR_ISO_CD
) in (
select
countrysub2_.CTRSD_CD <---------------------------------- WHERE is
CTR_ISO_CD???????
from
MKSG_MKS marketsegm1_,
MKSG_MKSCTRSD countrysub2_
where
marketsegm1_.MKS_NRI=countrysub2_.MKS_NRI
)
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:49 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3139) select elements(collection) does not return all composite key segments when used in subquery
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3139?page=c...
]
Carl Allain commented on HHH-3139:
----------------------------------
This sentence in the documentation makes it unclear in our case, since we're really
using it in a where clause (indirectly through a subquery)?
select elements(collection) does not return all composite key
segments when used in subquery
--------------------------------------------------------------------------------------------
Key: HHH-3139
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3139
Project: Hibernate3
Issue Type: Bug
Components: query-hql
Affects Versions: 3.2.4
Environment: HB 3, Oracle 10g
Reporter: Carl Allain
Priority: Blocker
When dealing with collection of entities having composite keys, elements() seems to
return all key segment columns, which seems fine.
So, in our case (CountrySubdivision has a composite PK, :CTRSD_CD + CTR_ISO_CD), when we
do
select elements(mks.countrySubdivisions) from MarketSegmentPdo mks
it gives this:
select
countrysub1_.CTRSD_CD as col_0_0_,
countrysub1_.CTR_ISO_CD as col_0_1_
from
MKSG_MKS marketsegm0_,
MKSG_MKSCTRSD countrysub1_
where
marketsegm0_.MKS_NRI=countrysub1_.MKS_NRI
while using the same elements() function construct in a subquery, only one PK segment is
included by Hibernate!. So:
from CountrySubdivisionPdo cs where cs.id in (select elements(mks.countrySubdivisions)
from MarketSegmentPdo mks)
gives this:
select
countrysub0_.CTRSD_CD as CTRSD1_65_,
countrysub0_.CTR_ISO_CD as CTR2_65_,
countrysub0_.CTRSD_TS as CTRSD3_65_
from
PLGE_CTRSD countrysub0_
where
(
countrysub0_.CTRSD_CD, countrysub0_.CTR_ISO_CD
) in (
select
countrysub2_.CTRSD_CD <---------------------------------- WHERE is
CTR_ISO_CD???????
from
MKSG_MKS marketsegm1_,
MKSG_MKSCTRSD countrysub2_
where
marketsegm1_.MKS_NRI=countrysub2_.MKS_NRI
)
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
6612
days inactive
6612
days old
hibernate-issues@lists.jboss.org
4 comments
1 participants
participants (1)
-
Carl Allain (JIRA)