diff options
| author | unknown <monty@donna.mysql.fi> | 2001-05-23 02:40:24 +0300 |
|---|---|---|
| committer | unknown <monty@donna.mysql.fi> | 2001-05-23 02:40:24 +0300 |
| commit | 41dd2aa2b5a2f8b7a5d760bff26e8ceb2ce10fff (patch) | |
| tree | 089c3177d314fd343965d105d3f57b5fe995b5a4 /mysql-test/r/func_time.result | |
| parent | 82a404d9fb1e3d181033473183be2e48d9ee406a (diff) | |
| download | mariadb-git-41dd2aa2b5a2f8b7a5d760bff26e8ceb2ce10fff.tar.gz | |
Remove wrong access check for locks.
Fixed problem with fuzzy dates.
mysql-test/r/func_time.result:
Added test of fuzzy dates
mysql-test/t/func_time.test:
Added test of fuzzy dates
sql/item.cc:
Fixed bug with fuzzy dates
sql/sql_parse.cc:
Remove wrong access check for locks.
(This has to be delayed for 4.0 because there is currently now way
to check for "any of the following privileges"
Docs/manual.texi:
Changelog
Diffstat (limited to 'mysql-test/r/func_time.result')
| -rw-r--r-- | mysql-test/r/func_time.result | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/r/func_time.result b/mysql-test/r/func_time.result index a24dc044a9a..fd7c6897574 100644 --- a/mysql-test/r/func_time.result +++ b/mysql-test/r/func_time.result @@ -20,6 +20,8 @@ dayofmonth("1997-01-02") dayofmonth(19970323) 2 23 month("1997-01-02") year("98-02-03") dayofyear("1997-12-31") 1 1998 365 +month("2001-02-00") year("2001-00-00") +2 2001 DAYOFYEAR("1997-03-03") WEEK("1998-03-03") QUARTER(980303) 62 9 1 HOUR("1997-03-03 23:03:22") MINUTE("23:03:22") SECOND(230322) @@ -184,6 +186,8 @@ extract(MINUTE_SECOND FROM "10:11:12") 1112 extract(SECOND FROM "1999-01-02 10:11:12") 12 +extract(MONTH FROM "2001-02-00") +2 ctime hour(ctime) 2001-01-12 12:23:40 12 monthname(date) |