[Firebird-devel] [FB-Tracker] Created: (CORE-4418) Can not run ALTER TABLE DROP CONSTRAINT after recent changes in svn

[Pavel Zotov (JIRA)]

Can not run ALTER TABLE DROP CONSTRAINT <FK_name> after recent changes in svn
-----------------------------------------------------------------------------

                 Key: CORE-4418
                 URL: http://tracker.firebirdsql.org/browse/CORE-4418
             Project: Firebird Core
          Issue Type: Bug
          Components: Engine
    Affects Versions: 3.0 Alpha 2
            Reporter: Pavel Zotov


Seems that this:
---- http://svn.code.sf.net/p/firebird/code/firebird/trunk/ChangeLog ---
 2014-05-01 05:55  robocop 
   M src/jrd/vio.cpp
More sys tables protected.
----

-- prevent us from dropping foreign key:

SQL> create database '192.168.0.220/3330:/var/db/fb30/tmp201405051238.fdb'; 
commit;
SQL> create table td(id int primary key using index td_pk, pid int, constraint 
td_fk foreign key(pid) references tm(id) using index td_fk);
SQL> commit;
SQL> show table td;
ID                              INTEGER Not Null
PID                             INTEGER Nullable
CONSTRAINT TD_FK:
  Foreign key (PID)    References TM (ID)
CONSTRAINT INTEG_4:
  Primary key (ID) uses explicit ascending index TD_PK

SQL> alter table td drop constraint td_fk;
Statement failed, SQLSTATE = 42000
unsuccessful metadata update
-ALTER TABLE TD failed
-DELETE operation is not allowed for system table RDB$REF_CONSTRAINTS
-At trigger 'RDB$TRIGGER_10'


PS.

SQL> show version;
ISQL Version: LI-T3.0.0.31099 Firebird 3.0 Alpha 2
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-T3.0.0.31099 Firebird 
3.0 Alpha 2"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-T3.0.0.31099 Firebird 
3.0 Alpha 2/tcp (oel64)/P13"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-T3.0.0.31099 
Firebird 3.0 Alpha 2/tcp (oel64)/P13"
on disk structure version 12.0


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

        

------------------------------------------------------------------------------
Is your legacy SCM system holding you back? Join Perforce May 7 to find out:
&#149; 3 signs your SCM is hindering your productivity
&#149; Requirements for releasing software faster
&#149; Expert tips and advice for migrating your SCM now
http://p.sf.net/sfu/perforce
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel