TRUNCATE problem ...

[Rafal Kedziorski]

hi,

I have this table:

CREATE TABLE `category_tree` (
`category_tree_id` BIGINT NOT NULL AUTO_INCREMENT,
`parent_id` BIGINT,
`mandant_id` SMALLINT NOT NULL,
`partner_id` SMALLINT NOT NULL,
`class_id` VARCHAR ( 32) NOT NULL,
`position` SMALLINT NOT NULL,
`path` VARCHAR (255),
`description` VARCHAR (255) NOT NULL,
#
PRIMARY KEY (`category_tree_id`),
INDEX (`parent_id`),
INDEX (`mandant_id`),
INDEX (`partner_id`),
FOREIGN KEY (`parent_id`)
REFERENCES `category_tree` (`category_tree_id`),
FOREIGN KEY (`mandant_id`)
REFERENCES `mandant` (`mandant_id`),
FOREIGN KEY (`partner_id`)
REFERENCES `partner` (`partner_id`)
) TYPE=InnoDB;
After call:

TRUNCATE TABLE `category_tree`;

I get this error message:

TRUNCATE TABLE `category_tree`
Cannot delete or update a parent row: a foreign key constraint fails

While there is an foreign key on each self. Is this a Bug in MySQL?
Regards,
Rafal
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw