You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
Submitted by: prenosil (prenosil)
Votes: 1
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.
The text was updated successfully, but these errors were encountered: