View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002078 | Database Workbench v6 | MySQL Module | public | 2022-10-24 11:18 | 2022-11-22 11:00 |
| Reporter | Martijn Tonies | Assigned To | Martijn Tonies | ||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | ||
| Product Version | 5.8.3 | ||||
| Fixed in Version | 6.1.4 | ||||
| Summary | 0002078: Commenting statement can result in faulty statement type detection and query handling | ||||
| 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. 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. | ||||
| 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 |
