Vlad Shalnev wrote: [...]
OR ||
Logical OR. Evaluates to 1 if any operand is non-zero, to NULL if any operand is NULL, otherwise 0 is returned.
This definition (from the manual) is self-contradicting: 1 OR NULL should evaluate to 1 because "any operand is non-zero", but it should also evaluate to NULL because "any operand is NULL".
<URL: http://dev.mysql.com/doc/mysql/en/Logical_Operators.html >
With an unclear definition, it is perhaps not so strange that behaviour will change with different versions of MySQL...?
Maybe if you explain why you depend on this behaviour someone can suggest a workaround or a different solution?
-- Roger
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
