Currently, the read-only analysis instance supports most MySQL comparison operations. However, limitations and incompatibilities still exist in some scenarios. This document describes the support for comparison operations in the read-only analysis instance and lists the type restrictions on input parameters. Any input parameters and usage methods not mentioned in this document are not supported.
Supported Comparison Operations
>= Greater Than or Equal to
Syntax: op1 >= op2
The data types supported by op1 are: int, bigint, float, double, decimal, char, varchar, date, datetime.
The data types supported by op2 are: int, bigint, float, double, decimal, char, varchar, date, datetime.
<= Less Than or Equal to
Syntax: op1 <= op2
The data types supported by op1 are: int, bigint, float, double, decimal, char, varchar, date, datetime.
The data types supported by op2 are: int, bigint, float, double, decimal, char, varchar, date, datetime.
= Equal to Comparison
Syntax: op1 = op2
The data types supported by op1 are: int, bigint, float, double, decimal, char, varchar, date, datetime.
The data types supported by op2 are: int, bigint, float, double, decimal, char, varchar, date, datetime.
!= Not Equal to Comparison
Syntax: op1 != op2
The data types supported by op1 are: int, bigint, float, double, decimal, char, varchar, date, datetime.
The data types supported by op2 are: int, bigint, float, double, decimal, char, varchar, date, datetime.
< Less Than
Syntax: op1 < op2
The data types supported by op1 are: int, bigint, float, double, decimal, char, varchar, date, datetime.
The data types supported by op2 are: int, bigint, float, double, decimal, char, varchar, date, datetime.
> Greater Than
Syntax: op1 > op2
The data types supported by op1 are: int, bigint, float, double, decimal, char, varchar, date, datetime.
The data types supported by op2 are: int, bigint, float, double, decimal, char, varchar, date, datetime.