diff options
Diffstat (limited to 'mysql-test/main/win_percentile.test')
-rw-r--r-- | mysql-test/main/win_percentile.test | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/main/win_percentile.test b/mysql-test/main/win_percentile.test index a709b38d2e6..d36b365dd9b 100644 --- a/mysql-test/main/win_percentile.test +++ b/mysql-test/main/win_percentile.test @@ -33,11 +33,15 @@ select percentile_cont() within group() over (partition by name) from t1; --echo # Test simple syntax --echo # +--sorted_result select name, percentile_cont(0.5) within group(order by score) over (partition by name) as c from t1; +--sorted_result select name, percentile_disc(0.5) within group(order by score) over (partition by name) as c from t1; --echo # no partition clause +--sorted_result select name, percentile_disc(0.5) within group(order by score) over () from t1; +--sorted_result select name, percentile_cont(0.5) within group(order by score) over () from t1; --echo # argument set to null @@ -47,8 +51,11 @@ select name, percentile_cont(null) within group(order by score) over (partition select name, percentile_disc(null) within group(order by score) over (partition by name) from t1; --echo #subqueries having percentile functions +--sorted_result select * from ( select name , percentile_cont(0.5) within group ( order by score) over (partition by name ) from t1 ) as t; +--sorted_result select * from ( select name , percentile_disc(0.5) within group ( order by score) over (partition by name ) from t1 ) as t; +--sorted_result select name from t1 a where (select percentile_disc(0.5) within group (order by score) over (partition by name) from t1 b limit 1) >= 0.5; --echo #disallowed fields in order by |