Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.mysqlx_interactive_timeout;
2 SELECT @start_global_value;
3 @start_global_value
4 28800
5 SET @@global.mysqlx_interactive_timeout = 100;
6 SET @@global.mysqlx_interactive_timeout = DEFAULT;
7 SELECT @@global.mysqlx_interactive_timeout;
8 @@global.mysqlx_interactive_timeout
9 28800
10 SET @@session.mysqlx_interactive_timeout = DEFAULT;
11 ERROR HY000: Variable 'mysqlx_interactive_timeout' is a GLOBAL variable and should be set with SET GLOBAL
12 SET @@global.mysqlx_interactive_timeout = DEFAULT;
13 SELECT @@global.mysqlx_interactive_timeout = 28800;
14 @@global.mysqlx_interactive_timeout = 28800
15 1
16 SET @@global.mysqlx_interactive_timeout = 1;
17 SELECT @@global.mysqlx_interactive_timeout;
18 @@global.mysqlx_interactive_timeout
19 1
20 SET @@global.mysqlx_interactive_timeout = 60020;
21 SELECT @@global.mysqlx_interactive_timeout;
22 @@global.mysqlx_interactive_timeout
23 60020
24 SET @@global.mysqlx_interactive_timeout = 65535;
25 SELECT @@global.mysqlx_interactive_timeout;
26 @@global.mysqlx_interactive_timeout
27 65535
28 SET @@global.mysqlx_interactive_timeout = 31536000;
29 Warnings:
30 Warning 1292 Truncated incorrect mysqlx_interactive_timeout value: '31536000'
31 SELECT @@global.mysqlx_interactive_timeout;
32 @@global.mysqlx_interactive_timeout
33 2147483
34 SET @@global.mysqlx_interactive_timeout = 0;
35 Warnings:
36 Warning 1292 Truncated incorrect mysqlx_interactive_timeout value: '0'
37 SELECT @@global.mysqlx_interactive_timeout;
38 @@global.mysqlx_interactive_timeout
39 1
40 SET @@global.mysqlx_interactive_timeout = -1024;
41 Warnings:
42 Warning 1292 Truncated incorrect mysqlx_interactive_timeout value: '-1024'
43 SELECT @@global.mysqlx_interactive_timeout;
44 @@global.mysqlx_interactive_timeout
45 1
46 SET @@global.mysqlx_interactive_timeout = 31536001;
47 Warnings:
48 Warning 1292 Truncated incorrect mysqlx_interactive_timeout value: '31536001'
49 SELECT @@global.mysqlx_interactive_timeout;
50 @@global.mysqlx_interactive_timeout
51 2147483
52 SET @@global.mysqlx_interactive_timeout = 1000000000;
53 Warnings:
54 Warning 1292 Truncated incorrect mysqlx_interactive_timeout value: '1000000000'
55 SELECT @@global.mysqlx_interactive_timeout;
56 @@global.mysqlx_interactive_timeout
57 2147483
58 SET @@global.mysqlx_interactive_timeout = 65530.34;
59 ERROR 42000: Incorrect argument type to variable 'mysqlx_interactive_timeout'
60 SELECT @@global.mysqlx_interactive_timeout;
61 @@global.mysqlx_interactive_timeout
62 2147483
63 SET @@global.mysqlx_interactive_timeout = test;
64 ERROR 42000: Incorrect argument type to variable 'mysqlx_interactive_timeout'
65 SELECT @@global.mysqlx_interactive_timeout;
66 @@global.mysqlx_interactive_timeout
67 2147483
68 SELECT @@global.mysqlx_interactive_timeout = VARIABLE_VALUE
69 FROM performance_schema.global_variables
70 WHERE VARIABLE_NAME='mysqlx_interactive_timeout';
71 @@global.mysqlx_interactive_timeout = VARIABLE_VALUE
72 1
73 SET @@global.mysqlx_interactive_timeout = TRUE;
74 SELECT @@global.mysqlx_interactive_timeout;
75 @@global.mysqlx_interactive_timeout
76 1
77 SET @@global.mysqlx_interactive_timeout = FALSE;
78 Warnings:
79 Warning 1292 Truncated incorrect mysqlx_interactive_timeout value: '0'
80 SELECT @@global.mysqlx_interactive_timeout;
81 @@global.mysqlx_interactive_timeout
82 1
83 SET @@global.mysqlx_interactive_timeout = 10;
84 SELECT @@mysqlx_interactive_timeout = @@global.mysqlx_interactive_timeout;
85 @@mysqlx_interactive_timeout = @@global.mysqlx_interactive_timeout
86 1
87 SET @@mysqlx_interactive_timeout = 100;
88 ERROR HY000: Variable 'mysqlx_interactive_timeout' is a GLOBAL variable and should be set with SET GLOBAL
89 SET mysqlx_interactive_timeout = 1;
90 ERROR HY000: Variable 'mysqlx_interactive_timeout' is a GLOBAL variable and should be set with SET GLOBAL
91 SET @@global.mysqlx_interactive_timeout = @start_global_value;