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....


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.

Reply via email to