Skip to content
New issue

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

create trigger fails with ambiguous field name between table B and table A error [CORE5147] #5430

Closed
firebird-issue-importer opened this issue Mar 10, 2016 · 5 comments

Comments

@firebird-issue-importer

Submitted by: jzugaj (jzugaj)

the return clause in trigger will cause ambiguous field name between table B and table A error

CREATE TABLE A
(
ID INTEGER NOT NULL,
QTY FLOAT,
CONSTRAINT PK_A PRIMARY KEY (ID)
);

CREATE TABLE B
(
ID INTEGER NOT NULL,
QTY FLOAT,
CONSTRAINT PK_B PRIMARY KEY (ID)
);

CREATE TRIGGER T_TEST_TRIGG FOR B ACTIVE BEFORE INSERT POSITION 0 AS
declare oldQty float;
declare newQty float;
begin

update a
set qty = new.qty
where
http://id=new.id
returning new.qty, old.qty
into newQty, oldQty;
end

Commits: 495047d e9eea07

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 10, 2016

Modified by: @dyemanov

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 10, 2016

Modified by: @dyemanov

Fix Version: 3.0.0 [ 10740 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 17, 2016

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 4.0 Alpha 1 [ 10731 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 18, 2016

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Done successfully

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 18, 2016

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment