View Issue Details

IDProjectCategoryView StatusLast Update
0004256SymmetricDSBugpublic2020-01-23 15:42
Reporterpmarzullo Assigned Topmarzullo  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.11.4 
Target Version3.11.4Fixed in Version3.11.4 
Summary0004256: Oracle trigger creates row data and old data when streaming row
DescriptionWhen stream row is turned on, the oracle trigger template still concatenates all rows for row_data and old_data, but these values are not used.
When stream row is turned on, only the primary keys are saved for later querying.
Stream row is turned on for a reason, and a valid reason is that the table is too wide, and causes overflow of the 4000 character limit.

Need to take out the row_data and old_data from the "updateReloadTriggerTemplate" template.
Tagsdialect: oracle, trigger

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.11 00dc7d5a

2020-01-22 11:12:55

Philip Marzullo

Details Diff
0004256: Oracle trigger creates row data and old data when streaming row Affected Issues
0004256
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/oracle/OracleTriggerTemplate.java Diff File

Issue History

Date Modified Username Field Change
2020-01-22 11:11 pmarzullo New Issue
2020-01-22 11:11 pmarzullo Status new => assigned
2020-01-22 11:11 pmarzullo Assigned To => pmarzullo
2020-01-22 11:11 pmarzullo Tag Attached: dialect: oracle
2020-01-22 11:11 pmarzullo Tag Attached: trigger
2020-01-22 11:13 pmarzullo Status assigned => resolved
2020-01-22 11:13 pmarzullo Resolution open => fixed
2020-01-22 11:13 pmarzullo Fixed in Version => 3.11.4
2020-01-22 12:00 Changeset attached => SymmetricDS 3.11 00dc7d5a
2020-01-23 15:42 admin Status resolved => closed