(10:54:24 AM) Darren: Furthermore, InnoDB does not recognize or support “inline REFERENCES specifications” (as defined in the SQL standard) where the references are defined as part of the column specification. InnoDB accepts REFERENCES clauses only when specified as part of a separate FOREIGN KEY specification. For other storage engines, MySQL Server parses and ignores foreign key specifications.
(10:54:53 AM) Plumpy: WHAT
(10:54:57 AM) Plumpy: Fuck.
(10:55:00 AM) Darren: yeah
(10:55:21 AM) Darren: MySQL is sure great they way it doesn't bother you with pesky things like an error if it can't do what you ask of it.
(10:55:40 AM) Plumpy: If it threw an error, people might realize how much there was that it couldn't do.
(10:55:45 AM) Plumpy: And that would make people sad.
(10:55:52 AM) Darren: I am sad
4 comments:
LOL!
Um. I have no idea what you're talking about. No idea. =)
I was just writing the code to work around this and I googled "inline REFERENCES specifications" (in quotes)... and the first thing that came up was this blog post containing our conversation. Ha.
Post a Comment