Sven K�hler wrote:
SELECT TRUE FROM dual WHERE NOT 1 <> NULL -> false (!)
This is strange, and this looks like a bug to me because the NOT should invert the result of 1<>NULL which is in fact false - and NOT false is true ;-)
The dreaded three valued logic monster rears it's head again: 1 <> NULL => NULL NOT NULL => NULL
Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
