diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2014-12-02 09:04:09 +0100 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2014-12-02 09:29:53 +0100 |
| commit | 53ff66fe31ee4e0fa646f646cee10095390471af (patch) | |
| tree | 6db707a02ac0fc3fcfc06d9d933c4c35923285c2 /mysql-test/t/set_statement.test | |
| parent | d6e881643508b77ae482014a061927f91f4a8eec (diff) | |
| download | mariadb-git-53ff66fe31ee4e0fa646f646cee10095390471af.tar.gz | |
MDEV-6996: SET STATEMENT default_week_format = .. has no effect
Change constant with a system variable.
Diffstat (limited to 'mysql-test/t/set_statement.test')
| -rw-r--r-- | mysql-test/t/set_statement.test | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/t/set_statement.test b/mysql-test/t/set_statement.test index 8b8431315f4..2c7e74093db 100644 --- a/mysql-test/t/set_statement.test +++ b/mysql-test/t/set_statement.test @@ -1033,3 +1033,20 @@ set statement wait_timeout=default for select 1; --error ER_SET_STATEMENT_NOT_SUPPORTED set statement interactive_timeout=default for select 1; +# MDEV-6996: SET STATEMENT default_week_format = .. has no effect +set @save_week_format=@@default_week_format; +set @@default_week_format=0; +SET STATEMENT default_week_format = 2 FOR SELECT WEEK('2000-01-01'); +create table t1 (a date); +insert t1 values ('2000-01-01'); +explain extended select week(a) from t1; +prepare stmt1 from "select week(a) from t1"; +execute stmt1; +set default_week_format = 2; +execute stmt1; +alter table t1 engine=myisam; +execute stmt1; +deallocate prepare stmt1; +drop table t1; +set @@default_week_format=@save_week_format; + |