Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-2487

Wrong aliasing when "supportsSelectExpression" is false in translator capabilities

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.4
    • None
    • Query Engine
    • None

    Description

      When "supportsSelectExpression" is false, in the translator capabilities and user submits a query like

      select sum (intnum) as "sum" from smalla group by intkey order by "sum"
      

      the pushdown command at the translator is

      SELECT SUM(SMALLA.INTNUM) FROM SMALLA GROUP BY SMALLA.INTKEY ORDER BY c_0
      

      The alias in the ORDER BY is wrong. Also do not understand why the query engine pushed the aggregate is being pushed, possibly due to "supportsAggregatesSum" is turned on.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rhn-engineering-rareddy Ramesh Reddy
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: