diff options
| author | unknown <ingo@mysql.com> | 2004-06-25 12:59:47 +0200 |
|---|---|---|
| committer | unknown <ingo@mysql.com> | 2004-06-25 12:59:47 +0200 |
| commit | fb987c8907c55d974b189ccd5e9c891f8dee7a14 (patch) | |
| tree | 1d74a4c02a5562fbb2989c5a7d17269c1f40161d /mysql-test/r/bdb.result | |
| parent | 098a1e3afa7a911c39dca37bad084f6c171f7c44 (diff) | |
| parent | afe29967e03d5c936c378fff9ea4e4bcf7e9251e (diff) | |
| download | mariadb-git-fb987c8907c55d974b189ccd5e9c891f8dee7a14.tar.gz | |
Merge
sql/ha_berkeley.cc:
Auto merged
mysql-test/r/bdb.result:
SCCS merged
mysql-test/t/bdb.test:
SCCS merged
Diffstat (limited to 'mysql-test/r/bdb.result')
| -rw-r--r-- | mysql-test/r/bdb.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/bdb.result b/mysql-test/r/bdb.result index 7d4b42e6a8c..684efc3ef1b 100644 --- a/mysql-test/r/bdb.result +++ b/mysql-test/r/bdb.result @@ -1190,6 +1190,22 @@ a A a drop table t1; +create table t1( +pk1 text not null, pk2 text not null, pk3 char(4), +key1 int, key2 int, +primary key(pk1(4), pk2(4), pk3), key(key1), key(key2) +) engine=bdb; +insert into t1 values (concat('aaa-', repeat('A', 4000)), +concat('eee-', repeat('e', 4000)), 'a++a', 1, 1); +insert into t1 values (concat('bbb-', repeat('B', 4000)), +concat('ggg-', repeat('G', 4000)), 'b++b', 1, 1); +select substring(pk1, 1, 4), substring(pk1, 4001), +substring(pk2, 1, 4), substring(pk2, 4001), pk3, key1, key2 +from t1 force index(key1, key2) where key1 < 3 or key2 < 3; +substring(pk1, 1, 4) substring(pk1, 4001) substring(pk2, 1, 4) substring(pk2, 4001) pk3 key1 key2 +aaa- AAAA eee- eeee a++a 1 1 +bbb- BBBB ggg- GGGG b++b 1 1 +drop table t1; create table t1 ( pk1 varchar(8) not null default '', pk2 varchar(4) not null default '', |