Bug #113943 If i command delete then insert is executed

• Submitted: 9 Feb 6:38
• Modified: 12 Feb 13:01
• Reporter: MinJeong Kang
• Status: Can't repeat
• Category: MySQL Workbench
• Severity: S7 (Test Cases)
• Version: 8.0.29
• OS: Windows (Microsoft Windows 10 Home)
• CPU Architecture: Any
• Tags: WBBugReporter

[9 Feb 6:38] MinJeong Kang

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.

[12 Feb 13:01] MySQL Verification Team

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