Dropping table fails after creating indexes
-------------------------------------------
Key: CORE-6465
URL: http://tracker.firebirdsql.org/browse/CORE-6465
Project: Firebird Core
Issue Type: Bug
Components: Engine
Environment: windows 10
Reporter: Jacob Lee
When a table has any indexes including primary key, then dropping tables seems
to get failure.
The following is the test code:
D:\>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database './data/testdb.fdb'
CON> user 'SYSDBA' password 'masterkey';
SQL> create table test (
CON> id integer generated by default as identity primary key,
CON> name varchar(20) not null
CON> );
SQL> show tables;
TEST
SQL> show table test;
ID INTEGER Not Null Identity (by default)
NAME VARCHAR(20) Not Null
CONSTRAINT INTEG_1:
Primary key (ID)
SQL> insert into test (name) values ('computer');
SQL> insert into test (name) values ('mouse');
SQL> insert into test (name) values ('keyboard');
SQL> insert into test (name) values ('monitor');
SQL> delete from test;
SQL> select * from test;
SQL> drop table test;
Statement failed, SQLSTATE = 42000
unsuccessful metadata update
-object TABLE "TEST" is in use
SQL> drop database;
SQL>
--
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
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
