View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003815 | SymmetricDS | Bug | public | 2018-12-03 19:08 | 2018-12-24 17:41 |
| Reporter | josh-a-hicks | Assigned To | josh-a-hicks | ||
| Priority | low | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.9.15 | ||||
| Target Version | 3.9.16 | Fixed in Version | 3.9.16 | ||
| Summary | 0003815: Create tables with a source foreign key in a non default catalog and/or schema to a target with default catalog/schema | ||||
| Description | The 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. | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-12-03 19:08 | josh-a-hicks | New Issue | |
| 2018-12-03 19:08 | josh-a-hicks | Status | new => assigned |
| 2018-12-03 19:08 | josh-a-hicks | Assigned To | => josh-a-hicks |
| 2018-12-03 19:09 | josh-a-hicks | Status | assigned => resolved |
| 2018-12-03 19:09 | josh-a-hicks | Resolution | open => fixed |
| 2018-12-03 19:09 | josh-a-hicks | Fixed in Version | => 3.9.16 |
| 2018-12-03 20:00 | josh-a-hicks | Changeset attached | => SymmetricDS 3.9 96440056 |
| 2018-12-24 17:41 | chenson | Status | resolved => closed |