View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001517 | Database Workbench v5 | Data Import & Export | public | 2017-09-15 10:53 | 2017-10-27 12:38 |
| Reporter | Martijn Tonies | Assigned To | Martijn Tonies | ||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | ||
| Fixed in Version | 5.3.4 | ||||
| Summary | 0001517: Export data to SQL UPDATE fails for multi-column primary keys | ||||
| Description | Export data to SQL UPDATE fails for multi-column primary keys | ||||
| Steps To Reproduce | Where a table has a compound primary key (e.g. in the Users table it is LocationId and UserId) and one selects “Export Resultset to clipboard as UPDATE…”, the resulting SQL WHERE clause looks like: WHERE LocationId = 0, UserId = 1; Note the comma separating the conditions, should be “AND”: WHERE LocationId = 0 AND UserId = 1; | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2017-09-15 10:53 | Martijn Tonies | New Issue | |
| 2017-09-15 12:56 | Martijn Tonies | Status | new => resolved |
| 2017-09-15 12:56 | Martijn Tonies | Fixed in Version | => 5.3.4 |
| 2017-09-15 12:56 | Martijn Tonies | Resolution | open => fixed |
| 2017-09-15 12:56 | Martijn Tonies | Assigned To | => Martijn Tonies |
| 2017-10-27 12:38 | Martijn Tonies | Status | resolved => closed |
