Bug 1189305 - [GSS](6.4.z) HHH-9597 - Criteria creates invalid column
Summary: [GSS](6.4.z) HHH-9597 - Criteria creates invalid column
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss Enterprise Application Platform 6
Classification: JBoss
Component: Hibernate
Version: 6.4.0
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: CR1
: EAP 6.4.2
Assignee: Gail Badner
QA Contact: Martin Simka
URL:
Whiteboard:
Depends On:
Blocks: 1196113 1219165
TreeView+ depends on / blocked
 
Reported: 2015-02-04 22:46 UTC by dstephan
Modified: 2019-08-15 04:14 UTC (History)
8 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2017-01-17 10:14:11 UTC
Type: Bug
Embargoed:
gbadner: needinfo-


Attachments (Terms of Use)

Description dstephan 2015-02-04 22:46:29 UTC
Criteria query that worked on EAP 5.1.2 now fails on EAP 5.2.0.

Possibly due to changes in this JIRA[1].

Generated query is:

select
this_.OFFER_CODE as OFFER1_23_6_,
this_.DESCRIPTION as DESCRIPT2_23_6_,
this_.PROD_SPEC_CODE as PROD6_23_6_,
this_.SALE_END_DTM as SALE3_23_6_,
this_.SALE_START_DTM as SALE4_23_6_,
this_.TERMS_AND_CONDITIONS as TERMS5_23_6_,
channels4_.OFFER_CODE as OFFER1_23_8_,
channel1_.CHANNEL_CODE as CHANNEL2_8_,
channel1_.CHANNEL_CODE as CHANNEL1_19_0_,
channel1_.DESCRIPTION as DESCRIPT2_19_0_,
prodspec2_.PROD_SPEC_CODE as PROD1_8_1_,
prodspec2_.DESCRIPTION as DESCRIPT2_8_1_,
prodspec2_.FARE_CATEGORY_CODE as FARE3_8_1_,
prodspec2_.PRODUCT_CATEGORY_CODE as PRODUCT4_8_1_,
prodspec2_.SKU as SKU8_1_,
productcat7_.PRODUCT_CATEGORY_CODE as PRODUCT1_24_2_,
productcat7_.DESCRIPTION as DESCRIPT2_24_2_,
productsku8_.SKU as SKU22_3_,
productsku8_.DESCRIPTION as DESCRIPT2_22_3_,
productspe9_.PROD_SPEC_CODE as PROD4_8_,
productspe9_.PROD_SPEC_CHARACTER_ID as PROD1_,
productspe9_.PROD_SPEC_CHARACTER_ID as PROD1_4_4_,
productspe9_.NAME as NAME4_4_,
productspe9_.PROD_SPEC_CODE as PROD4_4_4_,
productspe9_.VALUE as VALUE4_4_,
productoff10_.PROD_OFFER_PRICE_ID as PROD1_0_5_,
productoff10_.AMOUNT_IN_CENTS as AMOUNT2_0_5_,
productoff10_.INCLUDES_GST as INCLUDES3_0_5_,
productoff10_.OFFER_CODE as OFFER6_0_5_,
productoff10_.VALID_FROM_DATE as VALID4_0_5_,
productoff10_.VALID_TO_DATE as VALID5_0_5_
from
PRODUCT_OFFER this_
left outer join
PRODUCT_OFFER_CHANNEL channels4_
on this_.OFFER_CODE=channels4_.OFFER_CODE
left outer join
CHANNEL channel1_
on channels4_.CHANNEL_CODE=channel1_.CHANNEL_CODE
left outer join
PRODUCT_SPECIFICATION prodspec2_
on this_.PROD_SPEC_CODE=prodspec2_.PROD_SPEC_CODE
left outer join
PRODUCT_CATEGORY productcat7_
on prodspec2_.PRODUCT_CATEGORY_CODE=productcat7_.PRODUCT_CATEGORY_CODE
left outer join
PRODUCT_SKU productsku8_
on prodspec2_.SKU=productsku8_.SKU
left outer join
PROD_SPEC_CHARACTERISTIC productspe9_
on prodspec2_.PROD_SPEC_CODE=productspe9_.PROD_SPEC_CODE
left outer join
PROD_OFFER_PRICE productoff10_
on this_.OFFER_CODE=productoff10_.OFFER_CODE
where
channel1_.CHANNEL_CODE=?
and prodspec2_.PRODUCT_CATEGORY_CODE=?
and prodspec2_.FARE_CATEGORY_CODE=?
and this_.SALE_START_DTM<=?
and this_.SALE_END_DTM>=?
order by
this_.OFFER_CODE asc

Which fails with:

[org.hibernate.type.StringType] (http-192.168.121.93-8080-1) could not read column value
from result set: PROD4_8_8_; Invalid column name.

[1] https://issues.jboss.org/browse/JBPAPP-6395

Comment 1 dstephan 2015-02-04 22:52:27 UTC
Hibernate JIRA ref: https://hibernate.atlassian.net/browse/HHH-9597

Comment 2 Gail Badner 2015-02-13 05:28:44 UTC
HHH-9597 has been fixed upstream and will be released in 4.2.19.

Comment 3 Gail Badner 2015-03-09 20:24:06 UTC
This should be released in EAP 6.4.1.

Comment 7 Martin Simka 2015-06-22 14:55:00 UTC
verified
EAP 6.4.2.CP.CR1

Comment 8 Petr Penicka 2017-01-17 10:14:11 UTC
Retroactively bulk-closing issues from released EAP 6.4 cumulative patches.

Comment 9 Petr Penicka 2017-01-17 10:15:35 UTC
Retroactively bulk-closing issues from released EAP 6.4 cumulative patches.


Note You need to log in before you can comment on or make changes to this bug.