View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004168 | SymmetricDS | Improvement | public | 2019-11-27 17:12 | 2022-11-30 19:34 |
| Reporter | elong | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.8.0 | ||||
| Target Version | 3.12.20 | Fixed in Version | 3.12.20 | ||
| Summary | 0004168: 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.12 8a32ecf1 2022-10-26 20:28:35 Details Diff |
0004168: SQL-Server capture rows that exceed 4000 characters |
Affected Issues 0004168 |
|
| 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 |
|---|---|---|---|
| 2019-11-27 17:12 | elong | New Issue | |
| 2019-11-27 17:14 | elong | Description Updated | View Revisions |
| 2022-08-02 15:12 | elong | Tag Attached: dialect: sql-server | |
| 2022-10-26 20:21 | pmarzullo | Assigned To | => pmarzullo |
| 2022-10-26 20:21 | pmarzullo | Status | new => assigned |
| 2022-10-26 20:24 | pmarzullo | Target Version | => 3.12.20 |
| 2022-10-26 20:24 | pmarzullo | Steps to Reproduce Updated | View Revisions |
| 2022-10-26 20:30 | pmarzullo | Relationship added | related to 0005556 |
| 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.12.20 |
| 2022-10-26 21:00 | pmarzullo | Changeset attached | => SymmetricDS 3.12 8a32ecf1 |
| 2022-10-27 14:56 | pmarzullo | Note Added: 0002211 | |
| 2022-11-30 19:34 | admin | Status | resolved => closed |