Debian Codegraph @

mysql-test/suite/sys_vars/t/default_week_format_func.test

raw
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 ##
28 SET @@session.default_week_format = 0;
29 SELECT @@session.default_week_format;
30 SELECT WEEK('2008-01-20');
31
32 --echo ## Setting variable's value to 1 ##
33 SET @@session.default_week_format = 1;
34 SELECT @@session.default_week_format;
35 SELECT WEEK('2008-01-20');
36
37 --echo ## Setting variable's value to 2 ##
38 SET @@session.default_week_format = 2;
39 SELECT @@session.default_week_format;
40 SELECT WEEK('2008-01-20');
41
42 --echo ## Setting variable's value to 3 ##
43 SET @@session.default_week_format = 3;
44 SELECT @@session.default_week_format;
45 SELECT WEEK('2008-01-20');
46
47 --echo ## Setting variable's value to 4 ##
48 SET @@session.default_week_format = 4;
49 SELECT @@session.default_week_format;
50 SELECT WEEK('2008-01-20');
51
52 --echo ## Setting variable's value to 5 ##
53 SET @@session.default_week_format = 5;
54 SELECT @@session.default_week_format;
55 SELECT WEEK('2008-01-20');
56
57 --echo ## Setting variable's value to 6 ##
58 SET @@session.default_week_format = 6;
59 SELECT @@session.default_week_format;
60 SELECT WEEK('2008-01-20');
61
62 --echo ## Setting variable's value to 7 ##
63 SET @@session.default_week_format = 7;
64 SELECT @@session.default_week_format;
65 SELECT WEEK('2008-01-20');
66