View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004737 | SymmetricDS | Improvement | public | 2020-12-30 21:08 | 2021-01-11 13:47 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.5 | ||||
| Target Version | 3.12.6 | Fixed in Version | 3.12.6 | ||
| Summary | 0004737: Parameter for create or alter syntax | ||||
| Description | Allow user to turn off the "create or alter" syntax used on SQL-Server 2016 or newer. This parameter could apply to other platforms, so we'll name it trigger.allow.create.or.replace=true. Useful because some versions of SQL-Server 2016 appear to have a bug with the following error message: ERROR [server] [TriggerRouterService] [server-sync-triggers-1] Failed to create triggers for mytable org.jumpmind.db.sql.SqlException: There is already an object named 'SYM_ON_I_FOR_MYTBL_SRVR' in the database. | ||||
| Tags | dialect: sql-server | ||||
|
SymmetricDS: 3.12 c8931bce 2020-12-30 21:12:35 Details Diff |
0004737: Parameter for create or alter syntax |
Affected Issues 0004737 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/ClientSymmetricEngine.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql/MsSql2008SymmetricDialect.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql/MsSql2016SymmetricDialect.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql/MsSql2016TriggerTemplate.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql/MsSqlSymmetricDialect.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/ParameterConstants.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractSymmetricDialect.java | Diff File | ||
| mod - symmetric-core/src/main/resources/symmetric-default.properties | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/mssql/MsSql2016DdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/sql/SqlTemplateSettings.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/AbstractJdbcDdlReader.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/JdbcDatabasePlatformFactory.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/MsSql2016DatabasePlatform.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-12-30 21:08 | elong | New Issue | |
| 2020-12-30 21:08 | elong | Status | new => assigned |
| 2020-12-30 21:08 | elong | Assigned To | => elong |
| 2020-12-30 21:08 | elong | Tag Attached: dialect: sql-server | |
| 2020-12-30 21:12 | elong | Status | assigned => resolved |
| 2020-12-30 21:12 | elong | Resolution | open => fixed |
| 2020-12-30 21:12 | elong | Fixed in Version | => 3.12.6 |
| 2020-12-30 22:00 | admin | Changeset attached | => SymmetricDS 3.12 c8931bce |
| 2021-01-11 13:47 | admin | Status | resolved => closed |