Debian Codegraph @

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

raw
1 SET @start_value = @@global.max_connect_errors;
2 SELECT @start_value;
3 @start_value
4 100
5 '#--------------------FN_DYNVARS_073_01------------------------#'
6 SET @@global.max_connect_errors = 5000;
7 SET @@global.max_connect_errors = DEFAULT;
8 SELECT @@global.max_connect_errors;
9 @@global.max_connect_errors
10 100
11 '#---------------------FN_DYNVARS_073_02-------------------------#'
12 SET @@global.max_connect_errors = @start_value;
13 SELECT @@global.max_connect_errors = 100;
14 @@global.max_connect_errors = 100
15 1
16 '#--------------------FN_DYNVARS_073_03------------------------#'
17 SET @@global.max_connect_errors = 4096;
18 SELECT @@global.max_connect_errors;
19 @@global.max_connect_errors
20 4096
21 SET @@global.max_connect_errors = 4294967294;
22 SELECT @@global.max_connect_errors;
23 @@global.max_connect_errors
24 4294967294
25 SET @@global.max_connect_errors = 4294967295;
26 SELECT @@global.max_connect_errors;
27 @@global.max_connect_errors
28 4294967295
29 SET @@global.max_connect_errors = 1;
30 SELECT @@global.max_connect_errors;
31 @@global.max_connect_errors
32 1
33 SET @@global.max_connect_errors = 2;
34 SELECT @@global.max_connect_errors;
35 @@global.max_connect_errors
36 2
37 '#--------------------FN_DYNVARS_073_04-------------------------#'
38 SET @@global.max_connect_errors = -1;
39 Warnings:
40 Warning 1292 Truncated incorrect max_connect_errors value: '-1'
41 SELECT @@global.max_connect_errors;
42 @@global.max_connect_errors
43 1
44 SET @@global.max_connect_errors = 10000.01;
45 ERROR 42000: Incorrect argument type to variable 'max_connect_errors'
46 SELECT @@global.max_connect_errors;
47 @@global.max_connect_errors
48 1
49 SET @@global.max_connect_errors = -1024;
50 Warnings:
51 Warning 1292 Truncated incorrect max_connect_errors value: '-1024'
52 SELECT @@global.max_connect_errors;
53 @@global.max_connect_errors
54 1
55 SET @@global.max_connect_errors = 0;
56 Warnings:
57 Warning 1292 Truncated incorrect max_connect_errors value: '0'
58 SELECT @@global.max_connect_errors;
59 @@global.max_connect_errors
60 1
61 SET @@global.max_connect_errors = ON;
62 ERROR 42000: Incorrect argument type to variable 'max_connect_errors'
63 SELECT @@global.max_connect_errors;
64 @@global.max_connect_errors
65 1
66 SET @@global.max_connect_errors = 'test';
67 ERROR 42000: Incorrect argument type to variable 'max_connect_errors'
68 SELECT @@global.max_connect_errors;
69 @@global.max_connect_errors
70 1
71 SET @@global.max_connect_errors = 4294967296;
72 Warnings:
73 Warning 1292 Truncated incorrect max_connect_errors value: '4294967296'
74 SELECT @@global.max_connect_errors;
75 @@global.max_connect_errors
76 4294967295
77 SET @@global.max_connect_errors = 42949672950;
78 Warnings:
79 Warning 1292 Truncated incorrect max_connect_errors value: '42949672950'
80 SELECT @@global.max_connect_errors;
81 @@global.max_connect_errors
82 4294967295
83 '#-------------------FN_DYNVARS_073_05----------------------------#'
84 SET @@session.max_connect_errors = 4096;
85 ERROR HY000: Variable 'max_connect_errors' is a GLOBAL variable and should be set with SET GLOBAL
86 SELECT @@session.max_connect_errors;
87 ERROR HY000: Variable 'max_connect_errors' is a GLOBAL variable
88 '#----------------------FN_DYNVARS_073_06------------------------#'
89 SELECT @@global.max_connect_errors = VARIABLE_VALUE
90 FROM performance_schema.global_variables
91 WHERE VARIABLE_NAME='max_connect_errors';
92 @@global.max_connect_errors = VARIABLE_VALUE
93 1
94 SELECT @@max_connect_errors = VARIABLE_VALUE
95 FROM performance_schema.session_variables
96 WHERE VARIABLE_NAME='max_connect_errors';
97 @@max_connect_errors = VARIABLE_VALUE
98 1
99 '#---------------------FN_DYNVARS_073_07----------------------#'
100 SET @@global.max_connect_errors = TRUE;
101 SELECT @@global.max_connect_errors;
102 @@global.max_connect_errors
103 1
104 SET @@global.max_connect_errors = FALSE;
105 Warnings:
106 Warning 1292 Truncated incorrect max_connect_errors value: '0'
107 SELECT @@global.max_connect_errors;
108 @@global.max_connect_errors
109 1
110 '#---------------------FN_DYNVARS_073_08----------------------#'
111 SET @@global.max_connect_errors = 5000;
112 SELECT @@max_connect_errors = @@global.max_connect_errors;
113 @@max_connect_errors = @@global.max_connect_errors
114 1
115 '#---------------------FN_DYNVARS_073_09----------------------#'
116 SET max_connect_errors = 6000;
117 ERROR HY000: Variable 'max_connect_errors' is a GLOBAL variable and should be set with SET GLOBAL
118 SELECT @@max_connect_errors;
119 @@max_connect_errors
120 5000
121 SET local.max_connect_errors = 7000;
122 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 'local.max_connect_errors = 7000' at line 1
123 SELECT local.max_connect_errors;
124 ERROR 42S02: Unknown table 'local' in field list
125 SET global.max_connect_errors = 8000;
126 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.max_connect_errors = 8000' at line 1
127 SELECT global.max_connect_errors;
128 ERROR 42S02: Unknown table 'global' in field list
129 SELECT max_connect_errors;
130 ERROR 42S22: Unknown column 'max_connect_errors' in 'field list'
131 SELECT @@session.max_connect_errors;
132 ERROR HY000: Variable 'max_connect_errors' is a GLOBAL variable
133 SET @@global.max_connect_errors = @start_value;
134 SELECT @@global.max_connect_errors;
135 @@global.max_connect_errors
136 100