diff options
| author | serg@serg.mysql.com <> | 2003-02-22 18:22:39 +0100 |
|---|---|---|
| committer | serg@serg.mysql.com <> | 2003-02-22 18:22:39 +0100 |
| commit | 572e2a1568a8a561218f22bfa187b0002d642740 (patch) | |
| tree | e9499380cdbd24f4eb6ad141c2a962920c90a3ab | |
| parent | e7715445f381a51019add14f110749b6b61456ab (diff) | |
| download | mariadb-git-572e2a1568a8a561218f22bfa187b0002d642740.tar.gz | |
tests updated
| -rw-r--r-- | mysql-test/r/handler.result | 5 | ||||
| -rw-r--r-- | mysql-test/t/handler.test | 8 |
2 files changed, 9 insertions, 4 deletions
diff --git a/mysql-test/r/handler.result b/mysql-test/r/handler.result index 9760719ecf2..3be24305e09 100644 --- a/mysql-test/r/handler.result +++ b/mysql-test/r/handler.result @@ -129,7 +129,6 @@ a b handler t2 read next; a b 18 eee -alter table t1 type=MyISAM; handler t2 read next; a b 19 fff @@ -142,4 +141,8 @@ create table t1 (a int); insert into t1 values (17); handler t2 read first; Unknown table 't2' in HANDLER +handler t1 open as t2; +alter table t1 type=MyISAM; +handler t2 read first; +Unknown table 't2' in HANDLER drop table t1; diff --git a/mysql-test/t/handler.test b/mysql-test/t/handler.test index f5bab7cf337..7020a4ab3d3 100644 --- a/mysql-test/t/handler.test +++ b/mysql-test/t/handler.test @@ -60,15 +60,13 @@ handler t2 read a=(19) where b="yyy"; handler t2 read first; handler t2 read next; -alter table t1 type=MyISAM; handler t2 read next; --error 1064 handler t2 read last; - handler t2 close; # -# DROP TABLE +# DROP TABLE / ALTER TABLE # handler t1 open as t2; drop table t1; @@ -76,5 +74,9 @@ create table t1 (a int); insert into t1 values (17); --error 1109 handler t2 read first; +handler t1 open as t2; +alter table t1 type=MyISAM; +--error 1109 +handler t2 read first; drop table t1; |