diff options
| author | unknown <serg@serg.mylan> | 2004-01-15 16:31:27 +0100 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2004-01-15 16:31:27 +0100 |
| commit | ae4b94598c08747fcb75480ebe7ab2681f38bde6 (patch) | |
| tree | cbfd9c9f41af1345b736db36fc74e2e18e474d26 /mysql-test/t/range.test | |
| parent | 3640f7e11b629c4e0e0b47dd270b120d4dcd2377 (diff) | |
| download | mariadb-git-ae4b94598c08747fcb75480ebe7ab2681f38bde6.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; + |