View Issue Details

IDProjectCategoryView StatusLast Update
0006011SymmetricDSBugpublic2023-10-09 17:00
Reporteremiller Assigned Toemiller  
Status closedResolutionfixed 
Product Version3.14.0 
Target Version3.14.10Fixed in Version3.14.10 
Summary0006011: Do not attempt to "create or alter" triggers on SQL Server 2016 RTM
DescriptionSQL Server 2016 RTM (with no service packs installed) does not support the "create or alter" syntax. Microsoft added support for this syntax in the first service pack (SP1). Currently, if the trigger.allow.create.or.replace parameter is enabled, SymmetricDS will use this syntax for SQL Server 2016 regardless of whether SP1 is installed. Instead, it should check the SQL Server version during startup and avoid using this syntax if SP1 is not present, even if the trigger.allow.create.or.replace parameter is enabled.
Tagsdialect: sql-server


related to 0006012 closedemiller Do not attempt to "create or alter" triggers on SQL Server 2016 RTM 


There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.14 265f2948

2023-10-09 16:36:18


Details Diff
0006011: Prevented SymmetricDS from using 'create or alter' syntax on SQL Server 2016 RTM Affected Issues
mod - symmetric-core/src/main/resources/ Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/ Diff File

Issue History

Date Modified Username Field Change
2023-10-09 15:41 emiller New Issue
2023-10-09 15:41 emiller Status new => assigned
2023-10-09 15:41 emiller Assigned To => emiller
2023-10-09 15:42 emiller Tag Attached: dialect: sql-server
2023-10-09 15:42 emiller Issue cloned: 0006012
2023-10-09 15:42 emiller Relationship added related to 0006012
2023-10-09 16:36 emiller Status assigned => resolved
2023-10-09 16:36 emiller Resolution open => fixed
2023-10-09 16:36 emiller Fixed in Version => 3.14.10
2023-10-09 17:00 Changeset attached => SymmetricDS 3.14 265f2948
2023-10-27 20:06 admin Status resolved => closed