From 7fc86a73d8fbfa6d527d9eb1160bedaf939eae7a Mon Sep 17 00:00:00 2001 From: Alexander Barkov Date: Wed, 7 Aug 2019 22:44:54 +0400 Subject: MDEV-20272 PERCENTILE_DISC() crashes on a temporal type input --- mysql-test/main/win_percentile.test | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) (limited to 'mysql-test/main/win_percentile.test') diff --git a/mysql-test/main/win_percentile.test b/mysql-test/main/win_percentile.test index 2b3fffc4508..8705be123ff 100644 --- a/mysql-test/main/win_percentile.test +++ b/mysql-test/main/win_percentile.test @@ -209,3 +209,20 @@ CREATE OR REPLACE TABLE t2 AS SELECT name, PERCENTILE_DISC(0.5) SHOW CREATE TABLE t2; SELECT * FROM t2 ORDER BY name, pc; DROP TABLE t2, t1; + + +--echo # +--echo # MDEV-20272 PERCENTILE_DISC() crashes on a temporal type input +--echo # + +CREATE OR REPLACE TABLE t1 (name CHAR(30), star_rating TIME); +INSERT INTO t1 VALUES ('Lord of the Ladybirds', 5); +INSERT INTO t1 VALUES ('Lord of the Ladybirds', 3); +INSERT INTO t1 VALUES ('Lady of the Flies', 1); +INSERT INTO t1 VALUES ('Lady of the Flies', 2); +INSERT INTO t1 VALUES ('Lady of the Flies', 5); +--error ER_WRONG_TYPE_FOR_PERCENTILE_FUNC +SELECT name, PERCENTILE_DISC(0.5) + WITHIN GROUP (ORDER BY star_rating) + OVER (PARTITION BY name) AS pc FROM t1; +DROP TABLE t1; -- cgit v1.2.1