You are right. For mistake there is a different handling in the comparison of null values. The CreateIndex command handles the null values in a wrong way. This will be fixed soon. thank you Uwe
> -----Original Message----- > From: Carsten Sprenger - MediaTransfer AG Netresearch & Consulting > [mailto:[EMAIL PROTECTED] > Sent: Mittwoch, 26. M�rz 2003 15:25 > To: SAP > Subject: UNIQUE INDEX on a null column and different behaviour > > > 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 > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
