The read-only analysis engine currently supports most MySQL comparison operation logic, but there are still limitations and incompatibilities in some scenarios. This document introduces the support for comparison operations in the read-only analysis engine and lists the type limitations in input parameters. Input parameters and usage methods not mentioned in the document are not supported.
Supported Comparison Operations
>= Greater Than or Equal to Comparison
Syntax: op1 >= op2
Supported value types for op1: int, bigint, float, double, decimal, char, varchar, date, and datetime.
Supported value types for op2: int, bigint, float, double, decimal, char, varchar, date, and datetime.
<= Less Than or Equal to Comparison
Syntax: op1 <= op2
Supported value types for op1: int, bigint, float, double, decimal, char, varchar, date, and datetime.
Supported value types for op2: int, bigint, float, double, decimal, char, varchar, date, and datetime.
= Equal to Comparison
Syntax: op1 = op2
Supported value types for op1: int, bigint, float, double, decimal, char, varchar, date, and datetime.
Supported value types for op2: int, bigint, float, double, decimal, char, varchar, date, and datetime.
!= Not Equal to Comparison
Syntax: op1 != op2
Supported value types for op1: int, bigint, float, double, decimal, char, varchar, date, and datetime.
Supported value types for op2: int, bigint, float, double, decimal, char, varchar, date, and datetime.
< Less Than Comparison
Syntax: op1 < op2
Supported value types for op1: int, bigint, float, double, decimal, char, varchar, date, and datetime.
Supported value types for op2: int, bigint, float, double, decimal, char, varchar, date, and datetime.
> Greater Than Comparison
Syntax: op1 > op2
Supported value types for op1: int, bigint, float, double, decimal, char, varchar, date, and datetime.
Supported value types for op2: int, bigint, float, double, decimal, char, varchar, date, and datetime.