1 files changed, 0 insertions, 140 deletions
diff --git a/mysql-test/r/flush_table.result b/mysql-test/r/flush_table.result
deleted file mode 100644
index c56d63bd849..00000000000
--- a/mysql-test/r/flush_table.result
+++ /dev/null
@@ -1,140 +0,0 @@
-drop table if exists t1,t2;
-create table t1 (a int not null auto_increment primary key);
-insert into t1 values(0);
-lock table t1 read;
-flush table t1;
-ERROR HY000: Table 't1' was locked with a READ lock and can't be updated
-unlock tables;
-lock table t1 write;
-flush table t1;
-check table t1;
-Table	Op	Msg_type	Msg_text
-test.t1	check	status	OK
-unlock tables;
-lock table t1 write;
-connect  locker,localhost,root,,test;
-connection locker;
-lock table t1 read;
-connection default;
-flush table t1;
-select * from t1;
-a
-1
-unlock tables;
-connection locker;
-unlock tables;
-connection default;
-lock table t1 write;
-connection locker;
-lock table t1 write;
-connection default;
-flush table t1;
-select * from t1;
-a
-1
-unlock tables;
-connection locker;
-unlock tables;
-select * from t1;
-a
-1
-connection default;
-drop table t1;
-disconnect locker;
-create table t1(table_id char(20) primary key);
-create table t2(table_id char(20) primary key);
-insert into t1 values ('test.t1');
-insert into t1 values ('');
-insert into t2 values ('test.t2');
-insert into t2 values ('');
-handler t1 open as a1;
-handler t1 open as a2;
-handler t2 open;
-handler a1 read first limit 9;
-table_id
-test.t1
-
-handler a2 read first limit 9;
-table_id
-test.t1
-
-handler t2 read first limit 9;
-table_id
-test.t2
-
-flush tables;
-handler a1 read first limit 9;
-table_id
-test.t1
-
-handler a2 read first limit 9;
-table_id
-test.t1
-
-handler t2 read first limit 9;
-table_id
-test.t2
-
-handler t1 open as a1;
-ERROR 42000: Not unique table/alias: 'a1'
-handler t1 open as a2;
-ERROR 42000: Not unique table/alias: 'a2'
-handler t2 open;
-ERROR 42000: Not unique table/alias: 't2'
-handler a1 read first limit 9;
-table_id
-test.t1
-
-handler a2 read first limit 9;
-table_id
-test.t1
-
-handler t2 read first limit 9;
-table_id
-test.t2
-
-flush table t1;
-handler a1 read first limit 9;
-table_id
-test.t1
-
-handler a2 read first limit 9;
-table_id
-test.t1
-
-handler t2 read first limit 9;
-table_id
-test.t2
-
-flush table t2;
-handler t2 close;
-drop table t1;
-drop table t2;
-create table t1(table_id char(20) primary key);
-insert into t1 values ('Record-01');
-insert into t1 values ('Record-02');
-insert into t1 values ('Record-03');
-insert into t1 values ('Record-04');
-insert into t1 values ('Record-05');
-handler t1 open;
-handler t1 read first limit 1;
-table_id
-Record-01
-handler t1 read next limit 1;
-table_id
-Record-02
-handler t1 read next limit 1;
-table_id
-Record-03
-flush table t1;
-handler t1 read next limit 1;
-table_id
-Record-01
-handler t1 read next limit 1;
-table_id
-Record-02
-handler t1 close;
-drop table t1;
-FLUSH TABLES WITH READ LOCK ;
-FLUSH TABLES WITH READ LOCK ;
-UNLOCK TABLES;