Ivan,
currently InnoDB allows a NULL in the child column only if there is a NULL
in the parent column.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com for the online manual and latest news on InnoDB
...
Hi.
I am using MySQL 3.23.44-MAX. with InnoDB
I have create two tables (one of them parent, other child).
All seems Ok. But when I am trying to insert new record into the table I am getting key
violation.
It happened when I am trying insert null value into field that have foreign key.
(column c