diff options
| author | unknown <gluh@gluh.mysql.r18.ru> | 2003-06-19 14:02:19 +0500 |
|---|---|---|
| committer | unknown <gluh@gluh.mysql.r18.ru> | 2003-06-19 14:02:19 +0500 |
| commit | 85d2282e257ba47555fc05ef62dc70ece5b7a69e (patch) | |
| tree | e791f002cd3e313d2564441aa8afebf1b8b6ce0d /mysql-test/t/func_time.test | |
| parent | 725a4c39d2815315a1b2aa40bc2ce6bb54d3b828 (diff) | |
| download | mariadb-git-85d2282e257ba47555fc05ef62dc70ece5b7a69e.tar.gz | |
SCRUM
Task ID 894:
Backport default_week_format variable to 4.0
mysql-test/r/func_time.result:
Backport default_week_format variable to 4.0
mysql-test/t/func_time.test:
Backport default_week_format variable to 4.0
sql/mysqld.cc:
Backport default_week_format variable to 4.0
sql/set_var.cc:
Backport default_week_format variable to 4.0
sql/sql_class.h:
Backport default_week_format variable to 4.0
sql/sql_yacc.yy:
Backport default_week_format variable to 4.0
Diffstat (limited to 'mysql-test/t/func_time.test')
| -rw-r--r-- | mysql-test/t/func_time.test | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/t/func_time.test b/mysql-test/t/func_time.test index 3057729ab96..a51869e7d76 100644 --- a/mysql-test/t/func_time.test +++ b/mysql-test/t/func_time.test @@ -39,6 +39,10 @@ select yearweek("2000-01-06",1) as '2000', yearweek("2001-01-06",1) as '2001', y select week(19981231,2), week(19981231,3), week(20000101,2), week(20000101,3); select week(20001231,2),week(20001231,3); +set default_week_format = 2; +select week(20001231),week(20001231,2),week(20001231,0); +set default_week_format = 0; + select date_format('1998-12-31','%x-%v'),date_format('1999-01-01','%x-%v'); select date_format('1999-12-31','%x-%v'),date_format('2000-01-01','%x-%v'); |