Issue Details (XML | Word | Printable)

Key: CORE-1800
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Unassigned
Reporter: prenosil
Votes: 1
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Object INDEX is in use & RECREATE TABLE

Created: 25/Mar/08 06:44 AM   Updated: 25/Mar/08 06:44 AM
Component/s: Engine
Affects Version/s: 2.0.3, 2.1 Beta 2
Fix Version/s: None

Environment: WinXP


 Description  « Hide
Screenshot from FB2.0/2.1:
--------------------
CREATE TABLE TAB(
  ID INTEGER,
  A VARCHAR(100),
  CONSTRAINT CU UNIQUE(A));

RECREATE TABLE TAB(
  ID INTEGER,
  A VARCHAR(2000),
  CONSTRAINT CU UNIQUE(A));

Statement failed, SQLCODE = -607
unsuccessful metadata update
-key size exceeds implementation restriction for index "CU"

RECREATE TABLE TAB(
  ID INTEGER,
  A VARCHAR(2000),
  CONSTRAINT CU UNIQUE(A));

Statement failed, SQLCODE = -607
unsuccessful metadata update
-object INDEX is in use
--------------------

At this point it is not possible to e.g. drop the table (...object Index in use ...),
and it is not possible to apply usual solution, i.e. commit the transaction
holding the object, since no transaction is active.
The only solution is to disconnect.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.