diff options
| author | unknown <serg@serg.mysql.com> | 2000-12-11 14:09:31 +0100 |
|---|---|---|
| committer | unknown <serg@serg.mysql.com> | 2000-12-11 14:09:31 +0100 |
| commit | 4c6a415233e76ca0eaa95172ff12ea8eaabe345f (patch) | |
| tree | 1b2dc10daab96d2874b3b131078bf003e10ca094 /mysql-test/t/sel000033.test | |
| parent | 8beb43501be6bb4a4bd09e2b0aadc815dcc2f606 (diff) | |
| download | mariadb-git-4c6a415233e76ca0eaa95172ff12ea8eaabe345f.tar.gz | |
Tests backpropagated from mysql-4.0 bk tree
mysql-test/t/sel000004.test:
backpropagated from mysql-4.0
mysql-test/t/sel000005.test:
backpropagated from mysql-4.0
mysql-test/r/sel000004.result:
backpropagated from mysql-4.0
mysql-test/r/sel000005.result:
backpropagated from mysql-4.0
Diffstat (limited to 'mysql-test/t/sel000033.test')
| -rw-r--r-- | mysql-test/t/sel000033.test | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/t/sel000033.test b/mysql-test/t/sel000033.test new file mode 100644 index 00000000000..3f5e4af03fd --- /dev/null +++ b/mysql-test/t/sel000033.test @@ -0,0 +1,17 @@ +# sel000033 +# +# Versions +# -------- +# 3.22 +# 3.23 +# +# Description +# ----------- +# test for a bug with in() and unique key + +drop table if exists t; +create table t (id int(10) primary key); +insert into t values (1),(2),(3),(4),(5),(6),(7),(8),(9); + +@r/3.23/sel000033.result select id from t where id in (2,5,9) ; +@r/3.23/sel000033.result select id from t where id=2 or id=5 or id=9 ; |