create trigger fails with ambiguous field name between table B and table A error
--------------------------------------------------------------------------------
Key: CORE-5147
URL: http://tracker.firebirdsql.org/browse/CORE-5147
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 RC2
Environment: windows 10 64bit; fiebird 3.0 RC2 64bit
Reporter: 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
id=new.id
returning new.qty, old.qty
into newQty, oldQty;
end
--
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
------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785111&iu=/4140
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
