View Issue Details

IDProjectCategoryView StatusLast Update
0002643SymmetricDSBugpublic2016-07-11 10:23
ReporterelongAssigned Toelong 
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
Product Version3.7.0 
Target Version3.7.35Fixed in Version3.7.35 
Summary0002643: Trigger build fails for varchar(5000) when using mssql.use.ntypes.for.sync parameter
DescriptionOn 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 Reproduce1. Enable parameter mssql.use.ntypes.for.sync=true
2. Create table with varchar(5000)
3. Configure table triggers
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.7 58d2fcd8

2016-06-20 14:49:53

admin

Details Diff
0002643: Trigger build fails for varchar(5000) when using
mssql.use.ntypes.for.sync parameter

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

Issue History

Date Modified Username Field Change
2016-06-20 14:49 elong New Issue
2016-06-20 14:49 elong Status new => assigned
2016-06-20 14:49 elong Assigned To => elong
2016-06-20 14:51 elong Status assigned => resolved
2016-06-20 14:51 elong Fixed in Version => 3.7.35
2016-06-20 14:51 elong Resolution open => fixed
2016-06-20 15:00 admin Changeset attached => SymmetricDS 3.7 58d2fcd8
2016-07-11 10:23 elong Status resolved => closed