summaryrefslogtreecommitdiff
path: root/mysql-test/t/win_percent_cume.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/win_percent_cume.test')
-rw-r--r--mysql-test/t/win_percent_cume.test36
1 files changed, 0 insertions, 36 deletions
diff --git a/mysql-test/t/win_percent_cume.test b/mysql-test/t/win_percent_cume.test
deleted file mode 100644
index b851185cb32..00000000000
--- a/mysql-test/t/win_percent_cume.test
+++ /dev/null
@@ -1,36 +0,0 @@
-create table t1 (
- pk int primary key,
- a int,
- b int
-);
-
-
-insert into t1 values
-( 1 , 0, 10),
-( 2 , 0, 10),
-( 3 , 1, 10),
-( 4 , 1, 10),
-( 8 , 2, 10),
-( 5 , 2, 20),
-( 6 , 2, 20),
-( 7 , 2, 20),
-( 9 , 4, 20),
-(10 , 4, 20);
-
-select pk, a, b,
- percent_rank() over (order by a),
- cume_dist() over (order by a)
-from t1;
-
-select pk, a, b,
- percent_rank() over (order by pk),
- cume_dist() over (order by pk)
-from t1 order by pk;
-
-select pk, a, b,
- percent_rank() over (partition by a order by a),
- cume_dist() over (partition by a order by a)
-from t1;
-
-drop table t1;
-