> SELECT x FROM t WHERE NOT y<>?
> with
> ps.setNull(1, Types.NULL);
>
> should match any row in the table (because y<>NULL is always false)
Great idea, however it seems that 'NOT y <> NULL' always returns false as
well! Is this a bug, or did I get something wrong here? Try the following in
SQL Studio:
SELECT TRUE FROM dual WHERE 1 <> NULL -> false
SELECT TRUE FROM dual WHERE NOT 1 <> 1 -> true
SELECT TRUE FROM dual WHERE NOT 1 <> NULL -> false (!)
--
Eric Jain
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
