Operator Precedence
Descriptionβ
Operator precedence determines the order in which operators are evaluated in an expression. When an expression contains multiple operators, Doris will perform calculations in descending order of operator precedence.
Operator Precedenceβ
The precedence decreases from top to bottom, with the highest precedence at the top.
| Precedence | Operator |
|---|---|
| 1 | ! |
| 2 | + (unary plus), - (unary minus), ~ (unary bitwise NOT), ^ |
| 3 | *, /, %, DIV |
| 4 | -, + |
| 5 | & |
| 6 | | |
| 7 | =(comparison), <=>, >=, >, <=, <, <>, !=, IS, LIKE, REGEXP, MATCH, IN |
| 8 | NOT |
| 9 | AND, && |
| 10 | XOR |
| 11 | OR |
| 12 | || |
