diff options
Diffstat (limited to 'mysql-test/r/flush_table.result')
| -rw-r--r-- | mysql-test/r/flush_table.result | 48 |
1 files changed, 43 insertions, 5 deletions
diff --git a/mysql-test/r/flush_table.result b/mysql-test/r/flush_table.result index 257f69fa6d9..7d2e9ab0b8d 100644 --- a/mysql-test/r/flush_table.result +++ b/mysql-test/r/flush_table.result @@ -30,14 +30,23 @@ test.t2 flush tables; handler a1 read first limit 9; -ERROR 42S02: Unknown table 'a1' in HANDLER +table_id +test.t1 + handler a2 read first limit 9; -ERROR 42S02: Unknown table 'a2' in HANDLER +table_id +test.t1 + handler t2 read first limit 9; -ERROR 42S02: Unknown table 't2' in HANDLER +table_id +test.t2 + handler t1 open as a1; +Not unique table/alias: 'a1' handler t1 open as a2; +Not unique table/alias: 'a2' handler t2 open; +Not unique table/alias: 't2' handler a1 read first limit 9; table_id test.t1 @@ -52,9 +61,13 @@ test.t2 flush table t1; handler a1 read first limit 9; -ERROR 42S02: Unknown table 'a1' in HANDLER +table_id +test.t1 + handler a2 read first limit 9; -ERROR 42S02: Unknown table 'a2' in HANDLER +table_id +test.t1 + handler t2 read first limit 9; table_id test.t2 @@ -64,3 +77,28 @@ handler t2 close; ERROR 42S02: Unknown table 't2' in HANDLER 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; |