Other functions
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. {#multiTask1818-entry-f9n-zzu-ryo}
| Function | Description |
|---|---|
| RAND() | Returns a random number from 0 to 1. |
| UUID() | Returns a UUID. |
| UUID_SHORT() | Returns a UUID of the unsigned long long type. |
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. |
| IS_USED_LOCK() | Checks whether a lock is in use. |
| IS_FREE_LOCK() | Check whether a lock is released. |
| GET_LOCK() | Obtains a lock. |
| RELEASE_ALL_LOCKS() | Releases all locks. |
| RELEASE_LOCK() | Releases a lock of a specified name. |