1############## mysql-test\t\default_week_format_func.test ##################### 2# # 3# Variable Name: default_week_format # 4# Scope: GLOBAL & SESSION # 5# Access Type: Dynamic # 6# Data Type: Numeric # 7# Default Value: 0 # 8# Range: 0 - 7 # 9# # 10# # 11# Creation Date: 2008-03-07 # 12# Author: Salman Rawala # 13# # 14# Description: Test Cases of Dynamic System Variable "default_week_format" # 15# that checks functionality of this variable # 16# # 17# Reference: http://dev.mysql.com/doc/refman/5.1/en/ # 18# server-system-variables.html#option_mysqld_default_week_format # 19# # 20################################################################################ 21 22--echo '#--------------------FN_DYNVARS_022_01-------------------------#' 23#################################################################### 24# Verifying different values of default_week_format 25#################################################################### 26 27--echo ## Setting variable's value to 0 ## 28SET @@session.default_week_format = 0; 29SELECT @@session.default_week_format; 30SELECT WEEK('2008-01-20'); 31 32--echo ## Setting variable's value to 1 ## 33SET @@session.default_week_format = 1; 34SELECT @@session.default_week_format; 35SELECT WEEK('2008-01-20'); 36 37--echo ## Setting variable's value to 2 ## 38SET @@session.default_week_format = 2; 39SELECT @@session.default_week_format; 40SELECT WEEK('2008-01-20'); 41 42--echo ## Setting variable's value to 3 ## 43SET @@session.default_week_format = 3; 44SELECT @@session.default_week_format; 45SELECT WEEK('2008-01-20'); 46 47--echo ## Setting variable's value to 4 ## 48SET @@session.default_week_format = 4; 49SELECT @@session.default_week_format; 50SELECT WEEK('2008-01-20'); 51 52--echo ## Setting variable's value to 5 ## 53SET @@session.default_week_format = 5; 54SELECT @@session.default_week_format; 55SELECT WEEK('2008-01-20'); 56 57--echo ## Setting variable's value to 6 ## 58SET @@session.default_week_format = 6; 59SELECT @@session.default_week_format; 60SELECT WEEK('2008-01-20'); 61 62--echo ## Setting variable's value to 7 ## 63SET @@session.default_week_format = 7; 64SELECT @@session.default_week_format; 65SELECT WEEK('2008-01-20'); 66 67