IPV4_CIDR_TO_RANGE

SinceVersion dev

IPV4_CIDR_TO_RANGE

description

Syntax

STRUCT<IPV4, IPV4> IPV4_CIDR_TO_RANGE(IPV4 ip_v4, INT16 cidr)

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

notice

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

example

1. mysql> SELECT ipv4_cidr_to_range(ipv4_string_to_num('192.168.5.2'), 16);
2. +------------------------------------------------------------+
3. | ipv4_cidr_to_range(ipv4_string_to_num('192.168.5.2'), 16)  |
4. +------------------------------------------------------------+
5. | {"min": "192.168.0.0", "max": "192.168.255.255"}           |
6. +------------------------------------------------------------+

8. mysql> SELECT ipv4_cidr_to_range(to_ipv4('192.168.5.2'), 16);
9. +--------------------------------------------------+
10. | ipv4_cidr_to_range(to_ipv4('192.168.5.2'), 16)   |
11. +--------------------------------------------------+
12. | {"min": "192.168.0.0", "max": "192.168.255.255"} |
13. +--------------------------------------------------+

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

keywords

IPV4_CIDR_TO_RANGE, IP