diff options
author | Marko Mäkelä <marko.makela@mariadb.com> | 2019-01-06 17:43:02 +0200 |
---|---|---|
committer | Marko Mäkelä <marko.makela@mariadb.com> | 2019-01-06 17:43:02 +0200 |
commit | 734510a44d690dfb94264e1d2775ee1cb6f3ebb9 (patch) | |
tree | 0ccc317bf9462ca95cd1277b4ce65a7fda5fe315 /mysql-test/main/win.result | |
parent | 2465d3e00b2f18c7d4967f9bb10438883682787d (diff) | |
parent | faf206a848684bc0f87c93a2b47a55063bbccc6c (diff) | |
download | mariadb-git-734510a44d690dfb94264e1d2775ee1cb6f3ebb9.tar.gz |
Merge 10.3 into 10.4
Diffstat (limited to 'mysql-test/main/win.result')
-rw-r--r-- | mysql-test/main/win.result | 23 |
1 files changed, 22 insertions, 1 deletions
diff --git a/mysql-test/main/win.result b/mysql-test/main/win.result index ce8c1311222..279404968bf 100644 --- a/mysql-test/main/win.result +++ b/mysql-test/main/win.result @@ -3471,7 +3471,25 @@ MIN(b1) OVER () 1 drop table t1; # -# Start of 10.3 tests +# MDEV-15424: Unreasonal SQL Error (1356) on select from view +# +create table t1 (id int, n1 int); +insert into t1 values (1,1), (2,1), (3,2), (4,4); +create view v1 as SELECT ifnull(max(n1) over (partition by n1),'aaa') FROM t1; +explain select * from v1; +id select_type table type possible_keys key key_len ref rows Extra +1 PRIMARY <derived2> ALL NULL NULL NULL NULL 4 +2 DERIVED t1 ALL NULL NULL NULL NULL 4 Using temporary +select * from v1; +ifnull(max(n1) over (partition by n1),'aaa') +1 +1 +2 +4 +drop table t1; +drop view v1; +# +# End of 10.2 tests # # # MDEV-16489 when lead() returns null on a datetime field, the result is treated as the literal string '[NULL]' @@ -3491,6 +3509,9 @@ d x 00:00:02 NULL DROP TABLE t1; # +# End of 10.3 tests +# +# # MDEV-16722: Assertion `type() != NULL_ITEM' failed # create table t1 (a int); |