View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003644 | SymmetricDS | Bug | public | 2018-07-23 19:19 | 2018-08-03 14:12 |
| Reporter | mmichalek | Assigned To | mmichalek | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.9.10 | ||||
| Target Version | 3.9.10 | Fixed in Version | 3.9.10 | ||
| Summary | 0003644: Deleting a trigger associated with an unextracted batch causes invalid CSV | ||||
| Description | The scenario with the demo set: 1) Create a batch that has both item and item_selling_price data in it. 2) Delete the sym_trigger_router and sym_trigger for item_selling_price. 3) Delete the batch file and click "show CSV" on the Pro, or pull the batch again with the community edition. Invalid batch data is generated like this (note there should be a TABLE, declration between the 2 inserts) nodeid,000 binary,BASE64 channel,item batch,81 catalog, schema, table,item keys,ITEM_ID columns,ITEM_ID,NAME insert,"11000002","Yummy Gum2" insert,"11000002","002","0.30","0.20" commit,81 Attempting to load batches like this may result in messages like the following: The number of columns (%d) reported for table '%s' doesn't match up with the token count (%d) data: %s This is the corrected CSV in this case: nodeid,000 binary,BASE64 channel,item batch,81 catalog, schema, table,item keys,ITEM_ID columns,ITEM_ID,NAME insert,"11000002","Yummy Gum2" catalog, schema, table,item_selling_price keys,ITEM_ID,STORE_ID columns,ITEM_ID,STORE_ID,PRICE,COST insert,"11000002","002","0.30","0.20" commit,81 | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-07-23 19:19 | mmichalek | New Issue | |
| 2018-07-23 19:19 | mmichalek | Status | new => assigned |
| 2018-07-23 19:19 | mmichalek | Assigned To | => mmichalek |
| 2018-07-23 19:25 | mmichalek | Status | assigned => resolved |
| 2018-07-23 19:25 | mmichalek | Resolution | open => fixed |
| 2018-07-23 19:25 | mmichalek | Fixed in Version | => 3.9.10 |
| 2018-07-23 20:00 | mmichalek | Changeset attached | => SymmetricDS 3.9 fe8f0439 |
| 2018-08-03 14:12 | chenson | Status | resolved => closed |