ON DELETE CASCADE does not work with the last record of a table

[Fabian Kneubuehl]

I found a subtle bug:

 

In our DB we have a table Faelle and another FPositionen which belongs to
Faelle. I set a constraint ON DELETE CASCADE so that if a record was deleted
from Faelle all related records of FPositionen would also be deleted
(automatically). That works fine! But if I delete the last record of Faelle
all his FPositionen wouldn't be deletet!

 

Regards

Fabian

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina-beta/attachments/20120418/6ae7680a/attachment.html>