For supported functions and operators, refer to Section 2.12, “Supported Functions and Operators”.
-
Column-to-column filters, excluding the
<=>
filter. Both columns must beVARLEN
-encoded.Column-to-column filters must use columns that are encoded with the same character set and collation.
-
Column-to-constant filters, excluding the
<=>
filter.The character set and collation of the constant variable must match the character set and collation of the constant.