diff options
| author | monty@donna.mysql.com <> | 2001-01-31 04:47:25 +0200 |
|---|---|---|
| committer | monty@donna.mysql.com <> | 2001-01-31 04:47:25 +0200 |
| commit | bdbc0ef7a068d77e404bc4e13b864cb41112521a (patch) | |
| tree | 851a8ba92ed9883efe2504e0726aae6843c317c0 /mysql-test/r | |
| parent | acd45847ac0485617bece05abccbc9f4e9b2b782 (diff) | |
| download | mariadb-git-bdbc0ef7a068d77e404bc4e13b864cb41112521a.tar.gz | |
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()
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/case.result | 8 | ||||
| -rw-r--r-- | mysql-test/r/func_time.result | 6 | ||||
| -rw-r--r-- | mysql-test/r/type_blob.result | 4 | ||||
| -rw-r--r-- | mysql-test/r/type_datetime.result | 2 |
4 files changed, 20 insertions, 0 deletions
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 |