MySQL Forums
Forum List  »  Newbie

Re: NULL but TRUE
Posted by: Jonathon Wisnoski
Date: March 29, 2013 01:03PM

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?

Options: ReplyQuote


Subject
Written By
Posted
March 28, 2013 04:09PM
March 28, 2013 09:44PM
March 28, 2013 11:47PM
March 29, 2013 09:52AM
March 29, 2013 10:22AM
March 29, 2013 10:39AM
Re: NULL but TRUE
March 29, 2013 01:03PM
March 29, 2013 01:51PM
March 29, 2013 02:08PM
March 29, 2013 02:23PM
March 29, 2013 03:13PM
March 29, 2013 03:58PM
March 29, 2013 04:01PM
March 29, 2013 04:02PM
March 30, 2013 12:47PM
March 29, 2013 05:26AM


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.