diff options
author | unknown <ingo@mysql.com> | 2005-03-02 10:56:13 +0100 |
---|---|---|
committer | unknown <ingo@mysql.com> | 2005-03-02 10:56:13 +0100 |
commit | cc4455631a51c999324759391f6f843cf97fd923 (patch) | |
tree | 04e597e0f2cb62e0de40965ce2cecaf4f015f6ab /mysql-test/r/myisam.result | |
parent | c4409a7cbf9b43ed450340ba9dd6a33f821df5f2 (diff) | |
parent | 26f75ffc83e39ee915e8d4973955c950ddabb35b (diff) | |
download | mariadb-git-cc4455631a51c999324759391f6f843cf97fd923.tar.gz |
Merge
innobase/include/srv0srv.h:
Auto merged
innobase/srv/srv0srv.c:
Auto merged
myisam/mi_create.c:
Auto merged
myisam/mi_open.c:
Auto merged
myisam/myisamdef.h:
Auto merged
sql/ha_innodb.cc:
Auto merged
mysql-test/r/myisam.result:
SCCS merged
mysql-test/t/myisam.test:
SCCS merged
sql/ha_innodb.h:
SCCS merged
Diffstat (limited to 'mysql-test/r/myisam.result')
-rw-r--r-- | mysql-test/r/myisam.result | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/r/myisam.result b/mysql-test/r/myisam.result index b0cb6462252..73550d97dad 100644 --- a/mysql-test/r/myisam.result +++ b/mysql-test/r/myisam.result @@ -568,6 +568,24 @@ select count(*) from t1 where a is null; count(*) 2 drop table t1; +create table t1 (c1 int, index(c1)); +create table t2 (c1 int, index(c1)) engine=merge union=(t1); +insert into t1 values (1); +flush tables; +select * from t2; +c1 +1 +flush tables; +truncate table t1; +insert into t1 values (1); +flush tables; +select * from t2; +c1 +1 +truncate table t1; +ERROR HY000: MyISAM table 't1' is in use (most likely by a MERGE table). Try FLUSH TABLES. +insert into t1 values (1); +drop table t1,t2; set storage_engine=MyISAM; drop table if exists t1,t2,t3; --- Testing varchar --- |