Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.wait_timeout;
2 SET @start_session_value = @@session.wait_timeout;
3 '#--------------------FN_DYNVARS_005_01-------------------------#'
4 SET @@global.wait_timeout = 100;
5 SET @@global.wait_timeout = DEFAULT;
6 SELECT @@global.wait_timeout;
7 @@global.wait_timeout
8 28800
9 SET @@session.wait_timeout = 200;
10 SET @@session.wait_timeout = DEFAULT;
11 SELECT @@session.wait_timeout;
12 @@session.wait_timeout
13 28800
14 '#--------------------FN_DYNVARS_005_02-------------------------#'
15 SET @@global.wait_timeout = DEFAULT;
16 SELECT @@global.wait_timeout = @default_wait_timeout;
17 @@global.wait_timeout = @default_wait_timeout
18 1
19 SET @@session.wait_timeout = DEFAULT;
20 SELECT @@session.wait_timeout = @default_wait_timeout;
21 @@session.wait_timeout = @default_wait_timeout
22 1
23 '#--------------------FN_DYNVARS_005_03-------------------------#'
24 SET @@global.wait_timeout= 1;
25 SELECT @@global.wait_timeout;
26 @@global.wait_timeout
27 1
28 SET @@global.wait_timeout = 60020;
29 SELECT @@global.wait_timeout;
30 @@global.wait_timeout
31 60020
32 SET @@global.wait_timeout = 31536000;
33 SELECT @@global.wait_timeout = @max_wait_timeout;
34 @@global.wait_timeout = @max_wait_timeout
35 1
36 '#--------------------FN_DYNVARS_005_04-------------------------#'
37 SET @@session.wait_timeout =6000;
38 SELECT @@session.wait_timeout;
39 @@session.wait_timeout
40 6000
41 '#------------------FN_DYNVARS_005_05-----------------------#'
42 SET @@global.wait_timeout = 0;
43 Warnings:
44 Warning 1292 Truncated incorrect wait_timeout value: '0'
45 SET @@global.wait_timeout = -1024;
46 Warnings:
47 Warning 1292 Truncated incorrect wait_timeout value: '-1024'
48 SET @@global.wait_timeout = ON;
49 ERROR 42000: Incorrect argument type to variable 'wait_timeout'
50 SET @@global.wait_timeout = OFF;
51 ERROR 42000: Incorrect argument type to variable 'wait_timeout'
52 SET @@global.wait_timeout = True;
53 SELECT @@global.wait_timeout;
54 @@global.wait_timeout
55 1
56 SET @@global.wait_timeout = False;
57 Warnings:
58 Warning 1292 Truncated incorrect wait_timeout value: '0'
59 SELECT @@global.wait_timeout;
60 @@global.wait_timeout
61 1
62 SET @@global.wait_timeout = 65530.34;
63 ERROR 42000: Incorrect argument type to variable 'wait_timeout'
64 SET @@global.wait_timeout ="Test";
65 ERROR 42000: Incorrect argument type to variable 'wait_timeout'
66 SET @@session.wait_timeout = ON;
67 ERROR 42000: Incorrect argument type to variable 'wait_timeout'
68 SET @@session.wait_timeout = OFF;
69 ERROR 42000: Incorrect argument type to variable 'wait_timeout'
70 SET @@session.wait_timeout = True;
71 SELECT @@session.wait_timeout;
72 @@session.wait_timeout
73 1
74 SET @@session.wait_timeout = False;
75 Warnings:
76 Warning 1292 Truncated incorrect wait_timeout value: '0'
77 SELECT @@session.wait_timeout;
78 @@session.wait_timeout
79 1
80 SET @@session.wait_timeout = "Test";
81 ERROR 42000: Incorrect argument type to variable 'wait_timeout'
82 SET @@session.wait_timeout = 'test';
83 ERROR 42000: Incorrect argument type to variable 'wait_timeout'
84 SET @@session.wait_timeout = 123456789031;
85 Warnings:
86 Warning 1292 Truncated incorrect wait_timeout value: '123456789031'
87 SELECT @@session.wait_timeout = @max_wait_timeout;
88 @@session.wait_timeout = @max_wait_timeout
89 1
90 '#------------------FN_DYNVARS_005_06-----------------------#'
91 SELECT @@global.wait_timeout = VARIABLE_VALUE
92 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
93 WHERE VARIABLE_NAME='wait_timeout';
94 @@global.wait_timeout = VARIABLE_VALUE
95 1
96 '#------------------FN_DYNVARS_005_07-----------------------#'
97 SELECT @@session.wait_timeout = VARIABLE_VALUE
98 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
99 WHERE VARIABLE_NAME='wait_timeout';
100 @@session.wait_timeout = VARIABLE_VALUE
101 1
102 '#---------------------FN_DYNVARS_001_09----------------------#'
103 SET @@global.wait_timeout = 30000;
104 SET @@global.wait_timeout = 40000;
105 SELECT @@wait_timeout = @@global.wait_timeout;
106 @@wait_timeout = @@global.wait_timeout
107 0
108 '#---------------------FN_DYNVARS_001_10----------------------#'
109 SET @@wait_timeout = 100;
110 SELECT @@wait_timeout = @@local.wait_timeout;
111 @@wait_timeout = @@local.wait_timeout
112 1
113 SELECT @@local.wait_timeout = @@session.wait_timeout;
114 @@local.wait_timeout = @@session.wait_timeout
115 1
116 '#---------------------FN_DYNVARS_001_11----------------------#'
117 SET wait_timeout = 1027;
118 SELECT @@wait_timeout;
119 @@wait_timeout
120 1027
121 SELECT local.wait_timeout;
122 ERROR 42S02: Unknown table 'local' in SELECT
123 SELECT session.wait_timeout;
124 ERROR 42S02: Unknown table 'session' in SELECT
125 SELECT wait_timeout = @@session.wait_timeout;
126 ERROR 42S22: Unknown column 'wait_timeout' in 'SELECT'
127 #
128 # MDEV-9516 type error when setting session variable
129 #
130 SET SESSION wait_timeout= 28000;
131 SET SESSION wait_timeout= GREATEST(28000, @@wait_timeout);
132 SET SESSION wait_timeout= COALESCE(28000, @@wait_timeout);
133 SET SESSION wait_timeout= IFNULL(28000, @@wait_timeout);
134 SET SESSION wait_timeout= CASE WHEN TRUE THEN 28000 ELSE @@wait_timeout END;
135 SET SESSION wait_timeout= 28000.0;
136 ERROR 42000: Incorrect argument type to variable 'wait_timeout'
137 SET SESSION wait_timeout= 28000.1;
138 ERROR 42000: Incorrect argument type to variable 'wait_timeout'
139 SET @@global.wait_timeout = @start_global_value;
140 SET @@session.wait_timeout = @start_session_value;