summaryrefslogtreecommitdiff
path: root/mysql-test/r/win.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/win.result')
-rw-r--r--mysql-test/r/win.result12
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/win.result b/mysql-test/r/win.result
index 083b5dfd16d..0ddffc551dc 100644
--- a/mysql-test/r/win.result
+++ b/mysql-test/r/win.result
@@ -3506,5 +3506,17 @@ id a b sum_a_b
2 2 2 4
drop table t1;
#
+# MDEV-15837: Assertion `item1->type() == Item::FIELD_ITEM && item2->type() == Item::FIELD_ITEM'
+# failed in compare_order_elements function
+#
+CREATE TABLE t1 (a1 int);
+insert into t1 values (1),(2),(3);
+SELECT rank() OVER (ORDER BY 1), ROW_NUMBER() OVER (ORDER BY (EXPORT_SET(5,'Y','N',',',4))) FROM t1;
+rank() OVER (ORDER BY 1) ROW_NUMBER() OVER (ORDER BY (EXPORT_SET(5,'Y','N',',',4)))
+1 1
+1 2
+1 3
+drop table t1;
+#
# End of 10.2 tests
#