summaryrefslogtreecommitdiff
path: root/mysql-test/r/heap_btree.result
diff options
context:
space:
mode:
authorantony@pcg5ppc.xiphis.org <>2007-10-19 13:04:30 -0700
committerantony@pcg5ppc.xiphis.org <>2007-10-19 13:04:30 -0700
commitfb27ce61bc56580e3b525913138762fc56972ebd (patch)
tree1d419e4dfdb8c4328c5b9aaba767d6d5ae5eb904 /mysql-test/r/heap_btree.result
parent6fa35a5d3b3647682d1ee211a7afd20d220f8151 (diff)
parentda9b4288ed7a52b7d589d8605952cd7c648d73a3 (diff)
downloadmariadb-git-fb27ce61bc56580e3b525913138762fc56972ebd.tar.gz
Merge anubis.xiphis.org:/usr/home/antony/work/mysql-5.0-engines
into anubis.xiphis.org:/usr/home/antony/work/mysql-5.0-engines.merge
Diffstat (limited to 'mysql-test/r/heap_btree.result')
-rw-r--r--mysql-test/r/heap_btree.result7
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/heap_btree.result b/mysql-test/r/heap_btree.result
index 21f5a549529..c20dfbe80d2 100644
--- a/mysql-test/r/heap_btree.result
+++ b/mysql-test/r/heap_btree.result
@@ -307,6 +307,13 @@ UNIQUE USING BTREE(c1)
) ENGINE= MEMORY DEFAULT CHARSET= utf8;
INSERT INTO t1 VALUES('1'), ('2');
DROP TABLE t1;
+CREATE TABLE t1 (a INT, KEY USING BTREE(a)) ENGINE=MEMORY;
+INSERT INTO t1 VALUES(1),(2),(2);
+DELETE FROM t1 WHERE a=2;
+SELECT * FROM t1;
+a
+1
+DROP TABLE t1;
End of 4.1 tests
CREATE TABLE t1(val INT, KEY USING BTREE(val)) ENGINE=memory;
INSERT INTO t1 VALUES(0);