0004421: Primary key ordering based on the sequence of the PK - SymmetricDS

ID	Project	Category	View Status	Date Submitted	Last Update

0004421	SymmetricDS	Bug	public	2020-06-09 19:05	2022-09-19 14:56

Reporter	josh-a-hicks	Assigned To	josh-a-hicks
Priority	normal
Status	closed	Resolution	fixed
Product Version	3.12.0
Target Version	3.12.1	Fixed in Version	3.12.1

Summary	0004421: Primary key ordering based on the sequence of the PK
Description	If a composite primary key is used and referenced by a FK and the column order is incorrect it will not be able to add the FK constraint. There are no primary or candidate keys in the referenced table
Tags	No tags attached.

SymmetricDS: 3.12 b8aec9f2 2020-06-10 21:09:28 josh-a-hicks Details Diff	0004421: Primary key ordering based on the sequence of the PK	Affected Issues 0004421
	mod - symmetric-db/src/main/java/org/jumpmind/db/io/DatabaseXmlUtil.java	Diff File
	mod - symmetric-db/src/main/java/org/jumpmind/db/model/Column.java	Diff File
	mod - symmetric-db/src/main/java/org/jumpmind/db/model/Table.java	Diff File
	mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/AbstractJdbcDdlReader.java	Diff File
SymmetricDS: 3.12 c6304896 2020-06-15 13:26:10 josh-a-hicks Details Diff	0004421: Primary key ordering based on the sequence of the PK	Affected Issues 0004421
	mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/AbstractJdbcDdlReader.java	Diff File
SymmetricDS: 3.12 9cb5ed89 2020-06-18 11:11:13 josh-a-hicks Details Diff	0004421: Primary key ordering based on the sequence of the PK	Affected Issues 0004421
	mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/AbstractJdbcDdlReader.java	Diff File

Date Modified	Username	Field	Change
2020-06-09 19:05	josh-a-hicks	New Issue
2020-06-09 19:05	josh-a-hicks	Status	new => assigned
2020-06-09 19:05	josh-a-hicks	Assigned To	=> josh-a-hicks
2020-06-11 01:09	josh-a-hicks	Status	assigned => resolved
2020-06-11 01:09	josh-a-hicks	Resolution	open => fixed
2020-06-11 01:09	josh-a-hicks	Fixed in Version	=> 3.12.1
2020-06-18 15:00	josh-a-hicks	Changeset attached	=> SymmetricDS 3.12 c6304896
2020-06-18 15:00	josh-a-hicks	Changeset attached	=> SymmetricDS 3.12 b8aec9f2
2020-06-18 16:00	josh-a-hicks	Changeset attached	=> SymmetricDS 3.12 9cb5ed89
2020-06-24 20:47	admin	Status	resolved => closed
2021-05-19 16:52	elong	Relationship added	related to 0004996
2022-09-19 14:56	elong	Relationship added	related to 0004295

related to	0004996	closed	elong	Table PK column order mismatch with column order can cause errors
related to	0004295	closed	elong	Detect when the order of a primary key changes in order to regenerate it