Julian Hyde created CALCITE-6519:
------------------------------------
Summary: Non-aggregate query that uses measure in ORDER BY
Key: CALCITE-6519
URL: https://issues.apache.org/jira/browse/CALCITE-6519
Project: Calcite
Issue Type: Improvement
Reporter: Julian Hyde
As of CALCITE-4496, a non-aggregate query can use measures in its SELECT
clause; this change would further allow a non-aggregate query to use measures
in its ORDER BY clause.
An example such query:
{code}
WITH empm AS
(SELECT *, avg(sal) AS MEASURE avgSal FROM emp)
SELECT avgSal, deptno
FROM empm
ORDER BY avgSal DESC LIMIT 3;
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
