diff options
| author | svoj@june.mysql.com <> | 2007-09-13 17:12:46 +0500 |
|---|---|---|
| committer | svoj@june.mysql.com <> | 2007-09-13 17:12:46 +0500 |
| commit | ac29e21e0b0c4d32aba55ec10f0a61d0f261cb45 (patch) | |
| tree | 5ea61d125fed03323448e3b241b122355de97b0b /mysql-test | |
| parent | fe4f440a2e9fb572db1d53086e5ed96a2ce8738a (diff) | |
| parent | 6a04238e41ec0d107709711a25714086f601f69f (diff) | |
| download | mariadb-git-ac29e21e0b0c4d32aba55ec10f0a61d0f261cb45.tar.gz | |
Merge mysql.com:/home/svoj/devel/mysql/BUG30590/mysql-5.0-engines
into mysql.com:/home/svoj/devel/mysql/BUG30590/mysql-5.1-engines
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/heap_btree.result | 7 | ||||
| -rw-r--r-- | mysql-test/t/heap_btree.test | 9 |
2 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/heap_btree.result b/mysql-test/r/heap_btree.result index ab4b892170a..bdf19f130bd 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); diff --git a/mysql-test/t/heap_btree.test b/mysql-test/t/heap_btree.test index 0e8cc71dab5..cbab2b0472e 100644 --- a/mysql-test/t/heap_btree.test +++ b/mysql-test/t/heap_btree.test @@ -213,6 +213,15 @@ CREATE TABLE t1 ( INSERT INTO t1 VALUES('1'), ('2'); DROP TABLE t1; +# +# BUG#30590 - delete from memory table with composite btree primary key +# +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; +DROP TABLE t1; + --echo End of 4.1 tests # |