0001620: Check Model should report FK data type discrepancies

ID	Project	Category	View Status	Date Submitted	Last Update

0001620	Database Workbench v5	Diagramming	public	2018-06-27 11:14	2018-06-27 11:14

Reporter	Stephen Lappin	Assigned To
Priority	normal	Severity	minor	Reproducibility	sometimes
Status	new	Resolution	open
Product Version	5.4.2

Summary	0001620: Check Model should report FK data type discrepancies
Description	On 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. E.g. 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 Reproduce	Created 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.
Tags	No tags attached.

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