diff options
| author | unknown <sasha@mysql.sashanet.com> | 2000-11-03 07:04:33 -0700 |
|---|---|---|
| committer | unknown <sasha@mysql.sashanet.com> | 2000-11-03 07:04:33 -0700 |
| commit | a1b03526fc2d5a7e38da93fa589e7cb55242d86d (patch) | |
| tree | 5ee24e3e58295b7a4a6a0b779c5c380b4ab7891f /mysql-test/t/3.23 | |
| parent | 3dfc0a825ed3961460eb17b814fabab900adbffb (diff) | |
| download | mariadb-git-a1b03526fc2d5a7e38da93fa589e7cb55242d86d.tar.gz | |
fixed bugs in elt() and make_set()
added two new test cases
BitKeeper/etc/ignore:
Added mysql-test/r/3.23/sel000004.result.reject mysql-test/var/lib/mysql-bin.006 mysql-test/var/lib/test/elt_ck1.frm mysql-test/var/lib/test/elt_ck1.MYD mysql-test/var/lib/test/elt_ck1.MYI mysql-test/var/lib/test/elt_ck2.frm mysql-test/var/lib/test/elt_ck2.MYD mysql-test/var/lib/test/elt_ck2.MYI to the ignore list
mysql-test/r/3.23/sel000004.result:
new result
mysql-test/r/3.23/sel000005.result:
new result
sql/item_strfunc.cc:
fixed bug in make_set() and elt()
Diffstat (limited to 'mysql-test/t/3.23')
| -rw-r--r-- | mysql-test/t/3.23/sel000004.test | 21 | ||||
| -rw-r--r-- | mysql-test/t/3.23/sel000005.test | 21 |
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 ; + |