db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stefan Birrer (JIRA)" <j...@apache.org>
Subject [jira] Created: (TORQUE-89) OrderByColumn for COUNT, SUM
Date Sun, 15 Apr 2007 10:05:15 GMT
OrderByColumn for COUNT, SUM

                 Key: TORQUE-89
                 URL: https://issues.apache.org/jira/browse/TORQUE-89
             Project: Torque
          Issue Type: Bug
          Components: Runtime
    Affects Versions: 3.3-RC2
         Environment: Linux
            Reporter: Stefan Birrer

I've a "complicated" JOIN statement that features some custom column like "COUNT(a) AS ca".

Torque runtime fails on the 


because it expects a full qualified table.columnName which is not the case for the example
"ca" column.

The problem can be fixed by adapting the following functions (3.3-RC2):
removeSQLFunction(final String name) : name must not necessarily contain '.' or '*" thus replacing
the first thrown exception with a "return name" fixes that issue
processOrderBy(...) : in the for loop, strippedColumnName must not contain '.'  hence replacing
the first thrown exception with "orderByColumn.add(orderByColumn); break;" fixes the issue

This are quick fixes and I guess you want to reconsider whether you want to implement it that
way. After these two changes, it was working correctly though.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org

View raw message