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 Edgar Gonzalez <eg...@valhallaproject.com> on 2003/01/04 19:46:42 UTC

[SOURCE] Issue #TRQS108 - OrderBy when use alias

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