MySQL Bugs: #113943: If i command delete then insert is executed

Bug #113943	If i command delete then insert is executed
Submitted:	9 Feb 2024 6:38	Modified:	12 Feb 2024 13:01
Reporter:	MinJeong Kang	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Workbench	Severity:	S7 (Test Cases)
Version:	8.0.29	OS:	Windows (Microsoft Windows 10 Home)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\alswj\AppData\Roaming\MySQL\Workbench\log\wb.log]

DELETE FROM user WHERE user_id between 249523 and 294125;
when i use above query, but total data count is increased.
And i use SELECT max(user_id) FROM user; this query to figure out data count.

How to repeat:
SELECT max(user_id) FROM gitaehasam.user;

DELETE FROM gitaehasam.user WHERE user_id between 249523 and 294125;

select * from gitaehasam.user WHERE user_id between 200001 and 301850;

DELIMITER $$

DROP PROCEDURE IF EXISTS insertDummyUserData$$
 
CREATE PROCEDURE insertDummyUserData()
BEGIN
    DECLARE i INT DEFAULT 199842
        
    WHILE i <= 200000 DO
        INSERT INTO user(user_id, created_at, modified_at, image_url, name, nick_name, platform, social_id)
          VALUES(i, now(), now(), concat('test', i, 'png'), concat('이름', i), concat('닉네임', i), "KAKAO", concat("social", i));
		set i = i + 1;
		end while;
END$$
DELIMITER $$

CALL insertDummyUserData;

============================================================
Firstly, I used to run procedure until 200,000 count of data.
Secondly, I usesd to run select to figure out working properly.
But, count of data is over 200,000.
So I used to delete.
And then problem is generated.

Hello MinJeong Kang,

Thank you for the bug report.
I tried to reproduce your issue on windows 11 with workbench 8.0.36 using dummy table with DELETE operation but I am not seeing any issues at my end. 
Please check if you have any triggers on table user.
Also, please upgrade to latest version. Thanks.

Regards,
Ashwini Patil