View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003714 | SymmetricDS | Bug | public | 2018-09-10 18:59 | 2018-09-10 20:00 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | resolved | Resolution | fixed | ||
| Product Version | 3.9.0 | ||||
| Target Version | 3.9.14 | Fixed in Version | 3.9.14 | ||
| Summary | 0003714: Stream row with large number of columns on DB2 | ||||
| Description | On 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. | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.9 6e8820b3 2018-09-10 15:14:50 Details Diff |
0003714: Stream row with large number of columns on DB2 |
Affected Issues 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 Details Diff |
0003714: Stream row with large number of columns on DB2 |
Affected Issues 0003714 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/db2/Db2zOsTriggerTemplate.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-09-10 18:59 | elong | New Issue | |
| 2018-09-10 18:59 | elong | Status | new => assigned |
| 2018-09-10 18:59 | elong | Assigned To | => elong |
| 2018-09-10 19:30 | elong | Status | assigned => resolved |
| 2018-09-10 19:30 | elong | Resolution | open => fixed |
| 2018-09-10 19:30 | elong | Fixed in Version | => 3.9.14 |
| 2018-09-10 20:00 | admin | Changeset attached | => SymmetricDS 3.9 f89429e3 |
| 2018-09-10 20:00 | admin | Changeset attached | => SymmetricDS 3.9 6e8820b3 |