# -------------------------------------------------------------- #
# Test case migrated from regression test suite: bug5820.sql
#
# Author: Daniel Lee, daniel.lee@mariadb.com
# -------------------------------------------------------------- #
#
--source ../include/have_columnstore.inc
#
USE tpch1;
#
# re-test when we support PERCENTILE_CONT
SELECT o_orderkey, o_custkey, o_totalprice, PERCENTILE_CONT(0.4) WITHIN GROUP (ORDER BY o_totalprice DESC) OVER (partition by o_custkey) "percentile_cont" from orders where o_custkey in (88, 89, 91);
SELECT o_orderkey, o_custkey, PERCENTILE_CONT(0.4) WITHIN GROUP (ORDER BY o_totalprice DESC) OVER (partition by o_custkey) "percentile_cont" from orders order by  o_custkey, o_orderkey limit 860, 15;
#