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/r/range.result | |
| 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/r/range.result')
| -rw-r--r-- | mysql-test/r/range.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/range.result b/mysql-test/r/range.result index e87df9a6c24..45d20a8fced 100644 --- a/mysql-test/r/range.result +++ b/mysql-test/r/range.result @@ -300,3 +300,11 @@ SELECT COUNT(*) FROM t1 WHERE (c=0 and b=1) or (c=0 and a=1); COUNT(*) 6 DROP TABLE t1; +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'; +a b c +807780 477 165 +drop table t1; |