From bdbc0ef7a068d77e404bc4e13b864cb41112521a Mon Sep 17 00:00:00 2001
From: "monty@donna.mysql.com" <>
Date: Wed, 31 Jan 2001 04:47:25 +0200
Subject: New myisamchk option --sort-recover Allow delete of crashed MyISAM
 tables Fixed bug when BLOB was first part of key Fixed bug when using result
 from CASE in GROUP BY Fixed core-dump bug in monthname() Optimized calling of
 check_db_name()

---
 mysql-test/r/case.result          | 8 ++++++++
 mysql-test/r/func_time.result     | 6 ++++++
 mysql-test/r/type_blob.result     | 4 ++++
 mysql-test/r/type_datetime.result | 2 ++
 4 files changed, 20 insertions(+)

(limited to 'mysql-test/r')

diff --git a/mysql-test/r/case.result b/mysql-test/r/case.result
index 66538c2fbee..073164aa035 100644
--- a/mysql-test/r/case.result
+++ b/mysql-test/r/case.result
@@ -32,3 +32,11 @@ case when 1>0 then "TRUE" else "FALSE" END
 TRUE
 case when 1<0 then "TRUE" else "FALSE" END
 FALSE
+fcase	count(*)
+0	2
+2	1
+3	1
+fcase	count(*)
+nothing	2
+one	1
+two	1
diff --git a/mysql-test/r/func_time.result b/mysql-test/r/func_time.result
index 79a03bdbd48..5c55475e628 100644
--- a/mysql-test/r/func_time.result
+++ b/mysql-test/r/func_time.result
@@ -186,3 +186,9 @@ extract(SECOND FROM "1999-01-02 10:11:12")
 12
 ctime	hour(ctime)
 2001-01-12 12:23:40	12
+monthname(date)
+NULL
+January
+monthname(date)
+NULL
+January
diff --git a/mysql-test/r/type_blob.result b/mysql-test/r/type_blob.result
index 0ead1c30200..bc80ba38452 100644
--- a/mysql-test/r/type_blob.result
+++ b/mysql-test/r/type_blob.result
@@ -257,3 +257,7 @@ hello
 hello word
 count(*)
 2
+foobar	boggle
+fish	10
+foobar	boggle
+fish	10
diff --git a/mysql-test/r/type_datetime.result b/mysql-test/r/type_datetime.result
index 3a816e2ff68..7028b5ffe33 100644
--- a/mysql-test/r/type_datetime.result
+++ b/mysql-test/r/type_datetime.result
@@ -13,6 +13,8 @@ t
 9999-12-31 23:59:59
 Table	Op	Msg_type	Msg_text
 test.t1	optimize	status	OK
+Table	Op	Msg_type	Msg_text
+test.t1	check	status	OK
 t
 2000-01-01 00:00:00
 2069-12-31 00:00:00
-- 
cgit v1.2.1