summaryrefslogtreecommitdiff
path: root/mysql-test/suite/sys_vars/r/max_connect_errors_basic_64.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/sys_vars/r/max_connect_errors_basic_64.result')
-rw-r--r--mysql-test/suite/sys_vars/r/max_connect_errors_basic_64.result14
1 files changed, 9 insertions, 5 deletions
diff --git a/mysql-test/suite/sys_vars/r/max_connect_errors_basic_64.result b/mysql-test/suite/sys_vars/r/max_connect_errors_basic_64.result
index bbc117b65b6..19f6f12a50b 100644
--- a/mysql-test/suite/sys_vars/r/max_connect_errors_basic_64.result
+++ b/mysql-test/suite/sys_vars/r/max_connect_errors_basic_64.result
@@ -42,14 +42,16 @@ SELECT @@global.max_connect_errors;
@@global.max_connect_errors
1
SET @@global.max_connect_errors = 100000000000;
+Warnings:
+Warning 1292 Truncated incorrect max_connect_errors value: '100000000000'
SELECT @@global.max_connect_errors;
@@global.max_connect_errors
-100000000000
+4294967295
SET @@global.max_connect_errors = 10000.01;
ERROR 42000: Incorrect argument type to variable 'max_connect_errors'
SELECT @@global.max_connect_errors;
@@global.max_connect_errors
-100000000000
+4294967295
SET @@global.max_connect_errors = -1024;
Warnings:
Warning 1292 Truncated incorrect max_connect_errors value: '-1024'
@@ -63,19 +65,21 @@ SELECT @@global.max_connect_errors;
@@global.max_connect_errors
1
SET @@global.max_connect_errors = 4294967296;
+Warnings:
+Warning 1292 Truncated incorrect max_connect_errors value: '4294967296'
SELECT @@global.max_connect_errors;
@@global.max_connect_errors
-4294967296
+4294967295
SET @@global.max_connect_errors = ON;
ERROR 42000: Incorrect argument type to variable 'max_connect_errors'
SELECT @@global.max_connect_errors;
@@global.max_connect_errors
-4294967296
+4294967295
SET @@global.max_connect_errors = 'test';
ERROR 42000: Incorrect argument type to variable 'max_connect_errors'
SELECT @@global.max_connect_errors;
@@global.max_connect_errors
-4294967296
+4294967295
'#-------------------FN_DYNVARS_073_05----------------------------#'
SET @@session.max_connect_errors = 4096;
ERROR HY000: Variable 'max_connect_errors' is a GLOBAL variable and should be set with SET GLOBAL