View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003537 | SymmetricDS | Improvement | public | 2018-05-02 02:01 | 2019-02-11 21:46 |
| Reporter | vibhorejairath | Assigned To | pmarzullo | ||
| Priority | high | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.8.34 | ||||
| Target Version | 3.9.17 | Fixed in Version | 3.9.17 | ||
| Summary | 0003537: initial load create: Cascade Delete rule is not syncing as part of the create DDL | ||||
| Description | Symmetric is not syncing the Cascade delete rule from Central node to Store node level and hence cascade delete is not working at the store level. | ||||
| Steps To Reproduce | Register the store node to central node and allow schema and data to sync with store node. Open the table that has cascade rule set in Explore mode in Central and Store node and compare the delete rule for the same table. See the attached files for the screen shots taken for the same table in Central and Store nodes | ||||
| Tags | No tags attached. | ||||
| has duplicate | 0003409 | closed | Cascade clause is not being exported in the SQL DDL when syncing table DDL. |
|
|
|
|
|
Any updates on the ticket. |
|
|
Kindly provide guidance as this is causing issue in production now |
|
|
The issue is that it is missing the "on delete cascade" clause when creating application tables during the initial load on a PostgreSQL database. Did I understand correctly? |
|
|
That is correct, It is happening during initial load |
|
|
Also fixed in 3.10. |
|
SymmetricDS: 3.9 7ea58960 2019-02-04 14:17:24 Philip Marzullo Details Diff |
0003537: initial load create: Cascade Delete rule is not syncing as part of the create DDL |
Affected Issues 0003537 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/io/DatabaseXmlUtil.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/model/ForeignKey.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/ase/AseDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/db2/Db2DdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/derby/DerbyDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/firebird/FirebirdDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/greenplum/GreenplumDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/informix/InformixDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/interbase/InterbaseDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/mssql/MsSql2000DdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/nuodb/NuoDbDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/oracle/OracleDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/raima/RaimaDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/redshift/RedshiftDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/sqlanywhere/SqlAnywhereDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/tibero/TiberoDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/voltdb/VoltDbDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/test/java/org/jumpmind/db/platform/AbstractDdlBuilderTest.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/AbstractJdbcDdlReader.java | Diff File | ||
|
SymmetricDS: 3.10 886645a9 2019-02-04 14:17:24 Philip Marzullo Details Diff |
0003537: initial load create: Cascade Delete rule is not syncing as part of the create DDL |
Affected Issues 0003537 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/io/DatabaseXmlUtil.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/model/ForeignKey.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDdlBuilder.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/AbstractJdbcDdlReader.java | Diff File | ||
|
SymmetricDS: 3.10 6b4d6106 2019-02-04 15:32:39 Philip Marzullo Details Diff |
0003537: initial load create: Cascade Delete rule is not syncing as part of the create DDL |
Affected Issues 0003537 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/io/DatabaseXmlUtil.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/model/ForeignKey.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/ase/AseDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/db2/Db2DdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/derby/DerbyDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/firebird/FirebirdDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/greenplum/GreenplumDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/informix/InformixDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/interbase/InterbaseDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/mssql/MsSql2000DdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/nuodb/NuoDbDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/oracle/OracleDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/raima/RaimaDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/redshift/RedshiftDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/sqlanywhere/SqlAnywhereDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/tibero/TiberoDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/voltdb/VoltDbDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/test/java/org/jumpmind/db/platform/AbstractDdlBuilderTest.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/AbstractJdbcDdlReader.java | Diff File | ||
|
SymmetricDS: 3.9 e56ce719 2019-02-06 16:16:12 Philip Marzullo Details Diff |
0003537: initial load create: Cascade Delete rule is not syncing as part of the create DDL |
Affected Issues 0003537 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/io/DatabaseXmlUtil.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/model/ForeignKey.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDdlBuilder.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/AbstractJdbcDdlReader.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-05-02 02:01 | vibhorejairath | New Issue | |
| 2018-05-02 02:01 | vibhorejairath | File Added: Screen Shot Central Node.png | |
| 2018-05-02 02:01 | vibhorejairath | File Added: Screen Shot Store Node.png | |
| 2018-05-04 13:19 | vibhorejairath | Note Added: 0001177 | |
| 2018-05-16 01:02 | vibhorejairath | Note Added: 0001184 | |
| 2018-05-16 16:49 | elong | Note Added: 0001185 | |
| 2018-05-16 17:59 | vibhorejairath | Note Added: 0001186 | |
| 2018-10-17 19:38 | hanes | Category | Bug => Improvement |
| 2018-10-17 19:38 | hanes | Target Version | => 3.9.15 |
| 2018-10-17 19:39 | hanes | Status | new => acknowledged |
| 2018-10-31 18:20 | admin | Target Version | 3.9.15 => 3.9.16 |
| 2018-12-05 19:52 | hanes | Summary | Delete rule are not syncing from central node to store node => initial load create: Cascade Delete rule is not syncing as part of the create DDL |
| 2018-12-05 19:58 | hanes | Relationship added | has duplicate 0003409 |
| 2019-01-23 15:46 | pmarzullo | Assigned To | => pmarzullo |
| 2019-01-23 15:46 | pmarzullo | Status | acknowledged => assigned |
| 2019-01-23 15:48 | pmarzullo | Target Version | 3.9.16 => 3.9.17 |
| 2019-02-04 20:00 | Changeset attached | => SymmetricDS 3.9 7ea58960 | |
| 2019-02-04 21:00 | Changeset attached | => SymmetricDS 3.10 6b4d6106 | |
| 2019-02-04 21:22 | pmarzullo | Status | assigned => resolved |
| 2019-02-04 21:22 | pmarzullo | Resolution | open => fixed |
| 2019-02-04 21:22 | pmarzullo | Fixed in Version | => 3.9.17 |
| 2019-02-04 21:22 | pmarzullo | Note Added: 0001389 | |
| 2019-02-06 15:00 | Changeset attached | => SymmetricDS 3.10 886645a9 | |
| 2019-02-06 22:00 | Changeset attached | => SymmetricDS 3.9 e56ce719 | |
| 2019-02-11 21:46 | admin | Status | resolved => closed |