1
CREATE TABLE t1 (a IPV6, PRIMARY KEY(a));
6
PRIMARY KEY (`a`) USING BTREE
7
) ENGINE=InnoDB COLLATE = utf8_general_ci
8
INSERT INTO t1 VALUES ("10FB::C:ABC:1F0C:44DA");
11
10fb:0000:0000:0000:000c:0abc:1f0c:44da
12
CREATE TABLE t2 (a REAL);
13
INSERT INTO t2 SELECT a FROM t1 LIMIT 1;
14
ERROR 01000: Data truncated for column 'a' at row 1
17
CREATE TABLE t3 (a REAL);
18
INSERT INTO t3 SELECT a FROM t1 LIMIT 1;
19
ERROR 01000: Data truncated for column 'a' at row 1