diff options
| author | unknown <istruewing@chilla.local> | 2007-03-22 21:34:31 +0100 |
|---|---|---|
| committer | unknown <istruewing@chilla.local> | 2007-03-22 21:34:31 +0100 |
| commit | 786e6f7af9ddaea420fda83f9162988d64a581ff (patch) | |
| tree | 607d24af40f46b8dc2c679e2d40047347e8fc4cb /mysql-test/r/heap_btree.result | |
| parent | a1adb01e37e0b36fcb5d1cefe77dae724b5da948 (diff) | |
| parent | 38dde8527049a9b1c64872bdcc2f9c8ec9b7ff6f (diff) | |
| download | mariadb-git-786e6f7af9ddaea420fda83f9162988d64a581ff.tar.gz | |
Merge bk-internal.mysql.com:/home/bk/mysql-5.0-engines
into chilla.local:/home/mydev/mysql-5.0-bug26996
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 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); |