internal Firebird consistency check when trying to 'wrong' use computed_by 
index 
---------------------------------------------------------------------------------

                 Key: CORE-3763
                 URL: http://tracker.firebirdsql.org/browse/CORE-3763
             Project: Firebird Core
          Issue Type: Bug
            Reporter: Pavel Zotov


on LI-V2.5.2.26308, also 2.5.2.26390

SQL> create database 't1.fdb'; commit;
SQL> create table t(id int); commit;
SQL> create index t_idx on t computed by( (select min(id) from t) ); -- this 
looks very 'strange', of course.  But FB syntax allows such code!
SQL> commit;
SQL> insert into t values(123);
Aborted (core dumped)


on WI-V2.5.2.26390 the same actions results with:

Statement failed, SQLSTATE = 54001
unsuccessful metadata update
-request depth exceeded. (Recursive definition?)
-internal Firebird consistency check (error during savepoint backout (290), 
file: exe.cpp line: 4150)

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

        

------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing 
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to