View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002643 | SymmetricDS | Bug | public | 2016-06-20 18:49 | 2016-07-11 14:23 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.7.0 | ||||
| Target Version | 3.7.35 | Fixed in Version | 3.7.35 | ||
| Summary | 0002643: Trigger build fails for varchar(5000) when using mssql.use.ntypes.for.sync parameter | ||||
| Description | On SQL-Server, the trigger will fail to build on a table using varchar(5000) when the user has enabled the mssql.use.ntypes.for.sync parameter. The max size for varchar is 8000, while nvarchar is 4000. The trigger template uses a technique of converting to nvarchar of the same size, but it can't go past 4000. When the size is bigger than 4000, use nvarchar(max) instead. | ||||
| Steps To Reproduce | 1. Enable parameter mssql.use.ntypes.for.sync=true 2. Create table with varchar(5000) 3. Configure table triggers | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.7 58d2fcd8 2016-06-20 14:49:53 Details Diff |
0002643: Trigger build fails for varchar(5000) when using mssql.use.ntypes.for.sync parameter |
Affected Issues 0002643 |
|
| 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 |
|---|---|---|---|
| 2016-06-20 18:49 | elong | New Issue | |
| 2016-06-20 18:49 | elong | Status | new => assigned |
| 2016-06-20 18:49 | elong | Assigned To | => elong |
| 2016-06-20 18:51 | elong | Status | assigned => resolved |
| 2016-06-20 18:51 | elong | Fixed in Version | => 3.7.35 |
| 2016-06-20 18:51 | elong | Resolution | open => fixed |
| 2016-06-20 19:00 | admin | Changeset attached | => SymmetricDS 3.7 58d2fcd8 |
| 2016-07-11 14:23 | elong | Status | resolved => closed |