diff options
Diffstat (limited to 'mysql-test/r/max_user_connections_basic.result')
| -rw-r--r-- | mysql-test/r/max_user_connections_basic.result | 115 |
1 files changed, 115 insertions, 0 deletions
diff --git a/mysql-test/r/max_user_connections_basic.result b/mysql-test/r/max_user_connections_basic.result new file mode 100644 index 00000000000..3250b2f03ea --- /dev/null +++ b/mysql-test/r/max_user_connections_basic.result @@ -0,0 +1,115 @@ +SET @start_global_value = @@global.max_user_connections; +SELECT @start_global_value; +@start_global_value +0 +SET @start_session_value = @@session.max_user_connections; +SELECT @start_session_value; +@start_session_value +0 +'#--------------------FN_DYNVARS_087_01-------------------------#' +SET @@global.max_user_connections = 1000; +SET @@global.max_user_connections = DEFAULT; +SELECT @@global.max_user_connections; +@@global.max_user_connections +0 +SET @@session.max_user_connections = 1000; +ERROR HY000: Variable 'max_user_connections' is a GLOBAL variable and should be set with SET GLOBAL +SET @@session.max_user_connections = DEFAULT; +ERROR 42000: Variable 'max_user_connections' doesn't have a default value +SELECT @@session.max_user_connections; +@@session.max_user_connections +0 +'Bug # 34837: Errors are not coming on assigning invalid values to variable'; +'#--------------------FN_DYNVARS_087_02-------------------------#' +SET @@global.max_user_connections = DEFAULT; +SELECT @@global.max_user_connections = 0; +@@global.max_user_connections = 0 +1 +SET @@session.max_user_connections = DEFAULT; +ERROR 42000: Variable 'max_user_connections' doesn't have a default value +SELECT @@session.max_user_connections = 0; +@@session.max_user_connections = 0 +1 +'#--------------------FN_DYNVARS_087_03-------------------------#' +SET @@global.max_user_connections = 1; +SELECT @@global.max_user_connections; +@@global.max_user_connections +1 +SET @@global.max_user_connections = 2; +SELECT @@global.max_user_connections; +@@global.max_user_connections +2 +SET @@global.max_user_connections = 65536; +SELECT @@global.max_user_connections; +@@global.max_user_connections +65536 +SET @@global.max_user_connections = 4294967295; +SELECT @@global.max_user_connections; +@@global.max_user_connections +4294967295 +SET @@global.max_user_connections = 4294967294; +SELECT @@global.max_user_connections; +@@global.max_user_connections +4294967294 +'#------------------FN_DYNVARS_087_05-----------------------#' +SET @@global.max_user_connections = -1024; +SELECT @@global.max_user_connections; +@@global.max_user_connections +4294966272 +SET @@global.max_user_connections = 4294967296; +SELECT @@global.max_user_connections; +@@global.max_user_connections +0 +SET @@global.max_user_connections = -1; +SELECT @@global.max_user_connections; +@@global.max_user_connections +4294967295 +SET @@global.max_user_connections = 429496729500; +SELECT @@global.max_user_connections; +@@global.max_user_connections +4294967196 +SET @@global.max_user_connections = 65530.34.; +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 '.' at line 1 +SELECT @@global.max_user_connections; +@@global.max_user_connections +4294967196 +SET @@global.max_user_connections = test; +ERROR 42000: Incorrect argument type to variable 'max_user_connections' +SELECT @@global.max_user_connections; +@@global.max_user_connections +4294967196 +'#------------------FN_DYNVARS_087_06-----------------------#' +SELECT @@global.max_user_connections = VARIABLE_VALUE +FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='max_user_connections'; +@@global.max_user_connections = VARIABLE_VALUE +1 +'#------------------FN_DYNVARS_087_08-----------------------#' +SET @@global.max_user_connections = TRUE; +SELECT @@global.max_user_connections; +@@global.max_user_connections +1 +SET @@global.max_user_connections = FALSE; +SELECT @@global.max_user_connections; +@@global.max_user_connections +0 +'#---------------------FN_DYNVARS_087_09----------------------#' +SET @@global.max_user_connections = 20; +SELECT @@max_user_connections = @@global.max_user_connections; +@@max_user_connections = @@global.max_user_connections +1 +'#---------------------FN_DYNVARS_087_11----------------------#' +SET @@global.max_user_connections = 102; +SELECT @@max_user_connections; +@@max_user_connections +102 +SELECT local.max_user_connections; +ERROR 42S02: Unknown table 'local' in field list +SELECT session.max_user_connections; +ERROR 42S02: Unknown table 'session' in field list +SELECT max_user_connections = @@session.max_user_connections; +ERROR 42S22: Unknown column 'max_user_connections' in 'field list' +SET @@global.max_user_connections = @start_global_value; +SELECT @@global.max_user_connections; +@@global.max_user_connections +0 |