IPV6

SinceVersion dev

IPV6

description

IPv6类型，以UInt128的形式存储在16个字节中，用于表示IPv6地址。 取值范围是 [‘::’, ‘ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff’]。

超出取值范围或者格式非法的输入将返回NULL

example

建表示例如下：

1. CREATE TABLE ipv6_test (
2. `id` int,
3. `ip_v6` ipv6
4. ) ENGINE=OLAP
5. DISTRIBUTED BY HASH(`id`) BUCKETS 4
6. PROPERTIES (
7. "replication_allocation" = "tag.location.default: 1"
8. );

插入数据示例：

1. insert into ipv6_test values(1, '::');
2. insert into ipv6_test values(2, '2001:16a0:2:200a::2');
3. insert into ipv6_test values(3, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff');
4. insert into ipv6_test values(4, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffffg'); // invalid data

查询数据示例：

1. mysql> select * from ipv6_test order by id;
2. +------+-----------------------------------------+
3. | id   | ip_v6                                   |
4. +------+-----------------------------------------+
5. |    1 | ::                                      |
6. |    2 | 2001:16a0:2:200a::2                     |
7. |    3 | ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff |
8. |    4 | NULL                                    |
9. +------+-----------------------------------------+

keywords

IPV6