diff options
| author | Alexander Barkov <bar@mariadb.org> | 2017-07-21 23:38:30 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2017-07-21 23:38:30 +0400 |
| commit | 23290e42e3f105c93745ac94ad6864ed29afe31b (patch) | |
| tree | 9243ae94da39c042a707074ef52ca93aa1854092 /mysql-test/r/win.result | |
| parent | 34668e10b2e0636b5e784ae76f0c5cba5e4eb732 (diff) | |
| parent | e2afdb1ee430cb9d030aeeedc85eb903cda5e5d1 (diff) | |
| download | mariadb-git-23290e42e3f105c93745ac94ad6864ed29afe31b.tar.gz | |
Merge commit 'e2afdb1ee430cb9d030aeeedc85eb903cda5e5d1' into bb-10.2-ext
Diffstat (limited to 'mysql-test/r/win.result')
| -rw-r--r-- | mysql-test/r/win.result | 23 |
1 files changed, 21 insertions, 2 deletions
diff --git a/mysql-test/r/win.result b/mysql-test/r/win.result index eb4d612d398..69792ffbea4 100644 --- a/mysql-test/r/win.result +++ b/mysql-test/r/win.result @@ -2762,10 +2762,8 @@ CREATE TABLE t1 (i INT); INSERT INTO t1 VALUES (3), (1), (2); SELECT i, ROW_NUMBER() OVER () FROM t1 WHERE 1 = 2; i ROW_NUMBER() OVER () -NULL 1 SELECT i, COUNT(*) OVER () FROM t1 WHERE 1 = 2; i COUNT(*) OVER () -NULL 1 DROP TABLE t1; # # MDEV-12051: window function in query with implicit grouping @@ -3142,6 +3140,27 @@ sum(i) over (order by i) interval(sum(i) over (order by i), 10, 20) 63 2 drop table t1; # +# MDEV-13352: Server crashes in st_join_table::remove_duplicates +# +CREATE TABLE t1 (i INT); +INSERT INTO t1 VALUES (1),(2); +SELECT DISTINCT ROW_NUMBER() OVER(), i FROM t1 WHERE 0; +ROW_NUMBER() OVER() i +SELECT ROW_NUMBER() OVER(), i FROM t1 WHERE 0; +ROW_NUMBER() OVER() i +DROP TABLE t1; +# +# MDEV-13344: Server crashes in in AGGR_OP::put_record on subquery +# with window function and constant table +# (Testcase only) +# +CREATE TABLE t1 (c CHAR(8)) ENGINE=MyISAM; +INSERT IGNORE INTO t1 VALUES ('foo'); +SELECT ('bar',1) IN ( SELECT c, ROW_NUMBER() OVER (PARTITION BY c) FROM t1); +('bar',1) IN ( SELECT c, ROW_NUMBER() OVER (PARTITION BY c) FROM t1) +0 +DROP TABLE t1; +# # Start of 10.3 tests # # |