summaryrefslogtreecommitdiff
path: root/mysql-test/t/heap_btree.test
diff options
context:
space:
mode:
authorunknown <istruewing@chilla.local>2007-03-21 15:55:14 +0100
committerunknown <istruewing@chilla.local>2007-03-21 15:55:14 +0100
commit19630640976ebeb5dae65483d23742fdf64aba26 (patch)
treef372d969016aee0dc8a6b78e859d80baa9e48131 /mysql-test/t/heap_btree.test
parentc7ce63fb0ba339ffa15a36515831660225a49e53 (diff)
parentdb573e637c2ba66f214f7e1e2172ce9efeca0db0 (diff)
downloadmariadb-git-19630640976ebeb5dae65483d23742fdf64aba26.tar.gz
Merge chilla.local:/home/mydev/mysql-4.1-bug26996
into chilla.local:/home/mydev/mysql-5.0-bug26996 heap/hp_write.c: Auto merged mysql-test/r/heap_btree.result: Auto merged mysql-test/t/heap_btree.test: Bug#26996 - Update of a Field in a Memory Table ends with wrong result Manual merge from 4.1
Diffstat (limited to 'mysql-test/t/heap_btree.test')
-rw-r--r--mysql-test/t/heap_btree.test14
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/heap_btree.test b/mysql-test/t/heap_btree.test
index 03ba8661a3c..2dd5f64014a 100644
--- a/mysql-test/t/heap_btree.test
+++ b/mysql-test/t/heap_btree.test
@@ -182,6 +182,20 @@ delete from t1 where a >= 2;
select a from t1 order by a;
drop table t1;
+#
+# Bug#26996 - Update of a Field in a Memory Table ends with wrong result
+#
+CREATE TABLE t1 (
+ c1 CHAR(3),
+ c2 INTEGER,
+ KEY USING BTREE(c1),
+ KEY USING BTREE(c2)
+) ENGINE= MEMORY;
+INSERT INTO t1 VALUES ('ABC',0), ('A',0), ('B',0), ('C',0);
+UPDATE t1 SET c2= c2 + 1 WHERE c1 = 'A';
+SELECT * FROM t1;
+DROP TABLE t1;
+
--echo End of 4.1 tests
#