Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.max_statement_time;
2 SELECT @start_global_value;
3 @start_global_value
4 0
5 SET @start_session_value = @@session.max_statement_time;
6 SELECT @start_session_value;
7 @start_session_value
8 0
9 '#--------------------FN_DYNVARS_068_01-------------------------#'
10 SET @@global.max_statement_time = 100;
11 SET @@global.max_statement_time = DEFAULT;
12 SELECT @@global.max_statement_time;
13 @@global.max_statement_time
14 0.000000
15 SET @@session.max_statement_time = 200;
16 SET @@session.max_statement_time = DEFAULT;
17 SELECT @@session.max_statement_time;
18 @@session.max_statement_time
19 0.000000
20 '#--------------------FN_DYNVARS_068_02-------------------------#'
21 SET @@global.max_statement_time = DEFAULT;
22 SELECT @@global.max_statement_time = 0;
23 @@global.max_statement_time = 0
24 1
25 SET @@session.max_statement_time = DEFAULT;
26 SELECT @@session.max_statement_time = 0;
27 @@session.max_statement_time = 0
28 1
29 '#--------------------FN_DYNVARS_068_03-------------------------#'
30 SET @@global.max_statement_time = 0;
31 SELECT @@global.max_statement_time;
32 @@global.max_statement_time
33 0.000000
34 SET @@global.max_statement_time = 0.123456;
35 SELECT @@global.max_statement_time;
36 @@global.max_statement_time
37 0.123456
38 SET @@global.max_statement_time = 60020;
39 SELECT @@global.max_statement_time;
40 @@global.max_statement_time
41 60020.000000
42 SET @@global.max_statement_time = 31536000;
43 SELECT @@global.max_statement_time;
44 @@global.max_statement_time
45 31536000.000000
46 SET @@global.max_statement_time = 65536;
47 SELECT @@global.max_statement_time;
48 @@global.max_statement_time
49 65536.000000
50 '#--------------------FN_DYNVARS_068_04-------------------------#'
51 SET @@session.max_statement_time = 0;
52 SELECT @@session.max_statement_time;
53 @@session.max_statement_time
54 0.000000
55 SET @@session.max_statement_time = 1;
56 SELECT @@session.max_statement_time;
57 @@session.max_statement_time
58 1.000000
59 SET @@session.max_statement_time = 50050;
60 SELECT @@session.max_statement_time;
61 @@session.max_statement_time
62 50050.000000
63 SET @@session.max_statement_time = 31536000;
64 SELECT @@session.max_statement_time;
65 @@session.max_statement_time
66 31536000.000000
67 SET @@session.max_statement_time = 65550;
68 SELECT @@session.max_statement_time;
69 @@session.max_statement_time
70 65550.000000
71 '#------------------FN_DYNVARS_068_05-----------------------#'
72 SET @@global.max_statement_time = 100000000000;
73 Warnings:
74 Warning 1292 Truncated incorrect max_statement_time value: '100000000000'
75 SELECT @@global.max_statement_time;
76 @@global.max_statement_time
77 31536000.000000
78 SET @@global.max_statement_time = -1;
79 Warnings:
80 Warning 1292 Truncated incorrect max_statement_time value: '-1'
81 SELECT @@global.max_statement_time;
82 @@global.max_statement_time
83 0.000000
84 SET @@global.max_statement_time = 65530.34;
85 SELECT @@global.max_statement_time;
86 @@global.max_statement_time
87 65530.340000
88 SET @@global.max_statement_time = test;
89 ERROR 42000: Incorrect argument type to variable 'max_statement_time'
90 SELECT @@global.max_statement_time;
91 @@global.max_statement_time
92 65530.340000
93 SET @@session.max_statement_time = 100000000000;
94 Warnings:
95 Warning 1292 Truncated incorrect max_statement_time value: '100000000000'
96 SELECT @@session.max_statement_time;
97 @@session.max_statement_time
98 31536000.000000
99 SET @@session.max_statement_time = -2;
100 Warnings:
101 Warning 1292 Truncated incorrect max_statement_time value: '-2'
102 SELECT @@session.max_statement_time;
103 @@session.max_statement_time
104 0.000000
105 SET @@session.max_statement_time = 65530.34;
106 SELECT @@session.max_statement_time;
107 @@session.max_statement_time
108 65530.340000
109 SET @@session.max_statement_time = test;
110 ERROR 42000: Incorrect argument type to variable 'max_statement_time'
111 SELECT @@session.max_statement_time;
112 @@session.max_statement_time
113 65530.340000
114 '#------------------FN_DYNVARS_068_06-----------------------#'
115 SELECT @@global.max_statement_time = VARIABLE_VALUE
116 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
117 WHERE VARIABLE_NAME='max_statement_time';
118 @@global.max_statement_time = VARIABLE_VALUE
119 1
120 '#------------------FN_DYNVARS_068_07-----------------------#'
121 SELECT @@session.max_statement_time = VARIABLE_VALUE
122 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
123 WHERE VARIABLE_NAME='max_statement_time';
124 @@session.max_statement_time = VARIABLE_VALUE
125 1
126 '#------------------FN_DYNVARS_068_08-----------------------#'
127 SET @@global.max_statement_time = TRUE;
128 SELECT @@global.max_statement_time;
129 @@global.max_statement_time
130 1.000000
131 SET @@global.max_statement_time = FALSE;
132 SELECT @@global.max_statement_time;
133 @@global.max_statement_time
134 0.000000
135 '#---------------------FN_DYNVARS_001_09----------------------#'
136 SET @@global.max_statement_time = 10;
137 SELECT @@max_statement_time = @@global.max_statement_time;
138 @@max_statement_time = @@global.max_statement_time
139 0
140 '#---------------------FN_DYNVARS_001_10----------------------#'
141 SET @@max_statement_time = 100;
142 SELECT @@max_statement_time = @@local.max_statement_time;
143 @@max_statement_time = @@local.max_statement_time
144 1
145 SELECT @@local.max_statement_time = @@session.max_statement_time;
146 @@local.max_statement_time = @@session.max_statement_time
147 1
148 '#---------------------FN_DYNVARS_001_11----------------------#'
149 SET max_statement_time = 1;
150 SELECT @@max_statement_time;
151 @@max_statement_time
152 1.000000
153 SELECT local.max_statement_time;
154 ERROR 42S02: Unknown table 'local' in SELECT
155 SELECT session.max_statement_time;
156 ERROR 42S02: Unknown table 'session' in SELECT
157 SELECT max_statement_time = @@session.max_statement_time;
158 ERROR 42S22: Unknown column 'max_statement_time' in 'SELECT'
159 #
160 # Check that one can use max_statement_time as a field
161 #
162 drop table if exists t1;
163 create table t1 (a int, max_statement_time int);
164 drop table t1;
165 SET @@global.max_statement_time = @start_global_value;
166 SELECT @@global.max_statement_time;
167 @@global.max_statement_time
168 0.000000
169 SET @@session.max_statement_time = @start_session_value;
170 SELECT @@session.max_statement_time;
171 @@session.max_statement_time
172 0.000000