summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorunknown <serg@serg.mysql.com>2003-02-25 20:37:49 +0100
committerunknown <serg@serg.mysql.com>2003-02-25 20:37:49 +0100
commit11139d6f31d2a616383cbfa1d1263b01c1c18434 (patch)
tree3fb5315223b0cfcd7ac86abd9650a46ef3d5db31
parenta7cb587b3d27effae57d47f5437a534d09c30958 (diff)
downloadmariadb-git-11139d6f31d2a616383cbfa1d1263b01c1c18434.tar.gz
fix a bug in the test
-rw-r--r--mysql-test/r/innodb_handler.result6
-rw-r--r--mysql-test/t/innodb_handler.test6
2 files changed, 8 insertions, 4 deletions
diff --git a/mysql-test/r/innodb_handler.result b/mysql-test/r/innodb_handler.result
index 79ebd96ceaf..321aedabdc7 100644
--- a/mysql-test/r/innodb_handler.result
+++ b/mysql-test/r/innodb_handler.result
@@ -129,12 +129,14 @@ a b
handler t2 read next;
a b
18 eee
+handler t2 read last;
+You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
handler t2 close;
handler t1 open as t2;
handler t2 read first;
a b
17 ddd
alter table t1 type=innodb;
-handler t2 read last;
-You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
+handler t2 read first;
+Unknown table 't2' in HANDLER
drop table if exists t1;
diff --git a/mysql-test/t/innodb_handler.test b/mysql-test/t/innodb_handler.test
index 0af822334fa..5483871494e 100644
--- a/mysql-test/t/innodb_handler.test
+++ b/mysql-test/t/innodb_handler.test
@@ -62,13 +62,15 @@ handler t2 read a=(19) where b="yyy";
handler t2 read first;
handler t2 read next;
+--error 1109
+handler t2 read last;
handler t2 close;
handler t1 open as t2;
handler t2 read first;
alter table t1 type=innodb;
---error 1109
-handler t2 read last;
+--error 1064
+handler t2 read first;
drop table if exists t1;