diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2020-08-10 21:38:55 +0300 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2020-08-10 21:38:55 +0300 |
| commit | 1c587481966abc7a9ad5309d0a91ca920f7a5657 (patch) | |
| tree | 28b936bd807cab0ba7b82e4cc9ec963fa6de6307 /mysql-test/main/win.test | |
| parent | 17be2b47ba32535e69e28da9a444e528ba8ab155 (diff) | |
| parent | eae968f62d285de97ed607c87bc131cd863d5d03 (diff) | |
| download | mariadb-git-1c587481966abc7a9ad5309d0a91ca920f7a5657.tar.gz | |
Merge 10.4 into 10.5
Diffstat (limited to 'mysql-test/main/win.test')
| -rw-r--r-- | mysql-test/main/win.test | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/main/win.test b/mysql-test/main/win.test index 4b442c03ad6..d8065e15fee 100644 --- a/mysql-test/main/win.test +++ b/mysql-test/main/win.test @@ -2506,6 +2506,22 @@ SELECT cast((rank() over w1) as decimal (53,56)); SELECT cast((rank() over w1) as decimal (53,30)); --echo # +--echo # MDEV-15180: server crashed with NTH_VALUE() +--echo # + +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; + +DROP VIEW v1; +DROP TABLE t1,t2; + +--echo # --echo # End of 10.2 tests --echo # |