partitioned table using Limit #24636 • Fix the issue of displaying the incorrect TiDB address in IPv6 environment #43260 @nexustar • Fix the issue of displaying incorrect values for system variables execution #43755 @wjhuang2016 • Fix the issue that the cluster cannot query some system views in IPv6 environment #43286 @Defined2014 • Fix the issue of not finding the partition during inner join in 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_IPV4() Whether argument is an IPv4 address

check whether a value matches a certain named format. The formats that can be validated include ipv4, ipv6, time, date, duration, email, hostname, uuid, and uri. 4570 SELECT JSON_SCHEMA_VALID('{"format": 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_IPV4() Whether argument is an IPv4 address IS_IPV4_ �→ MAPPED �→ () Whether argument is an IPv4-mapped address IS_IPV6() Whether argument is an IPv6 address IS_UUID() Whether argument is an UUID NAME_ �→ CONST �→ () Can be used to rename a column

check whether a value matches a certain named format. The formats that can be validated include ipv4, ipv6, time, date, duration, email, hostname, uuid, and uri. SELECT JSON_SCHEMA_VALID('{"format": "ipv4"}' 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_IPV4() Whether argument is an IPv4 address IS_IPV4_ �→ MAPPED �→ () Whether argument is an IPv4-mapped address IS_IPV6() Whether argument is an IPv6 address IS_UUID() Whether argument is an UUID NAME_ �→ CONST �→ () Can be used to rename a column

check whether a value matches a certain named format. The formats that can be validated include ipv4, ipv6, time, date, duration, email, hostname, uuid, and uri. SELECT JSON_SCHEMA_VALID('{"format": "ipv4"}' 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_IPV4() Whether argument is an IPv4 address IS_IPV4_ �→ MAPPED �→ () Whether argument is an IPv4-mapped address IS_IPV6() Whether argument is an IPv6 address IS_UUID() Whether argument is an UUID NAME_ �→ CONST �→ () Can be used to rename a column

check whether a value matches a certain named format. The formats that can be validated include ipv4, ipv6, time, date, duration, email, hostname, uuid, and uri. SELECT JSON_SCHEMA_VALID('{"format": "ipv4"}' 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_IPV4() Whether argument is an IPv4 address IS_IPV4_ �→ MAPPED �→ () Whether argument is an IPv4-mapped address IS_IPV6() Whether argument is an IPv6 address IS_UUID() Whether argument is an UUID NAME_ �→ CONST �→ () Can be used to rename a column

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_IPV4() Whether argument is an IPv4 address IS_IPV4_ �→ MAPPED �→ () Whether argument is an IPv4-mapped address IS_IPV6() Whether argument is an IPv6 address IS_UUID() Whether argument is an UUID NAME_ �→ CONST �→ () Can be used to rename a column INET6_ATON() The INET6_ATON() function is similar to INET_ATON(), but INET6_ATON() can also han- dle IPv6 addresses. SELECT INET6_ATON('::1'); +--------------------------------------+ | INET6_ATON('::1')

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_IPV4() Whether argument is an IPv4 address IS_IPV4_ �→ MAPPED �→ () Whether argument is an IPv4-mapped address IS_IPV6() Whether argument is an IPv6 address IS_UUID() Whether argument is an UUID NAME_ �→ CONST �→ () Can be used to rename a column INET6_ATON() The INET6_ATON() function is similar to INET_ATON(), but INET6_ATON() can also han- dle IPv6 addresses. SELECT INET6_ATON('::1'); +--------------------------------------+ | INET6_ATON('::1')

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_IPV4() Whether argument is an IPv4 address IS_IPV4_ �→ MAPPED �→ () Whether argument is an IPv4-mapped address IS_IPV6() Whether argument is an IPv6 address IS_UUID() Whether argument is an UUID NAME_ �→ CONST �→ () Can be used to rename a column INET6_ATON() The INET6_ATON() function is similar to INET_ATON(), but INET6_ATON() can also han- dle IPv6 addresses. SELECT INET6_ATON('::1'); +--------------------------------------+ | INET6_ATON('::1')

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_IPV4() Whether argument is an IPv4 address IS_IPV4_MAPPED �→ () Whether argument is an IPv4-mapped address IS_IPV6() Whether argument is an IPv6 address NAME_CONST �→ () Can be used to rename a column name SLEEP() Sleep for a number of seconds partitioned table using Limit #24636 • Fix the issue of displaying the incorrect TiDB address in IPv6 environment #43260 @nexustar • Fix the issue of displaying incorrect values for system variables

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_IPV4() Whether argument is an IPv4 address IS_IPV4_MAPPED �→ () Whether argument is an IPv4-mapped address IS_IPV6() Whether argument is an IPv6 address NAME_CONST �→ () Can be used to rename a column name SLEEP() Sleep for a number of seconds partitioned table using Limit #24636 • Fix the issue of displaying the incorrect TiDB address in IPv6 environment #43260 @nexustar • Fix the issue of displaying incorrect values for system variables