diff options
author | Marko Mäkelä <marko.makela@mariadb.com> | 2019-08-16 10:51:20 +0300 |
---|---|---|
committer | Marko Mäkelä <marko.makela@mariadb.com> | 2019-08-16 10:51:20 +0300 |
commit | c221bcdce7714a74b89a02de941e8d8df2994ce3 (patch) | |
tree | 87a4e2d595ea3cc1465f212f26a9b9030655aa0c /mysql-test/main/win.result | |
parent | 3bbf008096fc997556459442bc2503c504248345 (diff) | |
parent | 395e1dcd176bbf0fcdb5d156bc58604590245a26 (diff) | |
download | mariadb-git-c221bcdce7714a74b89a02de941e8d8df2994ce3.tar.gz |
Merge 10.3 into 10.4
Diffstat (limited to 'mysql-test/main/win.result')
-rw-r--r-- | mysql-test/main/win.result | 35 |
1 files changed, 35 insertions, 0 deletions
diff --git a/mysql-test/main/win.result b/mysql-test/main/win.result index 51a0f35ad61..4adb5c84f1e 100644 --- a/mysql-test/main/win.result +++ b/mysql-test/main/win.result @@ -3654,6 +3654,41 @@ d x 00:00:02 NULL DROP TABLE t1; # +# MDEV-20351 Window function BIT_OR() OVER (..) return a wrong data type +# +CREATE TABLE t1 (pk INT, a INT, b BIGINT UNSIGNED); +INSERT INTO t1 VALUES (1, 0, 1), (2, 0, 18446744073709551615); +CREATE TABLE t2 AS +SELECT pk, a, bit_or(b) AS bit_or FROM t1 GROUP BY pk; +SHOW CREATE TABLE t2; +Table Create Table +t2 CREATE TABLE `t2` ( + `pk` int(11) DEFAULT NULL, + `a` int(11) DEFAULT NULL, + `bit_or` bigint(21) unsigned NOT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +SELECT * FROM t1; +pk a b +1 0 1 +2 0 18446744073709551615 +DROP TABLE t2; +CREATE OR REPLACE TABLE t2 AS +SELECT pk, a, BIT_OR(b) OVER (PARTITION BY a ORDER BY pk ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING) AS bit_or +FROM t1; +SHOW CREATE TABLE t2; +Table Create Table +t2 CREATE TABLE `t2` ( + `pk` int(11) DEFAULT NULL, + `a` int(11) DEFAULT NULL, + `bit_or` bigint(21) unsigned NOT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +SELECT * FROM t2; +pk a bit_or +1 0 18446744073709551615 +2 0 18446744073709551615 +DROP TABLE t2; +DROP TABLE t1; +# # End of 10.3 tests # # |