View Issue Details

IDProjectCategoryView StatusLast Update
0002078Database Workbench v6MySQL Modulepublic2022-11-22 11:00
ReporterMartijn Tonies Assigned ToMartijn Tonies  
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionfixed 
Product Version5.8.3 
Fixed in Version6.1.4 
Summary0002078: Commenting statement can result in faulty statement type detection and query handling
DescriptionWhen trying a select before a delete in the SQL Editor against a MariaDb database, then commenting out the select and putting the delete on a line below the select, Database Workbench gives an error message saying that it was surprised no rows were returned. The rows are deleted and autocommitted without any information about this.

It surprised me since I'm used to being told how many rows are deleted and have the option to rollback or commit.

Without the commented select line things works as expected.
just try running something like

-- select a.*
delete a
from a
join b on a.b_id =
where = 'Thomas Steinmaurer'

in the SQL Editor against a MySQL or MariaDb database
TagsNo tags attached.


There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2022-10-24 11:18 Martijn Tonies New Issue
2022-10-25 10:53 Martijn Tonies Assigned To => Martijn Tonies
2022-10-25 10:53 Martijn Tonies Status new => resolved
2022-10-25 10:53 Martijn Tonies Resolution open => fixed
2022-10-25 10:53 Martijn Tonies Fixed in Version => 6.1.4
2022-11-22 11:00 Martijn Tonies Status resolved => closed