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

HHH-4394 @OrderBy is used in conjunction with a table per class hierarchy produces incorred SQL syntax.

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 4.3.0.GA_CP10
    • 4.2.0.GA_CP08, 4.3.0.GA_CP08, 4.3.0.GA_CP09
    • Hibernate
    • None
    • Release Notes
    • Hide
      When @OrderBy was used in conjunction with a table-per-class hierarchy, the generated SQL was invalid because the "order by" clause qualified the columns using the table name instead of the alias.
      The "order by" clause now qualifies the column based on the table alias, however this is limited to the table-per-class hierarchy: other column qualification strategies are still affected. For more information about other affected column qualification strategies, refer to <ulink url="https://issues.jboss.org/browse/JBPAPP-1123">JBPAPP-1123</ulink>.
      Show
      When @OrderBy was used in conjunction with a table-per-class hierarchy, the generated SQL was invalid because the "order by" clause qualified the columns using the table name instead of the alias. The "order by" clause now qualifies the column based on the table alias, however this is limited to the table-per-class hierarchy: other column qualification strategies are still affected. For more information about other affected column qualification strategies, refer to <ulink url=" https://issues.jboss.org/browse/JBPAPP-1123 "> JBPAPP-1123 </ulink>.
    • Documented as Resolved Issue
    • ON_QA

          shaozliu Strong Liu(刘少壮) (Inactive)
          shaozliu Strong Liu(刘少壮) (Inactive)
          Jared Morgan Jared Morgan (Inactive)
          Votes:
          0 Vote for this issue
          Watchers:
          2 Start watching this issue

            Created:
            Updated:
            Resolved: