View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005556 | SymmetricDS | Bug | public | 2022-10-26 20:30 | 2022-11-30 19:40 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.8.0 | ||||
| Target Version | 3.13.9 | Fixed in Version | 3.13.9 | ||
| Summary | 0005556: 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.13 6f377bb9 2022-10-26 20:28:35 Details Diff |
0005556: SQL-Server capture rows that exceed 4000 characters # Conflicts: # symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractTriggerTemplate.java |
Affected Issues 0005556 |
|
| 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 | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2022-10-26 20:30 | pmarzullo | New Issue | |
| 2022-10-26 20:30 | pmarzullo | Status | new => assigned |
| 2022-10-26 20:30 | pmarzullo | Assigned To | => pmarzullo |
| 2022-10-26 20:30 | pmarzullo | Tag Attached: dialect: sql-server | |
| 2022-10-26 20:30 | pmarzullo | Relationship added | related to 0004168 |
| 2022-10-26 20:32 | pmarzullo | Relationship added | related to 0005557 |
| 2022-10-26 20:47 | pmarzullo | Status | assigned => resolved |
| 2022-10-26 20:47 | pmarzullo | Resolution | open => fixed |
| 2022-10-26 20:47 | pmarzullo | Fixed in Version | => 3.13.9 |
| 2022-10-26 21:00 | pmarzullo | Changeset attached | => SymmetricDS 3.13 6f377bb9 |
| 2022-10-27 14:55 | pmarzullo | Note Added: 0002210 | |
| 2022-11-30 19:40 | admin | Status | resolved => closed |