fixed bugs in elt() and make_set()

added two new test cases

2 files changed, 42 insertions, 0 deletions

diff --git a/mysql-test/t/3.23/sel000004.test b/mysql-test/t/3.23/sel000004.test
new file mode 100644
index 00000000000..6146ff641e0
--- /dev/null
+++ b/mysql-test/t/3.23/sel000004.test
@@ -0,0 +1,21 @@
+# sel000004
+#
+# 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/3.23/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;
+
diff --git a/mysql-test/t/3.23/sel000005.test b/mysql-test/t/3.23/sel000005.test
new file mode 100644
index 00000000000..18541d5d69e
--- /dev/null
+++ b/mysql-test/t/3.23/sel000005.test
@@ -0,0 +1,21 @@
+# sel000004
+#
+# Versions
+# --------
+#   3.22
+#   3.23
+#
+# Description
+# -----------
+# test for a bug with elt() 
+
+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/3.23/sel000005.result select one.id, elt(two.val,'one','two') from elt_ck1 one, elt_ck2 two 
+where two.id=one.id ;
+