View Issue Details

IDProjectCategoryView StatusLast Update
0001620Database Workbench v5Diagrammingpublic2018-06-27 11:14
ReporterStephen Lappin Assigned To 
Status newResolutionopen 
Product Version5.4.2 
Summary0001620: Check Model should report FK data type discrepancies
DescriptionOn running Check Model, validation messages are generated when col for FK is not defined.

I would expect it also to report FKs where there is a discrepancy in column data types.

Integer vs BigInt
BigInt UNSIGNED vs BigInt

Currently, such discrepancies only come to light when you execute the generated DDL, and MariaDB/MySQL halts with an error
Steps To ReproduceCreated table_a with PK (id BigInt UNSIGNED NOT NULL AUTO_INCREMENT).
Created table_b with a column (table_a_id BigInt NOT NULL)
Create FK fk_table_b_table_a FOREIGN KEY (table_a_id )
  REFERENCES table_a (id)
Execute Check Model - no validation errors reported
Generate DDL
Run DDL - errors creating FK.
TagsNo tags attached.


There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2018-06-27 11:14 Stephen Lappin New Issue