[CALCITE-6519] Non-aggregate query that uses measure in ORDER BY

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.38.0
• Labels: pull-request-available
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 07/Aug/24 01:58
• Updated: 5 days ago 22:41
• Resolved: 5 days ago 22:41

Description

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:

WITH empm AS
  (SELECT *, avg(sal) AS MEASURE avgSal FROM emp)
SELECT avgSal, deptno
FROM empm
ORDER BY avgSal DESC LIMIT 3;

Issue Links

• is related to: CALCITE-4496 Measure columns ("SELECT ... AS MEASURE")
• links to: GitHub Pull Request #3907