[Firebird-devel] [FB-Tracker] Created: (CORE-3293) Error at grants restore for renamed column

[arni (JIRA) <tr...@fi...>]

Error at grants restore for renamed column
------------------------------------------

                 Key: CORE-3293
                 URL: http://tracker.firebirdsql.org/browse/CORE-3293
             Project: Firebird Core
          Issue Type: Bug
          Components: Engine, GBAK
    Affects Versions: 2.5.0
            Reporter: arni
            Priority: Minor


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"

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira