Re: NULL but TRUE
> I was just matching Perl's syntax for a similar concept.
I don't use Perl much any more. Doesn't that Perl syntax have something to do with exponentials?
> ...silently casting 'NULL<>?' to Null and then FALSE is illogical...
MySQL does no such thing; it just evaluates the expression according to standard rules. If you need to allow for the possibility of a NULL value, code it. Doing so, you may find the <=> null-safe equal operator useful: it tests equality like =, but returns 1 rather than NULL if both operands are NULL, and 0 rather than NULL if one operand is NULL.
Subject
Written By
Posted
Re: NULL but TRUE
March 29, 2013 10:39AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.