The read-only analysis engine currently supports most MySQL mathematical operation functions, but there are still limits and incompatibilities in some scenarios. This document introduces the supported list of mathematical operation functions in the read-only analysis engine and lists the type limitations in input parameters. Input parameters and functions not mentioned in the document are not supported.
Supported Mathematical Operation Functions
round Function
Function that rounds a number.
Syntax: round(x)
Supported value types for x: Decimal data type.
abs Function
Function that returns the absolute value.
Syntax: abs(x)
Supported value types for x: int, bigint, double, and decimal data types.
floor Function
Function that gives the nearest integer down.
Syntax: floor(x)
Supported value types for x: int, bigint, double, and decimal data types.
ceil Function
Function that gives the nearest integer up.
Syntax: ceil(x)
Supported value types for x: int, bigint, double, and decimal data types.
ceiling Function
Function that rounds a number up.
Syntax: ceiling(x)
Supported value types for x: int, bigint, double, and decimal data types.
sqrt Function
Square root function.
Syntax: sqrt(x)
Supported value types for x: int, bigint, double, and decimal data types.
log Function
Logarithmic function.
Syntax: log(x)
Supported value types for x: int, bigint, double, and decimal data types.
log2 Function
Logarithmic function to base 2.
Syntax: log2(x)
Supported value types for x: int, bigint, double, and decimal data types.
log10 Function
Logarithmic function to base 10.
Syntax: log10(x)
Supported value types for x: int, bigint, double, and decimal data types.
ln Function
Function that returns the natural logarithm of a number.
Syntax: ln(x)
Supported value types for x: int, bigint, double, and decimal data types.
exp Function
Function that returns the e raised to the power of x.
Syntax: exp(x)
Supported value types for x: int, bigint, double, and decimal data types.
pow Function
Function that calculates x raised to the power of y.
Syntax: pow(x, y)
Supported value types for x: int, bigint, double, and decimal data types.
Supported value types for y: Support int, bigint, double, and decimal data types.
sign Function
Used to determine the sign of a real number.
Syntax: sign(x)
Supported value types for x: int, bigint, double, and decimal data types.
radians Function
Convert degrees to radians.
Syntax: radians(x)
Supported value types for x: int, bigint, double, and decimal data types.
degrees Function
Used to convert radians to degrees.
Syntax: degrees(x)
Supported value types for x: int, bigint, double, and decimal data types.
conv Function
Convert a number from one numeral base system to another and return the result as a string value.
Syntax: conv(n, from_base, to_base)
Supported value types for n: int, bigint, double, and decimal data types.
Supported value types for from_base: int, bigint, double, and decimal data types.
Supported value types for to_base: int data type.
crc32 Function
Cyclic redundancy check function.
Syntax: crc32(expr)
Supported value types for expr: int, bigint, double, and decimal data types.
greatest Function
Return the maximum value among N values.
Syntax: greatest(value1, value2, ...)
Supported value types for value1: int, bigint, double, and decimal data types.
Supported value types for value2: int, bigint, double, and decimal data types.
least Function
Return the minimum value among N values.
Syntax: least(value1, value2, ...)
Supported value types for value1: int, bigint, double, and decimal data types.
Supported value types for value2: int, bigint, double, and decimal data types.
truncate Function
Truncate a number by the number of decimal places.
Syntax: truncate(X, D)
Truncate the decimal places of X based on the value of D directly without rounding.
When D is greater than 0, it operates on the number of decimal places of value X.
When D equals 0, it removes the decimal part of value X and reserves the integer part.
When D is less than 0, it removes the decimal part of value X and replaces the integer part with 0 according to the specified number of digits in D.