summaryrefslogtreecommitdiff
path: root/mysql-test/t
diff options
context:
space:
mode:
authorserg@serg.mysql.com <>2001-04-15 20:56:29 +0200
committerserg@serg.mysql.com <>2001-04-15 20:56:29 +0200
commit4fbab1d681a8ebffa9a699a727910c322419a713 (patch)
treea73e872906e1ecc8029f3c9fd4aa66200dee9851 /mysql-test/t
parentb8c416ac65355104962587122e247200904dc107 (diff)
parent5d86c27a2d4e5a4851720b27f8ef733b174cb778 (diff)
downloadmariadb-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.test65
-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