Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 3.3-RC2
    • Fix Version/s: 4.0-beta1
    • Component/s: Runtime
    • Labels:
      None
    • Environment:
      Linux

      Description

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

      Torque runtime fails on the

      Criteria::addAscendingOrderByColumn("ca")

      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):
      src/java/org/apache/torque/util/SQLBuilder.java
      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.

        Activity

          People

          • Assignee:
            Thomas Fox
            Reporter:
            Stefan Birrer
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development