View Issue Details

IDProjectCategoryView StatusLast Update
0003714SymmetricDSBugpublic2018-09-10 16:00
ReporterelongAssigned Toelong 
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.9.0 
Target Version3.9.14Fixed in Version3.9.14 
Summary0003714: Stream row with large number of columns on DB2
DescriptionOn DB2: Stream row doesn't work for a table with more than 250 columns. Stream row does not handle updates to primary key or tables with no primary key.

Some background: On DB2, after a table with no primary key has more than 250 columns, we fail to add an update trigger. The insert and delete columns succeed. To capture 250 columns, we need to turn off "capture old data", so the trigger text references the 250 old key columns and 250 new columns. (Does that mean the limit of column references is 500?) To work around what appears to be a column reference limitation, we want to use "stream row" and capture only the pk columns.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.9 6e8820b3

2018-09-10 15:14:50

admin

Details Diff
0003714: Stream row with large number of columns on DB2
0003714
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/db2/Db2TriggerTemplate.java Diff File

SymmetricDS: 3.9 f89429e3

2018-09-10 15:33:42

admin

Details Diff
0003714: Stream row with large number of columns on DB2
0003714
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/db2/Db2zOsTriggerTemplate.java Diff File

Issue History

Date Modified Username Field Change
2018-09-10 14:59 elong New Issue
2018-09-10 14:59 elong Status new => assigned
2018-09-10 14:59 elong Assigned To => elong
2018-09-10 15:30 elong Status assigned => resolved
2018-09-10 15:30 elong Resolution open => fixed
2018-09-10 15:30 elong Fixed in Version => 3.9.14
2018-09-10 16:00 admin Changeset attached => SymmetricDS 3.9 f89429e3
2018-09-10 16:00 admin Changeset attached => SymmetricDS 3.9 6e8820b3