oceanbase

1
#owner: dachuan.sdc
2
#owner group: SQL3
3
# tags: optimizer
4

5
# test aggregation
6

7
--source mysql_test/test_suite/px/include/exam_data.inc
8

9
# 计算全年级平均分，最高分，最低分
10
explain select /*+ USE_PX parallel(2) */ subject, avg(score), max(score), min(score) from score group by subject;
11
--sorted_result
12
select /*+ USE_PX parallel(2) */ subject, avg(score), max(score), min(score) from score group by subject;
13

14
# 计算各个班级平均分，最高分，最低分
15
explain select /*+ USE_PX parallel(2) */ cls, subject, avg(score), max(score), min(score) from score join stu using (sid) group by cls, subject;
16
--sorted_result
17
select /*+ USE_PX parallel(2) */ cls, subject, avg(score), max(score), min(score) from score join stu using (sid) group by cls, subject;
18

19