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 |