View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005966 | SymmetricDS | Improvement | public | 2023-08-31 19:04 | 2023-08-31 20:21 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.14.9 | ||||
| Target Version | 3.14.10 | Fixed in Version | 3.14.10 | ||
| Summary | 0005966: SQLAnywhere support for stream row | ||||
| Description | SQLAnywhere platform does not support stream row when this option is set on the trigger. This needs to be supported. I will add it into the SQL Anywhere version 12 (and later) trigger template since that is what version of SQL Anywhere database docker that I have available. | ||||
| Steps To Reproduce | 1. Set up SQLAnywhere with a table as a source 2. Define trigger for this table to stream row. 3. Set up synchronization to another node for this table. 4. Insert and update records. 5. Check sym_data for captured records. 6. sym_data records should have event_type of 'R' but they will have 'U' and 'I' instead. | ||||
| Tags | dialect: sql anywhere, trigger | ||||
|
|
Patch provided here: https://downloads.jumpmind.com/symmetricds/patches/3.14/patch-0005966.jar Customer needs to upgrade to 3.14.9 first, then apply patch. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2023-08-31 19:04 | pmarzullo | New Issue | |
| 2023-08-31 19:04 | pmarzullo | Status | new => assigned |
| 2023-08-31 19:04 | pmarzullo | Assigned To | => pmarzullo |
| 2023-08-31 19:04 | pmarzullo | Tag Attached: dialect: sql anywhere | |
| 2023-08-31 19:04 | pmarzullo | Tag Attached: trigger | |
| 2023-08-31 19:07 | pmarzullo | Description Updated | View Revisions |
| 2023-08-31 20:00 | pmarzullo | Changeset attached | => SymmetricDS 3.14 332c84c9 |
| 2023-08-31 20:21 | pmarzullo | Status | assigned => resolved |
| 2023-08-31 20:21 | pmarzullo | Resolution | open => fixed |
| 2023-08-31 20:21 | pmarzullo | Fixed in Version | => 3.14.10 |
| 2023-08-31 20:21 | pmarzullo | Note Added: 0002377 | |
| 2023-10-27 20:06 | admin | Status | resolved => closed |