diff options
author | serg@serg.mysql.com <> | 2001-04-15 20:56:29 +0200 |
---|---|---|
committer | serg@serg.mysql.com <> | 2001-04-15 20:56:29 +0200 |
commit | 4fbab1d681a8ebffa9a699a727910c322419a713 (patch) | |
tree | a73e872906e1ecc8029f3c9fd4aa66200dee9851 /mysql-test/t | |
parent | b8c416ac65355104962587122e247200904dc107 (diff) | |
parent | 5d86c27a2d4e5a4851720b27f8ef733b174cb778 (diff) | |
download | mariadb-git-4fbab1d681a8ebffa9a699a727910c322419a713.tar.gz |
Merge work:/home/bk/mysql-4.0
into serg.mysql.com:/usr/home/serg/Abk/mysql-4.0
Diffstat (limited to 'mysql-test/t')
-rw-r--r-- | mysql-test/t/handler.test | 65 | ||||
-rw-r--r-- | mysql-test/t/innodb.test (renamed from mysql-test/t/innobase.test) | 2 |
2 files changed, 66 insertions, 1 deletions
diff --git a/mysql-test/t/handler.test b/mysql-test/t/handler.test new file mode 100644 index 00000000000..359c5641056 --- /dev/null +++ b/mysql-test/t/handler.test @@ -0,0 +1,65 @@ +# +# test of HANDLER ... +# + +drop table if exists t1; +create table t1 (a int, b char(10), key a(a), key b(a,b)); +insert into t1 values +(17,"ddd"),(18,"eee"),(19,"fff"),(19,"yyy"), +(14,"aaa"),(15,"bbb"),(16,"ccc"),(16,"xxx"), +(20,"ggg"),(21,"hhh"),(22,"iii"); +handler t1 open as t2; +handler t2 read a first; +handler t2 read a next; +handler t2 read a next; +handler t2 read a prev; +handler t2 read a last; +handler t2 read a prev; +handler t2 read a prev; + +handler t2 read a first; +handler t2 read a prev; + +handler t2 read a last; +handler t2 read a prev; +handler t2 read a next; +handler t2 read a next; + +handler t2 read a=(15); +handler t2 read a=(16); + +!$1070 handler t2 read a=(19,"fff"); + +handler t2 read b=(19,"fff"); +handler t2 read b=(19,"yyy"); +handler t2 read b=(19); + +!$1109 handler t1 read a last; + +handler t2 read a=(11); +handler t2 read a>=(11); + +handler t2 read a=(18); +handler t2 read a>=(18); +handler t2 read a>(18); +handler t2 read a<=(18); +handler t2 read a<(18); + +handler t2 read a first limit 5; +handler t2 read a next limit 3; +handler t2 read a prev limit 10; + +handler t2 read a>=(16) limit 4; +handler t2 read a>=(16) limit 2,2; +handler t2 read a last limit 3; + +handler t2 read a=(19); +handler t2 read a=(19) where b="yyy"; + +handler t2 read first; +handler t2 read next; +handler t2 read next; +!$1064 handler t2 read last; + +handler t2 close; +drop table if exists t1; diff --git a/mysql-test/t/innobase.test b/mysql-test/t/innodb.test index ee1bd7cddca..b18091656b6 100644 --- a/mysql-test/t/innobase.test +++ b/mysql-test/t/innodb.test @@ -1,4 +1,4 @@ --- source include/have_innobase.inc +-- source include/have_innodb.inc # # Small basic test with ignore |