Operators

All dialects support the following standard operators:

• Comparison: =, >, >=, <, <=, <>, !=
• Boolean: AND, OR, NOT, IS, IS NOT
• Math: +, -, *, /

The standard also defines operators that aren't supported a lot in actual implementations:

• :: static method invocation
• -> attribute or method reference
• || string concatenation
• .. embedded Ada and Pascal syntax

Below only additional non-standard operators are listed (the uncommon ones (::, ->, ||, ..) are assumed to be unsupported unless mentioned otherwise):

SingleStoreDB:

• Comparison operators: <=> (NULL-safe equal operator)
• Bitwise operators: &, |, ^, ~, >>, <<
• Boolean operators:¹ &&, ||

Notes:

1. Tested SingleStoreDB boolean operators manually. Found no docs for these.