diff options
| author | istruewing@chilla.local <> | 2007-03-21 15:55:14 +0100 |
|---|---|---|
| committer | istruewing@chilla.local <> | 2007-03-21 15:55:14 +0100 |
| commit | 4fdafc545de8121312a60ff0cad93673ef5dee39 (patch) | |
| tree | f372d969016aee0dc8a6b78e859d80baa9e48131 /mysql-test/r/heap_btree.result | |
| parent | 81c086a6e55ffc4d6d3a8c42d77eb40943783a38 (diff) | |
| parent | 344f33bb89d60f83e7ec7fdc2275f88dc9468523 (diff) | |
| download | mariadb-git-4fdafc545de8121312a60ff0cad93673ef5dee39.tar.gz | |
Merge chilla.local:/home/mydev/mysql-4.1-bug26996
into chilla.local:/home/mydev/mysql-5.0-bug26996
Diffstat (limited to 'mysql-test/r/heap_btree.result')
| -rw-r--r-- | mysql-test/r/heap_btree.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/heap_btree.result b/mysql-test/r/heap_btree.result index 5b9c7f2244f..7a0e46a2a1c 100644 --- a/mysql-test/r/heap_btree.result +++ b/mysql-test/r/heap_btree.result @@ -280,6 +280,21 @@ a 1 1 drop table t1; +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; +c1 c2 +ABC 0 +A 1 +B 0 +C 0 +DROP TABLE t1; End of 4.1 tests CREATE TABLE t1(val INT, KEY USING BTREE(val)) ENGINE=memory; INSERT INTO t1 VALUES(0); |