summaryrefslogtreecommitdiff
path: root/mysql-test/t/win.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/win.test')
-rw-r--r--mysql-test/t/win.test9
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/win.test b/mysql-test/t/win.test
index d19ff2c624d..a768b893432 100644
--- a/mysql-test/t/win.test
+++ b/mysql-test/t/win.test
@@ -2473,5 +2473,14 @@ SELECT FIRST_VALUE(MAX(a) OVER (PARTITION BY a)) OVER (ORDER BY a) AS x FROM t1
DROP TABLE t1;
--echo #
+--echo # MDEV-12059: Assertion `precision > 0' failed with a window function or window aggregate function
+--echo #
+
+CREATE TABLE t1 (d DECIMAL(1,0) UNSIGNED);
+INSERT INTO t1 VALUES (1),(2);
+SELECT MIN(d) OVER () FROM t1;
+DROP TABLE t1;
+
+--echo #
--echo # End of 10.2 tests
--echo #