Hello List.
This script demonstrates the problem.
------> schnipp <------
CREATE TABLE TESTTABLE(
ID FIXED(32) PRIMARY KEY,
TEXT VARCHAR(32)
)
//
CREATE UNIQUE INDEX INDEX_TESTTABLE ON TESTTABLE(TEXT)
//
INSERT INTO TESTTABLE VALUES(1,null)
//
INSERT INTO TESTTABLE VALUES(2,null)
//
INSERT INTO TESTTABLE VALUES(3,null)
//
DROP INDEX INDEX_TESTTABLE ON TESTTABLE
//
CREATE UNIQUE INDEX INDEX_TESTTABLE ON TESTTABLE(TEXT)
------> schnapp <------
It tested on SAP DB (Version 7.3.0.29 Linux), (Version 7.3.0.24 WIN32) and
(Version 7.4.3.10 Linux).
Only at the last statement, the DBs have a different behaviour.
If i execute the last statement on SAP DB (Version 7.3.0.29 Linux) and
(Version 7.3.0.24 WIN32) it works,
but if i execute it on SAP DB (Version 7.4.3.10 Linux),the DB throws
following error:
"Integrity constraint violation;250(1) Duplicate secondary key."
I think somewhere is bug or can you tell me the correct behaviour?
Best regards
Carsten Sprenger
____________________________________
MediaTransfer AG
Netresearch & Consulting
Rothenbaumchaussee 38, 20148 Hamburg
Tel: (040) 669 625 16
Fax: (040) 669 625 29
URL: http://b2b.mediatransfer.de
____________________________________
This email is printed with 100% recycled electrons.
/~\ The ASCII
~~so long~~ \ / Ribbon Campaign
Carsten X Against
/ \ HTML Email!
This email is printed with 100% recycled electrons.
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
