diff options
| author | unknown <monty@donna.mysql.com> | 2001-01-31 04:47:25 +0200 |
|---|---|---|
| committer | unknown <monty@donna.mysql.com> | 2001-01-31 04:47:25 +0200 |
| commit | 495231ea25a82d97e69e96ff9e5d7688434cfff2 (patch) | |
| tree | 851a8ba92ed9883efe2504e0726aae6843c317c0 /mysql-test/r/case.result | |
| parent | bf1f8fd3eb4b98dadd265f8ed10d92220dabe1bb (diff) | |
| download | mariadb-git-495231ea25a82d97e69e96ff9e5d7688434cfff2.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()
Docs/manual.texi:
Added more information about myisamchk
client/mysqladmin.c:
Added error message for CREATE database and fixed possible overflow bug
include/myisam.h:
New myisamchk option --sort-recover
libmysql/libmysql.c:
Removed commented code
Don't define getpwuid (breaks on SCO 3.2)
myisam/mi_check.c:
Fixed (new) bug when using --recover --optimize
myisam/mi_delete_table.c:
Allow delete of crashed tables
myisam/mi_key.c:
Fixed bug when BLOB was first part of key
myisam/myisamchk.c:
New myisamchk option --sort-recover
mysql-test/r/case.result:
New test cases to check for reported bugs
mysql-test/r/func_time.result:
New test cases to check for reported bugs
mysql-test/r/type_blob.result:
New test cases to check for reported bugs
mysql-test/r/type_datetime.result:
New test cases to check for reported bugs
mysql-test/t/case.test:
New test cases to check for reported bugs
mysql-test/t/func_time.test:
New test cases to check for reported bugs
mysql-test/t/type_blob.test:
New test cases to check for reported bugs
mysql-test/t/type_datetime.test:
New test cases to check for reported bugs
mysys/my_bitmap.c:
Optimize
sql-bench/limits/ms-sql.cfg:
Updated limits
sql/item_cmpfunc.cc:
Fixed bug when using result from CASE in GROUP BY
sql/item_cmpfunc.h:
Fixed bug when using result from CASE in GROUP BY
sql/item_timefunc.cc:
Fixed core-dump bug in monthname()
sql/sql_db.cc:
Optimized calling of check_db_name()
sql/sql_parse.cc:
Optimized calling of check_db_name()
sql/table.cc:
Fixed typo
Diffstat (limited to 'mysql-test/r/case.result')
| -rw-r--r-- | mysql-test/r/case.result | 8 |
1 files changed, 8 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 |