Bug #106892 Run SQL Script: error executing SQL script
Submitted: 1 Apr 2022 15:39 Modified: 2 Apr 2022 10:22
Reporter: Richard Scherck Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:8.0.28 OS:MacOS
Assigned to: CPU Architecture:Any

[1 Apr 2022 15:39] Richard Scherck
The Run SQL script functionality from the File menu immediately fails with the error 

Error executing SQL script.'>' not supported between instances of 'NoneType' and 'int'

11:37:36 [ERR][run_script.py:work:149]: Unexpected exception running script: '>' not supported between instances of 'NoneType' and 'int'
Traceback (most recent call last):
  File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/run_script.py", line 138, in work
    self.importer.import_script(file, default_schema = schema, default_charset = charset)
  File "/Applications/MySQLWorkbench.app/Contents/Resources/libraries/workbench/client_utils.py", line 277, in import_script
    self.report_progress("Preparing...", None, None)
  File "/Applications/MySQLWorkbench.app/Contents/Resources/plugins/run_script.py", line 81, in report_progress
    if total > 0:
TypeError: '>' not supported between instances of 'NoneType' and 'int'

How to repeat:
File -> Run SQL Script

Select .sql file to execute

Click Open

Verify Preview

Click Run

Error message appears
[2 Apr 2022 10:22] MySQL Verification Team
Hello Richard Scherck,

Thank you for the report and feedback.
Verified as described.