Tests backpropagated from mysql-4.0 bk tree

1 files changed, 20 insertions, 0 deletions

diff --git a/mysql-test/t/sel000031.test b/mysql-test/t/sel000031.test
new file mode 100644
index 00000000000..2aea31c492b
--- /dev/null
+++ b/mysql-test/t/sel000031.test
@@ -0,0 +1,20 @@
+# sel000031
+#
+# Versions
+# --------
+#   3.22
+#   3.23
+#
+# Description
+# -----------
+# test for a bug with elt() and order by
+
+drop table if exists elt_ck1,elt_ck2;
+create table elt_ck1 (id int(10) not null unique);
+create table elt_ck2 (id int(10) not null primary key,
+val int(10) not null);
+insert into elt_ck1 values (1),(2),(4);
+insert into elt_ck2 values (1,1),(2,1),(3,1),(4,2);
+
+@r/sel000004.result select one.id, elt(two.val,'one','two') from elt_ck1 one, elt_ck2 two where two.id=one.id order by one.id;
+