diff options
author | antony@pcg5ppc.xiphis.org <> | 2007-10-19 13:04:30 -0700 |
---|---|---|
committer | antony@pcg5ppc.xiphis.org <> | 2007-10-19 13:04:30 -0700 |
commit | fb27ce61bc56580e3b525913138762fc56972ebd (patch) | |
tree | 1d419e4dfdb8c4328c5b9aaba767d6d5ae5eb904 /mysql-test/r/heap_btree.result | |
parent | 6fa35a5d3b3647682d1ee211a7afd20d220f8151 (diff) | |
parent | da9b4288ed7a52b7d589d8605952cd7c648d73a3 (diff) | |
download | mariadb-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.result | 7 |
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); |