MySQL Forums
Forum List  »  NDB clusters

Re: ndb-7.5.5 : Foreignkey contraint failure returning incomplete error message
Posted by: Murali Annamneni
Date: November 30, 2017 08:49AM

Hi Martin,
Thanks for the quick reply.
I am using ndb-7.5.5 (I posted full version information in my original post)
Seems like it was fixed in ndb-7.6 !
Here are my table definitions -
1) Parent table:
CREATE TABLE `resource` (
`original_resource_id` varchar(255) NOT NULL,
`id` binary(16) NOT NULL,
.......
PRIMARY KEY (`id`),
.....
) ENGINE=ndbcluster DEFAULT CHARSET=utf8

2)Child table;
CREATE TABLE `metric` (
`id` binary(16) NOT NULL,
`resource_id` binary(16) DEFAULT NULL,
.........
PRIMARY KEY (`id`),
UNIQUE KEY `uniq_metric0resource_id0name` (`resource_id`,`name`),
CONSTRAINT `fk_metric_resource_id_resource_id` FOREIGN KEY (`resource_id`) REFERENCES `resource` (`id`) ON DELETE SET NULL ON UPDATE NO ACTION
) ENGINE=ndbcluster DEFAULT CHARSET=utf8

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: ndb-7.5.5 : Foreignkey contraint failure returning incomplete error message
82
November 30, 2017 08:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.