View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006012 | SymmetricDS | Bug | public | 2023-10-09 15:42 | 2023-10-09 17:00 |
| Reporter | emiller | Assigned To | emiller | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.15.0 | ||||
| Target Version | 3.15.1 | Fixed in Version | 3.15.1 | ||
| Summary | 0006012: Do not attempt to "create or alter" triggers on SQL Server 2016 RTM | ||||
| Description | SQL 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. | ||||
| Tags | dialect: sql-server | ||||
|
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 | ||
| 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 |