Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.slave_net_timeout;
2 SELECT @start_global_value;
3 @start_global_value
4 120
5 '#--------------------FN_DYNVARS_146_01-------------------------#'
6 SET @@global.slave_net_timeout = 500000;
7 SET @@global.slave_net_timeout = DEFAULT;
8 SELECT @@global.slave_net_timeout;
9 @@global.slave_net_timeout
10 60
11 '#--------------------FN_DYNVARS_146_02-------------------------#'
12 SET @@global.slave_net_timeout = DEFAULT;
13 SELECT @@global.slave_net_timeout = 3600;
14 @@global.slave_net_timeout = 3600
15 0
16 '#--------------------FN_DYNVARS_146_03-------------------------#'
17 SET @@global.slave_net_timeout = 0;
18 Warnings:
19 Warning 1292 Truncated incorrect slave_net_timeout value: '0'
20 SELECT @@global.slave_net_timeout;
21 @@global.slave_net_timeout
22 1
23 SET @@global.slave_net_timeout = 1;
24 SELECT @@global.slave_net_timeout;
25 @@global.slave_net_timeout
26 1
27 SET @@global.slave_net_timeout = 15;
28 SELECT @@global.slave_net_timeout;
29 @@global.slave_net_timeout
30 15
31 SET @@global.slave_net_timeout = 1024;
32 SELECT @@global.slave_net_timeout;
33 @@global.slave_net_timeout
34 1024
35 SET @@global.slave_net_timeout = 3600+1;
36 SELECT @@global.slave_net_timeout;
37 @@global.slave_net_timeout
38 3601
39 SET @@global.slave_net_timeout = 2147483648;
40 Warnings:
41 Warning 1292 Truncated incorrect slave_net_timeout value: '2147483648'
42 SELECT @@global.slave_net_timeout;
43 @@global.slave_net_timeout
44 31536000
45 SET @@global.slave_net_timeout = 2147483648*2-1;
46 Warnings:
47 Warning 1292 Truncated incorrect slave_net_timeout value: '4294967295'
48 SELECT @@global.slave_net_timeout;
49 @@global.slave_net_timeout
50 31536000
51 '#--------------------FN_DYNVARS_146_04-------------------------#'
52 SET @@slave_net_timeout = 2;
53 ERROR HY000: Variable 'slave_net_timeout' is a GLOBAL variable and should be set with SET GLOBAL
54 SET @@session.slave_net_timeout = 3;
55 ERROR HY000: Variable 'slave_net_timeout' is a GLOBAL variable and should be set with SET GLOBAL
56 SET @@local.slave_net_timeout = 4;
57 ERROR HY000: Variable 'slave_net_timeout' is a GLOBAL variable and should be set with SET GLOBAL
58 '#------------------FN_DYNVARS_146_05-----------------------#'
59 SET @@global.slave_net_timeout = -1;
60 Warnings:
61 Warning 1292 Truncated incorrect slave_net_timeout value: '-1'
62 SELECT @@global.slave_net_timeout;
63 @@global.slave_net_timeout
64 1
65 SET @@global.slave_net_timeout = -2147483648;
66 Warnings:
67 Warning 1292 Truncated incorrect slave_net_timeout value: '-2147483648'
68 SELECT @@global.slave_net_timeout;
69 @@global.slave_net_timeout
70 1
71 SET @@global.slave_net_timeout = 2147483649*2;
72 Warnings:
73 Warning 1292 Truncated incorrect slave_net_timeout value: '4294967298'
74 SELECT @@global.slave_net_timeout;
75 @@global.slave_net_timeout
76 31536000
77 SET @@global.slave_net_timeout = 65530.34;
78 ERROR 42000: Incorrect argument type to variable 'slave_net_timeout'
79 SET @@global.slave_net_timeout = 100s;
80 ERROR 42000: Incorrect argument type to variable 'slave_net_timeout'
81 SET @@global.slave_net_timeout = 7483649.56;
82 ERROR 42000: Incorrect argument type to variable 'slave_net_timeout'
83 SET @@global.slave_net_timeout = 0.6;
84 ERROR 42000: Incorrect argument type to variable 'slave_net_timeout'
85 '#------------------FN_DYNVARS_146_06-----------------------#'
86 SET @@global.slave_net_timeout = 3000;
87 SELECT @@global.slave_net_timeout = VARIABLE_VALUE
88 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
89 WHERE VARIABLE_NAME='slave_net_timeout';
90 @@global.slave_net_timeout = VARIABLE_VALUE
91 1
92 '#------------------FN_DYNVARS_146_07-----------------------#'
93 SELECT count(VARIABLE_VALUE)
94 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
95 WHERE VARIABLE_NAME='slave_net_timeout';
96 count(VARIABLE_VALUE)
97 1
98 '#------------------FN_DYNVARS_146_08-----------------------#'
99 SET @@global.slave_net_timeout = TRUE;
100 SELECT @@global.slave_net_timeout;
101 @@global.slave_net_timeout
102 1
103 SET @@global.slave_net_timeout = FALSE;
104 Warnings:
105 Warning 1292 Truncated incorrect slave_net_timeout value: '0'
106 SELECT @@global.slave_net_timeout;
107 @@global.slave_net_timeout
108 1
109 '#---------------------FN_DYNVARS_001_09----------------------#'
110 SET @@global.slave_net_timeout = 60*60;
111 SELECT @@slave_net_timeout = @@global.slave_net_timeout;
112 @@slave_net_timeout = @@global.slave_net_timeout
113 1
114 '#---------------------FN_DYNVARS_001_10----------------------#'
115 SET slave_net_timeout = 2048;
116 ERROR HY000: Variable 'slave_net_timeout' is a GLOBAL variable and should be set with SET GLOBAL
117 SELECT slave_net_timeout;
118 ERROR 42S22: Unknown column 'slave_net_timeout' in 'SELECT'
119 SELECT @@slave_net_timeout;
120 @@slave_net_timeout
121 3600
122 SET global slave_net_timeout = 99;
123 SET @@global.slave_net_timeout = @start_global_value;
124 SELECT @@global.slave_net_timeout;
125 @@global.slave_net_timeout
126 120