Re: Duplicate Primary Key

[Sven K�hler]

Performing this SQL-statement:
select * from SPHERES where   CID = '1' and ASSAY=False
results in one row.

But Performing this SQL-statement:
select * from SPHERES where   CID = '1' and ASSAY !=true
results in two rows with CID of '1' and ASSAY =  False.

How can this happen?

I cannot reproduce your problem with SAPDB 7.4.3.7

i tried these SQL statements:

CREATE TABLE "SPHERES"
(
"CID" Char (16) ASCII,
"ASSAY" Boolean,
"SPHERE1" Long ASCII,
"SPHERE2" Long ASCII,
"SPHERE3" Long ASCII,
PRIMARY KEY ("CID", "ASSAY")
)

insert into spheres(cid, assay) values('1', false)
//
insert into spheres(cid, assay) values('1', true)
//
insert into spheres(cid, assay) values('2', false)
//
insert into spheres(cid, assay) values('2', true)

select * from SPHERES where CID = '1' and ASSAY=true

select * from SPHERES where CID = '1' and ASSAY!=true

Both selects returned same result.
Please post more on how to reproduce the bug. I even doubt that such a bug exists.



_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general