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 |