IPV6_CIDR_TO_RANGE

SinceVersion dev

IPV6_CIDR_TO_RANGE

description

Syntax

STRUCT<IPV6, IPV6> IPV6_CIDR_TO_RANGE(IPV6 ip_v6, INT16 cidr)

接收一个IPv6和一个包含CIDR的Int16值。返回一个结构体，其中包含两个IPv6字段分别表示子网的较低范围（min）和较高范围（max）。

notice

如果入参为NULL，则返回NULL，表示无效输入

example

1. mysql> SELECT ipv6_cidr_to_range(ipv6_string_to_num('2001:0db8:0000:85a3:0000:0000:ac1f:8001'), 32);
2. +---------------------------------------------------------------------------------------+
3. | ipv6_cidr_to_range(ipv6_string_to_num('2001:0db8:0000:85a3:0000:0000:ac1f:8001'), 32) |
4. +---------------------------------------------------------------------------------------+
5. | {"min": "2001:db8::", "max": "2001:db8:ffff:ffff:ffff:ffff:ffff:ffff"}                |
6. +---------------------------------------------------------------------------------------+

8. mysql> SELECT ipv6_cidr_to_range(to_ipv6('2001:0db8:0000:85a3:0000:0000:ac1f:8001'), 32);
9. +----------------------------------------------------------------------------+
10. | ipv6_cidr_to_range(to_ipv6('2001:0db8:0000:85a3:0000:0000:ac1f:8001'), 32) |
11. +----------------------------------------------------------------------------+
12. | {"min": "2001:db8::", "max": "2001:db8:ffff:ffff:ffff:ffff:ffff:ffff"}     |
13. +----------------------------------------------------------------------------+

15. mysql> SELECT ipv6_cidr_to_range(NULL, NULL);
16. +--------------------------------+
17. | ipv6_cidr_to_range(NULL, NULL) |
18. +--------------------------------+
19. | NULL                           |
20. +--------------------------------+

keywords

IPV6_CIDR_TO_RANGE, IP