Debian Codegraph @

mysql-test/suite/sys_vars/r/max_connect_errors_basic_64.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 SET @@global.max_connect_errors = 18446744073709551615;
38 SELECT @@global.max_connect_errors;
39 @@global.max_connect_errors
40 18446744073709551615
41 '#--------------------FN_DYNVARS_073_04-------------------------#'
42 SET @@global.max_connect_errors = -1;
43 Warnings:
44 Warning 1292 Truncated incorrect max_connect_errors value: '-1'
45 SELECT @@global.max_connect_errors;
46 @@global.max_connect_errors
47 1
48 SET @@global.max_connect_errors = 10000.01;
49 ERROR 42000: Incorrect argument type to variable 'max_connect_errors'
50 SELECT @@global.max_connect_errors;
51 @@global.max_connect_errors
52 1
53 SET @@global.max_connect_errors = -1024;
54 Warnings:
55 Warning 1292 Truncated incorrect max_connect_errors value: '-1024'
56 SELECT @@global.max_connect_errors;
57 @@global.max_connect_errors
58 1
59 SET @@global.max_connect_errors = 0;
60 Warnings:
61 Warning 1292 Truncated incorrect max_connect_errors value: '0'
62 SELECT @@global.max_connect_errors;
63 @@global.max_connect_errors
64 1
65 SET @@global.max_connect_errors = ON;
66 ERROR 42000: Incorrect argument type to variable 'max_connect_errors'
67 SELECT @@global.max_connect_errors;
68 @@global.max_connect_errors
69 1
70 SET @@global.max_connect_errors = 'test';
71 ERROR 42000: Incorrect argument type to variable 'max_connect_errors'
72 SELECT @@global.max_connect_errors;
73 @@global.max_connect_errors
74 1
75 SET @@global.max_connect_errors = 18446744073709551616;
76 ERROR 42000: Incorrect argument type to variable 'max_connect_errors'
77 SELECT @@global.max_connect_errors;
78 @@global.max_connect_errors
79 1
80 '#-------------------FN_DYNVARS_073_05----------------------------#'
81 SET @@session.max_connect_errors = 4096;
82 ERROR HY000: Variable 'max_connect_errors' is a GLOBAL variable and should be set with SET GLOBAL
83 SELECT @@session.max_connect_errors;
84 ERROR HY000: Variable 'max_connect_errors' is a GLOBAL variable
85 '#----------------------FN_DYNVARS_073_06------------------------#'
86 SELECT @@global.max_connect_errors = VARIABLE_VALUE
87 FROM performance_schema.global_variables
88 WHERE VARIABLE_NAME='max_connect_errors';
89 @@global.max_connect_errors = VARIABLE_VALUE
90 1
91 SELECT @@max_connect_errors = VARIABLE_VALUE
92 FROM performance_schema.session_variables
93 WHERE VARIABLE_NAME='max_connect_errors';
94 @@max_connect_errors = VARIABLE_VALUE
95 1
96 '#---------------------FN_DYNVARS_073_07----------------------#'
97 SET @@global.max_connect_errors = TRUE;
98 SELECT @@global.max_connect_errors;
99 @@global.max_connect_errors
100 1
101 SET @@global.max_connect_errors = FALSE;
102 Warnings:
103 Warning 1292 Truncated incorrect max_connect_errors value: '0'
104 SELECT @@global.max_connect_errors;
105 @@global.max_connect_errors
106 1
107 '#---------------------FN_DYNVARS_073_08----------------------#'
108 SET @@global.max_connect_errors = 5000;
109 SELECT @@max_connect_errors = @@global.max_connect_errors;
110 @@max_connect_errors = @@global.max_connect_errors
111 1
112 '#---------------------FN_DYNVARS_073_09----------------------#'
113 SET max_connect_errors = 6000;
114 ERROR HY000: Variable 'max_connect_errors' is a GLOBAL variable and should be set with SET GLOBAL
115 SELECT @@max_connect_errors;
116 @@max_connect_errors
117 5000
118 SET local.max_connect_errors = 7000;
119 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
120 SELECT local.max_connect_errors;
121 ERROR 42S02: Unknown table 'local' in field list
122 SET global.max_connect_errors = 8000;
123 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
124 SELECT global.max_connect_errors;
125 ERROR 42S02: Unknown table 'global' in field list
126 SELECT max_connect_errors;
127 ERROR 42S22: Unknown column 'max_connect_errors' in 'field list'
128 SELECT @@session.max_connect_errors;
129 ERROR HY000: Variable 'max_connect_errors' is a GLOBAL variable
130 SET @@global.max_connect_errors = @start_value;
131 SELECT @@global.max_connect_errors;
132 @@global.max_connect_errors
133 100