You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
/*
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 */
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
The text was updated successfully, but these errors were encountered: