You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-dev@db.apache.org by "Thomas Vandahl (JIRA)" <ji...@apache.org> on 2006/11/26 19:25:08 UTC
[jira] Closed: (TORQUE-34) OrderBy using alias's and multiple
tables causes error on Sybase ASE 12.5
[ http://issues.apache.org/jira/browse/TORQUE-34?page=all ]
Thomas Vandahl closed TORQUE-34.
--------------------------------
> 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
> Issue Type: Bug
> Components: Runtime
> Environment: Sybase ASE 12.5
> Reporter: Scott Eade
> Assigned To: Thomas Fischer
> Fix For: 3.2
>
>
> 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