db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Scott Eade (JIRA)" <j...@apache.org>
Subject [jira] Created: (TORQUE-34) OrderBy using alias's and multiple tables causes error on Sybase ASE 12.5
Date Tue, 20 Jun 2006 04:04:31 GMT
OrderBy using alias's and multiple tables causes error on Sybase ASE 12.5
-------------------------------------------------------------------------

         Key: TORQUE-34
         URL: http://issues.apache.org/jira/browse/TORQUE-34
     Project: Torque
        Type: Bug

  Components: Runtime  
 Environment: Sybase ASE 12.5
    Reporter: Scott Eade


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).

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


Mime
View raw message