diff options
Diffstat (limited to 'mysql-test/r/log_warnings_basic_32.result')
| -rw-r--r-- | mysql-test/r/log_warnings_basic_32.result | 162 |
1 files changed, 162 insertions, 0 deletions
diff --git a/mysql-test/r/log_warnings_basic_32.result b/mysql-test/r/log_warnings_basic_32.result new file mode 100644 index 00000000000..702e95b1383 --- /dev/null +++ b/mysql-test/r/log_warnings_basic_32.result @@ -0,0 +1,162 @@ +SET @start_global_value = @@global.log_warnings; +SELECT @start_global_value; +@start_global_value +1 +SET @start_session_value = @@session.log_warnings; +SELECT @start_session_value; +@start_session_value +1 +'#--------------------FN_DYNVARS_067_01-------------------------#' +SET @@global.log_warnings = 100; +SET @@global.log_warnings = DEFAULT; +SELECT @@global.log_warnings; +@@global.log_warnings +1 +SET @@session.log_warnings = 200; +SET @@session.log_warnings = DEFAULT; +SELECT @@session.log_warnings; +@@session.log_warnings +1 +'#--------------------FN_DYNVARS_067_02-------------------------#' +SET @@global.log_warnings = DEFAULT; +SELECT @@global.log_warnings = 1; +@@global.log_warnings = 1 +1 +SET @@session.log_warnings = DEFAULT; +SELECT @@session.log_warnings = 1; +@@session.log_warnings = 1 +1 +'#--------------------FN_DYNVARS_067_03-------------------------#' +SET @@global.log_warnings = 0; +SELECT @@global.log_warnings; +@@global.log_warnings +0 +SET @@global.log_warnings = 1; +SELECT @@global.log_warnings; +@@global.log_warnings +1 +SET @@global.log_warnings = 60020; +SELECT @@global.log_warnings; +@@global.log_warnings +60020 +SET @@global.log_warnings = 65535; +SELECT @@global.log_warnings; +@@global.log_warnings +65535 +SET @@global.log_warnings = 65536; +SELECT @@global.log_warnings; +@@global.log_warnings +65536 +'#--------------------FN_DYNVARS_067_04-------------------------#' +SET @@session.log_warnings = 0; +SELECT @@session.log_warnings; +@@session.log_warnings +0 +SET @@session.log_warnings = 1; +SELECT @@session.log_warnings; +@@session.log_warnings +1 +SET @@session.log_warnings = 50050; +SELECT @@session.log_warnings; +@@session.log_warnings +50050 +SET @@session.log_warnings = 65535; +SELECT @@session.log_warnings; +@@session.log_warnings +65535 +SET @@session.log_warnings = 65550; +SELECT @@session.log_warnings; +@@session.log_warnings +65550 +'#------------------FN_DYNVARS_067_05-----------------------#' +SET @@global.log_warnings = 100000000000; +Warnings: +Warning 1292 Truncated incorrect log-warnings value: '100000000000' +SELECT @@global.log_warnings; +@@global.log_warnings +4294967295 +SET @@global.log_warnings = -1024; +SELECT @@global.log_warnings; +@@global.log_warnings +0 +SET @@global.log_warnings = 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.log_warnings; +@@global.log_warnings +0 +SET @@global.log_warnings = test; +ERROR 42000: Incorrect argument type to variable 'log_warnings' +SELECT @@global.log_warnings; +@@global.log_warnings +0 +SET @@session.log_warnings = 100000000000; +Warnings: +Warning 1292 Truncated incorrect log-warnings value: '100000000000' +SELECT @@session.log_warnings; +@@session.log_warnings +4294967295 +SET @@session.log_warnings = -2; +SELECT @@session.log_warnings; +@@session.log_warnings +0 +SET @@session.log_warnings = 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 +'Bug # 34837: Errors are not coming on assigning invalid values to variable'; +SET @@session.log_warnings = test; +ERROR 42000: Incorrect argument type to variable 'log_warnings' +SELECT @@session.log_warnings; +@@session.log_warnings +0 +'#------------------FN_DYNVARS_067_06-----------------------#' +SELECT @@global.log_warnings = VARIABLE_VALUE +FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='log_warnings'; +@@global.log_warnings = VARIABLE_VALUE +1 +'#------------------FN_DYNVARS_067_07-----------------------#' +SELECT @@session.log_warnings = VARIABLE_VALUE +FROM INFORMATION_SCHEMA.SESSION_VARIABLES +WHERE VARIABLE_NAME='log_warnings'; +@@session.log_warnings = VARIABLE_VALUE +1 +'#------------------FN_DYNVARS_067_08-----------------------#' +SET @@global.log_warnings = TRUE; +SELECT @@global.log_warnings; +@@global.log_warnings +1 +SET @@global.log_warnings = FALSE; +SELECT @@global.log_warnings; +@@global.log_warnings +0 +'#---------------------FN_DYNVARS_067_09----------------------#' +SET @@global.log_warnings = 10; +SELECT @@log_warnings = @@global.log_warnings; +@@log_warnings = @@global.log_warnings +0 +'#---------------------FN_DYNVARS_067_10----------------------#' +SET @@log_warnings = 100; +SELECT @@log_warnings = @@local.log_warnings; +@@log_warnings = @@local.log_warnings +1 +SELECT @@local.log_warnings = @@session.log_warnings; +@@local.log_warnings = @@session.log_warnings +1 +'#---------------------FN_DYNVARS_067_11----------------------#' +SET log_warnings = 1; +SELECT @@log_warnings; +@@log_warnings +1 +SELECT local.log_warnings; +ERROR 42S02: Unknown table 'local' in field list +SELECT session.log_warnings; +ERROR 42S02: Unknown table 'session' in field list +SELECT log_warnings = @@session.log_warnings; +ERROR 42S22: Unknown column 'log_warnings' in 'field list' +SET @@global.log_warnings = @start_global_value; +SELECT @@global.log_warnings; +@@global.log_warnings +1 +SET @@session.log_warnings = @start_session_value; +SELECT @@session.log_warnings; +@@session.log_warnings +1 |