We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Submitted by: fbbt (fbbt)
Duplicates CORE3458
CREATE TABLE T (F INTEGER);
CREATE TRIGGER T_BI FOR T ACTIVE BEFORE INSERT POSITION 0 AS BEGIN NEW.F = 0; END
COMMIT;
scenario 1: DROP TRIGGER T_BI; ALTER TABLE T ALTER F TO FF; -- error: -- unsuccessful metadata update -- Column F from table T is referenced in T_BI
scenario 2: DROP TRIGGER T_BI; ALTER TABLE T DROP F; COMMIT; -- ok
The text was updated successfully, but these errors were encountered:
Commented by: Sean Leyne (seanleyne)
Are you using ISQL to execute these statements?
Sorry, something went wrong.
Commented by: fbbt (fbbt)
I use IBExpert. I think it can be reproduced in ISQL with "SET AUTOddl off".
Link: This issue duplicates CORE3458 [ CORE3458 ]
status: Open [ 1 ] => Resolved [ 5 ]
resolution: Duplicate [ 3 ]
status: Resolved [ 5 ] => Closed [ 6 ]
No branches or pull requests
Submitted by: fbbt (fbbt)
Duplicates CORE3458
CREATE TABLE T (F INTEGER);
CREATE TRIGGER T_BI FOR T ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
NEW.F = 0;
END
COMMIT;
scenario 1:
DROP TRIGGER T_BI;
ALTER TABLE T ALTER F TO FF;
-- error:
-- unsuccessful metadata update
-- Column F from table T is referenced in T_BI
scenario 2:
DROP TRIGGER T_BI;
ALTER TABLE T DROP F;
COMMIT;
-- ok
The text was updated successfully, but these errors were encountered: