MySQL Bugs: #86682: The 'Stop Script Execution on Errors' will still stop if turned off

Bug #86682	The 'Stop Script Execution on Errors' will still stop if turned off
Submitted:	13 Jun 2017 17:12	Modified:	14 Jun 2017 14:14
Reporter:	Lundy Lim	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Workbench	Severity:	S5 (Performance)
Version:	6.3.9	OS:	MacOS (macOS 10.12.x Sierra x86_64)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
----[For better reports, please attach the log file after submitting. You can find it in /Users/llim/Library/Application Support/MySQL/Workbench/log/wb.log]

The application won't continue after running into an error. I am trying to bulk insert into a table and when it hits a duplicate primary key, it just stops and I have turned the feature, Stop Script Execution on Errors, in the Query menu.

How to repeat:
Attempt to insert multiple lines with duplicates already in the table.

Suggested fix:
make it work like it does on a windows machine.

Thank you for the bug report. I couldn't repeat on below environment:

MySQL Workbench Community (GPL) for Mac OS X version 6.3.9 CE build 10690321 (64 bit)
Configuration Directory: /Users/miguel/Library/Application Support/MySQL/Workbench
Data Directory: /Applications/MySQLWorkbench.app/Contents/Resources
Cairo Version: 1.10.2
OS: macOS 10.12.x Sierra x86_64
CPU: 4x Intel(R) Core(TM) i5-3210M CPU @ 2.50GHz - 16.00GiB RAM
No video adapter info available

Just so anyone else looking at this years later knows, this is a known, extremely dangerous bug in MySQL Workbench. The "Stop Script Execution On Errors" option in the UI seems to have its logic reversed and does the exact opposite of what you think it does. When enabled, it actually continues script execution on errors, and vice versa!

See bug report here: https://bugs.mysql.com/bug.php?id=86476