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