diff options
Diffstat (limited to 'mysql-test/suite/handler/heap.result')
| -rw-r--r-- | mysql-test/suite/handler/heap.result | 13 |
1 files changed, 12 insertions, 1 deletions
diff --git a/mysql-test/suite/handler/heap.result b/mysql-test/suite/handler/heap.result index 27d3f05b14e..b41f49091f1 100644 --- a/mysql-test/suite/handler/heap.result +++ b/mysql-test/suite/handler/heap.result @@ -772,4 +772,15 @@ HANDLER t1 READ NEXT LIMIT 2; ERROR HY000: Record has changed since last read in table 't1' HANDLER t1 CLOSE; DROP TABLE t1; -End of 5.1 tests +create table t1 (f1 integer not null, key (f1)) engine=Memory; +insert into t1 values (1); +HANDLER t1 OPEN; +HANDLER t1 READ f1 NEXT; +ERROR HY000: Table storage engine for 't1' doesn't have this option +HANDLER t1 READ f1 NEXT; +ERROR HY000: Table storage engine for 't1' doesn't have this option +HANDLER t1 READ f1 NEXT; +ERROR HY000: Table storage engine for 't1' doesn't have this option +HANDLER t1 CLOSE; +DROP TABLE t1; +End of 5.3 tests |