Multiple key columns lead to data corruption or data loss

Description

None

Environment

I selected two primary keys in table. See the pictures.

Activity

Show:
Carlos Ruiz
December 7, 2013, 5:09 PM

Anna, just one column can be key column, to define a composite primary key you need to define all columns as parent key and do not define a key column for that table.

I think is worthy to open a bug (or change the subject on this) to add a validation to forbid multiple key columns.

Regards,

Carlos Ruiz

Anna Fadeeva
December 7, 2013, 5:21 PM

OK, Carlos.
I think that better change the subject on this.

Hiep Lq
February 14, 2019, 5:57 PM

hi , maybe we create a wiki page to note all modify like this one.

it help people can verify old database and correct it follow that change

example this one, can add a note and a query to find out table have more than one column is key

Carlos Ruiz
February 14, 2019, 6:10 PM

Hi , yes, a wiki collecting potential inconsistencies sounds good.

However, this specific case is unlikely in a prod database, the data problem would have been discovered early on any test. But if you want to document it that sounds fine.

Regards,

Carlos Ruiz

Assignee

Carlos Ruiz

Reporter

Anna Fadeeva

Labels

Tested By

None

Components

Fix versions

Affects versions

Priority

Major
Configure