Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DB crashes if trigger BU deletes own row [CORE185] #512

Closed
firebird-automations opened this issue Jul 16, 2002 · 5 comments
Closed

DB crashes if trigger BU deletes own row [CORE185] #512

firebird-automations opened this issue Jul 16, 2002 · 5 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: boris00 (boris00)

SFID: 582425#⁠
Submitted By: boris00

Let's crash a DB together!

-------------------------- snipsnap ------------------------

/*
Attention: This test crashes the database.
Error "internal gds software consistency check (wrong record length
(183))"
will be raised
The database can't be used anymore without having it fixed before!
*/

/* Step 1: DDL */

SET SQL DIALECT 3;

CREATE DATABASE 'bstest.gdb' PAGE_SIZE 1024
DEFAULT CHARACTER SET ISO8859_1;

CREATE TABLE "TEST" ("ID" INTEGER NOT NULL
);

COMMIT WORK;
SET AUTODDL OFF;
SET TERM ^ ;

CREATE TRIGGER "TEST_BU" FOR "TEST"
ACTIVE BEFORE UPDATE POSITION 0
AS
BEGIN
delete from "TEST" where http://id=old.id;
END ^

COMMIT WORK ^
SET TERM ; ^

/* Step 2: DML */

insert into "TEST" values (1);
insert into "TEST" values (2);
insert into "TEST" values (3);
insert into "TEST" values (4);
insert into "TEST" values (5);
insert into "TEST" values (6);
commit;

/* fine so far */

update "TEST" set id=-1 where id=1;
rollback; /* error */

====== Test Details ======

Ortiginal test:
https://github.com/FirebirdSQL/fbtcs/blob/master/GTCS/tests/CF_ISQL_28.script

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 10209 ] => Firebird [ 14413 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: No test => Done successfully

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

Test Details: Ortiginal test:
https://github.com/FirebirdSQL/fbtcs/blob/master/GTCS/tests/CF_ISQL_26.script

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

Test Details: Ortiginal test:
https://github.com/FirebirdSQL/fbtcs/blob/master/GTCS/tests/CF_ISQL_26.script

=>

Ortiginal test:
https://github.com/FirebirdSQL/fbtcs/blob/master/GTCS/tests/CF_ISQL_28.script

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants