View Issue Details

IDProjectCategoryView StatusLast Update
0001517Database Workbench v5Data Import & Exportpublic2017-10-27 12:38
ReporterMartijn Tonies Assigned ToMartijn Tonies  
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionfixed 
Fixed in Version5.3.4 
Summary0001517: Export data to SQL UPDATE fails for multi-column primary keys
DescriptionExport data to SQL UPDATE fails for multi-column primary keys
Steps To ReproduceWhere 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:

   LocationId = 0,
   UserId = 1;

Note the comma separating the conditions, should be “AND”:

   LocationId = 0 AND
   UserId = 1;
TagsNo tags attached.


There are no notes attached to this issue.

Issue History

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