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 |
| Status | feedback | Resolution | open | ||
| Product Version | 5.7.6 | ||||
| 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.* 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 | ||||
| Tags | No tags attached. | ||||
|
|
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. |
| 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 |
