H2 v1.4.196 (latest)
I am hitting an issue where a foreign key is defined on a column of a table
with a cascade delete constraint.
alter table port
add constraint fk_port_network
foreign key (network_fk)
references network
on delete cascade on update cascade;
A row is left in a situation where the value of that field contains a value
that does not exist in the referenced table. Seems like a clear violation
of SQL ANSI standard.
I expect the immediate question I will be asked how to reproduce... this
happens occasionally so it is not easily reproduced. So I'll answer that
question right now - I have no way of reproducing it at will....
Pointers?
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
