You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-07-29 08:21:15 +03:00
60dc7550f1
This patch introduces an internal aggregate operator SELECT_SOME that is automatically added to columns that are not in GROUP BY. It "computes" some plausible value of the column (actually, last one passed). Along the way it fixes incorrect handling of HAVING being transferred into WHERE, window function handling and a bit of other inconsistencies.
20 lines
688 B
Plaintext
20 lines
688 B
Plaintext
USE tpch1;
|
|
select depname, empno, moda(salary) over(partition by depname order by enroll_date) from empsalary order by depname, empno, enroll_date;
|
|
depname empno moda(salary) over(partition by depname order by enroll_date)
|
|
develop 7 5200
|
|
develop 8 6000
|
|
develop 9 5200
|
|
develop 10 5200
|
|
develop 11 5200
|
|
develop 12 5200
|
|
personnel 2 3900
|
|
personnel 5 3500
|
|
sales 1 5000
|
|
sales 3 4800
|
|
sales 4 4800
|
|
select avg(salary),depname, moda(salary) over(partition by depname order by enroll_date) from empsalary group by depname order by depname, avg(salary);
|
|
avg(salary) depname moda(salary) over(partition by depname order by enroll_date)
|
|
5020.0000 develop 0
|
|
3700.0000 personnel 3900
|
|
4866.6667 sales 4800
|