Ticket #1118 (closed defect: fixed)
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
Note: See
TracTickets for help on using
tickets.