summaryrefslogtreecommitdiff
path: root/mysql-test/suite/handler/interface.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/handler/interface.test')
-rw-r--r--mysql-test/suite/handler/interface.test36
1 files changed, 0 insertions, 36 deletions
diff --git a/mysql-test/suite/handler/interface.test b/mysql-test/suite/handler/interface.test
index 2ef617c3ce7..2f576c9b291 100644
--- a/mysql-test/suite/handler/interface.test
+++ b/mysql-test/suite/handler/interface.test
@@ -175,22 +175,18 @@ create table t1 (c1 int);
create table t2 (c1 int);
insert into t1 values (1);
insert into t2 values (2);
---echo connection: default
handler t1 open;
handler t1 read first;
connect (flush,localhost,root,,);
connection flush;
---echo connection: flush
send flush tables;
connect (waiter,localhost,root,,);
connection waiter;
---echo connection: waiter
let $wait_condition=
select count(*) = 1 from information_schema.processlist
where state = "Waiting for table flush";
--source include/wait_condition.inc
connection default;
---echo connection: default
handler t2 open;
handler t2 read first;
handler t1 read next;
@@ -210,22 +206,18 @@ disconnect flush;
drop table if exists t1, t0;
--enable_warnings
create table t1 (c1 int);
---echo connection: default
handler t1 open;
handler t1 read first;
connect (flush,localhost,root,,);
connection flush;
---echo connection: flush
send rename table t1 to t0;
connection waiter;
---echo connection: waiter
let $wait_condition=
select count(*) = 1 from information_schema.processlist
where state = "Waiting for table metadata lock" and
info = "rename table t1 to t0";
--source include/wait_condition.inc
connection default;
---echo connection: default
--echo #
--echo # RENAME placed two pending locks and waits.
--echo # When HANDLER t0 OPEN does open_tables(), it calls
@@ -242,7 +234,6 @@ connection default;
handler t0 open;
--error 0, ER_UNKNOWN_TABLE
handler t0 close;
---echo connection: flush
connection flush;
reap;
--error ER_UNKNOWN_TABLE
@@ -307,32 +298,6 @@ handler t1 read a next;
connect(con1,localhost,root,,);
connect(con2,localhost,root,,);
-connection default;
---disable_warnings
-drop table if exists t1;
---enable_warnings
---echo # First test case which is supposed trigger the execution
---echo # path on which problem was discovered.
-create table t1 (a int not null);
-insert into t1 values (1);
-handler t1 open;
-connection con1;
-lock table t1 write;
-send alter table t1 engine=csv;
-connection con2;
-let $wait_condition=
- select count(*) = 1 from information_schema.processlist
- where state = "Waiting for table metadata lock" and
- info = "alter table t1 engine=csv";
---source include/wait_condition.inc
-connection default;
---error ER_ILLEGAL_HA
-handler t1 read a next;
-handler t1 close;
-connection con1;
---reap
-unlock tables;
-drop table t1;
--echo # Now test case which was reported originally but which no longer
--echo # triggers execution path which has caused the problem.
connection default;
@@ -389,4 +354,3 @@ execute stmt;
--error ER_UNKNOWN_TABLE
handler v read next;
drop view v;
-