S
sunonus
Unregistered / Unconfirmed
GUEST, unregistred user!
detail message如下:
Unsuccessful metadata update
STORE RDB$RELATION_FIELDS failed
attempt to store duplicate value (visible to active transactions) in unique index "RDB$INDEX_15"
Statement: CREATE TABLE ORDERING(Q_DATE char(12) NOT NULL,
Q_ISBN CHAR (10),
Q_NAME CHAR (40),
Q_OWNER VARCHAR(16),
Q_PUBLISH VARCHAR(18),
Q_PRICE DECIMAL(6,2) DEFAULT 0.00 ,
Q_NUM SMALLINT DEFAULT 1 NOT NULL,
Q_TYPE CHAR(6) DEFAULT '买入' ,
Q_PREPAY DECIMAL(6,2) DEFAULT 0.00,
Q_NAME VARCHAR(12),
Q_SEX CHAR(2) ,
Q_CALL VARCHAR(18),
Q_DONE CHAR (3) DEFAULT '否' ,
PRIMARY KEY(Q_DATE)
)
Unsuccessful metadata update
STORE RDB$RELATION_FIELDS failed
attempt to store duplicate value (visible to active transactions) in unique index "RDB$INDEX_15"
Statement: CREATE TABLE ORDERING(Q_DATE char(12) NOT NULL,
Q_ISBN CHAR (10),
Q_NAME CHAR (40),
Q_OWNER VARCHAR(16),
Q_PUBLISH VARCHAR(18),
Q_PRICE DECIMAL(6,2) DEFAULT 0.00 ,
Q_NUM SMALLINT DEFAULT 1 NOT NULL,
Q_TYPE CHAR(6) DEFAULT '买入' ,
Q_PREPAY DECIMAL(6,2) DEFAULT 0.00,
Q_NAME VARCHAR(12),
Q_SEX CHAR(2) ,
Q_CALL VARCHAR(18),
Q_DONE CHAR (3) DEFAULT '否' ,
PRIMARY KEY(Q_DATE)
)