Re: NULL but TRUE
Perl uses it when 0 is a legitimate response, but false is used to signify that a function has failed.
Such as string indexOf. An index of 9 is a legitimate response, but they want they returned value to equate to true in a conditional even so.
"MySQL does no such thing; it just evaluates the expression according to standard rules." And the "standard" rules are exactly how I outlined them. What particular part of what I have said do you disagree with? That NULL<>? returns NULL, of that NULL in a conditional (WHERE id=? AND NULL) is treated as a FALSE?
Subject
Written By
Posted
Re: NULL but TRUE
March 29, 2013 01:03PM
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.