hi all, this is a repost, because nobody noticed this problem. the sql below will not generate an error, but should not return a row. but this is what i mentioned a few week ago (reproduceable under linux with sapdb 7.4.3.17 and with the new version 7.4.3.27) if you remove colinteger from being part of the pk in version 7.4.3.17 the sql will not produce any result-set; in this new release you will get a result-set anyway. is there a workaround or will this be fixed in the near future? or is it my false?
regards ingo CREATE TABLE Test ( colinteger FIXED(7) NOT NULL , coltimestamp TIMESTAMP NOT NULL , PRIMARY KEY (colinteger, coltimestamp) ) INSERT INTO Test VALUES (1, '2003-01-01 10:01:00.000000') SELECT * FROM Test WHERE Test.coltimestamp <> '2003-01-01 10:01:00.000000' -- Ingo Trapphagen IOn AG Tel: 0211/92495-124 http://www.ion.ag _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
