I found this code:
stmt.executeUpdate("create table master (id identity)");
stmt.executeUpdate("create table detail (id identity,
master_id bigint"
+", constraint detail_master_fk foreign key (master_id)
references master (id) on delete cascade)");
stmt.executeUpdate("alter table detail alter column master_id
bigint");
stmt.executeUpdate("insert into master values (0)");
stmt.executeUpdate("insert into detail values (0,0)");
stmt.executeUpdate("delete from master where id=0");
throwing an exception:
Table TEMP_TABLE_2_0 not found; SQL statement:
DELETE FROM PUBLIC.TEMP_TABLE_2_0 WHERE MASTER_ID=? [42102-79]
The snippet works if you remove the alter statement.
This is strange because the alter statement does not in fact change
anything.
Is it a bug?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
