Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.default_week_format;
2 SELECT @start_global_value;
3 @start_global_value
4 0
5 SET @start_session_value = @@session.default_week_format;
6 SELECT @start_session_value;
7 @start_session_value
8 0
9 '#--------------------FN_DYNVARS_022_01-------------------------#'
10 SET @@global.default_week_format = 100;
11 Warnings:
12 Warning 1292 Truncated incorrect default_week_format value: '100'
13 SET @@global.default_week_format = DEFAULT;
14 SELECT @@global.default_week_format;
15 @@global.default_week_format
16 0
17 SET @@session.default_week_format = 200;
18 Warnings:
19 Warning 1292 Truncated incorrect default_week_format value: '200'
20 SET @@session.default_week_format = DEFAULT;
21 SELECT @@session.default_week_format;
22 @@session.default_week_format
23 0
24 '#--------------------FN_DYNVARS_022_02-------------------------#'
25 SET @@global.default_week_format = @start_global_value;
26 SELECT @@global.default_week_format = 0;
27 @@global.default_week_format = 0
28 1
29 SET @@session.default_week_format = @start_global_value;
30 SELECT @@session.default_week_format = 0;
31 @@session.default_week_format = 0
32 1
33 '#--------------------FN_DYNVARS_022_03-------------------------#'
34 SET @@global.default_week_format = 1;
35 SELECT @@global.default_week_format;
36 @@global.default_week_format
37 1
38 SET @@global.default_week_format = 0;
39 SELECT @@global.default_week_format;
40 @@global.default_week_format
41 0
42 SET @@global.default_week_format = 7;
43 SELECT @@global.default_week_format;
44 @@global.default_week_format
45 7
46 '#--------------------FN_DYNVARS_022_04-------------------------#'
47 SET @@session.default_week_format = 1;
48 SELECT @@session.default_week_format;
49 @@session.default_week_format
50 1
51 SET @@session.default_week_format = 0;
52 SELECT @@session.default_week_format;
53 @@session.default_week_format
54 0
55 SET @@session.default_week_format = 7;
56 SELECT @@session.default_week_format;
57 @@session.default_week_format
58 7
59 '#------------------FN_DYNVARS_022_05-----------------------#'
60 SET @@global.default_week_format = 8;
61 Warnings:
62 Warning 1292 Truncated incorrect default_week_format value: '8'
63 SELECT @@global.default_week_format;
64 @@global.default_week_format
65 7
66 SET @@global.default_week_format = -1024;
67 Warnings:
68 Warning 1292 Truncated incorrect default_week_format value: '-1024'
69 SELECT @@global.default_week_format;
70 @@global.default_week_format
71 0
72 SET @@global.default_week_format = 65536;
73 Warnings:
74 Warning 1292 Truncated incorrect default_week_format value: '65536'
75 SELECT @@global.default_week_format;
76 @@global.default_week_format
77 7
78 SET @@global.default_week_format = 65530.30;
79 ERROR 42000: Incorrect argument type to variable 'default_week_format'
80 SELECT @@global.default_week_format;
81 @@global.default_week_format
82 7
83 SET @@global.default_week_format = OFF;
84 ERROR 42000: Incorrect argument type to variable 'default_week_format'
85 SELECT @@global.default_week_format;
86 @@global.default_week_format
87 7
88 SET @@session.default_week_format = ON;
89 ERROR 42000: Incorrect argument type to variable 'default_week_format'
90 SELECT @@session.default_week_format;
91 @@session.default_week_format
92 7
93 SET @@session.default_week_format = 65530.30;
94 ERROR 42000: Incorrect argument type to variable 'default_week_format'
95 SELECT @@session.default_week_format;
96 @@session.default_week_format
97 7
98 SET @@session.default_week_format = 10;
99 Warnings:
100 Warning 1292 Truncated incorrect default_week_format value: '10'
101 SELECT @@session.default_week_format;
102 @@session.default_week_format
103 7
104 SET @@session.default_week_format = -2;
105 Warnings:
106 Warning 1292 Truncated incorrect default_week_format value: '-2'
107 SELECT @@session.default_week_format;
108 @@session.default_week_format
109 0
110 SET @@session.default_week_format = 65550;
111 Warnings:
112 Warning 1292 Truncated incorrect default_week_format value: '65550'
113 SELECT @@session.default_week_format;
114 @@session.default_week_format
115 7
116 '#------------------FN_DYNVARS_022_06-----------------------#'
117 SELECT @@global.default_week_format = VARIABLE_VALUE
118 FROM performance_schema.global_variables
119 WHERE VARIABLE_NAME='default_week_format';
120 @@global.default_week_format = VARIABLE_VALUE
121 1
122 SELECT @@session.default_week_format = VARIABLE_VALUE
123 FROM performance_schema.session_variables
124 WHERE VARIABLE_NAME='default_week_format';
125 @@session.default_week_format = VARIABLE_VALUE
126 1
127 '#------------------FN_DYNVARS_022_07-----------------------#'
128 SET @@global.default_week_format = TRUE;
129 SELECT @@global.default_week_format;
130 @@global.default_week_format
131 1
132 SET @@global.default_week_format = FALSE;
133 SELECT @@global.default_week_format;
134 @@global.default_week_format
135 0
136 '#---------------------FN_DYNVARS_001_08----------------------#'
137 SET @@global.default_week_format = 0;
138 SELECT @@default_week_format = @@global.default_week_format;
139 @@default_week_format = @@global.default_week_format
140 0
141 '#---------------------FN_DYNVARS_001_09----------------------#'
142 SET @@default_week_format = 1;
143 SELECT @@default_week_format = @@local.default_week_format;
144 @@default_week_format = @@local.default_week_format
145 1
146 SELECT @@local.default_week_format = @@session.default_week_format;
147 @@local.default_week_format = @@session.default_week_format
148 1
149 '#---------------------FN_DYNVARS_001_10----------------------#'
150 SET default_week_format = 1;
151 SELECT @@default_week_format;
152 @@default_week_format
153 1
154 SET local.default_week_format = 1;
155 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'local.default_week_format = 1' at line 1
156 SELECT local.default_week_format;
157 ERROR 42S02: Unknown table 'local' in field list
158 SET session.default_week_format = 1;
159 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'session.default_week_format = 1' at line 1
160 SELECT session.default_week_format;
161 ERROR 42S02: Unknown table 'session' in field list
162 SELECT default_week_format = @@session.default_week_format;
163 ERROR 42S22: Unknown column 'default_week_format' in 'field list'
164 SET @@global.default_week_format = @start_global_value;
165 SELECT @@global.default_week_format;
166 @@global.default_week_format
167 0
168 SET @@session.default_week_format = @start_session_value;
169 SELECT @@session.default_week_format;
170 @@session.default_week_format
171 0