Uploaded image for project: 'JBoss Enterprise Application Platform 4 and 5'
  1. JBoss Enterprise Application Platform 4 and 5
  2. JBPAPP-1554

HHH-3690 - Sybase - FumTest.testCompositeKeyPathExpressions() fails due to subquery with more than one column in select list

    Details

    • 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

      Gliffy Diagrams

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                stliu Strong Liu
                Reporter:
                gbadner Gail Badner
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: