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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
