diff options
| author | serg@serg.mylan <> | 2004-01-15 16:31:27 +0100 |
|---|---|---|
| committer | serg@serg.mylan <> | 2004-01-15 16:31:27 +0100 |
| commit | 8caf856afea5aa945d54641e1e75b5a4913e1c0f (patch) | |
| tree | cbfd9c9f41af1345b736db36fc74e2e18e474d26 /mysql-test/t/range.test | |
| parent | 709a12ecb14362462266bc49521520a6935eb2c2 (diff) | |
| download | mariadb-git-8caf856afea5aa945d54641e1e75b5a4913e1c0f.tar.gz | |
an obvious bug in _mi_key_cmp fixed (BUG#2295 - range on blobs)
Diffstat (limited to 'mysql-test/t/range.test')
| -rw-r--r-- | mysql-test/t/range.test | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/range.test b/mysql-test/t/range.test index 364ea2d4195..9d9feaa4edc 100644 --- a/mysql-test/t/range.test +++ b/mysql-test/t/range.test @@ -248,3 +248,15 @@ INSERT INTO t1 VALUES (0,1,0),(0,1,0),(0,1,0); SELECT COUNT(*) FROM t1 WHERE (c=0 and a=1) or (c=0 and b=1); SELECT COUNT(*) FROM t1 WHERE (c=0 and b=1) or (c=0 and a=1); DROP TABLE t1; + +# +# BUG#2295 - range on blob +# + +create table t1(a text not null, b text not null, c text not null, index (a(10),b(10),c(10))); +insert into t1 values('807780', '477', '165'); +insert into t1 values('807780', '477', '162'); +insert into t1 values('807780', '472', '162'); +select * from t1 where a='807780' and b='477' and c='165'; +drop table t1; + |