I have corrected this error in 7.4.3 build 18. regards Uwe
> -----Original Message----- > From: Hahn, Uwe > Sent: Mittwoch, 26. M�rz 2003 15:39 > To: 'Carsten Sprenger - MediaTransfer AG Netresearch & > Consulting'; SAP > Subject: RE: UNIQUE INDEX on a null column and different behaviour > > > 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 > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
