View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004151 | SymmetricDS | Bug | public | 2019-11-21 02:16 | 2023-05-31 17:00 |
| Reporter | j.mackay@backinmotion.com.au | Assigned To | emiller | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.11.0 | ||||
| Target Version | 3.14.8 | Fixed in Version | 3.14.8 | ||
| Summary | 0004151: MSSQL DDL ERROR: View / function / stored procedure | ||||
| Description | MSSQL DDL error when attempting to alter or delete Views, Functions & Stored Procedures that don't exist on the target server. | ||||
| Tags | ddl/schema | ||||
|
|
Does symmetric even sync views / functions / stored procedures? If not they should be removed from the sym_on_ddl database trigger. |
|
SymmetricDS: 3.14 0a8f84e9 2023-05-31 16:46:03 evan-miller-jumpmind Details Diff |
0004151: Detected and prevented some errors when syncing DDLand an object is unexpectedly missing or present (also covers issue 0002260) |
Affected Issues 0002260, 0004151 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDatabasePlatform.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/IDatabasePlatform.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/sql/AbstractSqlTemplate.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/sql/ISqlTemplate.java | Diff File | ||
| mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriter.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/MsSql2000DatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/MsSqlJdbcSqlTemplate.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/oracle/OracleDatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/oracle/OracleJdbcSqlTemplate.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/postgresql/PostgreSqlDatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/postgresql/PostgreSqlJdbcSqlTemplate.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/sql/JdbcSqlTemplate.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-11-21 02:16 | j.mackay@backinmotion.com.au | New Issue | |
| 2019-11-21 02:30 | j.mackay@backinmotion.com.au | Note Added: 0001639 | |
| 2022-08-02 19:42 | elong | Tag Attached: ddl/schema | |
| 2022-09-06 18:37 | emiller | Status | new => confirmed |
| 2023-05-31 16:40 | emiller | Relationship added | related to 0002260 |
| 2023-05-31 16:46 | emiller | Assigned To | => emiller |
| 2023-05-31 16:46 | emiller | Status | confirmed => resolved |
| 2023-05-31 16:46 | emiller | Resolution | open => fixed |
| 2023-05-31 16:46 | emiller | Fixed in Version | => 3.14.8 |
| 2023-05-31 17:00 | Changeset attached | => SymmetricDS 3.14 0a8f84e9 | |
| 2023-07-19 12:58 | admin | Status | resolved => closed |