View Issue Details

IDProjectCategoryView StatusLast Update
0005966SymmetricDSImprovementpublic2023-08-31 20:21
Reporterpmarzullo Assigned Topmarzullo  
Status closedResolutionfixed 
Product Version3.14.9 
Target Version3.14.10Fixed in Version3.14.10 
Summary0005966: SQLAnywhere support for stream row
DescriptionSQLAnywhere 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 Reproduce1. 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.
Tagsdialect: sql anywhere, trigger



2023-08-31 20:21

developer   ~0002377

Patch provided here:

Customer needs to upgrade to 3.14.9 first, then apply patch.

Related Changesets

SymmetricDS: 3.14 332c84c9

2023-08-31 19:19:08


Details Diff
0005966: SQLAnywhere support for stream row Affected Issues
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/sqlanywhere/ Diff File

Issue History

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