View Issue Details

IDProjectCategoryView StatusLast Update
0002052Database Workbench v5MySQL Modulepublic2022-10-24 11:16
ReporterSvein Erling Tysvær Assigned ToMartijn Tonies  
PrioritynormalSeverityminorReproducibilityhave not tried
Status feedbackResolutionopen 
Product Version5.7.6 
Summary0002052: Error, though still deleted
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.
Steps To ReproduceJust try running something like

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

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

Activities

Martijn Tonies

2022-10-24 11:15

administrator   ~0000579

Last edited: 2022-10-24 11:16

Hello Svein,

If you select the first line and use ctrl+shift+M, it will use the multi-line comment, then it should work.

It has to do with faulty statement type detection.

That said, version 5 won't get any more updates, I'll create another issue for this in the DBW 6 section.

Issue History

Date Modified Username Field Change
2022-09-16 11:47 Svein Erling Tysvær New Issue
2022-10-24 11:15 Martijn Tonies Assigned To => Martijn Tonies
2022-10-24 11:15 Martijn Tonies Status new => feedback
2022-10-24 11:15 Martijn Tonies Note Added: 0000579
2022-10-24 11:16 Martijn Tonies Note Edited: 0000579