Debian Codegraph @

mysql-test/suite/sys_vars/r/default_week_format_func.result

raw
1 '#--------------------FN_DYNVARS_022_01-------------------------#'
2 ## Setting variable's value to 0 ##
3 SET @@session.default_week_format = 0;
4 SELECT @@session.default_week_format;
5 @@session.default_week_format
6 0
7 SELECT WEEK('2008-01-20');
8 WEEK('2008-01-20')
9 3
10 ## Setting variable's value to 1 ##
11 SET @@session.default_week_format = 1;
12 SELECT @@session.default_week_format;
13 @@session.default_week_format
14 1
15 SELECT WEEK('2008-01-20');
16 WEEK('2008-01-20')
17 3
18 ## Setting variable's value to 2 ##
19 SET @@session.default_week_format = 2;
20 SELECT @@session.default_week_format;
21 @@session.default_week_format
22 2
23 SELECT WEEK('2008-01-20');
24 WEEK('2008-01-20')
25 3
26 ## Setting variable's value to 3 ##
27 SET @@session.default_week_format = 3;
28 SELECT @@session.default_week_format;
29 @@session.default_week_format
30 3
31 SELECT WEEK('2008-01-20');
32 WEEK('2008-01-20')
33 3
34 ## Setting variable's value to 4 ##
35 SET @@session.default_week_format = 4;
36 SELECT @@session.default_week_format;
37 @@session.default_week_format
38 4
39 SELECT WEEK('2008-01-20');
40 WEEK('2008-01-20')
41 4
42 ## Setting variable's value to 5 ##
43 SET @@session.default_week_format = 5;
44 SELECT @@session.default_week_format;
45 @@session.default_week_format
46 5
47 SELECT WEEK('2008-01-20');
48 WEEK('2008-01-20')
49 2
50 ## Setting variable's value to 6 ##
51 SET @@session.default_week_format = 6;
52 SELECT @@session.default_week_format;
53 @@session.default_week_format
54 6
55 SELECT WEEK('2008-01-20');
56 WEEK('2008-01-20')
57 4
58 ## Setting variable's value to 7 ##
59 SET @@session.default_week_format = 7;
60 SELECT @@session.default_week_format;
61 @@session.default_week_format
62 7
63 SELECT WEEK('2008-01-20');
64 WEEK('2008-01-20')
65 2