IPV6
更新时间：2025-10-17
IPV6
描述
IPv6 类型，以 UInt128 的形式存储在 16 个字节中，用于表示 IPv6 地址。 取值范围是 ['::', 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff']。
超出取值范围或者格式非法的输入将返回NULL
举例
建表示例如下：
Plain Text
1CREATE TABLE ipv6_test (
2 `id` int,
3 `ip_v6` ipv6
4) ENGINE=OLAP
5DISTRIBUTED BY HASH(`id`) BUCKETS 4
6PROPERTIES (
7"replication_allocation" = "tag.location.default: 1"
8);插入数据示例：
Plain Text
1insert into ipv6_test values(1, '::');
2insert into ipv6_test values(2, '2001:16a0:2:200a::2');
3insert into ipv6_test values(3, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff');
4insert into ipv6_test values(4, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffffg'); // invalid data查询数据示例：
Plain Text
1mysql> 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