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 '#--------------------FN_DYNVARS_019_04-------------------------#'
30 SET @@global.connect_timeout = 1;
31 Warnings:
32 Warning 1292 Truncated incorrect connect_timeout value: '1'
33 SELECT @@global.connect_timeout;
34 @@global.connect_timeout
35 2
36 SET @@global.connect_timeout = -1024;
37 Warnings:
38 Warning 1292 Truncated incorrect connect_timeout value: '-1024'
39 SELECT @@global.connect_timeout;
40 @@global.connect_timeout
41 2
42 SET @@global.connect_timeout = 42949672950;
43 Warnings:
44 Warning 1292 Truncated incorrect connect_timeout value: '42949672950'
45 SELECT @@global.connect_timeout;
46 @@global.connect_timeout
47 31536000
48 SET @@global.connect_timeout = 21221204.10;
49 ERROR 42000: Incorrect argument type to variable 'connect_timeout'
50 SET @@global.connect_timeout = ON;
51 ERROR 42000: Incorrect argument type to variable 'connect_timeout'
52 '#-------------------FN_DYNVARS_019_05----------------------------#'
53 SET @@session.connect_timeout = 0;
54 ERROR HY000: Variable 'connect_timeout' is a GLOBAL variable and should be set with SET GLOBAL
55 SELECT @@session.connect_timeout;
56 ERROR HY000: Variable 'connect_timeout' is a GLOBAL variable
57 '#----------------------FN_DYNVARS_019_06------------------------#'
58 SELECT @@global.connect_timeout = VARIABLE_VALUE
59 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
60 WHERE VARIABLE_NAME='connect_timeout';
61 @@global.connect_timeout = VARIABLE_VALUE
62 1
63 '#---------------------FN_DYNVARS_019_07----------------------#'
64 SET @@global.connect_timeout = TRUE;
65 Warnings:
66 Warning 1292 Truncated incorrect connect_timeout value: '1'
67 SELECT @@global.connect_timeout;
68 @@global.connect_timeout
69 2
70 SET @@global.connect_timeout = FALSE;
71 Warnings:
72 Warning 1292 Truncated incorrect connect_timeout value: '0'
73 SELECT @@global.connect_timeout;
74 @@global.connect_timeout
75 2
76 '#---------------------FN_DYNVARS_019_08----------------------#'
77 SET @@global.connect_timeout = 5;
78 SELECT @@connect_timeout = @@global.connect_timeout;
79 @@connect_timeout = @@global.connect_timeout
80 1
81 '#---------------------FN_DYNVARS_019_09----------------------#'
82 SET connect_timeout = 1;
83 ERROR HY000: Variable 'connect_timeout' is a GLOBAL variable and should be set with SET GLOBAL
84 SELECT global.connect_timeout;
85 ERROR 42S02: Unknown table 'global' in SELECT
86 SELECT connect_timeout = @@session.connect_timeout;
87 ERROR 42S22: Unknown column 'connect_timeout' in 'SELECT'
88 SET @@global.connect_timeout = @start_value;
89 SELECT @@global.connect_timeout;
90 @@global.connect_timeout
91 60