diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2022-10-17 08:43:55 +0200 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2022-10-17 08:43:55 +0200 |
| commit | 851b31bcc47b742cd3b39ad06176b0e8be591c18 (patch) | |
| tree | 93da42af4bd22fc448df71777bedb0a4690478ba /mysql-test/main/win_percentile.test | |
| parent | 618d82064618bda06bcd080af5b664b3d173dbe3 (diff) | |
| parent | a4234f0410008e14aa2ad7ad56973127f3046d5c (diff) | |
| download | mariadb-git-851b31bcc47b742cd3b39ad06176b0e8be591c18.tar.gz | |
Merge branch 'bb-10.8-vp-MDEV-27691' into 10.8
Diffstat (limited to 'mysql-test/main/win_percentile.test')
| -rw-r--r-- | mysql-test/main/win_percentile.test | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/main/win_percentile.test b/mysql-test/main/win_percentile.test index e981dc62c41..9626caffc54 100644 --- a/mysql-test/main/win_percentile.test +++ b/mysql-test/main/win_percentile.test @@ -50,11 +50,13 @@ select name, percentile_cont(null) within group(order by score) over (partition --error ER_WRONG_TYPE_OF_ARGUMENT select name, percentile_disc(null) within group(order by score) over (partition by name) from t1; +--disable_view_protocol --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; +--enable_view_protocol --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; @@ -62,7 +64,10 @@ select name from t1 a where (select percentile_disc(0.5) within group (order by --error ER_WRONG_TYPE_FOR_PERCENTILE_FUNC select score, percentile_cont(0.5) within group(order by name) over (partition by score) from t1; +#enable after fix MDEV-27871 +--disable_view_protocol select score, percentile_disc(0.5) within group(order by name) over (partition by score) from t1; +--enable_view_protocol --echo #parameter value should be in the range of [0,1] --error ER_ARGUMENT_OUT_OF_RANGE |