Debian Codegraph @

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

raw
1 SET @start_value = @@global.max_connect_errors;
2 SELECT @start_value >= 0;
3 @start_value >= 0
4 1
5 '#--------------------FN_DYNVARS_073_01------------------------#'
6 SET @@global.max_connect_errors = 5000;
7 SET @@global.max_connect_errors = DEFAULT;
8 '#---------------------FN_DYNVARS_073_02-------------------------#'
9 SET @@global.max_connect_errors = @start_value;
10 SELECT @@global.max_connect_errors = @start_value;
11 @@global.max_connect_errors = @start_value
12 1
13 '#--------------------FN_DYNVARS_073_03------------------------#'
14 SET @@global.max_connect_errors = 4096;
15 SELECT @@global.max_connect_errors;
16 @@global.max_connect_errors
17 4096
18 SET @@global.max_connect_errors = 4294967294;
19 SELECT @@global.max_connect_errors;
20 @@global.max_connect_errors
21 4294967294
22 SET @@global.max_connect_errors = 4294967295;
23 SELECT @@global.max_connect_errors;
24 @@global.max_connect_errors
25 4294967295
26 SET @@global.max_connect_errors = 1;
27 SELECT @@global.max_connect_errors;
28 @@global.max_connect_errors
29 1
30 SET @@global.max_connect_errors = 2;
31 SELECT @@global.max_connect_errors;
32 @@global.max_connect_errors
33 2
34 '#--------------------FN_DYNVARS_073_04-------------------------#'
35 SET @@global.max_connect_errors = -1;
36 Warnings:
37 Warning 1292 Truncated incorrect max_connect_errors value: '-1'
38 SELECT @@global.max_connect_errors;
39 @@global.max_connect_errors
40 1
41 SET @@global.max_connect_errors = 100000000000;
42 Warnings:
43 Warning 1292 Truncated incorrect max_connect_errors value: '100000000000'
44 SELECT @@global.max_connect_errors;
45 @@global.max_connect_errors
46 4294967295
47 SET @@global.max_connect_errors = 10000.01;
48 ERROR 42000: Incorrect argument type to variable 'max_connect_errors'
49 SELECT @@global.max_connect_errors;
50 @@global.max_connect_errors
51 4294967295
52 SET @@global.max_connect_errors = -1024;
53 Warnings:
54 Warning 1292 Truncated incorrect max_connect_errors value: '-1024'
55 SELECT @@global.max_connect_errors;
56 @@global.max_connect_errors
57 1
58 SET @@global.max_connect_errors = 0;
59 Warnings:
60 Warning 1292 Truncated incorrect max_connect_errors value: '0'
61 SELECT @@global.max_connect_errors;
62 @@global.max_connect_errors
63 1
64 SET @@global.max_connect_errors = 4294967296;
65 Warnings:
66 Warning 1292 Truncated incorrect max_connect_errors value: '4294967296'
67 SELECT @@global.max_connect_errors;
68 @@global.max_connect_errors
69 4294967295
70 SET @@global.max_connect_errors = ON;
71 ERROR 42000: Incorrect argument type to variable 'max_connect_errors'
72 SELECT @@global.max_connect_errors;
73 @@global.max_connect_errors
74 4294967295
75 SET @@global.max_connect_errors = 'test';
76 ERROR 42000: Incorrect argument type to variable 'max_connect_errors'
77 SELECT @@global.max_connect_errors;
78 @@global.max_connect_errors
79 4294967295
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 INFORMATION_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 INFORMATION_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 SELECT local.max_connect_errors;
119 ERROR 42S02: Unknown table 'local' in SELECT
120 SELECT global.max_connect_errors;
121 ERROR 42S02: Unknown table 'global' in SELECT
122 SELECT max_connect_errors = @@session.max_connect_errors;
123 ERROR 42S22: Unknown column 'max_connect_errors' in 'SELECT'
124 SET @@global.max_connect_errors = @start_value;