View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003684 | SymmetricDS | Bug | public | 2018-08-21 18:24 | 2018-08-31 13:33 |
| Reporter | mmichalek | Assigned To | mmichalek | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.9.12 | ||||
| Target Version | 3.9.13 | Fixed in Version | 3.9.13 | ||
| Summary | 0003684: Load Filter Beanshell variables are not properly scoped | ||||
| Description | Load filter bean shell can see variables from previous rows, whenever that variable name was not overwritten by the current row. Given this DML on the corp with the demo set: update item set name = '1235 updated4' where item_id = 1235; insert into "DEMO-CORP"."PUBLIC"."ITEM" ("ITEM_ID", "NAME") values (1239,'1239 desc'); And this before write load filter on the "item" table: print(table.getName() + ": OLD_NAME/NAME: " + OLD_NAME + "/" + NAME); return NAME; The output showed that the load filter could see the old_name from the update. item: OLD_NAME/NAME: 1235 updated3/1235 updated4 item: OLD_NAME/NAME: 1235 updated3/1239 desc The corrected code produces this output: item: OLD_NAME/NAME: 1235 updated3/1235 updated4 item: OLD_NAME/NAME: void/1239 desc | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-08-21 18:24 | mmichalek | New Issue | |
| 2018-08-21 18:24 | mmichalek | Status | new => assigned |
| 2018-08-21 18:24 | mmichalek | Assigned To | => mmichalek |
| 2018-08-21 19:03 | mmichalek | Status | assigned => resolved |
| 2018-08-21 19:03 | mmichalek | Resolution | open => fixed |
| 2018-08-21 19:03 | mmichalek | Fixed in Version | => 3.9.13 |
| 2018-08-21 20:00 | mmichalek | Changeset attached | => SymmetricDS 3.9 04bed138 |
| 2018-08-31 13:33 | chenson | Status | resolved => closed |