本文介绍了PolarDB-X 1.0支持的其他函数。
PolarDB-X 1.0还支持如下函数：
| 函数名 | 描述 |
|---|---|
| RAND() | Return a random floating-point value |
| RELEASE_ALL_LOCKS() | Releases all current named locks |
| RELEASE_LOCK() | Releases the named lock |
| SLEEP() | Sleep for a number of seconds |
| UUID() | Return a Universal Unique Identifier (UUID) |
| UUID_SHORT() | Return an integer-valued universal identifier |
| VALUES() | Defines the values to be used during an INSERT |
| ANY_VALUE() | Suppress ONLY_FULL_GROUP_BY value rejection |
| DEFAULT() | Return the default value for a table column |
| GET_LOCK() | Get a named lock |
| INET_ATON() | Return the numeric value of an IP address |
| INET_NTOA() | Return the IP address from a numeric value |
| INET6_ATON() | Return the numeric value of an IPv6 address |
| INET6_NTOA() | Return the IPv6 address from a numeric value |
| IS_FREE_LOCK() | Whether the named lock is free |
| IS_IPV4() | Whether argument is an IPv4 address |
| IS_IPV4_COMPAT() | Whether argument is an IPv4-compatible address |
| IS_IPV4_MAPPED() | Whether argument is an IPv4-mapped address |
| IS_IPV6() | Whether argument is an IPv6 address |
| IS_USED_LOCK() | Whether the named lock is in use; return connection identifier if true |
| MASTER_POS_WAIT() | Block until the slave has read and applied all updates up to the specified position |
| NAME_CONST() | Causes the column to have the given name |