Definition of computed field not properly stored
------------------------------------------------

                 Key: CORE-4808
                 URL: http://tracker.firebirdsql.org/browse/CORE-4808
             Project: Firebird Core
          Issue Type: Bug
          Components: Engine
    Affects Versions: 2.5.4
         Environment: Firebird-2.5.4.26856-0_x64, Windows
            Reporter: Jiri Cincura


This script produces badly stored value for "SP" field.

RECREATE TABLE CREATEME (
    NEW_FIELD          INTEGER NOT NULL,
    CF_ON_TABLE        COMPUTED BY ((select first 1 u."Created" from "Users" 
u)),
    SP                 COMPUTED BY ((select 1 from rdb$database))
);

Removing the "CF_ON_TABLE" column makes the problem go away.

-- 
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

        

------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud 
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to