diff options
Diffstat (limited to 'mysql-test')
23 files changed, 155 insertions, 90 deletions
diff --git a/mysql-test/suite/optimizer_unfixed_bugs/r/bug45221.result b/mysql-test/suite/optimizer_unfixed_bugs/r/bug45221.result index 657f1f57b2d..45e502ca5a4 100644 --- a/mysql-test/suite/optimizer_unfixed_bugs/r/bug45221.result +++ b/mysql-test/suite/optimizer_unfixed_bugs/r/bug45221.result @@ -36,11 +36,11 @@ SELECT `int_key` FROM CC WHERE `date_nokey` < `datetime_nokey` XOR '2009-11-25' ) ; pk -9 2 +4 5 6 -4 +9 Warnings: Warning 1292 Truncated incorrect INTEGER value: '2009-11-25' Warning 1292 Truncated incorrect INTEGER value: '2009-11-25' diff --git a/mysql-test/suite/sys_vars/r/deadlock_timeout_long_basic.result b/mysql-test/suite/sys_vars/r/deadlock_timeout_long_basic.result index 2a8f239dd39..b227b70133f 100644 --- a/mysql-test/suite/sys_vars/r/deadlock_timeout_long_basic.result +++ b/mysql-test/suite/sys_vars/r/deadlock_timeout_long_basic.result @@ -38,7 +38,8 @@ select @@global.deadlock_timeout_long; set session deadlock_timeout_long=cast(-1 as unsigned int); Warnings: Warning 1105 Cast to unsigned converted negative integer to it's positive complement +Warning 1292 Truncated incorrect deadlock_timeout_long value: '18446744073709551615' select @@session.deadlock_timeout_long; @@session.deadlock_timeout_long -18446744073709551615 +4294967295 SET @@global.deadlock_timeout_long = @start_global_value; diff --git a/mysql-test/suite/sys_vars/r/deadlock_timeout_short_basic.result b/mysql-test/suite/sys_vars/r/deadlock_timeout_short_basic.result index a789594a843..5b8449142f2 100644 --- a/mysql-test/suite/sys_vars/r/deadlock_timeout_short_basic.result +++ b/mysql-test/suite/sys_vars/r/deadlock_timeout_short_basic.result @@ -38,7 +38,8 @@ select @@global.deadlock_timeout_short; set session deadlock_timeout_short=cast(-1 as unsigned int); Warnings: Warning 1105 Cast to unsigned converted negative integer to it's positive complement +Warning 1292 Truncated incorrect deadlock_timeout_short value: '18446744073709551615' select @@session.deadlock_timeout_short; @@session.deadlock_timeout_short -18446744073709551615 +4294967295 SET @@global.deadlock_timeout_short = @start_global_value; diff --git a/mysql-test/suite/sys_vars/r/debug_binlog_fsync_sleep_basic.result b/mysql-test/suite/sys_vars/r/debug_binlog_fsync_sleep_basic.result index adf2b4c39b9..25706a1a3f4 100644 --- a/mysql-test/suite/sys_vars/r/debug_binlog_fsync_sleep_basic.result +++ b/mysql-test/suite/sys_vars/r/debug_binlog_fsync_sleep_basic.result @@ -35,7 +35,8 @@ select @@global.debug_binlog_fsync_sleep; set global debug_binlog_fsync_sleep=cast(-1 as unsigned int); Warnings: Warning 1105 Cast to unsigned converted negative integer to it's positive complement +Warning 1292 Truncated incorrect debug_binlog_fsync_sleep value: '18446744073709551615' select @@global.debug_binlog_fsync_sleep; @@global.debug_binlog_fsync_sleep -18446744073709551615 +4294967295 SET @@global.debug_binlog_fsync_sleep = @start_global_value; diff --git a/mysql-test/suite/sys_vars/r/delayed_insert_limit_basic_64.result b/mysql-test/suite/sys_vars/r/delayed_insert_limit_basic_64.result index af73196d14f..3da10bc8416 100644 --- a/mysql-test/suite/sys_vars/r/delayed_insert_limit_basic_64.result +++ b/mysql-test/suite/sys_vars/r/delayed_insert_limit_basic_64.result @@ -40,19 +40,21 @@ SELECT @@global.delayed_insert_limit; @@global.delayed_insert_limit 1 SET @@global.delayed_insert_limit = 42949672950; +Warnings: +Warning 1292 Truncated incorrect delayed_insert_limit value: '42949672950' SELECT @@global.delayed_insert_limit; @@global.delayed_insert_limit -42949672950 +4294967295 SET @@global.delayed_insert_limit = 429496729.5; ERROR 42000: Incorrect argument type to variable 'delayed_insert_limit' SELECT @@global.delayed_insert_limit; @@global.delayed_insert_limit -42949672950 +4294967295 SET @@global.delayed_insert_limit = ON; ERROR 42000: Incorrect argument type to variable 'delayed_insert_limit' SELECT @@global.delayed_insert_limit; @@global.delayed_insert_limit -42949672950 +4294967295 '#-------------------FN_DYNVARS_024_05----------------------------#' SET @@session.delayed_insert_limit = 0; ERROR HY000: Variable 'delayed_insert_limit' is a GLOBAL variable and should be set with SET GLOBAL diff --git a/mysql-test/suite/sys_vars/r/delayed_queue_size_basic_64.result b/mysql-test/suite/sys_vars/r/delayed_queue_size_basic_64.result index 8b1936e68c5..f4448b08b1f 100644 --- a/mysql-test/suite/sys_vars/r/delayed_queue_size_basic_64.result +++ b/mysql-test/suite/sys_vars/r/delayed_queue_size_basic_64.result @@ -40,19 +40,21 @@ SELECT @@global.delayed_queue_size; @@global.delayed_queue_size 1 SET @@global.delayed_queue_size = 42949672950; +Warnings: +Warning 1292 Truncated incorrect delayed_queue_size value: '42949672950' SELECT @@global.delayed_queue_size; @@global.delayed_queue_size -42949672950 +4294967295 SET @@global.delayed_queue_size = 429496729.5; ERROR 42000: Incorrect argument type to variable 'delayed_queue_size' SELECT @@global.delayed_queue_size; @@global.delayed_queue_size -42949672950 +4294967295 SET @@global.delayed_queue_size = ON; ERROR 42000: Incorrect argument type to variable 'delayed_queue_size' SELECT @@delayed_queue_size; @@delayed_queue_size -42949672950 +4294967295 '#-------------------FN_DYNVARS_026_05----------------------------#' SET @@session.delayed_queue_size = 0; ERROR HY000: Variable 'delayed_queue_size' is a GLOBAL variable and should be set with SET GLOBAL diff --git a/mysql-test/suite/sys_vars/r/key_cache_age_threshold_basic_64.result b/mysql-test/suite/sys_vars/r/key_cache_age_threshold_basic_64.result index 5e0222e8968..9df9f56bd1f 100644 --- a/mysql-test/suite/sys_vars/r/key_cache_age_threshold_basic_64.result +++ b/mysql-test/suite/sys_vars/r/key_cache_age_threshold_basic_64.result @@ -45,12 +45,12 @@ Warnings: Warning 1292 Truncated incorrect key_cache_age_threshold value: '42949672951' SELECT @@global.key_cache_age_threshold; @@global.key_cache_age_threshold -42949672900 +4294967200 SET @@global.key_cache_age_threshold = 10000.01; ERROR 42000: Incorrect argument type to variable 'key_cache_age_threshold' SELECT @@global.key_cache_age_threshold; @@global.key_cache_age_threshold -42949672900 +4294967200 SET @@global.key_cache_age_threshold = -1024; Warnings: Warning 1292 Truncated incorrect key_cache_age_threshold value: '-1024' diff --git a/mysql-test/suite/sys_vars/r/log_slow_rate_limit_basic.result b/mysql-test/suite/sys_vars/r/log_slow_rate_limit_basic.result index 8711d914980..30eebdc9f44 100644 --- a/mysql-test/suite/sys_vars/r/log_slow_rate_limit_basic.result +++ b/mysql-test/suite/sys_vars/r/log_slow_rate_limit_basic.result @@ -40,7 +40,8 @@ select @@global.log_slow_rate_limit; set session log_slow_rate_limit=cast(-1 as unsigned int); Warnings: Warning 1105 Cast to unsigned converted negative integer to it's positive complement +Warning 1292 Truncated incorrect log_slow_rate_limit value: '18446744073709551615' select @@session.log_slow_rate_limit; @@session.log_slow_rate_limit -18446744073709551615 +4294967295 SET @@global.log_slow_rate_limit = @start_global_value; diff --git a/mysql-test/suite/sys_vars/r/log_warnings_basic_64.result b/mysql-test/suite/sys_vars/r/log_warnings_basic_64.result index 838fdff269b..fee7f8966ca 100644 --- a/mysql-test/suite/sys_vars/r/log_warnings_basic_64.result +++ b/mysql-test/suite/sys_vars/r/log_warnings_basic_64.result @@ -70,9 +70,11 @@ SELECT @@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 -100000000000 +4294967295 SET @@global.log_warnings = -1024; Warnings: Warning 1292 Truncated incorrect log_warnings value: '-1024' @@ -90,9 +92,11 @@ 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 -100000000000 +4294967295 SET @@session.log_warnings = -2; Warnings: Warning 1292 Truncated incorrect log_warnings value: '-2' diff --git a/mysql-test/suite/sys_vars/r/max_binlog_cache_size_basic.result b/mysql-test/suite/sys_vars/r/max_binlog_cache_size_basic.result index d760474affd..d3c3cbd7a44 100644 --- a/mysql-test/suite/sys_vars/r/max_binlog_cache_size_basic.result +++ b/mysql-test/suite/sys_vars/r/max_binlog_cache_size_basic.result @@ -1,7 +1,7 @@ SET @start_value = @@global.max_binlog_cache_size; SELECT @start_value; @start_value -18446744073709547520 +4294963200 '#--------------------FN_DYNVARS_072_01------------------------#' SET @@global.max_binlog_cache_size = 5000; Warnings: @@ -9,7 +9,7 @@ Warning 1292 Truncated incorrect max_binlog_cache_size value: '5000' SET @@global.max_binlog_cache_size = DEFAULT; SELECT @@global.max_binlog_cache_size; @@global.max_binlog_cache_size -18446744073709547520 +4294963200 '#---------------------FN_DYNVARS_072_02-------------------------#' SET @@global.max_binlog_cache_size = @start_value; SELECT @@global.max_binlog_cache_size = 4294967295; @@ -149,4 +149,4 @@ ERROR 42S22: Unknown column 'max_binlog_cache_size' in 'field list' SET @@global.max_binlog_cache_size = @start_value; SELECT @@global.max_binlog_cache_size; @@global.max_binlog_cache_size -18446744073709547520 +4294963200 diff --git a/mysql-test/suite/sys_vars/r/max_binlog_stmt_cache_size_basic.result b/mysql-test/suite/sys_vars/r/max_binlog_stmt_cache_size_basic.result index f2229a0090b..12f40ed87b5 100644 --- a/mysql-test/suite/sys_vars/r/max_binlog_stmt_cache_size_basic.result +++ b/mysql-test/suite/sys_vars/r/max_binlog_stmt_cache_size_basic.result @@ -1,7 +1,7 @@ SET @start_value = @@global.max_binlog_stmt_cache_size; SELECT @start_value; @start_value -18446744073709547520 +4294963200 '#--------------------FN_DYNVARS_072_01------------------------#' SET @@global.max_binlog_stmt_cache_size = 5000; Warnings: @@ -9,7 +9,7 @@ Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '5000' SET @@global.max_binlog_stmt_cache_size = DEFAULT; SELECT @@global.max_binlog_stmt_cache_size; @@global.max_binlog_stmt_cache_size -18446744073709547520 +4294963200 '#---------------------FN_DYNVARS_072_02-------------------------#' SET @@global.max_binlog_stmt_cache_size = @start_value; SELECT @@global.max_binlog_stmt_cache_size = 4294967295; @@ -149,4 +149,4 @@ ERROR 42S22: Unknown column 'max_binlog_stmt_cache_size' in 'field list' SET @@global.max_binlog_stmt_cache_size = @start_value; SELECT @@global.max_binlog_stmt_cache_size; @@global.max_binlog_stmt_cache_size -18446744073709547520 +4294963200 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 diff --git a/mysql-test/suite/sys_vars/r/max_seeks_for_key_basic_64.result b/mysql-test/suite/sys_vars/r/max_seeks_for_key_basic_64.result index ef48f229abc..2973e7e1efd 100644 --- a/mysql-test/suite/sys_vars/r/max_seeks_for_key_basic_64.result +++ b/mysql-test/suite/sys_vars/r/max_seeks_for_key_basic_64.result @@ -1,31 +1,31 @@ SET @start_global_value = @@global.max_seeks_for_key; SELECT @start_global_value; @start_global_value -18446744073709551615 +4294967295 SET @start_session_value = @@session.max_seeks_for_key; SELECT @start_session_value; @start_session_value -18446744073709551615 +4294967295 '#--------------------FN_DYNVARS_083_01-------------------------#' SET @@global.max_seeks_for_key = 100; SET @@global.max_seeks_for_key = DEFAULT; SELECT @@global.max_seeks_for_key; @@global.max_seeks_for_key -18446744073709551615 +4294967295 SET @@session.max_seeks_for_key = 200; SET @@session.max_seeks_for_key = DEFAULT; SELECT @@session.max_seeks_for_key; @@session.max_seeks_for_key -18446744073709551615 +4294967295 '#--------------------FN_DYNVARS_083_02-------------------------#' SET @@global.max_seeks_for_key = DEFAULT; SELECT @@global.max_seeks_for_key = 4294967295; @@global.max_seeks_for_key = 4294967295 -0 +1 SET @@session.max_seeks_for_key = DEFAULT; SELECT @@session.max_seeks_for_key = 4294967295; @@session.max_seeks_for_key = 4294967295 -0 +1 '#--------------------FN_DYNVARS_083_03-------------------------#' SET @@global.max_seeks_for_key = 1; SELECT @@global.max_seeks_for_key; @@ -82,19 +82,21 @@ SELECT @@global.max_seeks_for_key; @@global.max_seeks_for_key 1 SET @@global.max_seeks_for_key = 4294967296; +Warnings: +Warning 1292 Truncated incorrect max_seeks_for_key value: '4294967296' SELECT @@global.max_seeks_for_key; @@global.max_seeks_for_key -4294967296 +4294967295 SET @@global.max_seeks_for_key = 65530.34; ERROR 42000: Incorrect argument type to variable 'max_seeks_for_key' SELECT @@global.max_seeks_for_key; @@global.max_seeks_for_key -4294967296 +4294967295 SET @@global.max_seeks_for_key = test; ERROR 42000: Incorrect argument type to variable 'max_seeks_for_key' SELECT @@global.max_seeks_for_key; @@global.max_seeks_for_key -4294967296 +4294967295 SET @@session.max_seeks_for_key = 0; Warnings: Warning 1292 Truncated incorrect max_seeks_for_key value: '0' @@ -110,14 +112,16 @@ SELECT @@session.max_seeks_for_key; SET @@session.max_seeks_for_key = 65530.34; ERROR 42000: Incorrect argument type to variable 'max_seeks_for_key' SET @@session.max_seeks_for_key = 4294967296; +Warnings: +Warning 1292 Truncated incorrect max_seeks_for_key value: '4294967296' SELECT @@session.max_seeks_for_key; @@session.max_seeks_for_key -4294967296 +4294967295 SET @@session.max_seeks_for_key = test; ERROR 42000: Incorrect argument type to variable 'max_seeks_for_key' SELECT @@session.max_seeks_for_key; @@session.max_seeks_for_key -4294967296 +4294967295 '#------------------FN_DYNVARS_083_06-----------------------#' SELECT @@global.max_seeks_for_key = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES @@ -168,8 +172,8 @@ ERROR 42S22: Unknown column 'max_seeks_for_key' in 'field list' SET @@global.max_seeks_for_key = @start_global_value; SELECT @@global.max_seeks_for_key; @@global.max_seeks_for_key -18446744073709551615 +4294967295 SET @@session.max_seeks_for_key = @start_session_value; SELECT @@session.max_seeks_for_key; @@session.max_seeks_for_key -18446744073709551615 +4294967295 diff --git a/mysql-test/suite/sys_vars/r/max_tmp_tables_basic_64.result b/mysql-test/suite/sys_vars/r/max_tmp_tables_basic_64.result index 32953d24b2b..5daf78fcae1 100644 --- a/mysql-test/suite/sys_vars/r/max_tmp_tables_basic_64.result +++ b/mysql-test/suite/sys_vars/r/max_tmp_tables_basic_64.result @@ -76,9 +76,11 @@ SELECT @@global.max_tmp_tables; @@global.max_tmp_tables 1 SET @@global.max_tmp_tables = 4294967296; +Warnings: +Warning 1292 Truncated incorrect max_tmp_tables value: '4294967296' SELECT @@global.max_tmp_tables; @@global.max_tmp_tables -4294967296 +4294967295 SET @@global.max_tmp_tables = -1; Warnings: Warning 1292 Truncated incorrect max_tmp_tables value: '-1' @@ -86,23 +88,27 @@ SELECT @@global.max_tmp_tables; @@global.max_tmp_tables 1 SET @@global.max_tmp_tables = 429496729500; +Warnings: +Warning 1292 Truncated incorrect max_tmp_tables value: '429496729500' SELECT @@global.max_tmp_tables; @@global.max_tmp_tables -429496729500 +4294967295 SET @@global.max_tmp_tables = 65530.34; ERROR 42000: Incorrect argument type to variable 'max_tmp_tables' SELECT @@global.max_tmp_tables; @@global.max_tmp_tables -429496729500 +4294967295 SET @@global.max_tmp_tables = test; ERROR 42000: Incorrect argument type to variable 'max_tmp_tables' SELECT @@global.max_tmp_tables; @@global.max_tmp_tables -429496729500 +4294967295 SET @@session.max_tmp_tables = 4294967296; +Warnings: +Warning 1292 Truncated incorrect max_tmp_tables value: '4294967296' SELECT @@session.max_tmp_tables; @@session.max_tmp_tables -4294967296 +4294967295 SET @@session.max_tmp_tables = -1; Warnings: Warning 1292 Truncated incorrect max_tmp_tables value: '-1' @@ -110,9 +116,11 @@ SELECT @@session.max_tmp_tables; @@session.max_tmp_tables 1 SET @@session.max_tmp_tables = 429496729500; +Warnings: +Warning 1292 Truncated incorrect max_tmp_tables value: '429496729500' SELECT @@session.max_tmp_tables; @@session.max_tmp_tables -429496729500 +4294967295 SET @@session.max_tmp_tables = -001; Warnings: Warning 1292 Truncated incorrect max_tmp_tables value: '-1' @@ -122,14 +130,16 @@ SELECT @@session.max_tmp_tables; SET @@session.max_tmp_tables = 65530.34; ERROR 42000: Incorrect argument type to variable 'max_tmp_tables' SET @@session.max_tmp_tables = 10737418241; +Warnings: +Warning 1292 Truncated incorrect max_tmp_tables value: '10737418241' SELECT @@session.max_tmp_tables; @@session.max_tmp_tables -10737418241 +4294967295 SET @@session.max_tmp_tables = test; ERROR 42000: Incorrect argument type to variable 'max_tmp_tables' SELECT @@session.max_tmp_tables; @@session.max_tmp_tables -10737418241 +4294967295 '#------------------FN_DYNVARS_086_06-----------------------#' SELECT @@global.max_tmp_tables = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES diff --git a/mysql-test/suite/sys_vars/r/max_write_lock_count_basic_64.result b/mysql-test/suite/sys_vars/r/max_write_lock_count_basic_64.result index af675e40e19..59d92d5cfe8 100644 --- a/mysql-test/suite/sys_vars/r/max_write_lock_count_basic_64.result +++ b/mysql-test/suite/sys_vars/r/max_write_lock_count_basic_64.result @@ -1,18 +1,18 @@ SET @start_global_value = @@global.max_write_lock_count; SELECT @start_global_value; @start_global_value -18446744073709551615 +4294967295 '#--------------------FN_DYNVARS_088_01-------------------------#' SET @@global.max_write_lock_count = 1000; SET @@global.max_write_lock_count = DEFAULT; SELECT @@global.max_write_lock_count; @@global.max_write_lock_count -18446744073709551615 +4294967295 '#--------------------FN_DYNVARS_088_02-------------------------#' SET @@global.max_write_lock_count = DEFAULT; SELECT @@global.max_write_lock_count = 4294967295; @@global.max_write_lock_count = 4294967295 -0 +1 '#--------------------FN_DYNVARS_088_03-------------------------#' SET @@global.max_write_lock_count = 1; SELECT @@global.max_write_lock_count; @@ -42,9 +42,11 @@ SELECT @@global.max_write_lock_count; @@global.max_write_lock_count 1 SET @@global.max_write_lock_count = 4294967296; +Warnings: +Warning 1292 Truncated incorrect max_write_lock_count value: '4294967296' SELECT @@global.max_write_lock_count; @@global.max_write_lock_count -4294967296 +4294967295 SET @@global.max_write_lock_count = -1; Warnings: Warning 1292 Truncated incorrect max_write_lock_count value: '-1' @@ -52,19 +54,21 @@ SELECT @@global.max_write_lock_count; @@global.max_write_lock_count 1 SET @@global.max_write_lock_count = 429496729500; +Warnings: +Warning 1292 Truncated incorrect max_write_lock_count value: '429496729500' SELECT @@global.max_write_lock_count; @@global.max_write_lock_count -429496729500 +4294967295 SET @@global.max_write_lock_count = 65530.34; ERROR 42000: Incorrect argument type to variable 'max_write_lock_count' SELECT @@global.max_write_lock_count; @@global.max_write_lock_count -429496729500 +4294967295 SET @@global.max_write_lock_count = test; ERROR 42000: Incorrect argument type to variable 'max_write_lock_count' SELECT @@global.max_write_lock_count; @@global.max_write_lock_count -429496729500 +4294967295 '#------------------FN_DYNVARS_088_05-----------------------#' SELECT @@global.max_write_lock_count = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES @@ -101,4 +105,4 @@ ERROR 42S22: Unknown column 'max_write_lock_count' in 'field list' SET @@global.max_write_lock_count = @start_global_value; SELECT @@global.max_write_lock_count; @@global.max_write_lock_count -18446744073709551615 +4294967295 diff --git a/mysql-test/suite/sys_vars/r/min_examined_row_limit_basic_64.result b/mysql-test/suite/sys_vars/r/min_examined_row_limit_basic_64.result index 30ccfce0175..b4b1b9ae402 100644 --- a/mysql-test/suite/sys_vars/r/min_examined_row_limit_basic_64.result +++ b/mysql-test/suite/sys_vars/r/min_examined_row_limit_basic_64.result @@ -88,23 +88,27 @@ SELECT @@global.min_examined_row_limit; @@global.min_examined_row_limit 0 SET @@global.min_examined_row_limit = 429496729500; +Warnings: +Warning 1292 Truncated incorrect min_examined_row_limit value: '429496729500' SELECT @@global.min_examined_row_limit; @@global.min_examined_row_limit -429496729500 +4294967295 SET @@global.min_examined_row_limit = 65530.34; ERROR 42000: Incorrect argument type to variable 'min_examined_row_limit' SELECT @@global.min_examined_row_limit; @@global.min_examined_row_limit -429496729500 +4294967295 SET @@global.min_examined_row_limit = test; ERROR 42000: Incorrect argument type to variable 'min_examined_row_limit' SELECT @@global.min_examined_row_limit; @@global.min_examined_row_limit -429496729500 +4294967295 SET @@session.min_examined_row_limit = 4294967296; +Warnings: +Warning 1292 Truncated incorrect min_examined_row_limit value: '4294967296' SELECT @@session.min_examined_row_limit; @@session.min_examined_row_limit -4294967296 +4294967295 SET @@session.min_examined_row_limit = -1; Warnings: Warning 1292 Truncated incorrect min_examined_row_limit value: '-1' @@ -114,14 +118,16 @@ SELECT @@session.min_examined_row_limit; SET @@session.min_examined_row_limit = 65530.34; ERROR 42000: Incorrect argument type to variable 'min_examined_row_limit' SET @@session.min_examined_row_limit = 4294967295021; +Warnings: +Warning 1292 Truncated incorrect min_examined_row_limit value: '4294967295021' SELECT @@session.min_examined_row_limit; @@session.min_examined_row_limit -4294967295021 +4294967295 SET @@session.min_examined_row_limit = test; ERROR 42000: Incorrect argument type to variable 'min_examined_row_limit' SELECT @@session.min_examined_row_limit; @@session.min_examined_row_limit -4294967295021 +4294967295 '#------------------FN_DYNVARS_089_06-----------------------#' SELECT @@global.min_examined_row_limit = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES diff --git a/mysql-test/suite/sys_vars/r/net_retry_count_basic_64.result b/mysql-test/suite/sys_vars/r/net_retry_count_basic_64.result index 28f0ca5be0f..46eb9d5e1c0 100644 --- a/mysql-test/suite/sys_vars/r/net_retry_count_basic_64.result +++ b/mysql-test/suite/sys_vars/r/net_retry_count_basic_64.result @@ -82,23 +82,27 @@ SELECT @@global.net_retry_count; @@global.net_retry_count 1 SET @@global.net_retry_count = 4294967296; +Warnings: +Warning 1292 Truncated incorrect net_retry_count value: '4294967296' SELECT @@global.net_retry_count; @@global.net_retry_count -4294967296 +4294967295 SET @@global.net_retry_count = 429496729500; +Warnings: +Warning 1292 Truncated incorrect net_retry_count value: '429496729500' SELECT @@global.net_retry_count; @@global.net_retry_count -429496729500 +4294967295 SET @@global.net_retry_count = 65530.34; ERROR 42000: Incorrect argument type to variable 'net_retry_count' SELECT @@global.net_retry_count; @@global.net_retry_count -429496729500 +4294967295 SET @@global.net_retry_count = test; ERROR 42000: Incorrect argument type to variable 'net_retry_count' SELECT @@global.net_retry_count; @@global.net_retry_count -429496729500 +4294967295 SET @@session.net_retry_count = 0; Warnings: Warning 1292 Truncated incorrect net_retry_count value: '0' @@ -114,18 +118,22 @@ SELECT @@session.net_retry_count; SET @@session.net_retry_count = 65530.34; ERROR 42000: Incorrect argument type to variable 'net_retry_count' SET @@session.net_retry_count = 6555015425; +Warnings: +Warning 1292 Truncated incorrect net_retry_count value: '6555015425' SELECT @@session.net_retry_count; @@session.net_retry_count -6555015425 +4294967295 SET @@session.net_retry_count = 4294967296; +Warnings: +Warning 1292 Truncated incorrect net_retry_count value: '4294967296' SELECT @@session.net_retry_count; @@session.net_retry_count -4294967296 +4294967295 SET @@session.net_retry_count = test; ERROR 42000: Incorrect argument type to variable 'net_retry_count' SELECT @@session.net_retry_count; @@session.net_retry_count -4294967296 +4294967295 '#------------------FN_DYNVARS_111_06-----------------------#' SELECT @@global.net_retry_count = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES diff --git a/mysql-test/suite/sys_vars/r/progress_report_time_basic.result b/mysql-test/suite/sys_vars/r/progress_report_time_basic.result index 8436ee699e2..a50dbca2062 100644 --- a/mysql-test/suite/sys_vars/r/progress_report_time_basic.result +++ b/mysql-test/suite/sys_vars/r/progress_report_time_basic.result @@ -38,7 +38,8 @@ select @@global.progress_report_time; set session progress_report_time=cast(-1 as unsigned int); Warnings: Warning 1105 Cast to unsigned converted negative integer to it's positive complement +Warning 1292 Truncated incorrect progress_report_time value: '18446744073709551615' select @@session.progress_report_time; @@session.progress_report_time -18446744073709551615 +4294967295 SET @@global.progress_report_time = @start_global_value; diff --git a/mysql-test/suite/sys_vars/r/query_cache_limit_basic_64.result b/mysql-test/suite/sys_vars/r/query_cache_limit_basic_64.result index 3125ee4a415..074075dd2f7 100644 --- a/mysql-test/suite/sys_vars/r/query_cache_limit_basic_64.result +++ b/mysql-test/suite/sys_vars/r/query_cache_limit_basic_64.result @@ -38,18 +38,22 @@ SELECT @@global.query_cache_limit; @@global.query_cache_limit 0 SET @@global.query_cache_limit = 4294967296; +Warnings: +Warning 1292 Truncated incorrect query_cache_limit value: '4294967296' SELECT @@global.query_cache_limit; @@global.query_cache_limit -4294967296 +4294967295 SET @@global.query_cache_limit = 10240022115; +Warnings: +Warning 1292 Truncated incorrect query_cache_limit value: '10240022115' SELECT @@global.query_cache_limit; @@global.query_cache_limit -10240022115 +4294967295 SET @@global.query_cache_limit = 10000.01; ERROR 42000: Incorrect argument type to variable 'query_cache_limit' SELECT @@global.query_cache_limit; @@global.query_cache_limit -10240022115 +4294967295 SET @@global.query_cache_limit = -1024; Warnings: Warning 1292 Truncated incorrect query_cache_limit value: '-1024' @@ -57,25 +61,27 @@ SELECT @@global.query_cache_limit; @@global.query_cache_limit 0 SET @@global.query_cache_limit = 42949672950; +Warnings: +Warning 1292 Truncated incorrect query_cache_limit value: '42949672950' SELECT @@global.query_cache_limit; @@global.query_cache_limit -42949672950 +4294967295 SET @@global.query_cache_limit = ON; ERROR 42000: Incorrect argument type to variable 'query_cache_limit' SELECT @@global.query_cache_limit; @@global.query_cache_limit -42949672950 +4294967295 SET @@global.query_cache_limit = 'test'; ERROR 42000: Incorrect argument type to variable 'query_cache_limit' SELECT @@global.query_cache_limit; @@global.query_cache_limit -42949672950 +4294967295 '#-------------------FN_DYNVARS_131_05----------------------------#' SET @@session.query_cache_limit = 0; ERROR HY000: Variable 'query_cache_limit' is a GLOBAL variable and should be set with SET GLOBAL SELECT @@query_cache_limit; @@query_cache_limit -42949672950 +4294967295 '#----------------------FN_DYNVARS_131_06------------------------#' SELECT @@global.query_cache_limit = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES diff --git a/mysql-test/suite/sys_vars/r/query_cache_min_res_unit_basic_64.result b/mysql-test/suite/sys_vars/r/query_cache_min_res_unit_basic_64.result index 8028098c3c5..91166b676d9 100644 --- a/mysql-test/suite/sys_vars/r/query_cache_min_res_unit_basic_64.result +++ b/mysql-test/suite/sys_vars/r/query_cache_min_res_unit_basic_64.result @@ -46,6 +46,8 @@ SELECT @@global.query_cache_min_res_unit; @@global.query_cache_min_res_unit 512 SET @@global.query_cache_min_res_unit = 4294967296; +Warnings: +Warning 1292 Truncated incorrect query_cache_min_res_unit value: '4294967296' SELECT @@global.query_cache_min_res_unit; @@global.query_cache_min_res_unit 4294967296 @@ -65,25 +67,27 @@ SELECT @@global.query_cache_min_res_unit; @@global.query_cache_min_res_unit 512 SET @@global.query_cache_min_res_unit = 42949672950; +Warnings: +Warning 1292 Truncated incorrect query_cache_min_res_unit value: '42949672950' SELECT @@global.query_cache_min_res_unit; @@global.query_cache_min_res_unit -42949672952 +4294967296 SET @@global.query_cache_min_res_unit = ON; ERROR 42000: Incorrect argument type to variable 'query_cache_min_res_unit' SELECT @@global.query_cache_min_res_unit; @@global.query_cache_min_res_unit -42949672952 +4294967296 SET @@global.query_cache_min_res_unit = 'test'; ERROR 42000: Incorrect argument type to variable 'query_cache_min_res_unit' SELECT @@global.query_cache_min_res_unit; @@global.query_cache_min_res_unit -42949672952 +4294967296 '#-------------------FN_DYNVARS_132_05----------------------------#' SET @@session.query_cache_min_res_unit = 0; ERROR HY000: Variable 'query_cache_min_res_unit' is a GLOBAL variable and should be set with SET GLOBAL SELECT @@query_cache_min_res_unit; @@query_cache_min_res_unit -42949672952 +4294967296 '#----------------------FN_DYNVARS_132_06------------------------#' SELECT @@global.query_cache_min_res_unit = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES diff --git a/mysql-test/suite/sys_vars/r/range_alloc_block_size_basic_64.result b/mysql-test/suite/sys_vars/r/range_alloc_block_size_basic_64.result index ef91e91ca86..26b32b56e57 100644 --- a/mysql-test/suite/sys_vars/r/range_alloc_block_size_basic_64.result +++ b/mysql-test/suite/sys_vars/r/range_alloc_block_size_basic_64.result @@ -86,17 +86,17 @@ Warnings: Warning 1292 Truncated incorrect range_alloc_block_size value: '42949672951' SELECT @@global.range_alloc_block_size; @@global.range_alloc_block_size -42949671936 +4294966272 SET @@global.range_alloc_block_size = 65530.34; ERROR 42000: Incorrect argument type to variable 'range_alloc_block_size' SELECT @@global.range_alloc_block_size; @@global.range_alloc_block_size -42949671936 +4294966272 SET @@global.range_alloc_block_size = test; ERROR 42000: Incorrect argument type to variable 'range_alloc_block_size' SELECT @@global.range_alloc_block_size; @@global.range_alloc_block_size -42949671936 +4294966272 SET @@session.range_alloc_block_size = 0; Warnings: Warning 1292 Truncated incorrect range_alloc_block_size value: '0' @@ -112,14 +112,16 @@ SELECT @@session.range_alloc_block_size; SET @@session.range_alloc_block_size = 65530.34; ERROR 42000: Incorrect argument type to variable 'range_alloc_block_size' SET @@session.range_alloc_block_size = 4294967296; +Warnings: +Warning 1292 Truncated incorrect range_alloc_block_size value: '4294967296' SELECT @@session.range_alloc_block_size; @@session.range_alloc_block_size -4294967296 +4294966272 SET @@session.range_alloc_block_size = test; ERROR 42000: Incorrect argument type to variable 'range_alloc_block_size' SELECT @@session.range_alloc_block_size; @@session.range_alloc_block_size -4294967296 +4294966272 '#------------------FN_DYNVARS_137_06-----------------------#' SELECT @@global.range_alloc_block_size = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES diff --git a/mysql-test/suite/sys_vars/r/slave_transaction_retries_basic_64.result b/mysql-test/suite/sys_vars/r/slave_transaction_retries_basic_64.result index 9bb422905b4..86a760a5386 100644 --- a/mysql-test/suite/sys_vars/r/slave_transaction_retries_basic_64.result +++ b/mysql-test/suite/sys_vars/r/slave_transaction_retries_basic_64.result @@ -39,9 +39,11 @@ SELECT @@global.slave_transaction_retries; @@global.slave_transaction_retries 4294967295 SET @@global.slave_transaction_retries = 2147483649*2; +Warnings: +Warning 1292 Truncated incorrect slave_transaction_retries value: '4294967298' SELECT @@global.slave_transaction_retries; @@global.slave_transaction_retries -4294967298 +4294967295 SET @@global.slave_transaction_retries = 4294967295; SELECT @@global.slave_transaction_retries; @@global.slave_transaction_retries @@ -61,9 +63,11 @@ SELECT @@global.slave_transaction_retries; @@global.slave_transaction_retries 0 SET @@global.slave_transaction_retries = 2147483649*2147483649; +Warnings: +Warning 1292 Truncated incorrect slave_transaction_retries value: '4611686022722355201' SELECT @@global.slave_transaction_retries; @@global.slave_transaction_retries -4611686022722355201 +4294967295 SET @@global.slave_transaction_retries = 65530.34; ERROR 42000: Incorrect argument type to variable 'slave_transaction_retries' SET @@global.slave_transaction_retries = '100'; diff --git a/mysql-test/suite/sys_vars/r/transaction_alloc_block_size_basic_64.result b/mysql-test/suite/sys_vars/r/transaction_alloc_block_size_basic_64.result index 3c958439231..a7afc334ba1 100644 --- a/mysql-test/suite/sys_vars/r/transaction_alloc_block_size_basic_64.result +++ b/mysql-test/suite/sys_vars/r/transaction_alloc_block_size_basic_64.result @@ -82,7 +82,7 @@ Warnings: Warning 1292 Truncated incorrect transaction_alloc_block_size value: '123456789201' SELECT @@global.transaction_alloc_block_size; @@global.transaction_alloc_block_size -123456788480 +4294966272 SET @@global.transaction_alloc_block_size = ON; ERROR 42000: Incorrect argument type to variable 'transaction_alloc_block_size' SET @@global.transaction_alloc_block_size = OFF; @@ -114,7 +114,7 @@ Warnings: Warning 1292 Truncated incorrect transaction_alloc_block_size value: '12345678901' SELECT @@session.transaction_alloc_block_size; @@session.transaction_alloc_block_size -12345678848 +4294966272 SET @@session.transaction_alloc_block_size = ON; ERROR 42000: Incorrect argument type to variable 'transaction_alloc_block_size' SET @@session.transaction_alloc_block_size = OFF; |