MDEV-21360 debug_dbug pre-test value restoration issues

5 files changed, 10 insertions, 2 deletions

diff --git a/mysql-test/suite/innodb/r/blob-update-debug.result b/mysql-test/suite/innodb/r/blob-update-debug.result
index 1360745b7e6..0d0fc6d5070 100644
--- a/mysql-test/suite/innodb/r/blob-update-debug.result
+++ b/mysql-test/suite/innodb/r/blob-update-debug.result
@@ -7,9 +7,11 @@ insert into t1 values (1, repeat('*', 50000));
 select f1, substring(f2, 1, 40) from t1;
 f1	substring(f2, 1, 40)
 1	****************************************
+set @saved_debug = @@session.debug_dbug;
 set debug_dbug = 'd,row_ins_index_entry_timeout';
 update t1 set f1 = 3;
 select f1, substring(f2, 1, 40) from t1;
 f1	substring(f2, 1, 40)
 3	****************************************
 drop table t1;
+set debug_dbug= @saved_debug;
diff --git a/mysql-test/suite/innodb/r/innodb-stats-initialize-failure.result b/mysql-test/suite/innodb/r/innodb-stats-initialize-failure.result
index ef2d3182b92..b48cfb05a5c 100644
--- a/mysql-test/suite/innodb/r/innodb-stats-initialize-failure.result
+++ b/mysql-test/suite/innodb/r/innodb-stats-initialize-failure.result
@@ -1,4 +1,5 @@
 call mtr.add_suppression("InnoDB: Warning: Index.*");
+set @saved_dbug = @@session.debug_dbug;
 set DEBUG_DBUG='+d,ib_ha_innodb_stat_not_initialized';
 create table t1(a int not null primary key, b int, c int, key(b), key(c)) engine=innodb;
 create procedure innodb_insert_proc (repeat_count int)
@@ -27,6 +28,6 @@ count(1)
 select count(1) from t1 where c between 7 and 787;
 count(1)
 781
-set DEBUG_DBUG=NULL;
 drop procedure innodb_insert_proc;
 drop table t1;
+set debug_dbug= @saved_dbug;
diff --git a/mysql-test/suite/innodb/r/innodb_bug11754376.result b/mysql-test/suite/innodb/r/innodb_bug11754376.result
index b9f2a169a73..a2c1ceed61f 100644
--- a/mysql-test/suite/innodb/r/innodb_bug11754376.result
+++ b/mysql-test/suite/innodb/r/innodb_bug11754376.result
@@ -1,3 +1,5 @@
 CREATE TABLE bug11754376 (c INT) ENGINE=INNODB;
+set @saved_dbug = @@session.debug_dbug;
 SET SESSION DEBUG_DBUG='+d,test_normalize_table_name_low';
 DROP TABLE bug11754376;
+set debug_dbug= @saved_dbug;
diff --git a/mysql-test/suite/innodb/r/innodb_bug56947.result b/mysql-test/suite/innodb/r/innodb_bug56947.result
index 4248013b088..981e08609a2 100644
--- a/mysql-test/suite/innodb/r/innodb_bug56947.result
+++ b/mysql-test/suite/innodb/r/innodb_bug56947.result
@@ -1,5 +1,6 @@
 SET GLOBAL innodb_file_per_table=0;
 create table bug56947(a int not null) engine = innodb;
+set @saved_dbug = @@session.debug_dbug;
 SET DEBUG_DBUG='+d,ib_rebuild_cannot_rename';
 alter table bug56947 add unique index (a);
 ERROR HY000: Got error 11 "xxx" from storage engine InnoDB
@@ -8,3 +9,4 @@ Table	Op	Msg_type	Msg_text
 test.bug56947	check	status	OK
 drop table bug56947;
 SET @@global.innodb_file_per_table=DEFAULT;
+set debug_dbug= @saved_dbug;
diff --git a/mysql-test/suite/innodb/r/innodb_sys_semaphore_waits.result b/mysql-test/suite/innodb/r/innodb_sys_semaphore_waits.result
index 5f14ad9b0d7..73b5f81a76f 100644
--- a/mysql-test/suite/innodb/r/innodb_sys_semaphore_waits.result
+++ b/mysql-test/suite/innodb/r/innodb_sys_semaphore_waits.result
@@ -4,6 +4,7 @@ drop table if exists t1;
 connection con1;
 create table t1 (id integer, x integer) engine = InnoDB;
 insert into t1 values(0, 0);
+set @saved_dbug = @@session.debug_dbug;
 set DEBUG_DBUG='+d,fatal-semaphore-timeout';
 set autocommit=0;
 # Sending query on con1,
@@ -21,6 +22,6 @@ connection default;
 # Waitting for reconnect after mysqld restarts
 # Reconnected after mysqld was successfully restarted
 # Cleaning up before exit
-set DEBUG_DBUG=NULL;
+set debug_dbug = @saved_dbug;
 drop table if exists t1;
 # Clean exit