diff options
| author | unknown <istruewing@chilla.local> | 2007-03-21 17:38:42 +0100 |
|---|---|---|
| committer | unknown <istruewing@chilla.local> | 2007-03-21 17:38:42 +0100 |
| commit | 26a34b1a2e2128a728d799c20ad3ad1388790512 (patch) | |
| tree | 97183e2b2c15794f7066339607bb29aa553bdf99 /mysql-test/r/heap_btree.result | |
| parent | e3108256e7e5118cd2097f2bfbc9987018a6b8a5 (diff) | |
| parent | 19630640976ebeb5dae65483d23742fdf64aba26 (diff) | |
| download | mariadb-git-26a34b1a2e2128a728d799c20ad3ad1388790512.tar.gz | |
Merge chilla.local:/home/mydev/mysql-5.0-bug26996
into chilla.local:/home/mydev/mysql-5.1-bug26996
mysql-test/r/heap_btree.result:
Auto merged
mysql-test/t/heap_btree.test:
Auto merged
storage/heap/hp_write.c:
Auto merged
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 fd789a39d88..18d3dab1b06 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); |