View Issue Details

IDProjectCategoryView StatusLast Update
0003537SymmetricDSImprovementpublic2019-02-11 16:46
ReportervibhorejairathAssigned Topmarzullo 
Priorityhigh 
Status closedResolutionfixed 
Product Version3.8.34 
Target Version3.9.17Fixed in Version3.9.17 
Summary0003537: initial load create: Cascade Delete rule is not syncing as part of the create DDL
DescriptionSymmetric 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 ReproduceRegister 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
TagsNo tags attached.

Relationships

has duplicate 0003409 closed Cascade clause is not being exported in the SQL DDL when syncing table DDL. 

Activities

vibhorejairath

2018-05-01 22:01

reporter  

Screen Shot Central Node.png (731,760 bytes)
Screen Shot Store Node.png (398,900 bytes)

vibhorejairath

2018-05-04 09:19

reporter   ~0001177

Any updates on the ticket.

vibhorejairath

2018-05-15 21:02

reporter   ~0001184

Kindly provide guidance as this is causing issue in production now

elong

2018-05-16 12:49

developer   ~0001185

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?

vibhorejairath

2018-05-16 13:59

reporter   ~0001186

That is correct, It is happening during initial load

pmarzullo

2019-02-04 16:22

developer   ~0001389

Also fixed in 3.10.

Related Changesets

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

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

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

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

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

Issue History

Date Modified Username Field Change
2018-05-01 22:01 vibhorejairath New Issue
2018-05-01 22:01 vibhorejairath File Added: Screen Shot Central Node.png
2018-05-01 22:01 vibhorejairath File Added: Screen Shot Store Node.png
2018-05-04 09:19 vibhorejairath Note Added: 0001177
2018-05-15 21:02 vibhorejairath Note Added: 0001184
2018-05-16 12:49 elong Note Added: 0001185
2018-05-16 13:59 vibhorejairath Note Added: 0001186
2018-10-17 15:38 hanes Category Bug => Improvement
2018-10-17 15:38 hanes Target Version => 3.9.15
2018-10-17 15:39 hanes Status new => acknowledged
2018-10-31 14:20 admin Target Version 3.9.15 => 3.9.16
2018-12-05 14: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 14:58 hanes Relationship added has duplicate 0003409
2019-01-23 10:46 pmarzullo Assigned To => pmarzullo
2019-01-23 10:46 pmarzullo Status acknowledged => assigned
2019-01-23 10:48 pmarzullo Target Version 3.9.16 => 3.9.17
2019-02-04 15:00 Changeset attached => SymmetricDS 3.9 7ea58960
2019-02-04 16:00 Changeset attached => SymmetricDS 3.10 6b4d6106
2019-02-04 16:22 pmarzullo Status assigned => resolved
2019-02-04 16:22 pmarzullo Resolution open => fixed
2019-02-04 16:22 pmarzullo Fixed in Version => 3.9.17
2019-02-04 16:22 pmarzullo Note Added: 0001389
2019-02-06 10:00 Changeset attached => SymmetricDS 3.10 886645a9
2019-02-06 17:00 Changeset attached => SymmetricDS 3.9 e56ce719
2019-02-11 16:46 admin Status resolved => closed