IPV4_CIDR_TO_RANGE

IPV4_CIDR_TO_RANGE

Description

Syntax

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

Receive an IPv4 and an Int16 value containing CIDR. Returns a struct that contains two IPv4 fields representing the lower range (min) and higher range (max) of the subnet, respectively.

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