diff options
Diffstat (limited to 'mysql-test/main/win_percentile.result')
| -rw-r--r-- | mysql-test/main/win_percentile.result | 60 |
1 files changed, 30 insertions, 30 deletions
diff --git a/mysql-test/main/win_percentile.result b/mysql-test/main/win_percentile.result index 6ae18488697..4a918bad17f 100644 --- a/mysql-test/main/win_percentile.result +++ b/mysql-test/main/win_percentile.result @@ -32,8 +32,8 @@ Chun 5.0000000000 Kaolin 4.0000000000 Kaolin 4.0000000000 Kaolin 4.0000000000 -Tatiana 4.0000000000 Tata 4.0000000000 +Tatiana 4.0000000000 select name, percentile_disc(0.5) within group(order by score) over (partition by name) as c from t1; name c Chun 3.0000000000 @@ -41,8 +41,8 @@ Chun 3.0000000000 Kaolin 4.0000000000 Kaolin 4.0000000000 Kaolin 4.0000000000 -Tatiana 4.0000000000 Tata 4.0000000000 +Tatiana 4.0000000000 # no partition clause select name, percentile_disc(0.5) within group(order by score) over () from t1; name percentile_disc(0.5) within group(order by score) over () @@ -51,8 +51,8 @@ Chun 4.0000000000 Kaolin 4.0000000000 Kaolin 4.0000000000 Kaolin 4.0000000000 -Tatiana 4.0000000000 Tata 4.0000000000 +Tatiana 4.0000000000 select name, percentile_cont(0.5) within group(order by score) over () from t1; name percentile_cont(0.5) within group(order by score) over () Chun 4.0000000000 @@ -60,8 +60,8 @@ Chun 4.0000000000 Kaolin 4.0000000000 Kaolin 4.0000000000 Kaolin 4.0000000000 -Tatiana 4.0000000000 Tata 4.0000000000 +Tatiana 4.0000000000 # argument set to null select name, percentile_cont(null) within group(order by score) over (partition by name) from t1; ERROR HY000: percentile_cont function only accepts arguments that can be converted to numerical types @@ -75,8 +75,8 @@ Chun 5.0000000000 Kaolin 4.0000000000 Kaolin 4.0000000000 Kaolin 4.0000000000 -Tatiana 4.0000000000 Tata 4.0000000000 +Tatiana 4.0000000000 select * from ( select name , percentile_disc(0.5) within group ( order by score) over (partition by name ) from t1 ) as t; name percentile_disc(0.5) within group ( order by score) over (partition by name ) Chun 3.0000000000 @@ -84,8 +84,8 @@ Chun 3.0000000000 Kaolin 4.0000000000 Kaolin 4.0000000000 Kaolin 4.0000000000 -Tatiana 4.0000000000 Tata 4.0000000000 +Tatiana 4.0000000000 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; name Chun @@ -93,8 +93,8 @@ Chun Kaolin Kaolin Kaolin -Tatiana Tata +Tatiana #disallowed fields in order by select score, percentile_cont(0.5) within group(order by name) over (partition by score) from t1; ERROR HY000: Numeric datatype is required for percentile_cont function @@ -121,10 +121,10 @@ name cume_dist() over (partition by name order by score) c Chun 0.5000000000 3.0000000000 Chun 1.0000000000 3.0000000000 Kaolin 0.3333333333 4.0000000000 -Kaolin 1.0000000000 4.0000000000 Kaolin 0.6666666667 4.0000000000 -Tatiana 1.0000000000 4.0000000000 +Kaolin 1.0000000000 4.0000000000 Tata 1.0000000000 4.0000000000 +Tatiana 1.0000000000 4.0000000000 select name, percentile_cont(0.5) within group(order by score) over (partition by name) as c from t1; name c Chun 5.0000000000 @@ -132,98 +132,98 @@ Chun 5.0000000000 Kaolin 4.0000000000 Kaolin 4.0000000000 Kaolin 4.0000000000 -Tatiana 4.0000000000 Tata 4.0000000000 +Tatiana 4.0000000000 select name,cume_dist() over (partition by name order by score) as b, percentile_disc(0.1) within group(order by score) over (partition by name) as c from t1; name b c Chun 0.5000000000 3.0000000000 Chun 1.0000000000 3.0000000000 Kaolin 0.3333333333 3.0000000000 -Kaolin 1.0000000000 3.0000000000 Kaolin 0.6666666667 3.0000000000 -Tatiana 1.0000000000 4.0000000000 +Kaolin 1.0000000000 3.0000000000 Tata 1.0000000000 4.0000000000 +Tatiana 1.0000000000 4.0000000000 select name,cume_dist() over (partition by name order by score) as b, percentile_disc(0.2) within group(order by score) over (partition by name) as c from t1; name b c Chun 0.5000000000 3.0000000000 Chun 1.0000000000 3.0000000000 Kaolin 0.3333333333 3.0000000000 -Kaolin 1.0000000000 3.0000000000 Kaolin 0.6666666667 3.0000000000 -Tatiana 1.0000000000 4.0000000000 +Kaolin 1.0000000000 3.0000000000 Tata 1.0000000000 4.0000000000 +Tatiana 1.0000000000 4.0000000000 select name,cume_dist() over (partition by name order by score) as b, percentile_disc(0.3) within group(order by score) over (partition by name) as c from t1; name b c Chun 0.5000000000 3.0000000000 Chun 1.0000000000 3.0000000000 Kaolin 0.3333333333 3.0000000000 -Kaolin 1.0000000000 3.0000000000 Kaolin 0.6666666667 3.0000000000 -Tatiana 1.0000000000 4.0000000000 +Kaolin 1.0000000000 3.0000000000 Tata 1.0000000000 4.0000000000 +Tatiana 1.0000000000 4.0000000000 select name,cume_dist() over (partition by name order by score) as b, percentile_disc(0.4) within group(order by score) over (partition by name) as c from t1; name b c Chun 0.5000000000 3.0000000000 Chun 1.0000000000 3.0000000000 Kaolin 0.3333333333 4.0000000000 -Kaolin 1.0000000000 4.0000000000 Kaolin 0.6666666667 4.0000000000 -Tatiana 1.0000000000 4.0000000000 +Kaolin 1.0000000000 4.0000000000 Tata 1.0000000000 4.0000000000 +Tatiana 1.0000000000 4.0000000000 select name,cume_dist() over (partition by name order by score) as b, percentile_disc(0.5) within group(order by score) over (partition by name) as c from t1; name b c Chun 0.5000000000 3.0000000000 Chun 1.0000000000 3.0000000000 Kaolin 0.3333333333 4.0000000000 -Kaolin 1.0000000000 4.0000000000 Kaolin 0.6666666667 4.0000000000 -Tatiana 1.0000000000 4.0000000000 +Kaolin 1.0000000000 4.0000000000 Tata 1.0000000000 4.0000000000 +Tatiana 1.0000000000 4.0000000000 select name,cume_dist() over (partition by name order by score) as b, percentile_disc(0.6) within group(order by score) over (partition by name) as c from t1; name b c Chun 0.5000000000 7.0000000000 Chun 1.0000000000 7.0000000000 Kaolin 0.3333333333 4.0000000000 -Kaolin 1.0000000000 4.0000000000 Kaolin 0.6666666667 4.0000000000 -Tatiana 1.0000000000 4.0000000000 +Kaolin 1.0000000000 4.0000000000 Tata 1.0000000000 4.0000000000 +Tatiana 1.0000000000 4.0000000000 select name,cume_dist() over (partition by name order by score) as b, percentile_disc(0.7) within group(order by score) over (partition by name) as c from t1; name b c Chun 0.5000000000 7.0000000000 Chun 1.0000000000 7.0000000000 Kaolin 0.3333333333 7.0000000000 -Kaolin 1.0000000000 7.0000000000 Kaolin 0.6666666667 7.0000000000 -Tatiana 1.0000000000 4.0000000000 +Kaolin 1.0000000000 7.0000000000 Tata 1.0000000000 4.0000000000 +Tatiana 1.0000000000 4.0000000000 select name,cume_dist() over (partition by name order by score) as b, percentile_disc(0.8) within group(order by score) over (partition by name) as c from t1; name b c Chun 0.5000000000 7.0000000000 Chun 1.0000000000 7.0000000000 Kaolin 0.3333333333 7.0000000000 -Kaolin 1.0000000000 7.0000000000 Kaolin 0.6666666667 7.0000000000 -Tatiana 1.0000000000 4.0000000000 +Kaolin 1.0000000000 7.0000000000 Tata 1.0000000000 4.0000000000 +Tatiana 1.0000000000 4.0000000000 select name,cume_dist() over (partition by name order by score) as b, percentile_disc(0.9) within group(order by score) over (partition by name) as c from t1; name b c Chun 0.5000000000 7.0000000000 Chun 1.0000000000 7.0000000000 Kaolin 0.3333333333 7.0000000000 -Kaolin 1.0000000000 7.0000000000 Kaolin 0.6666666667 7.0000000000 -Tatiana 1.0000000000 4.0000000000 +Kaolin 1.0000000000 7.0000000000 Tata 1.0000000000 4.0000000000 +Tatiana 1.0000000000 4.0000000000 select name,cume_dist() over (partition by name order by score) as b, percentile_disc(1) within group(order by score) over (partition by name) as c from t1; name b c Chun 0.5000000000 7.0000000000 Chun 1.0000000000 7.0000000000 Kaolin 0.3333333333 7.0000000000 -Kaolin 1.0000000000 7.0000000000 Kaolin 0.6666666667 7.0000000000 -Tatiana 1.0000000000 4.0000000000 +Kaolin 1.0000000000 7.0000000000 Tata 1.0000000000 4.0000000000 +Tatiana 1.0000000000 4.0000000000 select median(score) over (partition by name), percentile_cont(0) within group(order by score) over (partition by name) as c from t1; median(score) over (partition by name) c 5.0000000000 3.0000000000 |