> alter table A add constraint fk_a_b foreign key (FOO, BAR) references B > fails silently if there is no unique constraint on B.FOO and B.BAR.
Interesting syntax... Specifically because it seems to severely corrupt the database meta data. You should report this to HSQLDB > So sorry to spam the list with what is fundamentally an HSQL issue, but the > resultant JOOQ codegen did make me wonder. No worries. Thanks for the update. Cheers Lukas
