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 h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
