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
SET TERM ^ ;
CREATE TRIGGER TABLE1_BIU FOR TABLE1
ACTIVE BEFORE INSERT OR UPDATE POSITION 0
AS
begin
new.FIELD1 = 0;
end
^
SET TERM ; ^
GRANT UPDATE (FIELD1, FIELD2) ON TABLE1 TO TRIGGER TABLE1_BIU;
ALTER TABLE TABLE1 ALTER COLUMN FIELD2 TO FIELD3;
Then try b/r and get exception: "Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements.
action cancelled by trigger (1) to preserve data integrity.
could not find column for GRANT"
The text was updated successfully, but these errors were encountered:
The bug is that RDB$USER_PRIVILEGES still contains row for FIELD2 after last statement (renaming FIELD2 into FIELD3).
At restore time this row can't be inserted back to the RDB$USER_PRIVILEGES.
Submitted by: arni (arni)
CREATE TABLE TABLE1(
FIELD1 INTEGER,
FIELD2 INTEGER
);
SET TERM ^ ;
CREATE TRIGGER TABLE1_BIU FOR TABLE1
ACTIVE BEFORE INSERT OR UPDATE POSITION 0
AS
begin
new.FIELD1 = 0;
end
^
SET TERM ; ^
GRANT UPDATE (FIELD1, FIELD2) ON TABLE1 TO TRIGGER TABLE1_BIU;
ALTER TABLE TABLE1 ALTER COLUMN FIELD2 TO FIELD3;
Then try b/r and get exception: "Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements.
action cancelled by trigger (1) to preserve data integrity.
could not find column for GRANT"
The text was updated successfully, but these errors were encountered: