Details
-
Bug
-
Resolution: Done
-
Major
-
None
-
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.