This topic describes other functions that are supported by and those which are not supported by PolarDB-X.

The following table describes other functions that are supported by PolarDB-X.

Function Description
RAND() Returns a random number from 0 to 1.
RELEASE_ALL_LOCKS() Releases all locks.
RELEASE_LOCK() Releases a lock of a specified name.
UUID() Returns a UUID.
UUID_SHORT() Returns a UUID of the unsigned long long type.
GET_LOCK() Obtains a lock.
IS_USED_LOCK() Checks whether a lock is in use.
IS_FREE_LOCK() Check whether a lock is released.

PolarDB-X does not support the following functions.

Function Description
ANY_VALUE() Returns the first record of a specified column in one group.
DEFAULT(col_name) Returns the default value of the col_name field.
INET_ATON() Returns the numeric value of an IPv4 address.
INET_NTOA() Returns the dotted-quad string representation of an IPv4 address based on the numeric value of the address.
INET6_ATON() Returns the numeric value of an IPv6 address.
INET6_NTOA() Returns the dotted-quad string representation of an IPv6 address based on the numeric value of the address.
IS_IPV4() Checks whether the argument is an IPv4 address.
IS_IPV4_COMPAT() Checks whether the argument is an IPv4-compatible address.
IS_IPV4_MAPPED() Checks whether the argument is an IPv4-mapped address.
IS_IPV6() Checks whether the argument is an IPv6 address.
MASTER_POS_WAIT() Returns the number of the transactions that are executed by a secondary database to check whether the secondary database reads and applies all updates up to a specified position in the binary log of the primary database.
NAME_CONST() Creates a column based on a specified column name.