diff options
Diffstat (limited to 'mysql-test/t/sel000005.test')
| -rw-r--r-- | mysql-test/t/sel000005.test | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/t/sel000005.test b/mysql-test/t/sel000005.test new file mode 100644 index 00000000000..d6dbb381654 --- /dev/null +++ b/mysql-test/t/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/sel000005.result select one.id, elt(two.val,'one','two') from elt_ck1 one, elt_ck2 two +where two.id=one.id ; + |