From 8caf856afea5aa945d54641e1e75b5a4913e1c0f Mon Sep 17 00:00:00 2001
From: "serg@serg.mylan" <>
Date: Thu, 15 Jan 2004 16:31:27 +0100
Subject: an obvious bug in _mi_key_cmp fixed (BUG#2295 - range on blobs)

---
 mysql-test/t/range.test | 12 ++++++++++++
 1 file changed, 12 insertions(+)

(limited to 'mysql-test/t/range.test')

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;
+
-- 
cgit v1.2.1