diff options
Diffstat (limited to 'mysql-test/t/test_heap.test')
| -rw-r--r-- | mysql-test/t/test_heap.test | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/t/test_heap.test b/mysql-test/t/test_heap.test new file mode 100644 index 00000000000..851c376ba38 --- /dev/null +++ b/mysql-test/t/test_heap.test @@ -0,0 +1,20 @@ +# +# Test of heap tables. +# + +--disable_warnings +drop table if exists t1; +--enable_warnings + +# +# Bug 12796: Record doesn't show when selecting through index +# +CREATE TABLE t1 (a int, key(a)) engine=heap; +insert delayed into t1 values (0); +delete from t1; +select * from t1; +insert delayed into t1 values (0), (1); +select * from t1 where a = 0; +drop table t1; + +# End of 4.1 tests |