Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Not A Problem
-
2.1.0
-
None
-
None
Description
The following query doesn't seem to return the correct result.
create table test (empno string, deptno string, level string, manager string);
insert into test values ('1', '2', 'B', 'Else');
insert into test values ('1', '2', 'B', 'Else');
insert into test values ('2', '2', 'B', 'Other');
select count( manager) over (partition by deptno, level order by manager) from test;
It returns
2 2 3
Without ORDER BY, it returns correct result
3 3 3