Re: MySQL and foreign-key support

[prev] [thread] [next] [lurker] [Date index for 2006/10/19]

* Aaron Crane <hateful@xxxxxxxxxx.xx.xx> [2006-10-19 14:20]:
> MySQL still, after all these years, has a whole host of
> arbitrary limitations (like the limits on key length, and the
> inability to use TEXT columns in a foreign key, and the lack of
> recursion in stored functions). And there are still important
> features missing, whatever table engine you use (like CHECK
> constraints, and deferred constraint checking).

Not only those, but it will also still silently coerce data into
compliance with constraints, like silently truncating values on
INSERT and successfully performing the insertion instead of
rejecting the query.

"NO, YOU PIECE OF EXCREMENT, THESE WERE *NOT* SUPPOSED TO BE
ACCEPTED!" (Four days of checking records and cleaning up the
data ensue. Arrrrgh. *writhe*)

In compassionate hate,
-- 
Aristotle Pagaltzis // <http://plasmasturm.org/>;

• MySQL and foreign-key support Aaron Crane 13:16 on 19 Oct 2006
  • Re: MySQL and foreign-key support A. Pagaltzis 18:31 on 19 Oct 2006
    • David Cantrell 19:08 on 23 Oct 2006
      • too deep to show
  • David King 18:35 on 19 Oct 2006

Generated at 16:01 on 02 Nov 2006 by mariachi 0.52