computed field has null value inside BI trigger
-----------------------------------------------
Key: CORE-4201
URL: http://tracker.firebirdsql.org/browse/CORE-4201
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Alpha 1, 2.5.3
Reporter: Gorynich
CREATE TABLE NEW_TABLE (
NEW_FIELD1 INTEGER NOT NULL,
COMP_FIELD COMPUTED BY (NEW_FIELD1+1),
NEW_FIELD2 INTEGER
);
SET TERM ^ ;
CREATE TRIGGER NEW_TABLE_BI0 FOR NEW_TABLE
ACTIVE BEFORE INSERT POSITION 0
as
begin
new.New_Field2 = new.Comp_Field;
end
^
SET TERM ; ^
INSERT INTO NEW_TABLE (NEW_FIELD1)
VALUES (1);
NEW_FIELD1 - 1
COMP_FIELD - 2
NEW_FIELD2 - null ??????????? why ?
Firebird-2.5.2.26540
NEW_FIELD1 - 1
COMP_FIELD - 2
NEW_FIELD2 - 2 OK :)
--
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
------------------------------------------------------------------------------
Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
