New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Regression: Can not run ALTER TABLE DROP CONSTRAINT <FK_name> after recent changes in svn [CORE4418] #4740
Comments
Modified by: @dyemanovassignee: Claudio Valderrama C. [ robocop ] |
Commented by: @pavel-zotov One more sorrowful case: now I can`t RESTORE simple database from just created .fbk $ /opt/fb30/bin/isql -q $ /opt/fb30/bin/gbak -b /var/db/fb30/ttt.fdb /var/db/fb30/ttt.fbk $ /opt/fb30/bin/gbak -c /var/db/fb30/ttt.fbk /var/db/fb30/ttt.fdb.tmp |
Modified by: Sean Leyne (seanleyne)summary: Can not run ALTER TABLE DROP CONSTRAINT <FK_name> after recent changes in svn => Regression: Can not run ALTER TABLE DROP CONSTRAINT <FK_name> after recent changes in svn |
Commented by: @sim1984 Unfortunately the problem with the system tables still have Use CONNECT or CREATE DATABASE to specify a database |
Commented by: @pavel-zotov Seems that all issues mentioned above are fixed in LI-T3.0.0.31129 |
Modified by: @dyemanovstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 3.0 Beta 1 [ 10332 ] |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: @pavel-zotov
Assigned to: Claudio Valderrama C. (robocop)
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
Commits: e6d3b34 FirebirdSQL/fbt-repository@2462cfc
The text was updated successfully, but these errors were encountered: