View Issue Details

IDProjectCategoryView StatusLast Update
0006012SymmetricDSBugpublic2023-10-09 17:00
Reporteremiller Assigned Toemiller  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.15.0 
Target Version3.15.1Fixed in Version3.15.1 
Summary0006012: 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

Relationships

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

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.15 131227ad

2023-10-09 16:42:33

evan-miller-jumpmind

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

Issue History

Date Modified Username Field Change
2023-10-09 15:42 emiller New Issue
2023-10-09 15:42 emiller Status new => assigned
2023-10-09 15:42 emiller Assigned To => emiller
2023-10-09 15:42 emiller Tag Attached: dialect: sql-server
2023-10-09 15:42 emiller Issue generated from: 0006011
2023-10-09 15:42 emiller Relationship added related to 0006011
2023-10-09 16:43 emiller Status assigned => resolved
2023-10-09 16:43 emiller Resolution open => fixed
2023-10-09 16:43 emiller Fixed in Version => 3.15.1
2023-10-09 17:00 Changeset attached => SymmetricDS 3.15 131227ad
2023-11-14 21:10 admin Status resolved => closed