diff options
author | unknown <serg@serg.mysql.com> | 2003-02-25 20:37:49 +0100 |
---|---|---|
committer | unknown <serg@serg.mysql.com> | 2003-02-25 20:37:49 +0100 |
commit | 11139d6f31d2a616383cbfa1d1263b01c1c18434 (patch) | |
tree | 3fb5315223b0cfcd7ac86abd9650a46ef3d5db31 | |
parent | a7cb587b3d27effae57d47f5437a534d09c30958 (diff) | |
download | mariadb-git-11139d6f31d2a616383cbfa1d1263b01c1c18434.tar.gz |
fix a bug in the test
-rw-r--r-- | mysql-test/r/innodb_handler.result | 6 | ||||
-rw-r--r-- | mysql-test/t/innodb_handler.test | 6 |
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; |