diff options
author | Marko Mäkelä <marko.makela@mariadb.com> | 2020-08-10 18:40:57 +0300 |
---|---|---|
committer | Marko Mäkelä <marko.makela@mariadb.com> | 2020-08-10 18:40:57 +0300 |
commit | bafc5c1321a7dff5f2da292111bf98fed9d1658d (patch) | |
tree | b674bceb1f1fe8b2dc9a8fb7c1aeca6fd1b95dde /mysql-test/main/win.result | |
parent | 0025eb3f963fdca88028ff14a27d9b9638079337 (diff) | |
parent | 3b6dadb5ebedab71bf1870579745ff3cd05e498a (diff) | |
download | mariadb-git-bafc5c1321a7dff5f2da292111bf98fed9d1658d.tar.gz |
Merge 10.2 into 10.3
Diffstat (limited to 'mysql-test/main/win.result')
-rw-r--r-- | mysql-test/main/win.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/main/win.result b/mysql-test/main/win.result index 24aa29598cd..08668965cf6 100644 --- a/mysql-test/main/win.result +++ b/mysql-test/main/win.result @@ -3850,6 +3850,22 @@ ERROR 42000: Too big scale 56 specified for 'rank() over w1'. Maximum is 38 SELECT cast((rank() over w1) as decimal (53,30)); ERROR HY000: Window specification with name 'w1' is not defined # +# MDEV-15180: server crashed with NTH_VALUE() +# +CREATE TABLE t1 (i1 int, a int); +INSERT INTO t1 VALUES (1, 1), (2, 2),(3, 3); +CREATE TABLE t2 (i2 int); +INSERT INTO t2 VALUES (1),(2),(5),(1),(7),(4),(3); +CREATE VIEW v1 AS (SELECT * FROM t1,t2 WHERE t1.i1=t2.i2) ; +SELECT NTH_VALUE(i1, i1) OVER (PARTITION BY i1) FROM v1; +NTH_VALUE(i1, i1) OVER (PARTITION BY i1) +1 +1 +NULL +NULL +DROP VIEW v1; +DROP TABLE t1,t2; +# # End of 10.2 tests # # |