1
CREATE TABLE t1 (a IPV6, PRIMARY KEY(a));
2
INSERT INTO t1 VALUES ("fe8::b3ff:fe1a:8329");
3
INSERT INTO t1 VALUES ("::1");
4
INSERT INTO t1 VALUES ("::192.168.100.10");
5
INSERT INTO t1 VALUES ("2001:db8:85a3::8a2e:370:7334");
6
INSERT INTO t1 VALUES ("2001:db8:85a3::8a2e:370:7334");
7
ERROR 23000: Duplicate entry '2001:0db8:85a3:0000:0000:8a2e:0370:7334' for key 'PRIMARY'
8
SELECT a FROM t1 ORDER BY a;
10
0000:0000:0000:0000:0000:0000:0000:0001
11
000:000:000:000:000:000:192.168.100.010
12
2001:0db8:85a3:0000:0000:8a2e:0370:7334
13
0fe8:0000:0000:0000:0000:b3ff:fe1a:8329