View Issue Details

IDProjectCategoryView StatusLast Update
0002124SymmetricDSImprovementpublic2021-08-13 18:34
Reporterchenson Assigned Tochenson  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.7.0 
Target Version3.7.3Fixed in Version3.7.3 
Summary0002124: Support foreign keys in ddl builder for sqlite
DescriptionSupport foreign keys in ddl builder for sqlite. Sqlite only supports embedded foreign key syntax.

This is fine for table create, but when a fk is altered or removed embedded foreign keys don't work. The ddl builder needs to recognize that a table must be rebuilt.
TagsNo tags attached.

Relationships

has duplicate 0001385 resolvedchenson dbimport fails to create SQLite tables with foreign key restraints 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: master 35a4ef9d

2015-01-21 15:49:35

chenson

Details Diff
0002124: Support foreign keys in ddl builder for sqlite Affected Issues
0002124
mod - symmetric-db/src/main/java/org/jumpmind/db/alter/ModelComparator.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/sqlite/SqliteDdlBuilder.java Diff File
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/sqlite/SqliteDdlReader.java Diff File

Issue History

Date Modified Username Field Change
2015-01-07 19:34 chenson New Issue
2015-01-13 19:45 chenson Target Version 3.7.1 =>
2015-01-21 20:50 chenson Fixed in Version => 3.7.3
2015-01-21 20:50 chenson Target Version => 3.7.3
2015-01-21 20:50 chenson Status new => resolved
2015-01-21 20:50 chenson Resolution open => fixed
2015-01-21 20:50 chenson Assigned To => chenson
2015-01-21 21:00 chenson Changeset attached => SymmetricDS trunk r9302
2015-01-28 14:03 chenson Status resolved => closed
2015-07-31 01:49 chenson Changeset attached => SymmetricDS master 35a4ef9d
2021-08-13 18:34 rudiejd Relationship added has duplicate 0001385