summaryrefslogtreecommitdiff
path: root/mysql-test/suite/sys_vars/t/max_connections_basic.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/sys_vars/t/max_connections_basic.test')
-rw-r--r--mysql-test/suite/sys_vars/t/max_connections_basic.test10
1 files changed, 4 insertions, 6 deletions
diff --git a/mysql-test/suite/sys_vars/t/max_connections_basic.test b/mysql-test/suite/sys_vars/t/max_connections_basic.test
index de259b32c17..b4f3afbf3b6 100644
--- a/mysql-test/suite/sys_vars/t/max_connections_basic.test
+++ b/mysql-test/suite/sys_vars/t/max_connections_basic.test
@@ -35,7 +35,7 @@
###################################################################
SET @start_value = @@global.max_connections;
-SELECT @start_value;
+SELECT @start_value > 0;
--echo '#--------------------FN_DYNVARS_074_01------------------------#'
@@ -43,9 +43,9 @@ SELECT @start_value;
# Display the DEFAULT value of max_connections #
##################################################################
-SET @@global.max_connections = 5000;
+SET @@global.max_connections = @start_value+1;
SET @@global.max_connections = DEFAULT;
-SELECT @@global.max_connections;
+SELECT @@global.max_connections <> @start_value+1;
--echo '#---------------------FN_DYNVARS_074_02-------------------------#'
###############################################
@@ -53,7 +53,7 @@ SELECT @@global.max_connections;
###############################################
SET @@global.max_connections = @start_value;
-SELECT @@global.max_connections = 151;
+SELECT @@global.max_connections = @start_value;
--echo '#--------------------FN_DYNVARS_074_03------------------------#'
@@ -166,10 +166,8 @@ SELECT max_connections = @@session.max_connections;
##############################
SET @@global.max_connections = @start_value;
-SELECT @@global.max_connections;
##################################################################
# END OF max_connections TESTS #
##################################################################
-