From a2d4a042d098fb01183c9b47e9ac6194997007ba Mon Sep 17 00:00:00 2001
From: "igor@olga.mysql.com" <>
Date: Wed, 14 Feb 2007 22:06:41 -0800
Subject: Fixed bug #25971: indexes on text columns were ignored when ref
 accesses were evaluated. According to the new rules for string comparison
 partial indexes on text columns can be used in the same cases when partial
 indexes on varchar columns can be used.

---
 mysql-test/r/myisam.result | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'mysql-test/r/myisam.result')

diff --git a/mysql-test/r/myisam.result b/mysql-test/r/myisam.result
index 0f6e0ad537a..83359048a8c 100644
--- a/mysql-test/r/myisam.result
+++ b/mysql-test/r/myisam.result
@@ -1071,7 +1071,7 @@ id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	ref	c	c	11	const	#	Using where; Using index
 explain select count(*) from t1 where t='a  ';
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	t1	range	t	t	13	NULL	#	Using where
+1	SIMPLE	t1	ref	t	t	13	const	#	Using where
 explain select count(*) from t1 where v like 'a%';
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	SIMPLE	t1	range	v	v	13	NULL	#	Using where; Using index
-- 
cgit v1.2.1