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
CREATE TRIGGER TV1 FOR V1
ACTIVE BEFORE UPDATE
AS
BEGIN
IF (new.VID = 0) THEN
EXCEPTION EXA;
ELSE
EXCEPTION EXB;
END^
/* here is all Ok, trigger has been created */
COMMIT WORK;
Unsuccessful execution caused by system error that does not preclude successful execution of
subsequent statements.
bad BLR -- invalid stream.
Now I can do only rollback. Also I must note that trigger was created, i.e. if I try to
repeat CREATE TRIGGER, there will be a message 'trying to store duplicate ...'.
Removing one of exception call will remove "bad BLR" message too.
And, creating same trigger on view without union will not have this error.
Tested on FB 1.0.0 builds 555 (RC1), 608 and 641 for Windows, W2K Prof, SP2.
The text was updated successfully, but these errors were encountered:
Submitted by: @ibaseru
SFID: 489764#
Submitted By: kdv
Again bug with view containing union and triggers.
This was found testing bug
[ #489762 ] trigger on view with union receive nulls
Trigger with 2 exceptions can't be created on view with union.
/* begin script */
CREATE TABLE A (ID INTEGER);
CREATE VIEW V1 (VID) AS
SELECT ID FROM A
UNION ALL
SELECT ID FROM A;
/* UNION or UNION ALL does not makes difference for the bug */
CREATE EXCEPTION EXA 'A';
CREATE EXCEPTION EXB 'B';
COMMIT WORK;
set term ^;
CREATE TRIGGER TV1 FOR V1
ACTIVE BEFORE UPDATE
AS
BEGIN
IF (new.VID = 0) THEN
EXCEPTION EXA;
ELSE
EXCEPTION EXB;
END^
/* here is all Ok, trigger has been created */
COMMIT WORK;
Unsuccessful execution caused by system error that does not preclude successful execution of
subsequent statements.
bad BLR -- invalid stream.
Now I can do only rollback. Also I must note that trigger was created, i.e. if I try to
repeat CREATE TRIGGER, there will be a message 'trying to store duplicate ...'.
Removing one of exception call will remove "bad BLR" message too.
And, creating same trigger on view without union will not have this error.
Tested on FB 1.0.0 builds 555 (RC1), 608 and 641 for Windows, W2K Prof, SP2.
The text was updated successfully, but these errors were encountered: