Ticket #1118 (closed defect: fixed)

Opened 13 months ago

Last modified 10 months ago

detect_relations is not fully implemented

Reported by: colnector Owned by: jwage
Priority: minor Milestone:
Component: Schema Files Version: 0.11.0
Severity: Keywords:
Cc: Has Test:
Status: Has Patch:

Description (last modified by colnector) (diff)

Seems the implemention for detect_relations: true is still a bit incomplete.

The foreign key field still has to be defined completely in its table and if the type differs from the other table (for example it's defined as unsigned but we forgot to mention it in the other table) we would get a SQL error. This is from MySQL:

SQLSTATE[HY000]: General error: 1005 Can't create table '.proj#sql-

bc8_b8.frm' (errno: 150). Failing Query: ALTER TABLE some_table ADD FOREIGN KEY (user_id) REFERENCES user(id)

TEST CASE - simply remove the type definition from any sample that does work.

Change History

Changed 13 months ago by colnector

  • description modified (diff)

Changed 13 months ago by colnector

  • component changed from Attributes to Schema Files

Changed 13 months ago by jwage

  • status changed from new to closed
  • resolution set to fixed

(In [4517]) fixes #1118 - Added test coverage and fixed.

Changed 10 months ago by anonymous

  • milestone New deleted

Milestone New deleted

Note: See TracTickets for help on using tickets.