diff options
| author | istruewing@chilla.local <> | 2007-03-21 17:38:42 +0100 |
|---|---|---|
| committer | istruewing@chilla.local <> | 2007-03-21 17:38:42 +0100 |
| commit | c0f03fed94dd40cc2ec5bc493d4b71fba903cb5f (patch) | |
| tree | 97183e2b2c15794f7066339607bb29aa553bdf99 /mysql-test/t/heap_btree.test | |
| parent | dba23b56e59ea35b7a50e6e6574266fd15cd8f18 (diff) | |
| parent | 4fdafc545de8121312a60ff0cad93673ef5dee39 (diff) | |
| download | mariadb-git-c0f03fed94dd40cc2ec5bc493d4b71fba903cb5f.tar.gz | |
Merge chilla.local:/home/mydev/mysql-5.0-bug26996
into chilla.local:/home/mydev/mysql-5.1-bug26996
Diffstat (limited to 'mysql-test/t/heap_btree.test')
| -rw-r--r-- | mysql-test/t/heap_btree.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/heap_btree.test b/mysql-test/t/heap_btree.test index 68aa79834fc..8e745d7646d 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 # |