diff options
| author | unknown <monty@mashka.mysql.fi> | 2003-09-12 04:18:07 +0300 |
|---|---|---|
| committer | unknown <monty@mashka.mysql.fi> | 2003-09-12 04:18:07 +0300 |
| commit | 3500763b6e156bcdcb627fbc448681ec3c74c50e (patch) | |
| tree | d50c5c2c1a243241a31006d775628dd2fcc29a03 /mysql-test/t/range.test | |
| parent | 41824a35338012ff8196eb975f961d5e0f0e2a22 (diff) | |
| download | mariadb-git-3500763b6e156bcdcb627fbc448681ec3c74c50e.tar.gz | |
Optimize thai character handling
Remove sel000xxxx tests
After merge fixes
BitKeeper/deleted/.del-sel000033.test~3971fbe746eec069:
Delete: mysql-test/t/sel000033.test
BitKeeper/deleted/.del-sel000033.result~56d1d02d72b94602:
Delete: mysql-test/r/sel000033.result
BitKeeper/deleted/.del-sel000100.result~84ed46856cb3a69f:
Delete: mysql-test/r/sel000100.result
BitKeeper/deleted/.del-sel000100.test~548501cad19a1a59:
Delete: mysql-test/t/sel000100.test
mysql-test/r/distinct.result:
Merge test with sel000100
mysql-test/r/grant.result:
Update result after merge
mysql-test/r/range.result:
After merge fix
Merge test with sel000033
mysql-test/t/distinct.test:
Merge test with sel000100
mysql-test/t/range.test:
Merge test with sel000033
sql/log_event.cc:
Remove duplicate allocation
sql/sql_select.cc:
After merge fixes
strings/ctype-tis620.c:
Remove usage of strnlen
Optimize code and make it \0 safe
Diffstat (limited to 'mysql-test/t/range.test')
| -rw-r--r-- | mysql-test/t/range.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/range.test b/mysql-test/t/range.test index e8f51344ce1..7bf6570b558 100644 --- a/mysql-test/t/range.test +++ b/mysql-test/t/range.test @@ -217,3 +217,11 @@ explain select * from t1, t2 where (t1.key1 <t2.keya + 1) and t2.keya=3; explain select * from t1 force index(i2), t2 where (t1.key1 <t2.keya + 1) and t2.keya=3; DROP TABLE t1,t2; +# test for a bug with in() and unique key + +create table t1 (id int(10) primary key); +insert into t1 values (1),(2),(3),(4),(5),(6),(7),(8),(9); + +select id from t1 where id in (2,5,9) ; +select id from t1 where id=2 or id=5 or id=9 ; +drop table t1; |