Can't alter field after dropping all dependent triggers (all in one transaction)
--------------------------------------------------------------------------------
Key: CORE-3458
URL: http://tracker.firebirdsql.org/browse/CORE-3458
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.1
Reporter: Nick Dee
test:
CREATE TABLE T (F INTEGER);
CREATE TRIGGER T_BI FOR T ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
NEW.F = 0;
END
COMMIT;
DROP TRIGGER T_BI;
ALTER TABLE T ALTER F TO FF -- exception here
COMMIT;
Exception text:
unsuccessful metadata update
Column F from table T is referenced in T_BI
This operation is not defined for system tables.
Error Code: 31
-------
Tested on FB 2.5.1.26266
--
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
------------------------------------------------------------------------------
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today. Delivers lowest initial
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
