Uploaded image for project: 'Torque'
  1. Torque
  2. TORQUE-34

OrderBy using alias's and multiple tables causes error on Sybase ASE 12.5

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 3.2
    • Runtime
    • None
    • Sybase ASE 12.5
    • TTHS3

    Description

      When I include an OrderBy on a Criteria that uses table alias's, the order by column is added to the select clause as TableName.Column, not alias.Column. This results in an error on Sybase ASE 12.5 - you cannot reference a column by TableName if an alias is defined. Removing line 1281-82 from BasePeer from v3.1 solves this issue for Sybase, but I don't know what affect it has on other databases

      Scarab issue was raised by Jimmy Myerscough (wumpus at earthling dot net).

      Attachments

        Activity

          People

            tfischer Thomas Fox
            seade Scott Eade
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: