[PHOENIX-2876] Using aggregation function in ORDER BY

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.7.0
• Fix Version/s: 4.8.0
• Assignee: Sergey Soldatov
• Reporter: Sergey Soldatov
• Created: 03/May/16 08:02
• Updated: 11/Aug/16 08:28
• Resolved: 13/May/16 00:24

Description

create table x (id integer primary key, i1 integer, i2 integer);
upsert into x values (1, 1, 1);
upsert into x values (2, 2, 2);
upsert into x values (3, 2, 3);
upsert into x values (4, 3, 3);
upsert into x values (5, 3, 2);
upsert into x values (6, 3, 1);

Test query:

select i1 from X group by i1 order by avg(i2) desc;

Expected result: 2, 3, 1
Real result : 1, 3, 2
In other hands

select i1, avg(i2) from X group by i1 order by avg(i2) desc;

works correctly.
That happens because in ORDER BY we add nothing to RowProjector if we deal with aggregate functions. So, there is a question. Do we have any restrictions why we can't add the expression from ORDER BY to RowProjector ?