View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0002052||Database Workbench v5||MySQL Module||public||2022-09-16 11:47||2022-10-24 11:16|
|Reporter||Svein Erling Tysvær||Assigned To||Martijn Tonies|
|Priority||normal||Severity||minor||Reproducibility||have not tried|
|Summary||0002052: Error, though still deleted|
|Description||When 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 Reproduce||Just try running something like|
-- select a.*
join b on a.b_id = b.id
where b.name = 'Thomas Steinmaurer'
in the SQL Editor against a MySQL or MariaDb database
|Tags||No tags attached.|
Last edited: 2022-10-24 11:16
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.
|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|