View Issue Details

IDProjectCategoryView StatusLast Update
0003815SymmetricDSBugpublic2018-12-03 15:00
Reporterjosh-a-hicksAssigned Tojosh-a-hicks 
Prioritylow 
Status resolvedResolutionfixed 
Product Version3.9.15 
Target Version3.9.16Fixed in Version3.9.16 
Summary0003815: Create tables with a source foreign key in a non default catalog and/or schema to a target with default catalog/schema
DescriptionThe create table logic included the foreign key catalog and/or schema information if it was in a non default catalog and/or schema on the source. This causes an issue on the target if the catalog and/or schema do match the source or the defaults are used (no catalog schema provided).

Example:

myCatalog.mySchema.parent (id, description)
myCatalog.mySchema.child(id, parent_id) -- where parent_id is a FK to the parent table.

This would pass along a create table definition with the source myCatalog.mySchema in the FK definition at the target even if the default catalog/schema were to be used at the target and fail.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.9 96440056

2018-12-03 14:08:58

josh-a-hicks

Details Diff
0003815: Create tables with a source foreign key in a non default
catalog and/or schema to a target with default catalog/schema

0003815
mod - symmetric-db/src/main/java/org/jumpmind/db/model/Table.java Diff File

Issue History

Date Modified Username Field Change
2018-12-03 14:08 josh-a-hicks New Issue
2018-12-03 14:08 josh-a-hicks Status new => assigned
2018-12-03 14:08 josh-a-hicks Assigned To => josh-a-hicks
2018-12-03 14:09 josh-a-hicks Status assigned => resolved
2018-12-03 14:09 josh-a-hicks Resolution open => fixed
2018-12-03 14:09 josh-a-hicks Fixed in Version => 3.9.16
2018-12-03 15:00 josh-a-hicks Changeset attached => SymmetricDS 3.9 96440056