[Hibernate-issues] [Hibernate-JIRA] Updated: (HB-263) Order by restriction in DB2/400 for OS/400 prior to V5R2

[<leg...@at...>]

The following issue has been updated:

    Updater: Brian Koehler (mailto:brk...@ya...)
       Date: Fri, 15 Aug 2003 10:41 AM
    Comment:
Unified diff output patch, I've not done this before so let me know if the formatting needs to be changed.
    Changes:
             Attachment changed to patch.txt
    ---------------------------------------------------------------------
For a full history of the issue, see:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-263&page=history

---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-263


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-263
    Summary: Order by restriction in DB2/400 for OS/400 prior to V5R2
       Type: Patch

     Status: Unassigned
   Priority: Major

    Project: Hibernate2
 Components: 
             core

   Assignee: 
   Reporter: Brian Koehler

    Created: Fri, 15 Aug 2003 10:14 AM
    Updated: Fri, 15 Aug 2003 10:41 AM
Environment: This patch should fix Hibernate2 for anyone attempting to use HQL to access tables on an AS/400 using V5R1 or earlier.

Description:
The primary issue is that the column name specified in the order by clause must exist in the select clause.  Since Hibernate generates aliases on all selected columns, order by's never work.  The patch code modifies QuerySelect to replace column selections in the order by clause with the aliases defined in the select clause.  The modified QuerySelect code is only triggered if a new method defined in the Dialect class called useAliasesInOrderBy returns true.  By default the Dialect method returns false, and a new subclass of the DB2Dialect called AS400DB2Dialect returns true.


---------------------------------------------------------------------
JIRA INFORMATION:
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.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira