ERROR: Cannot insert a duplicate key into unique index func_index_index

-- but this shouldn't:

INSERT INTO func_index_heap VALUES('QWERTY');

--

-- Also try building functional, expressional, and partial indexes on

-- tables that already contain data.

--

create unique index hash_f8_index_1 on hash_f8_heap(abs(random));

create unique index hash_f8_index_2 on hash_f8_heap((seqno + 1), random);

create unique index hash_f8_index_3 on hash_f8_heap(random) where seqno > 1000;

INSERT INTO func_index_heapVALUES('ABCD','EF');

INSERT INTO func_index_heapVALUES('QWERTY');

createunique indexhash_f8_index_1on hash_f8_heap(abs(random));

createunique indexhash_f8_index_2on hash_f8_heap((seqno+1), random);

createunique indexhash_f8_index_3on hash_f8_heap(random)where seqno>1000;