db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Vandahl (JIRA)" <j...@apache.org>
Subject [jira] Closed: (TORQUE-34) OrderBy using alias's and multiple tables causes error on Sybase ASE 12.5
Date Sun, 26 Nov 2006 18:25:08 GMT
     [ 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

View raw message