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