Richard Barrington > > >> select * from SPHERES where CID = '1' and ASSAY=False > >> select * from SPHERES where CID = '1' and ASSAY !=true > >> > >> They are the same! > >> > >> ASSAY=False equal to say ASSAY (NOT EQUAL) True > > > >His Problem was, that the first query reports 1 row, and the second > >query returns 2 rows even though the queries seem to be the same. > > > >i haven't checked that yet. > > But what if ASSAY = NULL? It could return different values then.
A PRIMARY KEY column is not allowed to have the NULL-value. There should be no difference. I would like to see the data stored in the primary key (without where-clause) and some info if we are talking about a table or a view(ok, table), if there are indices around and how the explain-output looks like for the two different selects (=false/ !=true) and if "USER"."SPHERES" and SPHERES are really the same table, i.e. the user working is the user named "USER". It is not reproducable for me so far. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
