summaryrefslogtreecommitdiff
path: root/mysql-test/r/win.result
diff options
context:
space:
mode:
authorIgor Babaev <igor@askmonty.org>2017-02-06 22:12:53 -0800
committerIgor Babaev <igor@askmonty.org>2017-02-06 22:12:53 -0800
commitc16c9e8e76fc04cd051dc7eeb5589184fc349e21 (patch)
tree4698a94d2f5b58f04dcb4435ae17e04cf54cfaa9 /mysql-test/r/win.result
parent2f00b73a4bc4a87be54ced24969fddc796258e43 (diff)
downloadmariadb-git-c16c9e8e76fc04cd051dc7eeb5589184fc349e21.tar.gz
Fixed bug mdev-11999.
This patch complements the patch for bug 11138. Without this patch some table-less queries with window functions could cause crashes due to a memory overwrite.
Diffstat (limited to 'mysql-test/r/win.result')
-rw-r--r--mysql-test/r/win.result13
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/win.result b/mysql-test/r/win.result
index c84c98c6032..48bdb6a6cd8 100644
--- a/mysql-test/r/win.result
+++ b/mysql-test/r/win.result
@@ -2545,3 +2545,16 @@ row_number() over (partition by 2)
select row_number() over (partition by 4 order by 1+2);
row_number() over (partition by 4 order by 1+2)
1
+#
+# MDEV-11999: execution of prepared statement for
+# tableless query with window functions
+#
+prepare stmt from
+"select row_number() over (partition by 4 order by 1+2)";
+execute stmt;
+row_number() over (partition by 4 order by 1+2)
+1
+execute stmt;
+row_number() over (partition by 4 order by 1+2)
+1
+deallocate prepare stmt;