[JBPAPP-1554] HHH-3690 - Sybase - FumTest.testCompositeKeyPathExpressions() fails due to subquery with more than one column in select list - JBoss Issue Tracker

XML

Word

Printable

Type: Bug
Status: Resolved (View Workflow)
Priority: Major
Resolution: Won't Fix
Affects Version/s: 4.2.0.GA_CP05, 4.3.0.GA_CP03, 4.2.0.GA_CP06, 4.3.0.GA_CP04, 4.2.0.GA_CP07, 4.3.0.GA_CP05, EAP 5.0.0.CR3, EAP 5.0.0.CR4 (FCS and BETA2), EAP 5.0.0.CR5, EAP 5.0.0, 4.2.0.GA_CP08, 4.3.0.GA_CP07, EAP 5.0.1.CR1, 4.2.0.GA_CP09, 4.3.0.GA_CP08, EAP_EWP 5.1.0
Fix Version/s: TBD
Component/s: Hibernate
Labels:
None

Affects:

Release Notes
Workaround:

Workaround Exists
Workaround Description:

Hide

Don't use HQL elements() if the elements have a composite key. Reformulate the HQL so that there is no subquery with more than one item in the select list.

Show
Don't use HQL elements() if the elements have a composite key. Reformulate the HQL so that there is no subquery with more than one item in the select list.
Release Notes Text:

Hide
Sybase only allows only one entry (for example, column name or '*') in a subquery select list. The HQL function, <literal>elements()</literal>, fails when the collection elements have a composite ID, because the generated SQL contains a subquery select list with multiple entries. The workaround is to avoid using HQL <literal>elements()</literal> if the elements have a composite key. Instead, reformulate the HQL so that no subquery has multiple entries in its select list.

Show
Sybase only allows only one entry (for example, column name or '*') in a subquery select list. The HQL function, <literal>elements()</literal>, fails when the collection elements have a composite ID, because the generated SQL contains a subquery select list with multiple entries. The workaround is to avoid using HQL <literal>elements()</literal> if the elements have a composite key. Instead, reformulate the HQL so that no subquery has multiple entries in its select list.
Release Notes Docs Status:
Not Required

is incorporated by

JBPAPP-1230 HHH-3032 - On Sybase, a subquery is incorrectly generated, causing ''Incorrect syntax near the keyword 'as'.