Altering non existing trigger with OLD. variable cause "Column unknown" instead "Trigger not found" ---------------------------------------------------------------------------------------------------
Key: CORE-5941 URL: http://tracker.firebirdsql.org/browse/CORE-5941 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0.4, 3.0.5 Reporter: Karol Bieniaszewski try altering not existing trigger SET TERM ^ ; ALTER TRIGGER XYZXX ACTIVE AFTER DELETE POSITION 1000 AS DECLARE VARIABLE VAR_OLD_UMOWA_ID CHAR(7); begin END^ SET TERM ; ^ as expected: Engine Code : 335544351 Engine Message : unsuccessful metadata update ALTER TRIGGER XYZXX failed Trigger XYZXX not found -------------------------------------------------------------------------------- add reference to OLD variable in the not existing trigger SET TERM ^ ; ALTER TRIGGER XYZXX ACTIVE AFTER DELETE POSITION 1000 AS DECLARE VARIABLE VAR_OLD_UMOWA_ID CHAR(7); begin VAR_OLD_UMOWA_ID = OLD.UMOWA_ID; END^ SET TERM ; ^ Engine Code : 335544351 Engine Message : unsuccessful metadata update ALTER TRIGGER XYZXX failed Dynamic SQL Error SQL error code = -206 Column unknown OLD.UMOWA_ID ---------------------------------------------------------------- but the main reason is that this trigger does not exists at all the body does not matter here -- 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 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel