Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.mysqlx_wait_timeout;
2 SET @start_session_value = @@session.mysqlx_wait_timeout;
3 SET @@global.mysqlx_wait_timeout = 100;
4 SET @@global.mysqlx_wait_timeout = DEFAULT;
5 SELECT @@global.mysqlx_wait_timeout;
6 @@global.mysqlx_wait_timeout
7 28800
8 SET @@session.mysqlx_wait_timeout = 200;
9 SET @@session.mysqlx_wait_timeout = DEFAULT;
10 SELECT @@session.mysqlx_wait_timeout;
11 @@session.mysqlx_wait_timeout
12 28800
13 SET @@global.mysqlx_wait_timeout = DEFAULT;
14 SELECT @@global.mysqlx_wait_timeout = @default_mysqlx_wait_timeout;
15 @@global.mysqlx_wait_timeout = @default_mysqlx_wait_timeout
16 NULL
17 SET @@session.mysqlx_wait_timeout = DEFAULT;
18 SELECT @@session.mysqlx_wait_timeout = @default_mysqlx_wait_timeout;
19 @@session.mysqlx_wait_timeout = @default_mysqlx_wait_timeout
20 NULL
21 SET @@global.mysqlx_wait_timeout= 1;
22 SELECT @@global.mysqlx_wait_timeout;
23 @@global.mysqlx_wait_timeout
24 1
25 SET @@global.mysqlx_wait_timeout = 60020;
26 SELECT @@global.mysqlx_wait_timeout;
27 @@global.mysqlx_wait_timeout
28 60020
29 SET @@global.mysqlx_wait_timeout = 31536000;
30 Warnings:
31 Warning 1292 Truncated incorrect mysqlx_wait_timeout value: '31536000'
32 SELECT @@global.mysqlx_wait_timeout = @max_mysqlx_wait_timeout;
33 @@global.mysqlx_wait_timeout = @max_mysqlx_wait_timeout
34 NULL
35 SET @@session.mysqlx_wait_timeout =6000;
36 SELECT @@session.mysqlx_wait_timeout;
37 @@session.mysqlx_wait_timeout
38 6000
39 SET @@global.mysqlx_wait_timeout = 0;
40 Warnings:
41 Warning 1292 Truncated incorrect mysqlx_wait_timeout value: '0'
42 SELECT @@global.mysqlx_wait_timeout;
43 @@global.mysqlx_wait_timeout
44 1
45 SET @@global.mysqlx_wait_timeout = -1024;
46 Warnings:
47 Warning 1292 Truncated incorrect mysqlx_wait_timeout value: '-1024'
48 SELECT @@global.mysqlx_wait_timeout;
49 @@global.mysqlx_wait_timeout
50 1
51 SET @@global.mysqlx_wait_timeout = 123456789031;
52 Warnings:
53 Warning 1292 Truncated incorrect mysqlx_wait_timeout value: '123456789031'
54 SELECT @@global.mysqlx_wait_timeout;
55 @@global.mysqlx_wait_timeout
56 2147483
57 SET @@global.mysqlx_wait_timeout = 31536003;
58 Warnings:
59 Warning 1292 Truncated incorrect mysqlx_wait_timeout value: '31536003'
60 SELECT @@global.mysqlx_wait_timeout;
61 @@global.mysqlx_wait_timeout
62 2147483
63 SET @@global.mysqlx_wait_timeout = ' ';
64 ERROR 42000: Incorrect argument type to variable 'mysqlx_wait_timeout'
65 SELECT @@global.mysqlx_wait_timeout;
66 @@global.mysqlx_wait_timeout
67 2147483
68 SET @@global.mysqlx_wait_timeout = ON;
69 ERROR 42000: Incorrect argument type to variable 'mysqlx_wait_timeout'
70 SET @@global.mysqlx_wait_timeout = OFF;
71 ERROR 42000: Incorrect argument type to variable 'mysqlx_wait_timeout'
72 SET @@global.mysqlx_wait_timeout = True;
73 SELECT @@global.mysqlx_wait_timeout;
74 @@global.mysqlx_wait_timeout
75 1
76 SET @@global.mysqlx_wait_timeout = False;
77 Warnings:
78 Warning 1292 Truncated incorrect mysqlx_wait_timeout value: '0'
79 SELECT @@global.mysqlx_wait_timeout;
80 @@global.mysqlx_wait_timeout
81 1
82 SET @@global.mysqlx_wait_timeout = 65530.34;
83 ERROR 42000: Incorrect argument type to variable 'mysqlx_wait_timeout'
84 SELECT @@global.mysqlx_wait_timeout;
85 @@global.mysqlx_wait_timeout
86 1
87 SET @@global.mysqlx_wait_timeout ="Test";
88 ERROR 42000: Incorrect argument type to variable 'mysqlx_wait_timeout'
89 SET @@session.mysqlx_wait_timeout = ON;
90 ERROR 42000: Incorrect argument type to variable 'mysqlx_wait_timeout'
91 SET @@session.mysqlx_wait_timeout = OFF;
92 ERROR 42000: Incorrect argument type to variable 'mysqlx_wait_timeout'
93 SET @@session.mysqlx_wait_timeout = True;
94 SELECT @@session.mysqlx_wait_timeout;
95 @@session.mysqlx_wait_timeout
96 1
97 SET @@session.mysqlx_wait_timeout = False;
98 Warnings:
99 Warning 1292 Truncated incorrect mysqlx_wait_timeout value: '0'
100 SELECT @@session.mysqlx_wait_timeout;
101 @@session.mysqlx_wait_timeout
102 1
103 SET @@session.mysqlx_wait_timeout = "Test";
104 ERROR 42000: Incorrect argument type to variable 'mysqlx_wait_timeout'
105 SET @@session.mysqlx_wait_timeout = 65530.34;
106 ERROR 42000: Incorrect argument type to variable 'mysqlx_wait_timeout'
107 SELECT @@session.mysqlx_wait_timeout;
108 @@session.mysqlx_wait_timeout
109 1
110 SET @@session.mysqlx_wait_timeout = 'test';
111 ERROR 42000: Incorrect argument type to variable 'mysqlx_wait_timeout'
112 SET @@session.mysqlx_wait_timeout = 0;
113 Warnings:
114 Warning 1292 Truncated incorrect mysqlx_wait_timeout value: '0'
115 SELECT @@session.mysqlx_wait_timeout;
116 @@session.mysqlx_wait_timeout
117 1
118 SELECT @@session.mysqlx_wait_timeout = @max_mysqlx_wait_timeout;
119 @@session.mysqlx_wait_timeout = @max_mysqlx_wait_timeout
120 NULL
121 SELECT @@session.mysqlx_wait_timeout;
122 @@session.mysqlx_wait_timeout
123 1
124 SET @@session.mysqlx_wait_timeout = ' ';
125 ERROR 42000: Incorrect argument type to variable 'mysqlx_wait_timeout'
126 SELECT @@session.mysqlx_wait_timeout;
127 @@session.mysqlx_wait_timeout
128 1
129 SELECT @@global.mysqlx_wait_timeout = VARIABLE_VALUE
130 FROM performance_schema.global_variables
131 WHERE VARIABLE_NAME='mysqlx_wait_timeout';
132 @@global.mysqlx_wait_timeout = VARIABLE_VALUE
133 1
134 SELECT @@session.mysqlx_wait_timeout = VARIABLE_VALUE
135 FROM performance_schema.session_variables
136 WHERE VARIABLE_NAME='mysqlx_wait_timeout';
137 @@session.mysqlx_wait_timeout = VARIABLE_VALUE
138 1
139 SET @@global.mysqlx_wait_timeout = 30000;
140 SET @@global.mysqlx_wait_timeout = 40000;
141 SELECT @@mysqlx_wait_timeout = @@global.mysqlx_wait_timeout;
142 @@mysqlx_wait_timeout = @@global.mysqlx_wait_timeout
143 0
144 SET @@mysqlx_wait_timeout = 100;
145 SELECT @@mysqlx_wait_timeout = @@local.mysqlx_wait_timeout;
146 @@mysqlx_wait_timeout = @@local.mysqlx_wait_timeout
147 1
148 SELECT @@local.mysqlx_wait_timeout = @@session.mysqlx_wait_timeout;
149 @@local.mysqlx_wait_timeout = @@session.mysqlx_wait_timeout
150 1
151 SET mysqlx_wait_timeout = 1027;
152 SELECT @@mysqlx_wait_timeout;
153 @@mysqlx_wait_timeout
154 1027
155 SELECT local.mysqlx_wait_timeout;
156 ERROR 42S02: Unknown table 'local' in field list
157 SELECT session.mysqlx_wait_timeout;
158 ERROR 42S02: Unknown table 'session' in field list
159 SELECT mysqlx_wait_timeout = @@session.mysqlx_wait_timeout;
160 ERROR 42S22: Unknown column 'mysqlx_wait_timeout' in 'field list'
161 SET @@global.mysqlx_wait_timeout = @start_global_value;
162 SET @@session.mysqlx_wait_timeout = @start_session_value;