In the list here:
https://mariadb.com/kb/en/operator-precedence/
case-expressions are put at the same precedence level as BETWEEN
, between the NOT
operator and the comparison operators.
However, case-expressions always begin with CASE
and end with END
, and all subexpressions are also delimited by the CASE
keywords. They’re like parenthetical expressions, so I don’t understand why case-expressions are on this list.
Is there an SQL expression that would be parsed differently if the case-expression precedence was set higher or lower?
Go to Source
Author: JoL