Submitted by: Bjarne Rasmussen (bimmer_r)

Duplicates CORE3675

1) create empty database (or just use any test db at hand)
2) Run script :

SET SQL DIALECT 3;
CREATE GENERATOR GEN_NEW_TABLE_ID;
CREATE TABLE TESTTABLE (
ID INTEGER NOT NULL,
FIELD1 INTEGER NOT NULL,
FIELD2 INTEGER NOT NULL,
FIELD3 VARCHAR(10),
FIELD4 VARCHAR(10)
);
ALTER TABLE TESTTABLE ADD CONSTRAINT PK_TESTTABLE PRIMARY KEY (ID);
CREATE UNIQUE INDEX TESTTABLE_IDX1 ON TESTTABLE (FIELD1, FIELD2, FIELD3, FIELD4);
ALTER INDEX TESTTABLE_IDX1 INACTIVE;
SET TERM ^ ;
/* Trigger: TESTTABLE_BI */
CREATE OR ALTER TRIGGER TESTTABLE_BI FOR TESTTABLE
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
IF (http://NEW.id IS NULL) THEN
http://NEW.id = GEN_ID(gen_new_table_id,1);
END
^
SET TERM ; ^
3) Table is created with KEY, INDEX, GENERATOR and a Trigger ... lets put some data in.

INSERT INTO TESTTABLE (FIELD1, FIELD2, FIELD3, FIELD4) VALUES (1, 2, NULL, NULL);
INSERT INTO TESTTABLE (FIELD1, FIELD2, FIELD3, FIELD4) VALUES (1, 2, '', '');
COMMIT WORK;

4) Now we are ready to test the INDEX.
a. DeActivate index : ALTER INDEX TESTTABLE_IDX1 INACTIVE. (result is OK)
b. Activate index : ALTER INDEX TESTTABLE_IDX1 ACTIVE. <--------------------------- THIS FAILS ??????

Error is : "attempt to store duplicate value(visible to active transactions) in unique index "TESTTABLE_IDX1".

====== Test Details ======

Could NOT reproduce error on WI-V2.5.1.26351 (SuperClassic).