Debian Codegraph @

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

raw
1 SET @start_value = @@global.connect_timeout;
2 SELECT @start_value;
3 @start_value
4 60
5 '#--------------------FN_DYNVARS_019_01------------------------#'
6 SET @@global.connect_timeout = 100;
7 SET @@global.connect_timeout = DEFAULT;
8 SELECT @@global.connect_timeout;
9 @@global.connect_timeout
10 10
11 '#---------------------FN_DYNVARS_019_02-------------------------#'
12 SET @@global.connect_timeout = @start_value;
13 SELECT @@global.connect_timeout = 5;
14 @@global.connect_timeout = 5
15 0
16 '#--------------------FN_DYNVARS_019_03------------------------#'
17 SET @@global.connect_timeout = 2;
18 SELECT @@global.connect_timeout;
19 @@global.connect_timeout
20 2
21 SET @@global.connect_timeout = 10000;
22 SELECT @@global.connect_timeout;
23 @@global.connect_timeout
24 10000
25 SET @@global.connect_timeout = 21221204;
26 SELECT @@global.connect_timeout;
27 @@global.connect_timeout
28 21221204
29 SET @@global.connect_timeout = 31536000;
30 SELECT @@global.connect_timeout;
31 @@global.connect_timeout
32 31536000
33 '#--------------------FN_DYNVARS_019_04-------------------------#'
34 SET @@global.connect_timeout = 1;
35 Warnings:
36 Warning 1292 Truncated incorrect connect_timeout value: '1'
37 SELECT @@global.connect_timeout;
38 @@global.connect_timeout
39 2
40 SET @@global.connect_timeout = -1024;
41 Warnings:
42 Warning 1292 Truncated incorrect connect_timeout value: '-1024'
43 SELECT @@global.connect_timeout;
44 @@global.connect_timeout
45 2
46 SET @@global.connect_timeout = 31536001;
47 Warnings:
48 Warning 1292 Truncated incorrect connect_timeout value: '31536001'
49 SELECT @@global.connect_timeout;
50 @@global.connect_timeout
51 31536000
52 SET @@global.connect_timeout = 42949672950;
53 Warnings:
54 Warning 1292 Truncated incorrect connect_timeout value: '42949672950'
55 SELECT @@global.connect_timeout;
56 @@global.connect_timeout
57 31536000
58 SET @@global.connect_timeout = 21221204.10;
59 ERROR 42000: Incorrect argument type to variable 'connect_timeout'
60 SET @@global.connect_timeout = ON;
61 ERROR 42000: Incorrect argument type to variable 'connect_timeout'
62 '#-------------------FN_DYNVARS_019_05----------------------------#'
63 SET @@session.connect_timeout = 0;
64 ERROR HY000: Variable 'connect_timeout' is a GLOBAL variable and should be set with SET GLOBAL
65 SELECT @@session.connect_timeout;
66 ERROR HY000: Variable 'connect_timeout' is a GLOBAL variable
67 '#----------------------FN_DYNVARS_019_06------------------------#'
68 SELECT @@global.connect_timeout = VARIABLE_VALUE
69 FROM performance_schema.global_variables
70 WHERE VARIABLE_NAME='connect_timeout';
71 @@global.connect_timeout = VARIABLE_VALUE
72 1
73 '#---------------------FN_DYNVARS_019_07----------------------#'
74 SET @@global.connect_timeout = TRUE;
75 Warnings:
76 Warning 1292 Truncated incorrect connect_timeout value: '1'
77 SELECT @@global.connect_timeout;
78 @@global.connect_timeout
79 2
80 SET @@global.connect_timeout = FALSE;
81 Warnings:
82 Warning 1292 Truncated incorrect connect_timeout value: '0'
83 SELECT @@global.connect_timeout;
84 @@global.connect_timeout
85 2
86 '#---------------------FN_DYNVARS_019_08----------------------#'
87 SET @@global.connect_timeout = 5;
88 SELECT @@connect_timeout = @@global.connect_timeout;
89 @@connect_timeout = @@global.connect_timeout
90 1
91 '#---------------------FN_DYNVARS_019_09----------------------#'
92 SET connect_timeout = 1;
93 ERROR HY000: Variable 'connect_timeout' is a GLOBAL variable and should be set with SET GLOBAL
94 SET global.connect_timeout = 1;
95 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'global.connect_timeout = 1' at line 1
96 SELECT global.connect_timeout;
97 ERROR 42S02: Unknown table 'global' in field list
98 SELECT connect_timeout;
99 ERROR 42S22: Unknown column 'connect_timeout' in 'field list'
100 SELECT @@session.connect_timeout;
101 ERROR HY000: Variable 'connect_timeout' is a GLOBAL variable
102 SET @@global.connect_timeout = @start_value;
103 SELECT @@global.connect_timeout;
104 @@global.connect_timeout
105 60