I think this is correct - if unexplicable - behavior according to the Standard. Something about the state of the coulmn prior to the operation.
On Aug 31, 2013, at 8:13 AM, "Gorynich (JIRA)" <trac...@firebirdsql.org> wrote: > 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 ------------------------------------------------------------------------------ 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
