Currently, the read-only analysis engine supports most of MySQL's mathematical operation functions, but there are still limitations and incompatibilities in certain scenarios. This document introduces the list of supported mathematical operation functions in the read-only analysis engine, and enumerates type restrictions on input parameters. Input parameters and functions not mentioned in the document are not supported.
Supported Types of Mathematical Operation Functions
round Function
Rounding function.
Syntax: round(x)
Supported value types for x: decimal.
abs Function
A function that calculates the absolute value.
Syntax: abs(x)
Supported value types for x: int, bigint, double, and decimal.
floor Function
A function that rounds a value down.
Syntax: floor(x)
Supported value types for x: int, bigint, double, and decimal.
ceil Function
A function that rounds a value up.
Syntax: ceil(x)
Supported value types for x: int, bigint, double, and decimal.
ceiling Function
A function that calculates the larger integer nearest to a value.
Syntax: ceiling(x)
Supported value types for x: int, bigint, double, and decimal.
sqrt Function
Square root function.
Syntax: sqrt(x)
Supported value types for x: int, bigint, double, and decimal.
log Function
Logarithmic function.
Syntax: log(x)
Supported value types for x: int, bigint, double, and decimal.
log2 Function
Logarithmic function with a base of 2.
Syntax: log2(x)
Supported value types for x: int, bigint, double, and decimal.
log10 Function
Logarithmic function with a base of 10.
Syntax: log10(x)
Supported value types for x: int, bigint, double, and decimal.
ln Function
A function that returns the natural logarithm of a number.
Syntax: ln(x)
Supported value types for x: int, bigint, double, and decimal.
exp Function
A function that returns e raised to the power of x.
Syntax: exp(x)
Supported value types for x: int, bigint, double, and decimal.
pow Function
A function that calculates x raised to the power of y.
Syntax: pow(x, y)
Supported value types for x: int, bigint, double, and decimal.
Supported value types for y: int, bigint, double, and decimal.
sign Function
A function used to determine the sign of a real number.
Syntax: sign(x)
Supported value types for x: int, bigint, double, and decimal.
radians Function
A function that converts degrees to radians.
Syntax: radians(x)
Supported value types for x: int, bigint, double, and decimal.
degrees Function
A function that converts radians to degrees.
Syntax: degrees(x)
Supported value types for x: int, bigint, double, and decimal.
conv Function
A function that converts a number from one numeric base system to another and returns the result as a string value.
Syntax: conv(n, from_base, to_base)
Supported value types for n: int, bigint, double, and decimal.
Supported value types for from_base: int, bigint, double, and decimal.
Supported value types for to_base: int.
crc32 Function
Cyclic redundancy check function.
Syntax: crc32(expr)
Supported value types for expr: int, bigint, double, and decimal.
greatest Function
A function that returns the maximum value among N values.
Syntax: greatest(value1, value2, ...)
Supported value types for value1: int, bigint, double, and decimal.
Supported value types for value2: int, bigint, double, and decimal.
least Function
A function that returns the minimum value among N values.
Syntax: least(value1, value2, ...)
Supported value types for value1: int, bigint, double, and decimal.
Supported value types for value2: int, bigint, double, and decimal.
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.