Bugzilla – Attachment 48157 Details for
Bug 36546
Internal HSQLDB 1.8 fails to cascade updates through multiple paths and deletions through some cyclic structures
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
Stack overflow
stack overflow.txt (text/plain), 813 bytes, created by
ribotb
on 2011-06-19 02:40:26 UTC
(
hide
)
Description:
Stack overflow
Filename:
MIME Type:
Creator:
ribotb
Created:
2011-06-19 02:40:26 UTC
Size:
813 bytes
patch
obsolete
>-- DDL to create the tables > >create table d_node ( > node_name character varying(10) not null, > parent_node character varying(10), > constraint pk_node primary key (node_name), > constraint fk_node foreign key (parent_node) > references d_node (node_name) > on update cascade on delete cascade > ); > > >-- **** Test update >insert into d_node (node_name, parent_node) values ('NodeA', null); >insert into d_node (node_name, parent_node) values ('NodeB', 'NodeA'); >update d_node set parent_node='NodeB' where node_name='NodeA'; > >-- **** Test deletion with cascading deletions on deletes >delete from d_node; >insert into d_node (node_name, parent_node) values ('NodeA', 'NodeA'); >insert into d_node (node_name, parent_node) values ('NodeB', 'NodeA'); >delete from d_node where node_name='NodeA';
<b>You cannot view the attachment while viewing its details because your browser does not support IFRAMEs. <a href="attachment.cgi?id=48157">View the attachment on a separate page</a>.</b>
View Attachment As Raw
Actions:
View
Attachments on
bug 36546
:
48156
| 48157