EVOLUTION-MANAGER

Edit File: log_result_errors_basic.result

SET @start_global_value = @@global.log_result_errors; SELECT @start_global_value; @start_global_value 0 SET @start_session_value = @@session.log_result_errors; SELECT @start_session_value; @start_session_value 0 '#--------------------FN_DYNVARS_067_01-------------------------#' SET @@global.log_result_errors = 1; SET @@global.log_result_errors = DEFAULT; SELECT @@global.log_result_errors; @@global.log_result_errors 0 SET @@session.log_result_errors = 2; SET @@session.log_result_errors = DEFAULT; SELECT @@session.log_result_errors; @@session.log_result_errors 0 '#--------------------FN_DYNVARS_067_02-------------------------#' SET @@global.log_result_errors = DEFAULT; SELECT @@global.log_result_errors = 0; @@global.log_result_errors = 0 1 SET @@session.log_result_errors = DEFAULT; SELECT @@session.log_result_errors = 0; @@session.log_result_errors = 0 1 '#--------------------FN_DYNVARS_067_03-------------------------#' SET @@global.log_result_errors = 0; SELECT @@global.log_result_errors; @@global.log_result_errors 0 SET @@global.log_result_errors = 1; SELECT @@global.log_result_errors; @@global.log_result_errors 1 SET @@global.log_result_errors = 3; SELECT @@global.log_result_errors; @@global.log_result_errors 3 '#--------------------FN_DYNVARS_067_04-------------------------#' SET @@session.log_result_errors = 0; SELECT @@session.log_result_errors; @@session.log_result_errors 0 SET @@session.log_result_errors = 1; SELECT @@session.log_result_errors; @@session.log_result_errors 1 SET @@session.log_result_errors = 3; SELECT @@session.log_result_errors; @@session.log_result_errors 3 '#------------------FN_DYNVARS_067_05-----------------------#' SET @@global.log_result_errors = 4; Warnings: Warning 1292 Truncated incorrect log_result_errors value: '4' SELECT @@global.log_result_errors; @@global.log_result_errors 3 SET @@global.log_result_errors = 65530.34; ERROR 42000: Incorrect argument type to variable 'log_result_errors' SELECT @@global.log_result_errors; @@global.log_result_errors 3 SET @@global.log_result_errors = test; ERROR 42000: Incorrect argument type to variable 'log_result_errors' SELECT @@global.log_result_errors; @@global.log_result_errors 3 SET @@session.log_result_errors = -2; Warnings: Warning 1292 Truncated incorrect log_result_errors value: '-2' SELECT @@session.log_result_errors; @@session.log_result_errors 0 SET @@session.log_result_errors = 65530.34; ERROR 42000: Incorrect argument type to variable 'log_result_errors' SET @@session.log_result_errors = test; ERROR 42000: Incorrect argument type to variable 'log_result_errors' SELECT @@session.log_result_errors; @@session.log_result_errors 0 '#------------------FN_DYNVARS_067_06-----------------------#' SELECT @@global.log_result_errors = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='log_result_errors'; @@global.log_result_errors = VARIABLE_VALUE 1 '#------------------FN_DYNVARS_067_07-----------------------#' SELECT @@session.log_result_errors = VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='log_result_errors'; @@session.log_result_errors = VARIABLE_VALUE 1 '#------------------FN_DYNVARS_067_08-----------------------#' SET @@global.log_result_errors = TRUE; SELECT @@global.log_result_errors; @@global.log_result_errors 1 SET @@global.log_result_errors = FALSE; SELECT @@global.log_result_errors; @@global.log_result_errors 0 '#---------------------FN_DYNVARS_067_09----------------------#' SET @@session.log_result_errors = 1; SET @@global.log_result_errors = 2; SELECT @@log_result_errors = @@global.log_result_errors; @@log_result_errors = @@global.log_result_errors 0 '#---------------------FN_DYNVARS_067_10----------------------#' SET @@session.log_result_errors = 1; SET @@global.log_result_errors = 2; SELECT @@log_result_errors = @@local.log_result_errors; @@log_result_errors = @@local.log_result_errors 1 SELECT @@local.log_result_errors = @@session.log_result_errors; @@local.log_result_errors = @@session.log_result_errors 1 SET @@session.log_result_errors = 1; create table t1(a int primary key); insert into t1 values(1); insert into t1 values(1); ERROR 23000: Duplicate entry '1' for key 'PRIMARY' insert ignore into t1 values(1); Warnings: Warning 1062 Duplicate entry '1' for key 'PRIMARY' SET @@session.log_result_errors = 3; insert ignore into t1 values(1); Warnings: Warning 1062 Duplicate entry '1' for key 'PRIMARY' drop table t1; SET @@global.log_result_errors = @start_global_value; SELECT @@global.log_result_errors; @@global.log_result_errors 0 SET @@session.log_result_errors = @start_session_value; SELECT @@session.log_result_errors; @@session.log_result_errors 0 [WARN RESULT] affected_rows: 0 status: 2 warning_count: 1 [WARN RESULT] Level: Warning Code: 1292 'Truncated incorrect log_result_errors value: '4'' [ERROR RESULT] Code: 1232 'Incorrect argument type to variable 'log_result_errors'' [ERROR RESULT] Code: 1232 'Incorrect argument type to variable 'log_result_errors'' [ERROR RESULT] Code: 1062 'Duplicate entry '1' for key 'PRIMARY'' [WARN RESULT] affected_rows: 0 status: 2 warning_count: 1 [WARN RESULT] Level: Warning Code: 1062 'Duplicate entry '1' for key 'PRIMARY''