View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005557 | SymmetricDS | Bug | public | 2022-10-26 20:32 | 2022-11-30 19:49 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.8.0 | ||||
| Target Version | 3.14.3 | Fixed in Version | 3.14.3 | ||
| Summary | 0005557: SQL-Server capture rows that exceed 4000 characters | ||||
| Description | Add sym_trigger.use_capture_lobs support for SQL-Server. Convert to LOB with: cast(N'' as nvarchar(max)) + create table t1 ( id int not null primary key, f1 nvarchar(100) not null, f2 nvarchar(4000) null, f3 nvarchar(200) null, created datetime2 not null, modified datetime2 null ) https://sourceforge.net/p/symmetricds/discussion/739236/thread/99b3f8d861/ | ||||
| Steps To Reproduce | 1. Create a table in SQL Server with a column that is defined as varchar(4000) at both source and target, and several more columns. 2. Insert a record with 4000 characters in the column. 3. The target staging file will have truncated data and cause a protocol error. | ||||
| Tags | dialect: sql-server | ||||
|
SymmetricDS: 3.14 df14dccd 2022-10-26 20:28:35 Details Diff |
0005557: SQL-Server capture rows that exceed 4000 characters # Conflicts: # symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractTriggerTemplate.java # Conflicts: # symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql/MsSqlTriggerTemplate.java |
Affected Issues 0005557 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql/MsSqlTriggerTemplate.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractTriggerTemplate.java | Diff File | ||
|
SymmetricDS: 3.14 ff04a5ed 2022-10-27 15:01:39 Details Diff |
0005557: SQL-Server capture rows that exceed 4000 characters |
Affected Issues 0005557 |
|
| mod - symmetric-assemble/src/asciidoc/configuration/table-triggers.ad | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2022-10-26 20:32 | pmarzullo | New Issue | |
| 2022-10-26 20:32 | pmarzullo | Status | new => assigned |
| 2022-10-26 20:32 | pmarzullo | Assigned To | => pmarzullo |
| 2022-10-26 20:32 | pmarzullo | Tag Attached: dialect: sql-server | |
| 2022-10-26 20:32 | pmarzullo | Relationship added | related to 0004168 |
| 2022-10-26 20:32 | pmarzullo | Relationship added | related to 0005556 |
| 2022-10-26 20:48 | pmarzullo | Status | assigned => resolved |
| 2022-10-26 20:48 | pmarzullo | Resolution | open => fixed |
| 2022-10-26 20:48 | pmarzullo | Fixed in Version | => 3.14.3 |
| 2022-10-26 21:00 | pmarzullo | Changeset attached | => SymmetricDS 3.14 df14dccd |
| 2022-10-27 14:54 | pmarzullo | Note Added: 0002209 | |
| 2022-10-27 16:00 | pmarzullo | Changeset attached | => SymmetricDS 3.14 ff04a5ed |
| 2022-11-30 19:49 | admin | Status | resolved => closed |