Bug #21701 | Error Msg Incorrect: On delete set null on not null column | ||
---|---|---|---|
Submitted: | 17 Aug 2006 17:28 | Modified: | 28 Aug 2006 14:49 |
Reporter: | Jared Smith | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server | Severity: | S4 (Feature request) |
Version: | 5.0.24 | OS: | Linux (Redhat Linux AS 4) |
Assigned to: | CPU Architecture: | Any |
[17 Aug 2006 17:28]
Jared Smith
[28 Aug 2006 10:00]
Valeriy Kravchuk
Thank you for a problem report. In fact, you got information about the real error, 150. Try to execute "perror 150", and you'll get: MySQL error code 150: Foreighn key constraint is incorrectly formed Isn't it descriptive enough?
[28 Aug 2006 14:49]
Jared Smith
Yes that error looks sufficient I wasn't aware of the perror command and expected the that the error I saw was the only error. I changed the status to close since that description does sufficiently cover this case. Thanks for clearing things up and letting me know about the perror command.