The read-only analysis instance supports most MySQL logical operators, but it still has limitations and incompatibilities in some scenarios. This document describes the support for logical operators by the read-only analysis instance and lists the supported data types for each operator's parameters. Parameter types and usage methods not listed in this document are not supported.
Supported Logical Operations
AND Operation
Syntax: op1 AND op2
The data types supported by op1: Only bool is supported.
The data types supported by op2: Only bool is supported.
OR Operation
Syntax: op1 OR op2
The data types supported by op1: Only bool is supported.
The data types supported by op2: Only bool is supported.
NOT Operation
Syntax: NOT op1
The data types supported by op1: Only bool is supported.
CASE Operation
Syntax: CASE WHEN search_condition THEN statement_list ELSE statement_list END
The data types supported by search_condition: Only bool is supported.
The data types supported by statement_list are: int, bigint, double, decimal, varchar, char.
IF Operation
Syntax: IF(expr1, expr2, expr3)
The data types supported by expr1: Only bool is supported.
The data types supported by expr2 are: int, bigint, double, decimal, varchar, char.
The data types supported by expr3 are: int, bigint, double, decimal, varchar, char.
IFNULL Operation
Syntax: IFNULL(expr1, expr2)
The data types supported by expr1 are: int, bigint, double, decimal, varchar, char.
The data types supported by expr2 are: int, bigint, double, decimal, varchar, char.
ISNULL Operation
Syntax: ISNULL(expr1)
The data types supported by expr1 are: int, bigint, double, decimal, varchar, char.
IN Operation
Syntax: expr IN (value, ...)
The data types supported by expr are: int, bigint, double, decimal, varchar, char.
The data types supported by value are: int, bigint, double, decimal, varchar, char.
Attention:
In scenarios with multiple values, the value must be a constant, not a variable or a field name. For example, columnA IN (columnB, varA) is not supported. Only syntax similar to columnA IN ('1', '2', '3') is supported.
Syntax: expr IN (sub_query)
The data types supported by expr are: int, bigint, double, decimal, varchar, char.
The supported type for sub_query is: a subquery, and the result returned by the subquery must be a single field.
LIKE Operation
Syntax: expr LIKE pattern
The data types supported by expr are: int, bigint, double, decimal, varchar, char.
The data types supported by pattern are: int, bigint, double, decimal, varchar, char.
Attention:
pattern supports only constants, not variables or field names.
COALESCE Operation
Syntax: COALESCE(value, ...)
The data types supported by value are: int, bigint, double, decimal, varchar, char.