I'm not sure how NOT(FALSE)
is evaluated, but NOT
is not a function. If you want to negate a boolean literal, then parentheses should be placed around the entire expression, i.e. use (NOT FALSE)
instead of NOT(FALSE)
. Consider the following example:
SELECT (NOT FALSE) < FALSE; -- 0,與 TRUE < FALSE 相同 SELECT (NOT TRUE) < FALSE; -- 0,與 FALSE < FALSE 相同