db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edgar Gonzalez <...@valhallaproject.com>
Subject [SOURCE] Issue #TRQS108 - OrderBy when use alias
Date Sat, 04 Jan 2003 18:46:42 GMT
You can view the issue detail at the following URL:
<http://scarab.werken.com/scarab/issues/id/TRQS108>

Type :        Patch
Issue Id :    TRQS108
Reported by: Edgar Gonzalez
             egg - (egg@valhallaproject.com)

Details:

Platform: All
Operating system: windows 2000
Summary: OrderBy when use alias
Description: The bug happens when you use alias and specify an orderBy with an string column
of the table aliases, the code add a new column to the select clause with the ignoreCaseInOrderBy
database function. The problem is that when the column is added to the select clause not use
the alias name specified, instead use the table name, and if the table name is not used in
the query an SQL error ocurrs



Mime
View raw message