diff options
Diffstat (limited to 'mysql-test/r/handler.result')
| -rw-r--r-- | mysql-test/r/handler.result | 70 |
1 files changed, 33 insertions, 37 deletions
diff --git a/mysql-test/r/handler.result b/mysql-test/r/handler.result index dcbf558ac3f..072d4582cbc 100644 --- a/mysql-test/r/handler.result +++ b/mysql-test/r/handler.result @@ -230,40 +230,36 @@ create table t1(table_id char(20) primary key); insert into t1 values ('test.t1'); insert into t1 values (''); handler t1 open; -Not unique table/alias: 't1' +ERROR 42000: Not unique table/alias: 't1' use test; handler test.t1 read first limit 9; -Unknown table 'test.t1' in HANDLER +ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'read first limit 9' at line 1 handler test_test.t1 read first limit 9; -table_id -test_test.t1 - +ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'read first limit 9' at line 1 handler t1 read first limit 9; table_id test_test.t1 handler test_test.t2 read first limit 9; -table_id -test_test.t2 - +ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'read first limit 9' at line 1 handler t2 read first limit 9; table_id test_test.t2 handler test_test.t1 close; +ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'close' at line 1 handler t1 close; -Unknown table 't1' in HANDLER drop table test_test.t1; handler test_test.t2 close; +ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'close' at line 1 handler t2 close; -Unknown table 't2' in HANDLER drop table test_test.t2; drop database test_test; use test; handler test.t1 close; -Unknown table 'test.t1' in HANDLER +ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'close' at line 1 handler t1 close; -Unknown table 't1' in HANDLER +ERROR 42S02: Unknown table 't1' in HANDLER drop table test.t1; drop database if exists test_test; drop table if exists t1; @@ -291,20 +287,20 @@ insert into t1 values ('t1'); insert into t2 values ('t2'); insert into t3 values ('t3'); handler t1 open; -Not unique table/alias: 't1' +ERROR 42000: Not unique table/alias: 't1' handler t2 open t1; -Not unique table/alias: 't1' +ERROR 42000: Not unique table/alias: 't1' handler t3 open t1; -Not unique table/alias: 't1' +ERROR 42000: Not unique table/alias: 't1' handler t1 read first limit 9; c1 test_test.t1 handler test.t1 close; -Unknown table 'test.t1' in HANDLER +ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'close' at line 1 handler test.t1 open h1; -Not unique table/alias: 'h1' +ERROR 42000: Not unique table/alias: 'h1' handler test_test.t1 open h1; -Not unique table/alias: 'h1' +ERROR 42000: Not unique table/alias: 'h1' handler test_test.t3 open h3; handler test.t1 open h2; handler t1 read first limit 9; @@ -319,24 +315,24 @@ t1 handler h3 read first limit 9; c1 test_test.t3 -handler test.h2 read first limit 9; +handler h2 read first limit 9; c1 t1 handler test.h1 close; -Unknown table 'test.h1' in HANDLER -handler test_test.t1 close; -handler test_test.h1 close; +ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'close' at line 1 +handler t1 close; +handler h1 close; handler h2 close; handler t1 read first limit 9; -Unknown table 't1' in HANDLER +ERROR 42S02: Unknown table 't1' in HANDLER handler h1 read first limit 9; -Unknown table 'h1' in HANDLER +ERROR 42S02: Unknown table 'h1' in HANDLER handler h2 read first limit 9; -Unknown table 'h2' in HANDLER +ERROR 42S02: Unknown table 'h2' in HANDLER handler h3 read first limit 9; c1 test_test.t3 -handler test_test.h3 read first limit 9; +handler h3 read first limit 9; c1 test_test.t3 use test_test; @@ -344,8 +340,8 @@ handler h3 read first limit 9; c1 test_test.t3 handler test.h3 read first limit 9; -Unknown table 'test.h3' in HANDLER -handler test_test.h3 close; +ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'read first limit 9' at line 1 +handler h3 close; use test; drop table t3; drop table t2; @@ -383,7 +379,7 @@ c1 t5 alter table t1 engine=MyISAM; handler h1 read first limit 9; -Unknown table 'h1' in HANDLER +ERROR 42S02: Unknown table 'h1' in HANDLER handler h2 read first limit 9; c1 t2 @@ -398,7 +394,7 @@ c1 t5 alter table t5 engine=MyISAM; handler h1 read first limit 9; -Unknown table 'h1' in HANDLER +ERROR 42S02: Unknown table 'h1' in HANDLER handler h2 read first limit 9; c1 t2 @@ -409,20 +405,20 @@ handler h4 read first limit 9; c1 t4 handler h5 read first limit 9; -Unknown table 'h5' in HANDLER +ERROR 42S02: Unknown table 'h5' in HANDLER alter table t3 engine=MyISAM; handler h1 read first limit 9; -Unknown table 'h1' in HANDLER +ERROR 42S02: Unknown table 'h1' in HANDLER handler h2 read first limit 9; c1 t2 handler h3 read first limit 9; -Unknown table 'h3' in HANDLER +ERROR 42S02: Unknown table 'h3' in HANDLER handler h4 read first limit 9; c1 t4 handler h5 read first limit 9; -Unknown table 'h5' in HANDLER +ERROR 42S02: Unknown table 'h5' in HANDLER handler h2 close; handler h4 close; handler t1 open as h1_1; @@ -439,11 +435,11 @@ c1 t1 alter table t1 engine=MyISAM; handler h1_1 read first limit 9; -Unknown table 'h1_1' in HANDLER +ERROR 42S02: Unknown table 'h1_1' in HANDLER handler h1_2 read first limit 9; -Unknown table 'h1_2' in HANDLER +ERROR 42S02: Unknown table 'h1_2' in HANDLER handler h1_3 read first limit 9; -Unknown table 'h1_3' in HANDLER +ERROR 42S02: Unknown table 'h1_3' in HANDLER drop table t1; drop table t2; drop table t3; |