summaryrefslogtreecommitdiff
path: root/mysql-test/r/myisam.result
diff options
context:
space:
mode:
authorunknown <ingo@mysql.com>2005-03-02 10:56:13 +0100
committerunknown <ingo@mysql.com>2005-03-02 10:56:13 +0100
commitcc4455631a51c999324759391f6f843cf97fd923 (patch)
tree04e597e0f2cb62e0de40965ce2cecaf4f015f6ab /mysql-test/r/myisam.result
parentc4409a7cbf9b43ed450340ba9dd6a33f821df5f2 (diff)
parent26f75ffc83e39ee915e8d4973955c950ddabb35b (diff)
downloadmariadb-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.result18
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 ---