Fix bug when repairing compressed MyISAM files

LOCATE() is now case sensitive


BUILD/compile-alpha-cxx:
  Don't build manager because it fails with linker error on Linux Alpha
Docs/manual.texi:
  Changelog
myisam/mi_check.c:
  Fix bug when repairing compressed MyISAM files
myisam/mi_open.c:
  Fix bug when repairing compressed MyISAM files
myisam/mi_packrec.c:
  Fix bug when repairing compressed MyISAM files
myisam/myisamchk.c:
  Fix bug when repairing compressed MyISAM files
myisam/myisamdef.h:
  Fix bug when repairing compressed MyISAM files
mysql-test/r/func_group.result:
  Fix result for new RND function
mysql-test/r/func_math.result:
  Fix result for new RND function
mysql-test/r/func_str.result:
  test of new locate()
mysql-test/t/func_str.test:
  test of new locate()
sql/item_func.cc:
  LOCATE() is now case sensitive
sql/sql_string.cc:
  LOCATE() is now case sensitive
sql/sql_string.h:
  LOCATE() is now case sensitive

3 files changed, 10 insertions, 10 deletions

diff --git a/mysql-test/r/func_group.result b/mysql-test/r/func_group.result
index bdb33be5d4c..2d24b8ffd4e 100644
--- a/mysql-test/r/func_group.result
+++ b/mysql-test/r/func_group.result
@@ -20,19 +20,19 @@ sum(a)
 NULL
 select a from t1 order by rand(10);
 a
+2
+6
 1
 3
-6
 5
-2
 4
 select distinct a from t1 order by rand(10);
 a
+2
+6
 1
 3
-6
 5
-2
 4
 select count(distinct a),count(distinct grp) from t1;
 count(distinct a)	count(distinct grp)
diff --git a/mysql-test/r/func_math.result b/mysql-test/r/func_math.result
index 771c640805b..fce98a58682 100644
--- a/mysql-test/r/func_math.result
+++ b/mysql-test/r/func_math.result
@@ -24,7 +24,7 @@ pow(10,log10(10))	power(2,4)
 10.000000	16.000000
 select rand(999999),rand();
 rand(999999)	rand()
-0.18435012473199	0.76373626176616
+0.014231365187309	0.8078568166195
 select pi(),sin(pi()/2),cos(pi()/2),abs(tan(pi())),cot(1),asin(1),acos(0),atan(1);
 PI()	sin(pi()/2)	cos(pi()/2)	abs(tan(pi()))	cot(1)	asin(1)	acos(0)	atan(1)
 3.141593	1.000000	0.000000	0.000000	0.64209262	1.570796	1.570796	0.785398
diff --git a/mysql-test/r/func_str.result b/mysql-test/r/func_str.result
index efbcd91964b..28a4870cfc6 100644
--- a/mysql-test/r/func_str.result
+++ b/mysql-test/r/func_str.result
@@ -14,11 +14,11 @@ monty was here again	5	h
 select locate('he','hello'),locate('he','hello',2),locate('lo','hello',2) ;
 locate('he','hello')	locate('he','hello',2)	locate('lo','hello',2)
 1	0	4
-select instr('hello','he');
-instr('hello','he')
-1
-select position('ll' in 'hello'),position('a' in 'hello');
-position('ll' in 'hello')	position('a' in 'hello')
+select instr('hello','HE'), instr('hello',binary 'HE'), instr(binary 'hello','HE');
+instr('hello','HE')	instr('hello',binary 'HE')	instr(binary 'hello','HE')
+1	0	0
+select position(binary 'll' in 'hello'),position('a' in binary 'hello');
+position(binary 'll' in 'hello')	position('a' in binary 'hello')
 3	0
 select left('hello',2),right('hello',2),substring('hello',2,2),mid('hello',1,5) ;
 left('hello',2)	right('hello',2)	substring('hello',2,2)	mid('hello',1,5)