View Issue Details

Related ChangesetsJump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0002874SymmetricDSBugpublic2016-10-21 14:042016-11-08 16:59
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.8.7 
Target Version3.8.8Fixed in Version3.8.8 
Summary0002874: [SQL Server] When capture changes only is enabled, pk is not compared and potential syntax error
DescriptionWhen capture changes only parameter for the triggers is enabled, the trigger syntax can get an error if the table has no primary key defined.

org.jumpmind.db.sql.SqlException: Incorrect syntax near ')'.

Changes to primary key fields are not compared, so changes to primary key fields are not captured.
Steps To Reproduce1. Use SQL Server
2. Set trigger.update.capture.changed.data.only.enabled=true
3. Setup trigger on table without a primary key
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.8 c4c7dd05

2016-10-21 10:11:35

admin

Details Diff 		0002874: [SQL Server] When capture changes only is enabled, pk is not
compared and potential syntax error		 Affected Issues
0002874
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql/MsSqlTriggerTemplate.java Diff File

Issue History

Date Modified Username Field Change
2016-10-21 14:04 elong New Issue
2016-10-21 14:04 elong Status new => assigned
2016-10-21 14:04 elong Assigned To => elong
2016-10-21 14:14 elong Status assigned => resolved
2016-10-21 14:14 elong Fixed in Version => 3.8.8
2016-10-21 14:14 elong Resolution open => fixed
2016-10-21 15:00 admin Changeset attached => SymmetricDS 3.8 c4c7dd05
2016-11-08 16:59 chenson Status resolved => closed